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

For global_buffers, it can be understood as the SGA of Oracle, which is used to cache data blocks retrieved from data files in memory, which can greatly improve the performance of querying and updating data, including the following parameters.

1 、 innodb_buffer_pool_size

This parameter is the core parameter of the InnoDB storage engine. The default is 128MB. This parameter should be set to 60-70% of the material memory.

2 、 innodb_addditional_mem_pool_size

This parameter is used to store data dictionary information and other internal data structures, and the more tables you have, the more memory you need. If InnoDB runs out of memory in this pool, InnoDB begins to allocate memory from the operating system and writes alarm messages to the MySQL error log. The default is 8MB, which is generally set to 16MB.

3 、 innodb_log_buffer_size

The buffer used by the transaction log. When InnoDB writes the transaction log, in order to improve performance, it first writes the information to innodb_log_buffer_size, and then writes the log to a file or disk when the corresponding conditions set by the innodb_flush_log_trx_commit parameter are met. The default is 8MB, which is generally set to 16-64MB.

4 、 key_buffer_size

This parameter is used to cache the index parameters of the MyISAM storage engine, usually 64MB.

5 、 query_cache_size

Cache parameters for select statements and result set size.

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.