Posting Takes Forever - Slow Preformance

[vskylabv]

I've already mentioned this in a ticket and was told to optimize the server. That's why I'm here.

[vskylabv]

Could I get an update on this?

[vskylabv]

MySQL is taking up 566MB of memory. This screenshot was recorded after I pressed Post Reply. When posting any new Thread or Post Reply. No Go to http://nightclubcity.com/forums/ to view the...

[vskylabv]

Whenever someone tries to post a new thread of topic it takes ages to post. I'm assuming this could be a performance issue with the database so I started to investigate.

Running MySQLTuner...

[vskylabv]

Was there an email about the security issue? I only just realized it now and deleted the folder.

[vskylabv]

I got NightClubCity running with 2M posts. It has not been an easy move. There's been a huge downfall in traffic and a lot of downtime. It's completely changed the UX. I'm still troubleshooting ways to...

[vskylabv]

Why wouldn't it matter?

[vskylabv]

My database is close to 7 gigs. I'm looking to optimize this a bit and reduce the size. Any thoughts or suggestions? Server configurations? What I can drop?
Thanks!

[vskylabv]

It took some editing of files to fix. Try opening a ticket if you still have ticket support.

[vskylabv]

I think CDN support would make a huge difference in the performance of vBulletin 5. I could implement this manually but I think having it as an option within admincp would be pretty great. What do you...

[vskylabv]

The site itself loads pretty well for me but posting takes maybe a full minute. Working with support on fixing this.

[vskylabv]

Perhaps it was the rise of social networks but vBulletin has been seeing a steady drop in interest for awhile now. Less people are searching for vBulletin and I'd imagine traffic here will continue to...

[vskylabv]

Is there any way to rebuild attachments and albums from vB4?

What's happening is the Attachment Storage Type was incorrect when upgrading from vB4 to vB5. I had to reset and move the server...

[vskylabv]

I was wondering whether if it was safe to drop all tables related to Blog and the CMS on vB5. I'm guessing they're there from vB4.
I'm trying to save as much space as possible in our database so...

[vskylabv]

I was suggested that but my memory limit is set to 256M. That's pretty high.