MySQL database performance tuning using MMS(MySQL Monitor System)

• Main Authors: Chia-Feng Chou, 周家豐
• Other Authors: 洪國寶
• Format: Others
• Language: zh-TW
• Published: 2012
• Online Access: http://ndltd.ncl.edu.tw/handle/98559713592775978443

碩士 === 國立中興大學 === 資訊科學與工程學系所 === 100 === Nowadays, the requirement of system availability is getting higher and higher while the company e-operations become popular and indispensable. Because the database must be kept running 24 hours a day, 7 days a week, it’s necessary to implement a customized monitor system to record the server performance and database status. Most freewares from the Internet, supporting recording system status and database sessions, can provide system status information, but cannot identify the performance bottlenecks. In this thesis, we design a MySQL monitor system(MMS) which combine manager’s point of view with the monitor method of MySQL Enterprise Monitor. MMS will record the bad SQL statements, check the database parameters automatically and provide the information for performance tuning. The manager could simulate the status of database anytime for trouble-shooting and get the warning before database crash. Experiments show that tuning MySQL using MMS could improve 10% performance and prevent disaster occurred. Keyword: MySQL monitor, performance tuning, monitor tool