Please use this identifier to cite or link to this item: http://hdl.handle.net/11455/19889
標題: 利用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: http://php.net [5] The Apache Software Foundation: The Apache HTTP Server Projext. URL: http://httpd.apache.org/ [6] Businesswire.com URL: http://www.businesswire.com/portal/site/google/index.jsp?ndmViewId=news_view&newsId=20080116005349&newsLang=en [7] oracle.com URL: http://www.oracle.com/us/sun/index.html [8] MySQL Enterprise Edition news URL: http://www.ithome.com.tw/itadm/article.php?c=64310 [9] MySQL Cluster availability URL:http://www.mysql.com/products/cluster/ [10] Rasmus Lerdorf URL: http://zh.wikipedia.org/wiki/%E6%8B%89%E6%96%AF%E5%A7%86%E6%96%AF%C2%B7%E5%8B%92%E5%A4%9A%E5%A4%AB [11] SSD(Solid State Drive) URL: http://www.eettaiwan.com/SEARCH/ART/SSD.HTM?jumpto=view_welcomead_1319641771473 [12]MySQL Key Cache URL: http://dev.mysql.com/doc/refman/5.1/en/key-cache-block-size.html [13]InnoDB_Buffer_pool URL: http://dev.mysql.com/doc/refman/5.1/en/innodb-buffer-pool.html [14]Query Cache URL: http://dev.mysql.com/doc/refman/5.1/en/query-cache.html [15]Key rate formula URL: http://download.oracle.com/docs/cd/E17952_01/refman-5.0-en/server-status-variables.html#statvar_Key_reads [16]Query cache Rate URL: http://blogs.oracle.com/dlutz/entry/mysql_query_cache_sizing [17]Oracle Data Guard URL: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/concepts.htm [18]S.Sahri,Design of a scalable Distributed Database System:SD-SQL Server, IEEE, pp2918 – 2919,2006 [19] PHP GD MODLE URL: http://php.net/manual/en/book.image.php [20] RRDTOOL URL: http://oss.oetiker.ch/rrdtool/ [21] HIGHCHARTS URL: http://www.highcharts.com/ [22] Scientific Linux URL: http://www.scientificlinux.org/ [23] Alexander P. Pons University of Miami, Object prefetching using semantic links, Newsletter ACM SIGMIS Database,vol 37,page 97,2006
摘要: 隨著公司電子化作業的普及,電腦系統已成為日常作業所不可或缺的工具,對於系統可用率的要求也越來越高。由於資料庫運作是24小時全年無休,為能有效掌控資料庫任何時間點的狀態與效能,導入一套客製化的監控系統是不可或缺的。 觀看市面上免費監控軟體均以記錄系統狀態與資料庫連線數為主,雖然可以提供系統狀態資訊,卻無法找出資料庫效能瓶頸。本論文以MySQL Enterprise Monitor 的監控方法與結合DBA(DataBase Adminitrators)管理者的角度,進行開發MySQL資料庫的監控系統(MMS),採用關連性方式記錄資訊,自動找出造成系統高負載的SQL statement與檢測資料庫的參數是否恰當,即使資料庫發生異常時無人在場,依舊可藉由MMS還原當時資料庫情況查出主因,其警訊機置除了可即時異常通知之外甚至可達到預防的成效。 本文之實驗結果証明運用此系統的確能成功降低資料庫約10%的負載,並在資料庫crash之前及早發出警訊以預防災難的發生。 關鍵字: 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
URI: http://hdl.handle.net/11455/19889
Appears in Collections:資訊科學與工程學系所

文件中的檔案:

取得全文請前往華藝線上圖書館



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