MySQL takes forever after running certain php scripts... optimization help?

Posted by DFischer on Server Fault See other posts from Server Fault or by DFischer
Published on 2010-04-12T19:05:27Z Indexed on 2010/04/12 19:13 UTC
Read the original article Hit count: 258

Filed under:

vbulletin

When I run a couple scripts from the vBulletin software (like uninstalling a plugin) it takes forever.

When monitoring the memory usage, it shows this =>

-/+ buffers/cache: 158 381 Swap: 255 10 245

It seems that MySQL is only using a certain amount and once it does it tries to use the swap instead?

I have a 512MB slice and right now my key buffer is at 16M and max_allowed_packet is at 16M.

Is there something else I should increase or can I increase those variables and still be safe?

Thanks.

Related posts about vbulletin

Integrate VBulletin in a J2EE application and support single sign on

as seen on Stack Overflow - Search for 'Stack Overflow'
I am considering purchasing VBulletin and integrating it with my J2EE application. While I am still looking into what it takes to enable this integration, I was wondering if VBulletin supports single sign on so that my users do not have to login to VBulletin once they have been authenticated to the… >>> More
vBulletin BBCode on external page.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I integrated my vBulletin with custom front page. I'm wondering, how could I use vBulletin BBcode on that page (I'm displaying some posts there). Any suggestions? >>> More
How to integrate vBulletin auth with my site?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I need to use vBulletin auth system on the rest of my site. Does vB has any APIs for that? Im expecting to find something like that: if($vBulletin->isAuthenticated()) { // user authenticated } In case of vB does not have such API, is there any other ways to check if user is authenticated… >>> More
vBulletin Nightmare

as seen on Stack Overflow - Search for 'Stack Overflow'
I am creating a vBulletin forum community called: wehypnosis We purchased the vBulletin version 4.0 CMS and the SEO plugin. Im used to designing and building templates for drupal, wordpress and joomla. All of which have great documentation and many tutorials built by the community. But vBulletin… >>> More
vBulletin Publishing Suite 4.0: Not Just for Discussion Anymore

as seen on Internet.com - Search for 'Internet.com'
Scott Clark was lucky enough to get a sneak peek at vBulletin 4.0 Publishing Suite, which is a big step up from an ordinary discussion forum; in fact, it's a complete publishing system. Learn about the main features and find out why Scott gives it a thumbs up. >>> More

Developer IT