mysql my-innodb-heavy-4g.cnf_my-innodb-heavy-4G.cnf配置文件说明

  • Post author:
  • Post category:mysql


[client]                   port  = 3306               socket  = /application/mysql-5.5.32/tmp/mysql.sock[mysqld]port  = 3306               socket  = /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 = 192K                    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



版权声明:本文为weixin_39725154原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。