MySql5.6 adjust the buffer and query cache size

I have been searching for a long time on the Internet. They are all configuration files in linux. The original configuration files in windows are in my. ini: you only need to change the parameters you want to configure. You can just remove the preceding comments and write them clearly in the file. In fact, an important parameter is innodb_buffer_pool_size, size adjusted to 50% of memory

I have been searching for a long time on the Internet. They are all configuration files in linux. The original configuration files in windows are in my. ini: you only need to change the parameters you want to configure. You can just remove the preceding comments and write them clearly in the file. In fact, an important parameter is innodb_buffer_pool_size, size adjusted to 50% of memory

I have been searching for a long time on the Internet. They are all configuration files in linux. The original configuration files in windows are in my. ini under the mysql installation directory,

You only need to change the parameters you want to configure and remove the preceding comments. The file is clearly written,

In fact, an important parameter is innodb_buffer_pool_size. It is good to adjust the size to 50%-80% of the memory.

The default size of the query cache is 2 MB, which is not as large as possible. Because it is a connection-level parameter, excessive settings + high concurrency may exhaust system memory resources. For example, 500 connections consume 500 * sort_buffer_size (8 M) = 4G memory.

My system is winxp with 4 GB memory. The original query cache configuration when Mysql is installed is:

Mysql> show variables like 'query _ cache _ % ';
+ ------------------------------ + --------- +
| Variable_name | Value |
+ ------------------------------ + --------- +
| Query_cache_limit | 1048576 |
| Query_cache_min_res_unit | 4096 |
| Query_cache_size | 0 |
| Query_cache_type | OFF |
| Query_cache_wlock_invalidate | OFF |
+ ------------------------------ + --------- +
5 rows in set


Mysql> show status like 'qcache % ';
+ ------------------------- + ------- +
| Variable_name | Value |
+ ------------------------- + ------- +
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
+ ------------------------- + ------- +

After Configuration:

Mostly configured according to this article: http://blog.csdn.net/txwcan999/article/details/2217435

References:

Query cache for MySQL-yaya888-ChinaUnix blog
Http://blog.chinaunix.net/uid-570310-id-2734848.html

Mysql cache query and setting global query_cache_size _ Baidu Library
Http://wenku.baidu.com/link? Url = e8E3W5_OjHKSai3UJPkROFn4mQOJZgvBmu_BKeMVmd3UZdAAbrq80PGUUAmJrzyFDH9WqFhNzeiq6EXsjUIPoO9Z5UVJ-C4vwYuWdM9nl9W

How to adjust MySQL Query Buffer-MySQL performance and Optimization-TechTarget Database
Http://www.searchdatabase.com.cn/showcontent_42327.htm

Five categories of MySQL parameter settings-xp system home, Windows 7 system download, Windows 7 flagship version, latest computer system download
Http://www.ezit.com.cn/article/html/3008.html

InnoDB Chinese Reference Manual --- dog and dog (xinfan) Translation
Http://man.chinaunix.net/database/mysql/inonodb_zh/2.htm

Mysql Service Performance Optimization-my. cnf configuration description (16 GB memory) _ Linux system O & M-professional linux O & M learning and communication community
Http://www.linuxyw.com/a/shujuku/20130506/216.html

Dynamic Modification of MYSQL configuration parameters-floating white-blog channel-CSDN. NET
Http://blog.csdn.net/turkeyzhou/article/details/5741626

MySQL parameter adjustment _ Old Wang Technical Manual (my new blog: http://huoding.com) _ Baidu Space
Http://hi.baidu.com/thinkinginlamp/item/69595079339dab346cc37c6d

Understanding and summary of MySql query cache and SQL Server process cache-JeffWong-blog
Http://www.cnblogs.com/jeffwongishandsome/p/3235177.html

MySQL parameter optimization | P. Linux Laboratory
Http://www.penglixun.com/tech/database/mysql_parameter_tuning.html

MYSQL buffer and cache settings-website creation
Http://database.jzxue.com/mysql/200910/20-2982.html