my.cnf

my.cnf

[mysqld]
max_allowed_packet=268435456
open_files_limit=10000
local-infile=0
innodb_file_per_table=1

max_connections =256

query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 256K
#32-64mb ,2x mysqltuner recomendation
tmp_table_size = 512M
max_heap_table_size = 512M
thread_cache_size = 4
table_cache = 2000
#4 x dari table_cache
table_definition_cache = 8000
#3 x dari table_definition_cache
innodb_buffer_pool_size = 512M
max_allowed_packet = 16M

innodb_log_file_size = 5M

innodb_buffer_pool_size = 1GB
innodb_buffer_pool_instances = 1

#log slow query

#long_query_time = 1
#log-slow-queries = /var/log/mysql/log-slow-queries.log


#long_query_time = 1
#log-slow-queries=/var/log/log-slow-queries.log