ASTRAPI Posted November 21, 2009 Posted November 21, 2009 Hello 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)
ASTRAPI Posted November 22, 2009 Author Posted November 22, 2009 Many of those are missing can you help me to adjust them?[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking skip-innodb skip-bdb 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 skip-networking [mysqldump] quick max_allowed_packet = 1M [mysql] no-auto-rehash safe-updates [isamchk] key_buffer = 10M sort_buffer_size = 2M [myisamchk] key_buffer = 10M sort_buffer_size = 2M
rct2·com Posted November 22, 2009 Posted November 22, 2009 [quote name='rct2·com' date='18 November 2009 - 11:05 PM' timestamp='1258585517' post='1880486']You might also like to google for different recommended my.cnf settings based on typical server spaces and usage profiles.
ASTRAPI Posted November 22, 2009 Author Posted November 22, 2009 I thought it was specific file and not able to use any file that i get from net as i want to be very stable .... If anyone can adjust my.cnf please post it here. Thank you
Recommended Posts
Archived
This topic is now archived and is closed to further replies.