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

Discussion in 'General Discussion' started by richenou, Sep 28, 2007.

  1. richenou

    richenou Well-Known Member
    PartnerNOC

    Joined:
    Feb 17, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    hi
    what do you think about my mysql config?
    I run a coreduo2 with 4G RAM


    !:


    [mysqld]
    set-variable = max_connections=300
    safe-show-database
    max_user_connections = 20
    skip-networking
    log-slow-queries = /var/log/mysql/slow-query.log



    skip-locking
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=60
    key_buffer=64M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=400
    record_buffer=1M
    sort_buffer_size=768K
    read_buffer_size=512K
    read_rnd_buffer_size=512K
    max_connect_errors=10
     
  2. sv1

    sv1 Well-Known Member

    Joined:
    Aug 31, 2003
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Here's one of ours:

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    safe-show-database
    old_passwords
    back_log = 75
    skip-innodb
    max_connections = 400
    key_buffer = 16M
    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 = 45
    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 = 80M
    query_cache_type = 1
    query_prealloc_size = 163840
    query_alloc_block_size = 32768
    default-storage-engine = MyISAM
    [mysql.server]
    user=mysql
    basedir=/var/lib
    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    open_files_limit = 8192
    [mysqldump]
    quick
    max_allowed_packet = 16M
    [myisamchk]
    key_buffer = 1M
    sort_buffer = 100K
    read_buffer = 100K
    write_buffer = 100K
    
    
    
     
  3. richenou

    richenou Well-Known Member
    PartnerNOC

    Joined:
    Feb 17, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    can you tell me which line is very usefull or not?

    thx
     
Loading...

Share This Page