If your MySQL server performance is poor check the following
details in your server.
1.Check the load average.
ex:
w
Note:load average is not more than 1.
2.Check free memory.
ex:
free -m
Check the available memory.
3.Check the updating running process.
ex:
top
Check CPU utilization and Memory of the server.
4.Show processlist.
This statement shows you which threads are running and to see “too many connections” error message and want to find out what is going on. …
[Read more]