Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- local-infile=0
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- long_query_time=1
- log-slow-queries=/var/log/mysql/log-slow-queries.log
- interactive_timeout=180
- wait_timeout=180
- max_connections=100
- innodb_buffer_pool_size=256M
- query_cache_size=256M
- key_buffer_size=256M
- sort_buffer_size=20M
- innodb_flush_log_at_trx_commit=0
- innodb_flush_method=O_DIRECT
- query_cache_type=1
- query_cache_limit=2M
- table_cache=1024
- join_buffer_size=4M
- thread_cache_size=4
- tmp_table_size=40M
- max_heap_table_size=256MB
- user=mysql
- symbolic-links=0
- #bind-address=127.0.0.1
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- [mysqld]
- local-infile=0
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- long_query_time=1
- log-slow-queries=/var/log/mysql/log-slow-queries.log
- interactive_timeout=180
- wait_timeout=180
- max_connections=100
- innodb_buffer_pool_size=256M
- query_cache_size=256M
- key_buffer_size=256M
- sort_buffer_size=20M
- innodb_flush_log_at_trx_commit=0
- innodb_flush_method=O_DIRECT
- query_cache_type=1
- query_cache_limit=2M
- table_cache=1024
- join_buffer_size=4M
- thread_cache_size=4
- tmp_table_size=40M
- max_heap_table_size=256MB
- user=mysql
- symbolic-links=0
- #bind-address=127.0.0.1
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- innodb_buffer_pool_size=256M
- max_heap_table_size=256MB needs to be
- max_heap_table_size=40M # from 256MB to correct MB and match tmp_table_size
Add Comment
Please, Sign In to add comment