本文共 1044 字,大约阅读时间需要 3 分钟。
[mysqld] port = 3306 ;socket = /tmp/mysql.sock log-error=/var/log/mysql-error.log slow_query_log=1 ;log_queries_not_using_indexes=1 ;log-slow-queries=/var/log/mysql-slow.log ;log_slow_queries=1 ;slow_query_log_file=/var/log/mysql-slow.log ;long_query_time=10 log-output=FILE slow_query_log_file=/var/log/mysql-slow.log ;long-query-time=10 skip-external-locking table_open_cache = 2048 max_allowed_packet = 1024M table_definition_cache = 1024 max_connections = 1000 max_connect_errors = 10 max_heap_table_size =64M sort_buffer_size = 8M join_buffer_size = 1M thread_cache_size = 64 thread_concurrency = 24 query_cache_size = 256M query_cache_limit = 4M tmp_table_size = 1024M key_buffer_size = 256M read_buffer_size = 2M read_rnd_buffer_size = 16M bulk_insert_buffer_size= 64M myisam_sort_buffer_size = 128M myisam_max_sort_file_size = 256M myisam_repair_threads = 1 myisam_recover innodb_additional_mem_pool_size = 1024M innodb_log_buffer_size = 256M innodb_log_file_size = 1024M innodb_buffer_pool_size = 24G [mysqlhotcopy] interactive-timeout转载地址:http://undli.baihongyu.com/