Good performance Mysql, my.cnf

[TekkForCeAD2 199]

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

[ds_aim 263]

You are sure about that ?

Just install mysqltuner and post here the results.

[IceShiva 183]

it depends... What hardware youre using

[[007]DawisHU 352]

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 ==========