| 1234567891011121314151617181920212223242526272829303132333435 |
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- symbolic-links=0
- max_connections=70
- max_user_connections=30
- wait_timeout=10
- interactive_timeout=50
- long_query_time=5
- #log-queries-not-using-indexes
- #log-slow-queries=/var/log/mysql/log-slow-queries.log
- key_buffer = 16M
- myisam_sort_buffer_size = 32M
- join_buffer_size=1M
- read_buffer_size=1M
- sort_buffer_size=2M
- table_cache=1024
- thread_cache_size=286
- interactive_timeout=25
- connect_timeout=5
- max_allowed_packet=1M
- max_connect_errors=1000
- query_cache_limit=1M
- query_cache_size=8M
- query_cache_type=1
- tmp_table_size=16M
- #innodb_use_native_aio = 0
- innodb_file_per_table
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
|
