Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- # LBU TUNE
- query_cache_limit=2M
- query_cache_size=48M
- query_cache_type=1
- max_connections=1800
- interactive_timeout=600
- wait_timeout=600
- connect_timeout=20
- thread_cache_size=128
- key_buffer=256M
- join_buffer=2M
- max_allowed_packet=16M
- table_cache=2048
- sort_buffer_size=4M
- read_buffer_size=4M
- max_connect_errors=30
- # Try number of CPU's*2 for thread_concurrency
- thread_concurrency=4
- myisam_sort_buffer_size=64M
- server-id=1
- slow_query_log=/var/log/mysqld.slow.log
- long_query_time=2
- innodb_buffer_pool_size = 1024M
- innodb_log_file_size = 250M
- #innodb_flush_log_at_trx_commit = 0
- innodb_flush_log_at_trx_commit = 0
- innodb_flush_method=O_DIRECT
- expire_logs_days = 3
- max_binlog_size = 512M
- innodb_file_per_table = 1
- innodb_file_per_table
- innodb_data_home_dir =
- innodb_data_file_path=/mysql/mysql/ibdata1:250M;/mysql/mysql/ibdata2:250M:autoextend
- datadir=/mysql/mysql/
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- [mysqldump]
- quick
- max_allowed_packet=32M
- [isamchk]
- key_buffer=64M
- sort_buffer=64M
- read_buffer=16M
- write_buffer=16M
- [myisamchk]
- key_buffer=64M
- sort_buffer=64M
- read_buffer=16M
- write_buffer=16M
- [mysqlhotcopy]
- interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment