Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- bulk_insert_buffer_size=64M
- datadir="/home/mysql"
- innodb_additional_mem_pool_size=16M
- innodb_buffer_pool_size=24G
- innodb_buffer_pool_instances=4
- innodb_file_per_table=1
- innodb_log_file_size=256M
- join_buffer_size=128M
- key_buffer_size=32M
- log-warnings=10
- max_allowed_packet=128M
- max_connect_errors=10
- max_connections=1000
- max_heap_table_size=512M
- myisam_repair_threads=1
- myisam_sort_buffer_size=128M
- query_cache_limit=2M
- query_cache_size=128M
- query_cache_type=1
- read_buffer_size=8M
- read_rnd_buffer_size=16M
- sort_buffer_size=128M
- thread_cache_size=32
- thread_pool_size = 32
- thread_concurrency=4
- tmpdir="/tmp"
- tmp_table_size=512M
- open_files_limit = 65535
- table_definition_cache = 8000
- table_open_cache = 8000
- innodb_read_io_threads = 12
- innodb_write_io_threads = 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement