Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

please help - mysql - high cpu usage!!

Discussion in 'General Discussion' started by 50c, Apr 20, 2006.

  1. 50c

    50c Active Member

    Joined:
    Jun 26, 2004
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    UK
    Hi,
    im having some problems with mysql.
    After i restart mysql, the CPU load is ok, after some time 10-15 minutes the load starts increasing... I have checked the processes and this is the problem:

    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/dualxeon.compacthost.com.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock

    This process eats about 90% of CPU, after some time it gets back to normal.. i have no idea what it could be..

    Here is my my.cnf:

    # The MySQL server
    [mysqld]
    port = 3306
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=64M
    query_cache_type=1

    max_connections = 448
    max_user_connections = 448

    interactive_timeout=6
    wait_timeout=6
    connect_timeout=6

    thread_cache_size=384
    key_buffer=96M

    max_allowed_packet=1M
    table_cache=512
    record_buffer=1M
    sort_buffer_size=1M
    read_buffer_size=1M

    thread_concurrency=4
    myisam_sort_buffer_size=64M
    server-id=1

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [mysql]
    no-auto-rehash

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=2M
    write_buffer=2M

    [mysqlhotcopy]
    interactive-timeout

    The machine is a DualXeon 2,4GHZ with 2 GB of ram...

    Please Help..
    Thanks

    Mike
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    The problem is NOT MySQL itself. You need to see who is exahusting many concurrnet connections causing high server load. Use mytop to monitor MySQL processes.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice