mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2025-12-31 05:27:55 -05:00
33 lines
800 B
INI
33 lines
800 B
INI
[mysqld]
|
|
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
|
|
|
|
key_buffer = 16M
|
|
max_allowed_packet = 1M
|
|
|
|
tmp-table-size = 32M
|
|
max-heap-table-size = 32M
|
|
query_cache_limit = 4M
|
|
query_cache_size = 32M
|
|
query_cache_type = ON
|
|
log_slow_queries = OFF
|
|
innodb_buffer_pool_size = 56M
|
|
innodb_log_file_size = 15M
|
|
thread_cache_size = 4
|
|
expire_logs_days = 10
|
|
max_binlog_size = 100M
|
|
innodb_file_per_table = 1
|
|
myisam_sort_buffer_size = 8M
|
|
read_rnd_buffer_size = 512K
|
|
net_buffer_length = 8K
|
|
read_buffer_size = 256K
|
|
sort_buffer_size = 4M
|
|
table_cache = 64
|
|
key_buffer_size = 16M
|
|
|
|
[isamchk]
|
|
key_buffer = 16M
|
|
write_buffer = 2M
|
|
read_buffer = 2M
|
|
sort_buffer_size = 20M
|
|
key_buffer_size = 20M
|