Home / server / Questions / 112785
Accepted
Daniel Fischer
Asked: 2010-02-15 12:02:15 +0800 CST

Does my top indicate I need to optimize apache or mysql?

  • 772

Take a look at this:

http://img.skitch.com/20100214-pf95t9dpywxqgne7wrk65nnhq5.png

After taking a look at that would you be able to say I need to optimize or am I doing ok?

mysql apache-2.2 vps

3 Answers

  1. Best Answer

    i see that you have 15 % io wait - from my experience this is caused by the mysql

    io wait means, that the kernel is waiting for the hard disks - and this is really slow

    so if you use innodb in mysql you should increase the buffer pool value in my.cnf

    a bigger buffer pool will lower the io wait.

    additionally you should try to kill some processes to free up some memory or upgrade it

    • 1

  2. Optimize is not the word you're looking for. You seem to have 6 gigs of ram, and your mysql process is taking up 37% cpu.. is this a trend that's going up or down? or is this just a one off thing?

    to figure out if it's apache or mysql that needs the "optimization" you need to find out what's causing mysql to take up so much cpu. run "show processlist; " in your mysql list.. that'll give you an idea of what mysqld is doing, if it's just got one process that's taking forever.. you need to optimize that one query.. ..

    this question needs more details to answer properly.

    • 0

  3. It's difficult, i no impossible know what and how to optimize apache & my.

    About my, there is a script here http://www.day32.com/MySQL/ that based on "show status" and "show variables", help tune some variables.

    • 0