1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

optimize my.cnf file

Discussion in 'Plesk for Linux - 8.x and Older' started by noworyz, May 12, 2007.

  1. noworyz

    noworyz Guest

    0
     
    I am working on getting the VPS I have being setup to best performance and I have seen a lot of talk about changing the my.cnf file for mysql as this seems to be the major performance issue I am having.

    Here is the my.cnf for my server which is the default that came with it (except for the slow queries.

    Does anyone know what I should do to this file to better the server or know of any resources to tell me what settings to do?

    My server specs are:

    CPU: AuthenticAMD, Dual-Core AMD Opteron(tm) Processor 2212
    Version: psa v8.1.1_build81070423.15 os_FedoraCore 6
    OS: Linux 2.6.9-023stab043.1-smp
    HD: 25GB Hard Drive Space (3GB Used)
    RAM: 1GB Total (about 280 MB used)



    Here is the my.cnf file
    Code:
    [mysqld]
    set-variable=local-infile=0
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1
    
    skip-bdb
    
    set-variable = innodb_buffer_pool_size=2M
    set-variable = innodb_additional_mem_pool_size=500K
    set-variable = innodb_log_buffer_size=500K
    set-variable = innodb_thread_concurrency=2
    log-slow-queries = slow_queries.log
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    skip-bdb
    
    set-variable = innodb_buffer_pool_size=2M
    set-variable = innodb_additional_mem_pool_size=500K
    set-variable = innodb_log_buffer_size=500K
    set-variable = innodb_thread_concurrency=2
     
Loading...