server: how to see which mysql is causing the problem?

Discussion in 'Site & Server Administration' started by nevret2, Jul 27, 2008.

0
  1. #1
    hello,

    i have a vps with root acces, now i have 3gb ram, and like 99% of the memmory gets used, i have like 100 blogs and want to know which mysqls are causing the problem, how can i see this? i have cpanel/whm too, hope someone can help

    thnx,
     
    nevret2, Jul 27, 2008 IP
  2. kailash

    kailash Well-Known Member

    Messages:
    1,248
    Likes Received:
    42
    Best Answers:
    0
    Trophy Points:
    190
    #2
    You can check the MySQL usage from the WHM. In WHM, there is an option called "Show MySQL Processes". From here you will get the list of database which are currently in use. Additional you may install mytop on your server. You may refer below articles to install it:

    http://www.eth0.us/mytop

    Hope this will help you.

    Kailash
     
    kailash, Jul 27, 2008 IP
  3. klimu

    klimu Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    login in to mysql and use command SHOW PROCESSLIST;
     
    klimu, Jul 28, 2008 IP
  4. zacharooni

    zacharooni Well-Known Member

    Messages:
    346
    Likes Received:
    20
    Best Answers:
    4
    Trophy Points:
    120
    #4
    watch -n 0.5 mysqladmin proc
     
    zacharooni, Jul 28, 2008 IP
  5. hostingspeak

    hostingspeak Peon

    Messages:
    233
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #5
    How much traffic are you getting? That's an awful lot of usage for only 100 sites.
     
    hostingspeak, Jul 29, 2008 IP