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 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:
    6
    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:
    16
    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:
    6
    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