[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