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.

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:
    1
    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:
    3
    Trophy Points:
    38
    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.
     
Loading...

Share This Page