[client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock key_buffer = 8192M max_connections=400 max_user_connections=200 max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 8196M read_buffer_size = 1024M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 8196M thread_cache_size = 16 query_cache_size=0 thread_concurrency = 8 innodb_additional_mem_pool_size = 128M innodb_buffer_pool_size = 128M innodb_log_buffer_size = 256M innodb_log_file_size = 256M innodb_thread_concurrency = 10 datadir=/usr/local/var/ #datadir=/var/lib/mysql/