Optimizing my.cnf in new server | Justin.my - The Diigo Meta page

• 13 May 12
  

  Erik James Albaugh

  • [mysqld]
    local-infile=0
    skip-locking
    query_cache_limit=4M
    query_cache_size=32M
    query_cache_type=1
    max_connections=500
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    key_buffer_size=256M
    join_buffer=1M
    join_buffer_size=1M
    max_allowed_packet=16M
    table_cache=2048
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10
    # Try number of CPU’s*2 for thread_concurrency
    thread_concurrency=8
    myisam_sort_buffer_size=64M
    server-id=1
    tmp_table_size=64M
    max_heap_table_siz=64M
    innodb_buffer_pool_size=128M

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

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.