MYSQL應用
SELECT * FROM tbl_name 
Select * from tbl_name

MYSQL應用
mysql> SHOW VARIABLES LIKE '%query_cache%'; 

MYSQL應用
+------------------------------+---------+ 
| Variable_name        | Value  | 
+------------------------------+---------+ 
| have_query_cache       | YES   | --查詢緩存是否可用 
| query_cache_limit      | 1048576 | --可緩存具體查詢結果的最大值 
| query_cache_min_res_unit   | 4096  |  
| query_cache_size       | 599040 | --查詢緩存的大小 
| query_cache_type       | ON   | --阻止或是支持查詢緩存 
| query_cache_wlock_invalidate | OFF   |  
+------------------------------+---------+ 

MYSQL應用
[mysql@csdba1850 ~]$ mysql -u root -p 

MYSQL應用
Enter password:  
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 3 
Server version: 5.0.45-community MySQL Community Edition (GPL) 
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 

MYSQL應用
mysql> set global query_cache_size = 600000; --設置緩存內存 

MYSQL應用
Query OK, 0 rows affected (0.00 sec) 

MYSQL應用
mysql> set session query_cache_type = ON; --開啟查詢緩存 

MYSQL應用
Query OK, 0 rows affected (0.00 sec) 

MYSQL應用
 
mysql> use test 

MYSQL應用
Reading table information for completion of table and column names 
You can turn off this feature to get a quicker startup with -A 
 
Database changed 

MYSQL應用
mysql> show tables; 

MYSQL應用
+----------------+ 
| Tables_in_test | 
+----------------+ 
| animals    |  
| person     |  
+----------------+ 
5 rows in set (0.00 sec) 
 
mysql> select count(*) from animals; 
+----------+ 
| count(*) | 
+----------+ 
|    6 |  
+----------+ 
1 row in set (0.00 sec) 
 
--Qcache_hits表示sql查詢在緩存中命中的累計次數,是累加值. 

MYSQL應用
mysql> SHOW STATUS LIKE 'Qcache_hits'; 

MYSQL應用
+---------------+-------+ 
| Variable_name | Value | 
+---------------+-------+ 
| Qcache_hits  | 0   | --0次 
+---------------+-------+ 
8 rows in set (0.00 sec) 
 
mysql> select count(*) from animals; 
+----------+ 
| count(*) | 
+----------+ 
|    6 |  
+----------+ 
1 row in set (0.00 sec) 

MYSQL應用
mysql> SHOW STATUS LIKE 'Qcache%'; 

MYSQL應用
+---------------+-------+ 
| Variable_name | Value | 
+---------------+-------+ 
| Qcache_hits  | 1   | --表示sql在緩存中直接得到結果,不需要再去解析 
+---------------+-------+ 
8 rows in set (0.00 sec) 

MYSQL應用
mysql> select count(*) from animals; 

MYSQL應用
+----------+ 
| count(*) | 
+----------+ 
|    6 |  
+----------+ 
1 row in set (0.00 sec) 

MYSQL應用
mysql> select count(*) from animals; 

MYSQL應用
+----------+ 
| count(*) | 
+----------+ 
|    6 |  
+----------+ 
1 row in set (0.00 sec) 

MYSQL應用
mysql> SHOW STATUS LIKE 'Qcache_hits'; 

MYSQL應用
+---------------+-------+ 
| Variable_name | Value | 
+---------------+-------+ 
| Qcache_hits  | 3   |  --上面的sql也是是從緩存中直接取到結果 
+---------------+-------+ 
1 row in set (0.00 sec) 

MYSQL應用
 
mysql> insert into animals select 9,'testsds' ; --插入數據后,跟這個表所有相關的sql緩存就會被清空掉 

MYSQL應用
Query OK, 1 row affected (0.00 sec) 
Records: 1 Duplicates: 0 Warnings: 0 

MYSQL應用
 
mysql> select count(*) from animals; 

MYSQL應用
+----------+ 
| count(*) | 
+----------+ 
|    7 |  
+----------+ 
1 row in set (0.00 sec) 

MYSQL應用
 
mysql> SHOW STATUS LIKE 'Qcache_hits'; 

MYSQL應用
+---------------+-------+ 
| Variable_name | Value | 
+---------------+-------+ 
| Qcache_hits  | 3  | --還是等于3,說明上一條sql是沒有直接從緩存中直接得到的 
+---------------+-------+ 
1 row in set (0.00 sec) 

MYSQL應用
mysql> select count(*) from animals; 

MYSQL應用
+----------+ 
| count(*) | 
+----------+ 
|    7 |  
+----------+ 
1 row in set (0.00 sec) 

MYSQL應用
mysql> SHOW STATUS LIKE 'Qcache_hits';  

MYSQL應用
+---------------+-------+ 
| Variable_name | Value | 
+---------------+-------+ 
| Qcache_hits  | 4   |  
+---------------+-------+ 
1 row in set (0.00 sec)