MySQL数据库的查询缓存机制(2)_MySQL数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

MySQL数据库的查询缓存机制(2)

作者:黑客防线网安MYSQL维护基地 来源:黑客防线网安MYSQL维护基地 浏览次数:0

本篇关键词:机制查询数据库
黑客防线网安网讯:  +---------------+-------+ 8 rows in set (0.00 sec) mysql>  select count(*) from animals; +----------+ | count(*) | +----------+ |        6 |  +----------+ 1 row in set (0.0...

  +---------------+-------+
8 rows in set (0.00 sec)

mysql>  select count(*) from animals;
+----------+
| count(*) |
+----------+
|        6 | 
+----------+
1 row in set (0.00 sec)

mysql>  SHOW STATUS LIKE ’Qcache%’;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Qcache_hits   | 1     | --表示sql在缓存中直接得到结果不需要再去解析
+---------------+-------+
8 rows in set (0.00 sec)

mysql> select count(*) from animals;
+----------+
| count(*) |
+----------+
|        6 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from animals;
+----------+
| count(*) |
+----------+
|        6 | 
+----------+
1 row in set (0.00 sec)

mysql> SHOW STATUS LIKE ’Qcache_hits’;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Qcache_hits   | 3     |    --上面的sql也是是从缓存中直接取到结果
+---------------+-------+
1 row in set (0.00 sec)

mysql> insert into animals select 9,’testsds’ ; --插入数据后跟这个表所有相关的sql缓存就会被清空掉
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> select count(*) from animals;
+----------+
| count(*) |
+----------+
|        7 | 
+----------+
1 row in set (0.00 sec)

mysql> SHOW STATUS LIKE ’Qcache_hits’;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Qcache_hits   | 3    |  --还是等于3,说明上一条sql是没有直接从缓存中直接得到的
+---------------+-------+
1 row in set (0.00 sec)

mysql> select count(*) from animals;
+----------+
| count(*) |
+----------+
|        7 | 
+----------+
1 row in set (0.00 sec)

mysql> SHOW STATUS LIKE ’Qcache_hits’; 
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Qcache_hits   | 4     | 
+---------------+-------+
1 row in set (0.00 sec)

    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-8996-1.html
网站维护教程更新时间:2012-03-20 16:50:08  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer