random1 Posted January 25, 2009 Share Posted January 25, 2009 Hi, I've been using MONYog to monitor my mysql installation and it has made recommendations. I looked up and got the mysql variables to make the changes and got: max_heap_table_size = 64M key_buffer_size = 64M tmp_table_size = 64M innodb_log_file_size = 10485760 innodb_buffer_pool_size = 2.5GB innodb_log_buffer_size = 4M innodb_thread_concurrency = 8 innodb_flush_method = O_DIRECT thread_cache_size = 25 query_cache_type = 1 query_cache_size = 1073741824 query_cache_limit = 2147483648 delay_key_write = OFF I put that code at the bottom of the mysql config file and restarted it but the following mysql variables are not set: key_buffer_size (defaults to 16M) delay_key_write (defaults to ON) innodb_log_file_size (defaults to 5M) thread_cache_size (defaults to 0) query_cache_size (defaults to disabled) max_heap_table_size (defaults to 16M) How do you set these settings in MySQL? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 27, 2009 Share Posted January 27, 2009 Not sure what you mean by the "bottom". Quote Link to comment Share on other sites More sharing options...
random1 Posted January 28, 2009 Author Share Posted January 28, 2009 Fixed this up... needed to be under: [mysqld] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.