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

[client]                            ### #客户端配置port = 3306                  ### #mysql连接时默认的端口号                 socket= /tmp/mysql.sock       ### #用于连接mysql [mysqld]                             ### #服务端配置port = 3306                  ### #mysql服务默认监听的端口socket = /tmp/mysql.sock      #### For connecting mysqlback_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 per host run table_open_cache = 2048             ### #所有线程打开表的数字, the size of the file descriptor max_allowed_packet = 16m            ### #服务器一次能够处理的最大查询包的值 is also the maximum query that the server can handle binlog_cache_size = 1m              ### #在一个事务中, binary logs can handle the maximum cache value of an SQL statement, and if complex transactions are frequently used, This value can be increased for better performance, all statements in the transaction are cached into the binlog, and a one-time commit is written to the binary log immediately, and if the transaction is larger than this value, the temporary file on the disk is replaced, and the buffer is changed in the first state of the transaction. are assigned to each connection max_heap_table_size = 64m          #### Maximum capacity allowed for stand-alone memory tables READ_BUFFER_SIZE =&Nbsp;2m              #### MySQL read-in buffer size read_rnd_buffer_size = 16m         #### MySQL Random read buffer size sort_buffer_size = 8m               ### #排序缓冲被用来处理类似ORDER  by and Group by queues are caused by the sort join_buffer_size = 8m               ### #联合查询所能使用的缓冲区大小, This parameter corresponds to the allocated memory that is exclusive to each connection thread_cache_size = 8               ### #在cache保留多少线程用于重用thread_concurrency  = 8              ### #允许应用程序给予线程系统一个提示在同一时间给予渴望被运行的线程数量query_cache_size  =  64m             ### #查询缓冲区的大小, Query buffers are commonly used to buffer the results of a select and are not executed directly when the next query is performed QUERY_CACHE_LIMIT&NBSp;= 2m             #### Only results that are smaller than this set value are buffered ft_min_word_len = 4                 ### #被全文检索索引最小的字长default-storage-engine = myisam     ### #创建新表时默认使用的表类型thread_stack  = 192K                 ### #线程使用的堆大小, the memory of this capacity is reserved for each connection transaction_isolation =  repeatable-read    ### #数据库的隔离级别tmp_table_size  = 64M                ### #内部 (in-memory) the maximum size of the temporary table log-bin=mysql-bin                   #### Turn on the binary log function binlog_format=mixed                 ### #设定记录二进制日志的格式, there are 3 formats, based on the statement statement,Row row, mixed-mode mixedslow_query_log                      ### #记录慢查询long_query_time  = 2                 ### #所有超过这个参数的请求都将被作为慢查询server-id  = 1                       ### #唯一的服务标识号, the value between 2^32-1, this value in the primary server and from the server is required to set, the default parameter is 1, if the host does not need to set, and ignore this option, MySQL does not take effect as master key_buffer_size = 32m               ### #关键词的缓冲大小, commonly used to buffer the index block of a MyISAM table bulk_insert_buffer_size = 64m       ### #MyISAM使用特殊的类似树的cache来使得突发插入更快, this variable restricts the bytes of the buffer tree in each process myisam_sort_buffer_size =  128m     ### #当需要对于执行PERAIR, OPTIMIZE, alter statements when rebuilding the index, MySQL allocates this cache, and load data  InFile will be loaded into a new table, and he will carefully assign each of them according to the maximum configurationA thread myisam_max_sort_file_size = 10g    ### #当重建索引PERAIR, OPTIMIZE, ALTER, LOAD, DATA, infile, 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                      #### Automatic check and repair of MyISAM tables without proper shutdown innodb_additional_mem_pool_size = 16m   #### To set the memory pool size for InnoDB stored data directory information and other internal data structures, the more tables you have in your application, the more memory you need to allocate here innodb_buffer_pool_size = 2g        ### #InnoDB使用一个缓冲池来保存索引和原始数据, the larger the setting, the less disk I/O is required to access the data inside innodb_data_file_path =  ibdata1:10m:autoextend    ### #InnoDB将数据保存在一个或多个数据文件中成为表空间innodb_write_io_threads  = 8        ### #用来同步IO操作的IO线程数量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's calling program, and too high a value will certainly cause thread jitter innodb_flush_log_at_trx_commit = 1 #### If set to 1,innodb, the transaction log is flushed (Fsync) to disk after each commit innodb_log_buffer_size = 8m         ### #用来缓冲日志数据的缓冲大小innodb_log_file_size  = 256M         ### #日志组中每个日志文件的大小innodb_log_files_in_group  = 3      ### #日志文件的总量   General 2-3 enough innodb_max_dirty_pages_pct = 90    #### The scale of the maximum allowable dirty pages in the InnoDB buffer pool is 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           #### Number of open files allowed per program

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