#skip-innodb
[mysqld]
performance-schema=0
#socket=/path/to/mysql.sock
#datadir=/var/lib/mysql
skip-external-locking
local-infile=0
# MySQL 4.x has query caching available.
# Enable it for vast improvement and it may be all you need to tweak.
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
max_connections=60
interactive_timeout=300
wait_timeout=300
connect_timeout=100
table_open_cache=512
# thread_cache=32
max_allowed_packet=268435456
open_files_limit=40000
innodb_file_per_table=1
[mysqldump]
quick
max_allowed_packet = 2M
[mysql]
no-auto-rehash
[isamchk]
key-buffer-size=50M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key-buffer-size=4M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 4M
sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
