--skip-external-locking HELP!

[Crazy4]

--skip-external-locking is eating up all my CPU, it is a mySQL process.

my VPS has loads above 140

waiting for some help!

Crazy4 Reviewed by Crazy4 on 9th Oct 2010. --skip-external-locking HELP! --skip-external-locking is eating up all my CPU, it is a mySQL process. my VPS has loads above 140 waiting for some help! Rating: 5

[devilmaycry]

contact at my msn id : sales@myoffshorehost.in

and i will check and tell you whats wrong WITH IT

[Crazy4]

anyone has a solution??

the mySQL process list says copying to tmp file

and its getting over loaded with it

[Crazy4]

any help?

[Crazy4]

????????

[warezrock]

what kind of script you are running on your VPS ? wordpress ??

[Crazy4]

vbulletin

[Angeix]

Hello,

Look's like the node you're on. it oversold.

[l0calh0st]

I think you are on an oversold VPS, because "--skip-external-locking" is a normal process.

[Lock Down]

anyone has a solution??

the mySQL process list says copying to tmp file

and its getting over loaded with it

If this is what it says it could be that the sql statement is formed so that it needs way too much time and space.
Normally a group by and order by without the proper keys being set will cause this to happen.
I took over a server that kept locking up mysql and it was on its own dedi with 12 gig ram.

Try removing all the mods and see if it still happens. Then you can add them back one at a time until you find the bad one and rewrite the mysql or confront the author.