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!

MYSQL 4 Problem & Server Load

Discussion in 'General Discussion' started by hugo24, May 7, 2003.

  1. hugo24

    hugo24 Well-Known Member

    Joined:
    Nov 16, 2002
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    CPANEL has upgraded to MYSQL 4 and I am having problem with
    Invision Board.

    I tried to work do some change in /etc/my.cnf with the following guide provided by InvisionBoard member

    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=50
    key_buffer=40M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=512
    record_buffer=1M
    sort_buffer_size=768K
    read_buffer_size=512K
    max_connect_errors=10
    thread_concurrency=2
    myisam_sort_buffer_size=64M

    But I only have this in my /etc/my.cnf,

    [mysqld]

    max_connection=500

    So, I did a cut and paste and save it. I am not sure will it works
    but my server load shoot up from average 0.2 to 2.

    Any help? Am I doing the right thing?
     
  2. mesranet

    mesranet Well-Known Member

    Joined:
    May 6, 2002
    Messages:
    126
    Likes Received:
    0
    Trophy Points:
    316
    Hi,

    Mine is :

    [mysqld]
    skip-locking
    skip-innodb
    set-variable = max_connections=1000
    set-variable = interactive_timeout=100
    set-variable = wait_timeout=200
    set-variable = connect_timeout=30
    set-variable = thread_cache_size=8
    set-variable = key_buffer=384M
    set-variable = max_allowed_packet=16M
    set-variable = table_cache=1024
    set-variable = sort_buffer=2M
    set-variable = record_buffer=2M
    set-variable = thread_cache=8
    # Try number of CPU's*2 for thread_concurrency
    set-variable = thread_concurrency=8
    set-variable = myisam_sort_buffer_size=64M
    set-variable = query_cache_limit=1M
    set-variable = query_cache_size=32M
    set-variable = query_cache_type=1

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    open_files_limit=8192

    [mysqldump]
    quick
    set-variable = max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    set-variable = key_buffer=256M
    set-variable = sort_buffer=256M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    [myisamchk]
    set-variable = key_buffer=256M
    set-variable = sort_buffer=256M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    [mysqlhotcopy]
    interactive-timeout
     
  3. hugo24

    hugo24 Well-Known Member

    Joined:
    Nov 16, 2002
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    156
    Hello,

    Thank you for the response.

    Will it be ok for me to cut and paste everything into /etc/my.cnf?

    Should I remove away those "#"?

    My Server is P4 1.7ghz with 512RAM. Do I need to change anything from there?
     
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