看看当前缓存中有多少条信息代码,MYSQL代码库,德仔网

代码语言

代码分类

【MYSQL】看看当前缓存中有多少条信息

作者:曾祥展 / 发布于2011/3/15/ 1269

<div>MySQL> show status like 'qcache_q%'; 
+-------------------------+-------+ 
| Variable_name | Value | 
+-------------------------+-------+ 
| Qcache_queries_in_cache | 0 | 
+-------------------------+-------+ 
1 row in set (0.00 sec) 
MySQL> select sql_cache id, title, body from article; 
MySQL> show status like 'qcache_q%'; PhP100.Com 
+-------------------------+-------+ 
| Variable_name | Value | 
+-------------------------+-------+ 
| Qcache_queries_in_cache | 1 | 
+-------------------------+-------+ 
1 row in set (0.00 sec) 
MySQL> show status like 'qcache_f%'; 
+--------------------+----------+ 
| Variable_name | Value | 
+--------------------+----------+ PhP100.cOm 
| Qcache_free_blocks | 1 | 
| Qcache_free_memory | 16766728 | 
+--------------------+----------+ 
2 rows in set (0.00 sec) 
</div>

试试其它关键字

　缓存　

同语言下

可能有用的

曾祥展贡献的其它代码(13)