mysql using a lot of resources?
I have a high traffic server - Cpanel 1200+ accounts...however mysql seems to be hogging the server pretty darn welll.
usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/pluto.digitalnetwork.co.nz.pid --skip-locking --socket/var/lib/mysql/mysql.sock
Any idea on how to stop mysql from using so much resources? Limits etc, the my.cnf is already tweaked etc...
Any help would be appreciated
