I am hosting a game on VPS. currently game has very few members but even then my server get slow down and load average reaches 3. I have purchased VPS from VPS.net. here are my stats of cpus in my vps Total RAM installed in 2300MB below is SQl conf file my.cnf I need help, MySQL sometimes uses 150% of CPU which slow downs my server.
Also, run "mysqladmin processlist" ; When this issue is occurring to find out which queries and databases are causing the issue. From here, you will be able to see what needs to be optimized.