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.

Upgraded to MySQL 5- Now the Server Load is through the roof

Discussion in 'General Discussion' started by MattC, Apr 16, 2007.

  1. MattC

    MattC Registered

    Joined:
    May 25, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    I just upgraded to mySQL 5 after a long ordeal with it. Now, my server load creeps up to 20-30 with no problems. I've checked the top processes and nothing is out of the ordinary. The server was rebooted and it popped right back up again.

    I have experience in computers, but not much in the way of servers. If anyone could point me in the direction of where to start or what to do, it would be greatly appreciated. I've been searching Google, but nothing useful as of yet.

    Thanks.
     
    #1 MattC, Apr 16, 2007
    Last edited: Apr 16, 2007
  2. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    What does your /etc/my.cnf file look like?
     
  3. MattC

    MattC Registered

    Joined:
    May 25, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I've tried 2 copies of my.cnf. Neither of them appear to be working. The first one I found on another forum. It was about optimizing. Here it is:

    Code:
    [mysqld]
    safe-show-database
    old_passwords
    back_log = 75
    skip-innodb
    max_connections = 650
    key_buffer = 64M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1800
    thread_cache_size = 384
    wait_timeout = 30
    connect_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet = 64M
    max_connect_errors = 10
    read_rnd_buffer_size = 524288
    bulk_insert_buffer_size = 8M
    query_cache_limit = 3M
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 163840
    query_alloc_block_size = 32768
    default-storage-engine = MyISAM
    
    [mysqld_safe]
    open_files_limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout
    
    And this is the one I was using before:

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
         
    [mysql.server]
    user=mysql
    basedir=/var/lib
    old-passwords = 1
    
    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    I also commented out the 'base dir', which was recommended for MySQL 5. Didn't do a thing. BTW, at the time I'm posting this, the server load has jumped up to 48!
     
Loading...

Share This Page