Mysql optimization with mysqltuner

morteza3245

• October 09, 2013 13:58

Hi below is my output from mysql tuner : root@host [/]# /usr/local/bin/mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> Bug reports, feature requests, and downloads at

• 

  thinkbot

  • October 11, 2013 20:24

  [mysqld] local-infile=0 myisam_use_mmap=1 join_buffer_size=1M read_rnd_buffer_size=2M query_cache_type = 1 query_cache_size=50M query_cache_limit=1M tmp_table_size=50M max_heap_table_size=50M thread_cache_size=30 table_open_cache = 5000 table_definition_cache = 2500 max_allowed_packet=32M key_buffer_size=5G open_files_limit=20000 slow_query_log=1 slow_query_log_file=mysql-slow.log long_query_time=0.1 innodb_buffer_pool_size = 200M

  0
• 

  cPanelMichael

  • October 14, 2013 17:07

  Hello :) We encourage you to let us know the outcome after trying the recommended changes in the previous post. Thank you.

  0
• 

  felz

  • October 23, 2013 02:57

  hai thinkbot, is that really necessary to adjust the key_buffer_size up to 5GB, bse on this blog below, It works just fine until you have less than 4GB worth of key cache used and then it would crash. [url=http://www.mysqlperformanceblog.com/2007/02/14/beware-key_buffer_size-larger-than-4g-does-not-work/]Beware: key_buffer_size larger than 4G does not work - MySQL Performance Blog

  0
• 

  thinkbot

  • October 23, 2013 08:33

  That blog post is from February 14, 2007, on mysql version 5.0 In your case 1,5G would be more than enough, but this is max option, we set it max 5G, so when needed it will increase to this number

  0

Please sign in to leave a comment.