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.

Optimize MySQL

Discussion in 'General Discussion' started by Domenico, Jul 24, 2002.

  1. Domenico

    Domenico Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    361
    Likes Received:
    0
    Trophy Points:
    16
    Hello,

    Have a look at this MySQL config (my.cnf),
    Can it be optimized better or is this ok?
    Or do you have any other optimize tricks?

    Thank you!

    [client]
    port = 3306
    socket = /tmp/mysql.sock


    # The MySQL server
    [mysqld]
    port= 3306
    socket= /tmp/mysql.sock
    skip-locking
    set-variable = max_connections=400
    set-variable = key_buffer=36M
    set-variable = join_buffer=6M
    set-variable = record_buffer=6M
    set-variable = sort_buffer=10M
    set-variable = table_cache=1536
    set-variable = myisam_sort_buffer_size=40M
    set-variable = thread_cache_size=530
    set-variable = connect_timeout=30
    set-variable = wait_timeout=30
    set-variable = interactive_timeout=28800

    # Try number of CPU's*2 for thread_concurrency
    set-variable= thread_concurrency=3

    log-slow-queries=/var/log/slow.log
    log=/var/log/mysql.log
    #log-bin
    #server-id= 1
    # Uncomment the following if you are using Innobase tables
    #innodb_data_home_dir = /var/lib/mysql/
    #innodb_log_group_home_dir = /var/lib/mysql/
    #innodb_log_arch_dir = /var/lib/mysql/
    #innodb_data_file_path = ibdata1:25M;ibdata2:37M;ibdata3:100M;ibdata4:300M
    #set-variable = innodb_mirrored_log_groups=1
    #set-variable = innodb_log_files_in_group=3
    #set-variable = innodb_log_file_size=5M
    #set-variable = innodb_log_buffer_size=8M
    #innodb_flush_log_at_trx_commit=1
    #innodb_log_archive=0
    #set-variable = innodb_buffer_pool_size=16M
    #set-variable = innodb_additional_mem_pool_size=2M
    #set-variable = innodb_file_io_threads=4
    #set-variable = innodb_lock_wait_timeout=50

    # Point the following paths to different dedicated disks
    #tmpdir= /tmp/
    #log-update = /path-to-dedicated-directory/hostname

    [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=128M
    set-variable= sort_buffer=128M
    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=8M
    set-variable= write_buffer=8M

    [mysqlhotcopy]
    interactive-timeout
     
  2. taivu

    taivu Well-Known Member

    Joined:
    Nov 22, 2001
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    I think posting your server stats (amount of RAM etc) could help :)
     
  3. Domenico

    Domenico Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    361
    Likes Received:
    0
    Trophy Points:
    16
    Ok, here they are

    last pid: 48739; load averages: 0.31, 0.12, 0.06 up 17+22:11:46 16:21:14
    39 processes: 1 running, 38 sleeping
    CPU states: 0.0% user, 0.0% nice, 0.8% system, 0.8% interrupt, 98.8% idle
    Mem: 138M Active, 223M Inact, 93M Wired, 24M Cache, 60M Buf, 20M Free
    Swap: 846M Total, 9728K Used, 837M Free, 1% Inuse
     
Loading...

Share This Page