MY-INNODB-HEAVY-4G.CNF configuration file annotations

[client]                    ### #客户端port   = 3306                ### #mysql客户端连接时的默认端口号socket   = /application/mysql-5.5.32/tmp/ mysql.sock[mysqld]port  = 3306                ### #mysql服务器监听的默认端口socket   = /application/mysql-5.5.32/tmp/ mysql.sockback_log = 50               ### #是指保持在操作系统监听队列的连接数量, that is, the number of connections before the MySQL Connection Manager thread processes them max_connections = 100       ### #MySQL允许的并发会话的最大数量max_connect_errors  = 10    #### Maximum number of errors allowed per host table_open_cache = 2048    ### #所有线程打开表的数字, file descriptor size Max_allowed_ packet = 16m   ### #服务器一次能The value of the largest query package processed, and also the maximum query that the server program can handle binlog_cache_size = 1m     ### #在一个事务中, The binary log can handle the maximum number of cached SQL statements, and if you frequently use complex statement transactions, you can increase this value for better performance, and all statements in the transaction are cached in Binlog and written to the binary log immediately after a one-time commit. If the transaction is larger than this value, the temporary file on the disk is replaced with a buffer that is allocated on each link when the transaction first changes state. max_heap_table_size = 64m  ### #独立的内存表所允许的最大容量read_buffer_size  = 2M       ### #MySql读入缓冲区大小. read_rnd_buffer_size = 16m ### #是MySql的随机读缓冲区大小. sort_buffer_size = 8m      ####  sort buffers are used to handle similar order by and group The  by queue causes the sort join_buffer_size = 8m      ### #此缓冲被使用来优化全联合 (full  joins  Union without index). thread_cache_size = 8      #### How many threads we keep in the cache for reuse thread_concurrency = 8     #### This allows the application to give the thread system a hint at the same time to give the desired number of threads that are running. query_cache_size = 64m     ### #查询缓冲的大小. Query buffering is often used to buffer the results of  SELECT  andAnd no direct return results will be executed the next time the same query is performed. query_cache_limit = 2m     ### #只有小于此设定值的结果才会被缓冲ft_ min_word_len = 4        ####  The smallest word length of the index that is retrieved by the full text. default-storage-engine = myisam        #### The table type that is used as the default when creating a new table thread_stack = 192k                     ### #线程使用的堆大小 .  Memory of this capacity is reserved for each connection Transaction_ isolation = repeatable-readtmp_table_size = 64m                    ### #内部 (in-memory) the maximum size of the temporary table Log-bin=mysql-bin                        ### #打开二进制日志功能 .binlog_format=mixed                     ### #设定记录二进制日志的格式, available in three formats, based on statement  statement,   line  row,   blending  mixedslow_query_log                           ### #记录慢查询,long_query_time = 2                     #### All requests over this parameter time will be used as slow queries server-id = 1                           ### #唯一的服务标识号, it is valued at 1 to Between  2^32-1, this value is required to be set on the primary server and from the server. His default parameter is 1, if the host does not need to be set, but if this option is ignored, MySQL will not be effective as Master . key_buffer_size = 32m                   ### #关键词缓冲的大小,  An index block that is typically used to buffer MyISAM tables. bulk_insert_buffer_size = 64m           ### #MyISAM   Use special tree-like caches to make burst insertions, (these insertions are, insert ... select, insert ... values   (...),  (...), ...,  and  load data infile)   faster .  This variable limits the number of bytes in the buffer tree in each process .  myisam_sort_buffer_size = 128m         #### When you need to rebuild the index for the execution of the repair, optimize, alter  statement, MySQL allocates the cache, and load data infile loads into a new table. It will be carefully allocated according to the maximum configuration of each thread.  myisam_max_sort_file_size = 10g        #### When you re-create the index (repair,alter,table, or load,data,tnfile), MySQL is allowed to use the maximum value of the temporary file. myisam_repair_threads = 1               ### #如果一个表拥有超过一个索引, myisam  can use more than one thread to fix them by using parallel sorting .myisam_recover                           ### #自动检查和修复没有适当关闭的  MyISAM  table. innodb_additional_mem_pool_size = 16m  ### #附加的内存池被InnoDB用来保存  metadata  Information innodb_buffer_pool_size  = 2g           ### #InnoDB使用一个缓冲池来保存索引和原始数据,  innodb_data_file_path = ibdata1:10m:autoextend  ### #InnoDB   Saving data in one or more data files becomes a tablespace .innodb_write_io_threads = 8         innodb_read_io_threads = 8              ### #用来同步IO操作的IO线程的数量 .innodb_thread_concurrency = 16          ### #使用InnoDB引擎, the number of threads allowed by the kernel, the best value depends on the application, the hardware, and the operating system scheduler. A value that is too high will certainly cause thread jitter. innodb_flush_log_at_trx_commit = 1     ### #如果设置为1  ,innodb will refresh after each commit ( Fsync) transaction log to disk,innodb_log_buffer_size = 8m             ### #用来缓冲日志数据的缓冲区的大小. innodb_log_file_size = 256m            ### #在日志组中每个日志文件的大小, Innodb_log_files_in_ group = 3          ### #在日志组中文件的总量, usually 2-3 is enough innodb_ max_dirty_pages_pct = 90        #### The scale of the maximum allowable dirty pages in the InnoDB buffer pool .innodb_lock_wait_timeout = 120          ### #在被回滚前, how long a InnoDB transaction should wait for a lock to be approved. [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                ### #每个程序允许打开文件的数量

From the old boy 26 students: http://zhangchuang.blog.51cto.com/10884116/1723406

This article is from the "Old boy Linux ops" blog, please be sure to keep this source http://oldboy.blog.51cto.com/2561410/1726517

MY-INNODB-HEAVY-4G.CNF configuration file annotations