mysql数据库参数show status(2007-04-25)

mysql> show status like '%table%';
+-------------------------+----------+
|Variable_name          | Value   |
+-------------------------+----------+
|Com_alter_table        |0       |
|Com_backup_table       |0       |
|Com_create_table       |0       |
|Com_drop_table         |0       |
| Com_load_master_table   |0       |
|Com_lock_tables        |0       |
|Com_rename_table       |0       |
|Com_restore_table      |0       |
| Com_show_create_table   |0       |
|Com_show_open_tables   |0       |
|Com_show_tables        |0       |
|Com_unlock_tables      |0       |
| Created_tmp_disk_tables |0       |
|Created_tmp_tables     |1       |
|Open_tables            |510     |
|Opened_tables          |0       |
| Slave_open_temp_tables  |0       |
| Table_locks_immediate   |12645624 |
|Table_locks_waited     |2605    |
+-------------------------+----------+
19 rows in set (0.00 sec)

mysql> show status like '%Qca%';
+-------------------------+----------+
|Variable_name          | Value   |
+-------------------------+----------+
|Qcache_free_blocks     |9277    |
|Qcache_free_memory     | 43576824 |
|Qcache_hits            | 16606663 |
|Qcache_inserts         | 5974860  |
|Qcache_lowmem_prunes   | 165442   |
|Qcache_not_cached      | 259237   |
| Qcache_queries_in_cache |13438    |
|Qcache_total_blocks    | 36359   |
+-------------------------+----------+
8 rows in set (0.00 sec)

mysql> show status like '%read%';
+-----------------------------------+--------------+
|Variable_name                    |Value       |
+-----------------------------------+--------------+
|Com_ha_read                      |0           |
|Delayed_insert_threads           |0           |
|Handler_read_first               |0           |
|Handler_read_key                 |0           |
|Handler_read_next                |0           |
|Handler_read_prev                |0           |
|Handler_read_rnd                 |0           |
|Handler_read_rnd_next            |29          |
| Innodb_buffer_pool_read_ahead_rnd |37028       |
| Innodb_buffer_pool_read_ahead_seq |563419      |
| Innodb_buffer_pool_read_requests  |1224957470   |
|Innodb_buffer_pool_reads         |985422      |
|Innodb_data_pending_reads        |0           |
|Innodb_data_read                 | 169279442944 |
|Innodb_data_reads                |1637481     |
|Innodb_pages_read                |10331864    |
|Innodb_rows_read                 | 1178904493   |
|Key_read_requests                | 2895525276   |
|Key_reads                        |1840704     |
|Slow_launch_threads              |5           |
|Threads_cached                   |0           |
|Threads_connected                |22          |
|Threads_created                  |2396716     |
|Threads_running                  |1           |
+-----------------------------------+--------------+
24 rows in set (0.00 sec)