Results 1 to 3 of 3
  1. #1

    mysql optimization?

    I currently have a VPS with 1GB RAM, can anyone suggest a good optimization through the my.cnf file?

    I tried "myself tuning primer", it ran but there were a lot of errors in the python script so I don't want to rely on that. Or is mysql auto-optimized when its installed?

    Here's my current my.cnf:

    Code:
    [mysqld]
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 16K
    max_allowed_packet = 1M
    table_cache = 4
    sort_buffer_size = 64K
    read_buffer_size = 256K
    read_rnd_buffer_size = 256K
    net_buffer_length = 2K
    thread_stack = 64K
    skip-bdb
    skip-innodb
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    #safe-updates
    
    [isamchk]
    key_buffer = 8M
    sort_buffer_size = 8M
    
    [myisamchk]
    key_buffer = 8M
    sort_buffer_size = 8M
    
    [mysqlhotcopy]
    interactive-timeout
    Thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Melbourne, AU
    Posts
    539
    Are there existing performance problems?
    WK Woon
    CTO | http://www.aflexi.net - A flexible Network
    Building the next generation CDN platform - DEMO .... coming soon

  3. #3
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,452
    Mysql is not auto optimized, and you need to optimize it according to your personal performance requirement. One optimized my.cnf may not be the same for yours.

    The process is server/VPS specific

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •