![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
l19861025
这个作者很懒,什么都没留下…
展开
-
Buffering and Caching
8.9 Buffering and Caching8.9.1 The InnoDB Buffer Pool8.9.2 The MyISAM Key Cache8.9.3 The MySQL Query Cache8.9.4 Caching of Prepared Statements and Stored ProgramsMySQL uses several s转载 2014-08-02 22:48:49 · 553 阅读 · 0 评论 -
3.6.9 Using AUTO_INCREMENT
3.6.9 Using AUTO_INCREMENTThe AUTO_INCREMENT attribute can be used to generate a unique identity for new rows:CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR转载 2014-08-02 21:53:29 · 326 阅读 · 0 评论 -
8.9.3 The MySQL Query Cache
8.9.3 The MySQL Query Cache8.9.3.1 How the Query Cache Operates8.9.3.2 Query Cache SELECT Options8.9.3.3 Query Cache Configuration8.9.3.4 Query Cache Status and MaintenanceThe query ca转载 2014-08-03 09:37:08 · 436 阅读 · 0 评论 -
一个简单的sql优化
Simple optimizationsYou can sometimes use MyISAM’s COUNT(*) optimization to your advantage when youwant to count all but a very small number of rows that are well indexed. The followingexample ...原创 2014-04-21 13:09:49 · 94 阅读 · 0 评论 -
优化groupby 和distinct
Optimizing GROUP BY and DISTINCTMySQL optimizes these two kinds of queries similarly in many cases, and in fact con-verts between them as needed internally during the optimization process. Both t...原创 2014-04-21 13:43:58 · 509 阅读 · 0 评论