I interspireadd Member 5 2014 0 0 Apr 28, 2014 #1 Mysql is putting dam load on server, some times it is going to 556%. how can i optimize it?
R REAK Active Member 651 2012 294 0 Apr 29, 2014 #2 Optimize the my.cnf, See if the CPU is wasted on IO wait, if thats the case move mysql to ssd drives.
Optimize the my.cnf, See if the CPU is wasted on IO wait, if thats the case move mysql to ssd drives.
L Lock Down Active Member 2,122 2010 228 0 May 4, 2014 #3 You can try Code: http://mysqltuner.pl or https://launchpad.net/mysql-tuning-primer Last edited: May 5, 2014
V VersaceBoys Active Member 345 2014 73 0 May 4, 2014 #4 Use remote SQL Sent from my iPhone using Tapatalk