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? Link to comment https://forums.phpfreaks.com/topic/142409-solved-mysql-and-settings-not-set/ 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". Link to comment https://forums.phpfreaks.com/topic/142409-solved-mysql-and-settings-not-set/#findComment-747540 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] Link to comment https://forums.phpfreaks.com/topic/142409-solved-mysql-and-settings-not-set/#findComment-748206 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.