[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 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysql.server] user=mysql max_connections=3000 max_connect_errors=10 table_cache=2048 max_allowed_packet=1M binlog_cache_size=1M max_heap_table_size=64M sort_buffer_size=64K join_buffer_size=1M thread_cache=16 thread_concurrency=16 thread_stack=196K query_cache_size=0 ft_min_word_len=4 default_table_type=MYISAM transaction_isolation=REPEATABLE-READ tmp_table_size=64M skip-locking server-id=1 innodb_status_file=0 innodb_data_home_dir=/var/lib/mysql/ innodb_data_file_path=ibdata1:100M:autoextend innodb_log_group_home_dir=/var/lib/mysql/ innodb_buffer_pool_size=500M innodb_additional_mem_pool_size=20M innodb_log_file_size=100M innodb_log_files_in_group=2 innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_lock_wait_timeout=300 innodb_locks_unsafe_for_binlog=1 innodb_thread_concurrency=0