TekkForCeAD2 158 Posted July 24, 2016 Share Posted July 24, 2016 Hello, I wanted to ask how you set up your my.cnf for a good perfomance. Here is my.cnf: #INNODB innodb_buffer_pool_size = 378M innodb_log_file_size = 64M innodb_file_per_table=1 innodb_flush_method = O_DIRECT #MyISAM key_buffer_size = 64M #OTHER tmp_table_size = 32M max_heap_table_size = 32M query_cache_type = 0 query_cache_size = 00 max_connections = 500 max_connect_errors = 500 thread_cache_size = 50 table_open_cache = 800 open_files_limit = 65535 innodb_force_recovery = 0 Link to comment Share on other sites More sharing options...
ds_aim 241 Posted July 24, 2016 Share Posted July 24, 2016 You are sure about that ? Just install mysqltuner and post here the results. Link to comment Share on other sites More sharing options...
IceShiva 150 Posted July 25, 2016 Share Posted July 25, 2016 it depends... What hardware youre using Link to comment Share on other sites More sharing options...
[007]DawisHU 277 Posted February 18, 2017 Share Posted February 18, 2017 On 2016. 07. 25. at 1:17 AM, TekkForCeAD2 said: Hello, I wanted to ask how you set up your my.cnf for a good perfomance. Here is my.cnf: #INNODB innodb_buffer_pool_size = 378M innodb_log_file_size = 64M innodb_file_per_table=1 innodb_flush_method = O_DIRECT #MyISAM key_buffer_size = 64M #OTHER tmp_table_size = 32M max_heap_table_size = 32M query_cache_type = 0 query_cache_size = 00 max_connections = 500 max_connect_errors = 500 thread_cache_size = 50 table_open_cache = 800 open_files_limit = 65535 innodb_force_recovery = 0 My.cnf Spoiler #INNODB innodb_buffer_pool_size = 200M innodb_log_file_size = 100M innodb_file_per_table=1 innodb_flush_method = O_DIRECT #MyISAM key_buffer_size = 75M #OTHER tmp_table_size = 35M max_heap_table_size = 335M query_cache_type = 0 query_cache_size = 00 max_connections = 500 max_connect_errors = 150 thread_cache_size = 50 table_open_cache = 800 open_files_limit = 65535 innodb_force_recovery = 0 ========== NOT TESTED ========== 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now