Please use this identifier to cite or link to this item:
標題: 利用MMS工具調校MySQL資料庫效能
MySQL database performance tuning using MMS(MySQL Monitor System)
作者: 周家豐
Chou, Chia-Feng
關鍵字: MySQL監控;校能調校;監控工具
出版社: 資訊科學與工程學系所
引用: [1]林震岩,「資訊系統與組織配合關係之研究」,國科會研究報告,1996年。 [2]華炯榮, 利用資料庫系統統計資訊評估索引效能之新方法,國立中興大學資訊科學研究所碩士論文 [3]吳建達,動態網頁應用程式調校以Apache+PHP+MySQL為例,國立清華大學碩士論文,2006 [4] PHP: Hypertext Preprocessor. URL: [5] The Apache Software Foundation: The Apache HTTP Server Projext. URL: [6] URL: [7] URL: [8] MySQL Enterprise Edition news URL: [9] MySQL Cluster availability URL: [10] Rasmus Lerdorf URL: [11] SSD(Solid State Drive) URL: [12]MySQL Key Cache URL: [13]InnoDB_Buffer_pool URL: [14]Query Cache URL: [15]Key rate formula URL: [16]Query cache Rate URL: [17]Oracle Data Guard URL: [18]S.Sahri,Design of a scalable Distributed Database System:SD-SQL Server, IEEE, pp2918 – 2919,2006 [19] PHP GD MODLE URL: [20] RRDTOOL URL: [21] HIGHCHARTS URL: [22] Scientific Linux URL: [23] Alexander P. Pons University of Miami, Object prefetching using semantic links, Newsletter ACM SIGMIS Database,vol 37,page 97,2006
觀看市面上免費監控軟體均以記錄系統狀態與資料庫連線數為主,雖然可以提供系統狀態資訊,卻無法找出資料庫效能瓶頸。本論文以MySQL Enterprise Monitor 的監控方法與結合DBA(DataBase Adminitrators)管理者的角度,進行開發MySQL資料庫的監控系統(MMS),採用關連性方式記錄資訊,自動找出造成系統高負載的SQL statement與檢測資料庫的參數是否恰當,即使資料庫發生異常時無人在場,依舊可藉由MMS還原當時資料庫情況查出主因,其警訊機置除了可即時異常通知之外甚至可達到預防的成效。

關鍵字: MySQL監控、校能調校、監控工具

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
Appears in Collections:資訊科學與工程學系所

Show full item record

Google ScholarTM


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.