MYSQL實例
--查詢當前MySQL本次啟動后的運行統(tǒng)計時間
show status like 'uptime';

MYSQL實例
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Uptime    | 5667 |
+---------------+-------+
1 row in set (0.00 sec)

MYSQL實例
show status like 'com_select';

MYSQL實例
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_select  | 1   |
+---------------+-------+
1 row in set (0.00 sec)

MYSQL實例
show status like 'Thread_%';

MYSQL實例
+-------------------+-------+
| Variable_name   | Value |
+-------------------+-------+
| Threads_cached  | 0   |
| Threads_connected | 1   |
| Threads_created  | 1   |
| Threads_running  | 1   |
+-------------------+-------+
4 rows in set (0.00 sec)

MYSQL實例
SHOW [統(tǒng)計范圍] STATUS [LIKE '狀態(tài)項名稱']
--統(tǒng)計范圍關(guān)鍵字分為GLOBAL和SESSION(或LOCAL)兩種.

MYSQL實例
show global status like 'com_select';

MYSQL實例
--查看MySQL本次啟動后的運行時間(單位：秒)
show status like 'uptime';
--查看select語句的執(zhí)行數(shù)
show [global] status like 'com_select';
--查看insert語句的執(zhí)行數(shù)
show [global] status like 'com_insert';
--查看update語句的執(zhí)行數(shù)
show [global] status like 'com_update';
--查看delete語句的執(zhí)行數(shù)
show [global] status like 'com_delete';
--查看試圖連接到MySQL(不管是否連接成功)的連接數(shù)
show status like 'connections';
--查看線程緩存內(nèi)的線程的數(shù)量.
show status like 'threads_cached';
--查看當前打開的連接的數(shù)量.
show status like 'threads_connected';
--查看當前打開的連接的數(shù)量.
show status like 'threads_connected';
--查看創(chuàng)建用來處理連接的線程數(shù).如果Threads_created較大,你可能要增加thread_cache_size值.
show status like 'threads_created';
--查看激活的(非睡眠狀態(tài))線程數(shù).
show status like 'threads_running';
--查看立即獲得的表的鎖的次數(shù).
show status like 'table_locks_immediate';
--查看不能立即獲得的表的鎖的次數(shù).如果該值較高,并且有性能問題,你應(yīng)首先優(yōu)化查詢,然后拆分表或使用復制.
show status like 'table_locks_waited';
--查看創(chuàng)建時間超過slow_launch_time秒的線程數(shù).
show status like 'slow_launch_threads';
--查看查詢時間超過long_query_time秒的查詢的個數(shù).
show status like 'slow_queries';