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 and optimization mysql server

Discussion in 'General Discussion' started by upsforum, Mar 1, 2007.

  1. upsforum

    upsforum Well-Known Member

    Joined:
    Jul 27, 2005
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    I have 3 GByte of RAM in my server, and this is my.cnf file

    ___________________________

    [mysqld]
    skip-locking
    #skip-innodb
    query_cache_limit=1M
    query_cache_size=128M
    query_cache_type=1
    max_connections=1000
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=65M
    join_buffer=1M
    max_allowed_packet=32M
    table_cache=1024
    record_buffer=16M
    key_buffer_size=16M
    sort_buffer_size=8M
    read_buffer_size=8M
    max_connect_errors=10
    # Prova numero di CPU's*2 per thread_concurrency
    thread_concurrency=2
    myisam_sort_buffer_size=128M
    log-bin
    server-id=1
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    ft_min_word_len=3
    safe-show-database

    [mysql.server]
    user=mysql
    basedir=/var/lib
    old-passwords = 1

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    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

    _____________________________


    I can to increase some value for optimize the performances the mysql server?

    thanks
    Alex
     
Loading...
Similar Threads - cnf optimization mysql
  1. Ajeje989
    Replies:
    1
    Views:
    167

Share This Page