Spotlight on Mysql詳細介紹
by:授客 QQ:1033553122
1. 版本........................................................................................................................... 1
2. 使用介紹................................................................................................................... 1
1) 首頁.................................................................................................................. 1
會話面闆........................................................................................................... 1
MySQL面闆........................................................................................................ 2
INNODB面闆...................................................................................................... 4
存儲面闆........................................................................................................... 5
主機面闆........................................................................................................... 7
2) MySQL Drilldown............................................................................................ 7
Activity Summary.......................................................................................... 7
Mutex................................................................................................................ 8
Sorts................................................................................................................ 9
Query Cache.................................................................................................... 9
Configuration.............................................................................................. 10
Statics.......................................................................................................... 10
InnoDB Status.............................................................................................. 10
Error Log...................................................................................................... 10
General Log.................................................................................................. 10
Slow Query Log............................................................................................ 11
3) OS Performance page.................................................................................. 11
CPU utilization.......................................................................................... 11
Disk IO.......................................................................................................... 11
Paging and scan rates.............................................................................. 12
Load average/Run queue............................................................................ 12
Network.......................................................................................................... 12
Free memory.................................................................................................. 12
4)OS Processes page...................................................................................... 12
5) OS Drilldown error.................................................................................... 13
1. 版本
Quest_Spotlight-on-MySQL_80.exe
2. 使用介紹
1) 首頁
會話面闆
說明:
Total Users:已連接配接到mysql伺服器的使用者數
Active Users:正在執行sql語句、其它資料庫請求的使用者數
Active Sessions:正在執行sql語句、其它資料庫請求的會話占比
SQL Executions/s:每秒向伺服器發送sql語句、其它資料庫請求的次數。統計所有資料庫請求,包括CALL, SHOW, DESC 和SET語句。如果發起的是CALL請求,即便存儲過程調用執行多條SQL語句,也隻算一次。
Data Send rate (kb/s):每秒向伺服器發送的資料大小。資料包括指令包(比如SQL語句)和需要存儲至資料庫的資料。
通常,該比例越大,表示插入(INSERT)速率越大。
Data Received rate (kb/s):所有用戶端每秒從mysql資料庫伺服器接收的資料大小。資料包除了包含通常由SELECT傳回的結果集,還可能包括傳回的代碼,錯誤資訊等、
……
檢視更多:歡迎加入全國軟體性能測試交流QQ群(群号:7156436),擷取pdf文檔
作者:授客
微信/QQ:1033553122
全國軟體測試QQ交流群:7156436
Git位址:https://gitee.com/ishouke
友情提示:限于時間倉促,文中可能存在錯誤,歡迎指正、評論!
作者五行缺錢,如果覺得文章對您有幫助,請掃描下邊的二維碼打賞作者,金額随意,您的支援将是我繼續創作的源動力,打賞後如有任何疑問,請聯系我!!!
微信打賞
支付寶打賞 全國軟體測試交流QQ群