MySQL 效能監控 這篇文章主要列出MySQL可以用來查詢效能監控的SQL語句 https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html 效能指標 SQL語句 緩存 show variables like “%Query_cache%” thread_cache_size show variables like ‘threatd%’; Database current connections show…
資料庫效能
4個MySQL 資料庫基本除錯技巧
4個MySQL 資料庫基本除錯技巧 1. 資料庫日誌error.log /var/log/mysql / error.log /var/ lib/mysql / error.log [pastacode lang=”markup” manual=”120714%2015%3A35%3A26%20%5BNote%5D%20Plugin%20’FEDERATED’%20is%20disabled.%0A120714%2015%3A35%3A26%20InnoDB%3A%20Initializing%20buffer%20pool%2C%20size%20%3D%208.0M%0A120714%2015%3A35%3A26%20InnoDB%3A%20Completed%20initialization%20of%20buffer%20pool%0A120714%2015%3A35%3A26%20InnoDB%3A%20Started%3B%20log%20sequence%20number%200%2067138180%0A120714%2015%3A35%3A27%20%5BNote%5D%20Event%20Scheduler%3A%20Loaded%200%20events%0A120714%2015%3A35%3A27%20%5BNote%5D%20%2Fusr%2Fsbin%2Fmysqld%3A%20ready%20for%20connections.%0AVersion%3A%20’5.1.63-0ubuntu0.10.04.1-log’%20socket%3A%20’%2Fvar%2Frun%2Fmysqld%2Fmysqld.sock’%20port%3A%203306%0A%C3%8A(Ubuntu)” message=”” highlight=”” provider=”manual”/] 2. 資料庫執行狀態 …
Jmeter 3.1/3.2新版重大改進
Jmeter 3.1/3.2新版重大改進 Jmeter 被大量的應用在效能測試, WebAPI 測試, Jmeter 3.0 之後讓這開源的工具變得越來越人性化, 這篇文章主要介紹幾個 3.1/3.2常用功能的重大改進 Response Assertion 這個功能是進行 Web 或是 rest API 測試一定會用到的…