Shulou(Shulou.com)06/01 Report--

[client] port = 3306 # specify mysql startup port 3306socket = / application/mysql-5.5.32/tmp/mysql.sock # # specify socket path [mysqld] port = 3306socket = / application/mysql-5.5.32/tmp/mysql.sockback_log = 50 max_connections = 100 max_connect_errors = 10 table_open_cache = 2048 max_allowed_ Packet = 16m binlog_cache_size = 1m max_heap_table_size = 64m read_buffer_size = 2m read_rnd_buffer_size = 16m sort_buffer_size = 8m join_buffer_size = 8m thread_cache_size = 8 thread_concurrency = 8 query_cache_size = 64m query_cache_limit = 2m ft_min_word_len = 4 default-storage-engine = MYISAM thread_stack = 19K Transaction_isolation = REPEATABLE-READtmp_table_size = 64m log-bin=mysql-bin binlog_format=mixed slow_query_log long_query_time = 2 server-id = 1 key_buffer_size = 32m Bulk_insert_buffer_size = 64m myisam_sort_buffer_size = 128m myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover innodb_additional_mem_pool_size = 16m innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_write_io_threads = 8 Innodb_read_io_threads = 8 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8m innodb_log_file_size = 256m innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 [mysqldump] quickmax_allowed_packet = 16m [mysql] no-auto- rehash [myisamchk] key_buffer_size = 512Msort_buffer_size = 512Mread_buffer = 8Mwrite_buffer = 8m [mysqlhotcopy] interactive- timeout [mysqld _ safe] open-files-limit = 8192

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.