[mysqld]

default-storage-engine=MyISAM

innodb_file_per_table=1
innodb_buffer_pool_size = 1500M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_instances=2

#join_buffer = 1M
key_buffer_size = 1024M
read_buffer_size = 128K
sort_buffer_size = 128K
read_rnd_buffer_size= 256K

myisam_sort_buffer_size=64M
table_open_cache = 2048
table_definition_cache = 2048
max_heap_table_size = 64M
tmp_table_size = 64M


max_connections=500
max_user_connections = 100
max_allowed_packet = 1024M
open_files_limit=50000

query_cache_type=1
query_cache_limit=64M
query_cache_size = 256M
query_cache_type=1
query_prealloc_size=65536
query_alloc_block_size=131072

performance_schema=0
show_compatibility_56 = 1
thread_cache_size = 8
tmpdir="/dev/shm"

sql_mode = "NO_ENGINE_SUBSTITUTION"
log-error = /var/log/mysqld.log
internal_tmp_disk_storage_engine=MyISAM
log_error_verbosity=3

slow_query_log = 1
long_query_time = 10

[mysqld_safe]
# malloc-lib=/usr/lib64/libjemalloc.so.1

[mysqldump]
max_allowed_packet = 1G