The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql is very slow

Discussion in 'General Discussion' started by WhiteBear, Jul 9, 2005.

  1. WhiteBear

    WhiteBear Well-Known Member

    Joined:
    Feb 19, 2004
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Today the MYSQL is very slow. One searches simple delay 1 minute almost. How I can decide this problem?

    mysql (4.0.24-standard)
    WHM 10.1.0 cPanel 10.2.0-S83

    PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
    2659 mysql 16 0 39844 25M 2488 S 99.1 2.5 2:23 1 mysqld

    root@server [/var/lib/mysql]# ps auxww | grep mysqld | wc -l
    15
    root@server [/var/lib/mysql]# mysqladmin processlist
    +--------+--------------+-----------+--------------+---------+-------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+--------------+-----------+--------------+---------+-------+-------+------------------+
    | 269678 | eximstats | localhost | eximstats | Sleep | 74 | | |
    | 310697 | leechprotect | localhost | leechprotect | Sleep | 15539 | | |
    | 319708 | root | localhost | | Query | 0 | | show processlist |
    +--------+--------------+-----------+--------------+---------+-------+-------+------------------+
    root@server [/var/lib/mysql]# mysqladmin status
    Uptime: 787204 Threads: 4 Questions: 6951422 Slow queries: 23 Opens: 351458 Flush tables: 1 Open tables: 64 Queries per second avg: 8.831

    Thank you,
     
Loading...

Share This Page