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.

my.cnf settings for....

Discussion in 'General Discussion' started by BlackDemon, Aug 12, 2006.

  1. BlackDemon

    BlackDemon Active Member

    Joined:
    Jun 5, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    I just got a new Dual Xeon 3.0 / 2Gb's ram / 2x 73Gb 15,000 RPM SCSI's in Raid 0. This is my current my.cnf file. What would you suggest changing or is this good?


    [mysqld]
    max_connections = 1000
    safe-show-database
    key_buffer = 1024M
    myisam_sort_buffer_size = 128M
    join_buffer_size = 32M
    read_buffer_size = 32M
    sort_buffer_size = 32M
    table_cache = 1024
    thread_cache_size = 256
    wait_timeout = 30
    connect_timeout = 20
    max_allowed_packet = 64M
    max_connect_errors = 15
    query_cache_limit = 16M
    query_cache_size = 128M
    query_cache_type = 1
    skip-innodb
    skip-name-resolve

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

    [mysqldump]
    quick
    max_allowed_packet = 64M

    [isamchk]
    key_buffer = 1024M
    sort_buffer_size = 1024M
    read_buffer = 32M
    write_buffer = 32M

    [myisamchk]
    key_buffer = 1024M
    sort_buffer = 1024M
    read_buffer = 64M
    write_buffer = 64M
     
Loading...

Share This Page