Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- skip-name-resolve
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- log-error=/var/log/mysqld.log
- port=48221
- user=mysql
- old_passwords=0
- max_connections = 400
- table_cache = 2048
- max_allowed_packet = 16M
- sort_buffer_size = 2M
- thread_cache = 8
- thread_concurrency = 32
- query_cache_size = 160M
- query_cache_limit =3M
- #query_cache_type = 0
- default-storage-engine = innodb
- transaction_isolation = REPEATABLE-READ
- tmp_table_size = 256M
- max_heap_table_size = 256M
- #log_slow_queries = 0
- #slow_query_log_file=/var/log/mysqlslow.log
- #long_query_time=1
- innodb_additional_mem_pool_size=48M
- innodb_file_per_table
- innodb_flush_log_at_trx_commit=2
- innodb_log_buffer_size=32M
- innodb_autoinc_lock_mode=2
- innodb_io_capacity=1000
- innodb_read_io_threads=64
- innodb_write_io_threads=64
- innodb_buffer_pool_size = 16000M
- innodb_lock_wait_timeout = 300
- innodb_max_dirty_pages_pct = 90
- innodb_thread_concurrency =0
- #log-bin = /var/log/mysql-bin.log
- #binlog-do-db=lolbin
- #server-id=1
- [mysqldump]
- quick
- single-transaction
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement