Skip external locking eating up to much cpu

The following command cause mysql to contantly use about 40%cpu:



/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/MYSERVER.pid --skip-external-locking



I have search the internet and it seems that the only solution is to optimize queries… whats you thoughts?

That is just mysql itself running



if you ps auxf you will see that it has a parent process similar to



/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql ------------------------

_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql---------------------



You may just need to optimize mysql to better support the loads it is receiving.



What is the contents of your /etc/my.cnf file? and also the available resources on your server (cpu/memory)



Also read the contents of the following error log to see if that indicates any problems



/var/lib/mysql/YOURSERVERHOSTNAME.err