Jump to content

Mysqltuner recomendations

Recommended Posts


Using mysqltuner i got the above recomendations:

1) Total fragmented tables: 13
2) Query cache is disabled
3) Sorts requiring temporary tables: 95% (1M temp sorts / 1M sorts)
4) Thread cache is disabled
5) Table cache hit rate: 0% (64 open / 47K opened)
6) Table locks acquired immediately: 93%

And as recomendations i got:

General recommendations:

Where are those variables to adjust?

Thank you

    Run OPTIMIZE TABLE to defragment tables for better performance

    Enable the slow query log to troubleshoot bad queries

    Set thread_cache_size to 4 as a starting value

    Increase table_cache gradually to avoid file descriptor limits

    Optimize queries and/or use MyISAM to reduce lock wait

Variables to adjust:

    query_cache_size (>= 8M)

    sort_buffer_size (> 1M)

    read_rnd_buffer_size (> 256K)

    thread_cache_size (start at 4)

    table_cache (> 64)
Link to comment
Share on other sites

Many of those are missing can you help me to adjust them?


port            = 3306

socket          = /var/lib/mysql/mysql.sock




key_buffer = 10M

max_allowed_packet = 1M

table_cache = 1024

sort_buffer_size = 2M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

net_buffer_length = 2K

thread_stack = 64K

log-slow-queries       = /var/log/mysql/mysql-slow.log

server-id = 1




max_allowed_packet = 1M





key_buffer = 10M

sort_buffer_size = 2M


key_buffer = 10M

sort_buffer_size = 2M
Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...