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.

High load - please check my.cnf

Discussion in 'Workarounds and Optimization' started by dusanf, Aug 1, 2012.

  1. dusanf

    dusanf Member

    Joined:
    Jul 22, 2009
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    Hi,

    Im hosting a website with a lot of visitors (joomla, etc) and im having load over 60 on my vps with 4 gigs of ram and 4 gigs burst. Im using cpanel.

    This is my.cnf, can anyone tell whats wrong?


    Code:
    #[mysqld]
    #innodb_file_per_table=1
    
    [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_user_connections=250
    max_connections=5000
    interactive_timeout=10
    wait_timeout=10
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10
    thread_concurrency=8
    myisam_sort_buffer_size=64M
    server-id=1
    
    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192 
    
    [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
    
    [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
    
     
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    745
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    I'd ask that you open a ticket. There could be more going on than MySQL load.

    Thanks!
     
  3. nibb

    nibb Well-Known Member

    Joined:
    Mar 22, 2008
    Messages:
    301
    Likes Received:
    1
    Trophy Points:
    18
    I was not aware cPanel did MySQL optimization. Is this included in standard support?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    We can help with optimization on the forums. In the ticket system, we can check the system to see if a cPanel service is the issue. If it isn't, we can provide input on where to look further and then suggest the forums otherwise.

    For determining what you might want to change for MySQL settings, please run the following after MySQL has been up at least 24 hours:

    Code:
    /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
    Also, you might want to review this presentation on optimizing MySQL:

    http://videos.cpanel.net/mysql-optimization/
     
Loading...

Share This Page