簡易檢索 / 詳目顯示

研究生: 吳建達
Chien-Ta Wu
論文名稱: 動態網頁應用程式調校-以Apache+PHP+MySQL為例
Dynamic Web Application's Performance Tuning in Apache+PHP+MySQL
指導教授: 石維寬
Wei-Kuan Shih
口試委員:
學位類別: 碩士
Master
系所名稱: 電機資訊學院 - 資訊系統與應用研究所
Institute of Information Systems and Applications
論文出版年: 2006
畢業學年度: 94
語文別: 中文
論文頁數: 26
中文關鍵詞: 動態網頁效能調教
外文關鍵詞: performance, tuning, apache, php, mysql
相關次數: 點閱:2下載:0
分享至:
查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報
  • 數十年來網際網路(internet)的發展歷程中,全球資訊網(World Wide Web,WWW)的出現,使得網路從一般文字資訊的傳輸,躍升為結合圖片影像來展現的資訊平台。而網頁瀏覽器外掛程式(plugin)的發展,讓網頁的內容能夠內嵌(embedded)語音、動畫甚至是影像檔案,使WWW在多媒體(multimedia)的方面呈現出各種應用,數位學習(e-learning)就是其中的一種。

    數位學習一開始是以電腦設備來輔助學習(computer aided instruction)以及學習成果檢定(certification)為主,受到WWW網路技術發展的影響而延伸進化為線上輔助教學和線上測驗。而這兩種網路的應用在實際運作上,潛藏著一個相當大的問題:當越多使用者在同時連線操作時,使用者點選網頁選項後所等待的時間就越久,甚至有可能使伺服器超載(overloading)而癱瘓或當機。

    在這篇論文中,使用了開放源碼(open source)的Apache網站伺服器軟體、PHP程式模組與MySQL資料庫伺服器軟體的組合,針對其各自的功能和特性來做調整,以一個線上測驗系統為實作範例,期望在使用者數量同時段超過千人連線運作時,能夠有效加速程式的執行而盡快傳回使用者所需要的動態頁面內容。


    In the history of internet, technology of WWW application made the network communication from text only to the web pages that presented with text and pictures. By developed plug-in programs of browser, voice file, animated file, and video file can embedded in web page for multimedia application. One of these applications is e-learning.

    E-learning includes computer aided instruction and certification in the beginning, but now it becomes to online education and online certification by WWW technic. The two WWW applications has a problem: more online users use the system in the same time, the waiting time becomes longer, even server could be overloading and halted.

    In this thesis, we use these open source software: Apache web server with PHP module and MySQL database server. We tuned them and PHP web page code by their built-in functions and features for an online certification system, and make it run efficiently with better performance when more then one thousand users connected.

    中文摘要…………………………………………………………………2 Abstract…………………………………………………………………3 誌謝………………………………………………………………………4 目錄………………………………………………………………………5 圖目錄……………………………………………………………………6 第一章 緒論……………………………………………………………7 第二章 研究背景………………………………………………………9 2-1 靜態網頁運作………………………………………………………9 2-2 動態網頁運作 ……………………………………………………10 2-3 資料庫軟體的選用 ………………………………………………11 2-4 Apache一般調校 …………………………………………………11 2-5 PHP一般調校………………………………………………………12 2-6 MySQL一般調校……………………………………………………13 第三章 系統設計………………………………………………………15 3-1 分而治之╱Divide and Conquer ………………………………15 3-2 方案一:除冗碼 …………………………………………………15 3-3 方案二:減少JOIN ………………………………………………17 3-4 方案三:降低資料空間 …………………………………………19 第四章 實作與分析……………………………………………………20 4-1 測試環境與方式 …………………………………………………20 4-2 方案一:除冗碼的實際測試結果 ………………………………21 4-3 方案二:減少JOIN的實際測試結果 ……………………………21 4-4 方案三:降低資料搜尋空間的實際測試結果 …………………22 第五章 結論與未來展望………………………………………………24 參考文獻 ………………………………………………………………25

    [1] Wikipedia: World Wide Web, WWW. URL: http://en.wikipedia.org/wiki/Www
    [2] Wikipedia: Plugin. URL: http://en.wikipedia.org/wiki/Plugin
    [3] A Review of the HTML+ Document Format, David Raggett, Hewlett Packard Laboratories. URL: http://www.w3.org/MarkUp/htmlplus_paper/htmlplus.html
    [4] IETF RFC 1945 (1996):“Hypertext Transfer Protocol – HTTP/1.0”URL: http://www.ietf.org/rfc/rfc1945.txt
    [5] Wikipedia: Common Gateway Interface. URL: http://en.wikipedia.org/wiki/Common_Gateway_Interface
    [6] Ajax: A New Approach to Web Applications, Jasse James Garrett, Feb-18-2005. URL: http://www.adaptivepath.com/publications/essays/archives/000385.php
    [7] Google Spreadsheets. URL: http://spreadsheets.google.com
    [8] Writely. URL: http://www.writely.com
    [9] Wikipedia: E-learning. URL: http://en.wikipedia.org/wiki/E-learning
    [10] 2003年6月底止台灣上網人口, 2003-08-15, 經濟部技術處-產業電子化指標與標準研究科專計畫/資策會ECRC-FIND。
    [11] The Apache Software Foundation: The Apache HTTP Server Project. URL: http://httpd.apache.org/
    [12] PHP: Hypertext Preprocessor. URL: http://php.net
    [13] MySQL AB: The world’s most popular open source database. URL: http://www.mysql.com
    [14] Netcraft: June 2006 Web Server Survey. URL: http://news.netcraft.com/archives/2006/06/04/june_2006_web_server_survey.html
    [15] IETF RFC 1738 (1994):“Uniform Resource Locators (URL)” URL: http://www.ietf.org/rfc/rfc1738.txt
    [16] The Perl Directory. URL: http://www.perl.org/
    [17] The Object-Oriented Scripting Language Ruby. URL: http://www.ruby-lang.org/
    [18] Python Programming Language. URL: http://www.python.org/
    [19] PHP Manual, VI. Function Reference. URL: http://php.net/manual/en/funcref.php
    [20] PostgreSQL: The world’s most advanced open source database. URL: http://www.postgresql.org/
    [21] phpMyAdmin: MySQL Database Administration Tool. URL: http://www.phpmyadmin.net/
    [22] Apache Core Features, URL: http://httpd.apache.org/docs/1.3/mod/core.html
    [23] Zend: The PHP Company. URL: http://www.zend.com/
    [24] Turck MMCache for PHP – Turck Software St. Petersburg. URL: http://turck-mmcache.sourceforge.net/
    [25] Web-Related Talk - PHP4 Benchmark. URL: http://byster.net/?page_id=36
    [26] Fundamentals of Database Systems, Ramez Elmasri & Shamkant Navathe, Addison Wesley, 3 edition (August 1999). Chapter 14.3, page 483-488.
    [27] Fundamentals of Database Systems, Ramez Elmasri & Shamkant Navathe, Addison Wesley, 3 edition (August 1999). Chapter 7.4.5, page 219-229.
    [28] “Object Prefeching Using Semantic Links”, Alexander P Pons, Database for Advances in Information System. New York: Winter 2006. Vol. 37, page 97.
    [29] Wikipedia: Binary Search. URL: http://en.wikipedia.org/wiki/Binary_search

    無法下載圖示 全文公開日期 本全文未授權公開 (校內網路)
    全文公開日期 本全文未授權公開 (校外網路)

    QR CODE