ASTRAPI Posted November 21, 2009 Share 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) Link to comment Share on other sites More sharing options...
rct2·com Posted November 21, 2009 Share Posted November 21, 2009 my.cnf Link to comment Share on other sites More sharing options...
ASTRAPI Posted November 22, 2009 Author Share 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 Link to comment Share on other sites More sharing options...
rct2·com Posted November 22, 2009 Share 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. Link to comment Share on other sites More sharing options...
ASTRAPI Posted November 22, 2009 Author Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.