[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 #log=/var/log/mysql-queries.log log_slow_queries=/var/log/mysqld_slow.log long_query_time=2 #log-queries-not-using-indexes connect_timeout=15 interactive_timeout=100 key_buffer=348M max_allowed_packet=16M max_connections=500 max_connect_errors=10 myisam_sort_buffer_size=96M max_heap_table_size = 348M tmp_table_size=348M concurrent_insert = 2 low_priority_updates = 1 sort_buffer_size=5M read_buffer_size=5M join_buffer_size=5M read_rnd_buffer_size=8M table_cache=2048 thread_cache_size=200 thread_concurrency=4 wait_timeout=60 query_cache_type=1 query_cache_limit=1M query_cache_size=32M #skip-innodb #innodb_buffer_pool_size = 1024M skip-locking skip-name-resolve [mysql.server] user=mysql #basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/lib/mysql/localhost.localdomain.pid