Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- datadir=/disk3/mysql
- performance-schema=0
- table_definition_cache=2000
- table_open_cache=3000
- open_files_limit=50000
- innodb_buffer_pool_instances=16
- innodb_buffer_pool_size=60G
- innodb_log_file_size=1G
- innodb_log_buffer_size=256M
- innodb_file_per_table=1
- innodb_stats_on_metadata=OFF
- innodb_purge_threads=8
- table_open_cache_instances=16
- open_files_limit=30000
- default_storage_engine=InnoDB
- max_allowed_packet=268435456
- myisam_sort_buffer_size=64M
- key_buffer_size=1G
- join_buffer_size=256k
- tmp_table_size=576M
- max_heap_table_size=576M
- max_connections=600
- slow-query-log=1
- slow-query-log-file=/output/mysql-slow.log
- long_query_time=1
- log_warnings=2
- query_cache_type=OFF
- query_cache_size=0
- expire_logs_days=5
- sort_buffer_size=2M
- innodb_io_capacity_max=10000
- innodb_io_capacity=5000
- innodb_lru_scan_depth=100
- thread_cache_size=100
- innodb_flush_neighbors=0
- query_cache_limit=1024
- key_cache_age_threshold=64800
- max_write_lock_count=16
- thread_concurrency=30
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement