...
| Code Block |
|---|
[mysqld]
# Set timeouts
wait_timeout = 230400
interactive_timeout = 230400
# use a file per table (easier to manage space this way)
innodb_file_per_table
# memory usage (make as big as you can)
innodb_buffer_pool_size=512M
# flushes once per second rather than every commit
innodb_flush_log_at_trx_commit=0
# Log file settings
innodb_log_buffer_size=8M
innodb_log_file_size=1024M
# disable the query cache
query_cache_size=0
# make sure tables are not case-sensitive
lower_case_table_names=1
# this is mostly for importing mysql dump data, packets may be very large
max_allowed_packet = 32M |
...