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 Load! Please Help!

Discussion in 'General Discussion' started by mike_r, Jul 10, 2004.

  1. mike_r

    mike_r Well-Known Member

    Joined:
    Nov 26, 2002
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    mySQL on my server is using 50% of the CPU at least and I have found in the Apache/mySQL CPU usage feature of WHM that its the top process and it uses about 190+ of ram.

    ::Server Specs::
    P4 2.4 Ghz
    1 GB DDRam

    ::mySQL my.CNF File::
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_connections=500
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=256
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=1M
    max_connect_errors=10
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency=2
    myisam_sort_buffer_size=64M
    log-bin
    server-id=1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

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

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout

    --------------------------------

    Okay now about the sites.

    We host a lot of forums, 40-50 small forums, 5-10 medium forums ( ipb and phpbb ), 1 big forum ( 70 gb / month bw usage )..

    And we host a site that has a game which requires communicating with mysql frequently, like updating battle records in a second, or retrieving the records in a few more seconds etc..

    So i would say, mySQL is used a lot. Apache also uses 20-40% almost all the time.

    Can anyone help me with quick optimization of the mySQL. I am not any expert at mysql configurations, although i tried my best, i wasn't able to optimize it. I would really be grateful if someone can help me out here.

    Thanks :)
     
  2. mike_r

    mike_r Well-Known Member

    Joined:
    Nov 26, 2002
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    6
    Anyone ????? *BUMP*
     
Loading...

Share This Page