GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Revise my.cnf for best performance

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Revise my.cnf for best performance

    Hi all,

    Hi have a website with a MyIsam Database with 10 millon records, and 50 tables.

    I have an Avg of 600 query by second.

    My server is a 2 x Opteron 2352(2 x 4 x 2,1 GHz) with 16 GB ram

    This is my.cnf file:

    [mysqld]
    set-variable=local-infile=0
    set-variable=max_connections=600
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    long_query_time = 1
    thread_cache_size = 50
    log-slow-queries = /var/log/mysql-slow.log
    query_cache_type = 1
    query_cache_size = 26214400
    key_buffer_size = 1500M
    table_cache = 400
    sort_buffer_size=4M
    read_buffer_size=1M

    You change any?

    Thanks!!!
    Giro.

  • #2
    There is no general best my.cnf for your hardware. Let someone look at it if you have performance issues. Pm me if interested, or hire someone from percona.

    Comment

    Working...
    X