[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock performance-schema=0 symbolic-links=0 log-error=/var/log/mysqld.log innodb_buffer_pool_size=134217728 max_allowed_packet=5998435456 open_files_limit=10000 innodb_file_per_table=1 local-infile=0 sql_mode="" bind-address = 0.0.0.0 tmpdir =/dev/shm max_connections = 650 max_user_connections=300 key_buffer_size = 512M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 256K table_open_cache=4000 thread_cache_size = 384 wait_timeout = 100 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M #max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 7M query_cache_size = 64M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 16 #default-storage-engine=MyISAM unix_socket=OFF [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key-buffer-size=384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M