CPU Cache
Most CPUs only have Level 1 cache and level 2 cache, and some have Level 3 cache.The cache memory is the temporary memory between the CPU and memory. It has a smaller capacity than the memory but is faster than the memory. The data in the
Query_cache_type How to use query cachingIn general, we will set the Query_cache_type to on, which should be on by defaultMySQL>SELECT@ @query_cache_type; + -- ------------------+ | @ @query_cache_type | + -- ------------------+ | on
1. What is a query cacheMyBatis provides query caching to mitigate database stress and improve database performance.MyBatis provides a first-level cache and a level two cache.The first-level cache is a cache at the sqlsession level. The Sqlsession
Reprint Please specify source: http://www.cnblogs.com/Joanna-Yan/p/6956206.htmlMentioned earlier: Spring+springmvc+mybatis deep learning and Building (vii)--mybatis delay loading1. What is a query cacheMyBatis provides query caching to mitigate
1. The principle of level two caching As described earlier, the level two cache in MyBatis is the mapper level of caching, it is worth noting that different mapper have a level two cache, that is, the different mapper between the two-level cache is
Mysql buffer and cache settings
MySQL Adjustable settings can be applied to the entire mysqld process, or to a single client session.
Server Settings
Each table can be represented as a file on the disk. It must be opened first and then read. To
1. The principle of level two cachingAs described earlier, the level two cache in MyBatis is the mapper level of caching, it is worth noting that different mapper have a level two cache, that is, the different mapper between the two-level cache is
I've been asked a lot of questions about MySQL query cache recently, just sort out the contents of MySQL query cache for reference.As the name implies, MySQL query cache is used for caching and query-related data. Specifically, Query cache caches
1 , table Cacherelated parameters: Table_open_cacheSpecifies the size of the table cache. Whenever MySQL accesses a table, if there is room in the table buffer, the table is opened and put into it, which allows for faster access to the table
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.