【摘要】：隨著互聯(lián)網(wǎng)應(yīng)用和計(jì)算機(jī)信息系統(tǒng)的不斷發(fā)展，數(shù)據(jù)庫的應(yīng)用范圍越來越廣泛。伴隨著數(shù)據(jù)庫規(guī)模不斷地?cái)U(kuò)大，業(yè)務(wù)復(fù)雜程度不斷地增加，數(shù)據(jù)庫系統(tǒng)的性能問題越來越突出，對數(shù)據(jù)庫性能進(jìn)行優(yōu)化也變得十分重要。 本文根據(jù)上海市垃圾物流管理平臺的運(yùn)行狀況，，結(jié)合MySQL優(yōu)化技術(shù)，對數(shù)據(jù)庫性能問題進(jìn)行了深入分析，尋找出了造成性能降低的各種原因。根據(jù)分析出的問題原因，提出了具體的數(shù)據(jù)庫優(yōu)化策略。 本文作者的主要研究內(nèi)容和創(chuàng)新點(diǎn)概述如下： 1）分表技術(shù)的應(yīng)用研究。分析了數(shù)據(jù)庫分表的兩種方案及其適用場景，根據(jù)系統(tǒng)中大數(shù)據(jù)表的特點(diǎn)，采用了水平分表的方案。 2）服務(wù)器配置優(yōu)化的應(yīng)用研究。硬件方面，在分析了不同磁盤陣列的原理和應(yīng)用場景之后，采用RAID10的磁盤陣列策略。軟件方面，通過改善服務(wù)器配置，提高數(shù)據(jù)庫的并發(fā)性處理能力和緩存命中率。 3）SQL語句及索引優(yōu)化的應(yīng)用研究。在分析了SQL語句和索引優(yōu)化的基本方法后，針對系統(tǒng)中的慢查詢語句進(jìn)行了優(yōu)化。 4）Hibernate優(yōu)化的應(yīng)用研究。分析了J2EE系統(tǒng)中主流的持久層框架Hibernate的緩存機(jī)制，并提出了提升Hibernate緩存利用率的方法。 5）數(shù)據(jù)庫備份恢復(fù)策略的應(yīng)用研究。根據(jù)應(yīng)用系統(tǒng)特性，研究設(shè)計(jì)了基于Linux定時(shí)任務(wù)機(jī)制的自動(dòng)備份策略。 本文的研究工作已經(jīng)完成，提出的數(shù)據(jù)庫優(yōu)化策略在實(shí)踐中得到了實(shí)際檢驗(yàn)。實(shí)踐結(jié)果表明，本文提出的優(yōu)化策略對于關(guān)系型數(shù)據(jù)庫性能優(yōu)化方面具有積極的借鑒意義。
[Abstract]:With the development of Internet and computer information system, the application of database is more and more extensive. With the expansion of database scale and the increase of business complexity, the performance problem of database system becomes more and more serious, so it is very important to optimize database performance. According to the running situation of the garbage logistics management platform in Shanghai and the MySQL optimization technology, this paper makes a deep analysis of the database performance problems, and finds out the various causes of the performance degradation. According to the analysis of the causes of the problems, a specific database optimization strategy is put forward. The main research contents and innovations of this paper are summarized as follows: 1) the applied research of tabular technology. In this paper, two schemes and their applicable scenarios are analyzed. According to the characteristics of large data table in the system, the scheme of horizontal table is adopted. 2) the application research of server configuration optimization. In the aspect of hardware, after analyzing the principle and application scenario of different disk array, RAID10's disk array strategy is adopted. Software, through improving server configuration, improve database concurrency processing ability and cache hit rate. 3) the application research of SQL statement and index optimization. After analyzing the basic methods of SQL and index optimization, the slow query statements in the system are optimized. 4) the application of Hibernate optimization. This paper analyzes the caching mechanism of Hibernate, the mainstream persistence layer framework in J2EE system, and puts forward a method to improve the utilization rate of Hibernate cache. 5) Research on the application of database backup recovery strategy. According to the characteristics of the application system, an automatic backup strategy based on Linux timing task mechanism is designed. The research work in this paper has been completed, and the proposed database optimization strategy has been tested in practice. The practical results show that the proposed optimization strategy has positive reference significance for the performance optimization of relational database.
【學(xué)位授予單位】：東華大學(xué)
【學(xué)位級別】：碩士
【學(xué)位授予年份】：2015
【分類號】：TP311.13

【相似文獻(xiàn)】

相關(guān)期刊論文 前10條

1 吳京慧;數(shù)據(jù)庫優(yōu)化技術(shù)分析研究[J];計(jì)算機(jī)與現(xiàn)代化;2004年12期

2 徐鑫濤;;淺談數(shù)據(jù)庫優(yōu)化[J];中國科技信息;2008年04期

3 周吉文;;醫(yī)院HIS系統(tǒng)數(shù)據(jù)庫優(yōu)化技術(shù)淺析[J];科技資訊;2008年23期

4 劉斌;湯曉兵;劉震;李盛恩;;基于數(shù)據(jù)庫優(yōu)化技術(shù)的查詢應(yīng)用[J];信息技術(shù)與信息化;2008年05期

5 李潔琦;;數(shù)據(jù)庫優(yōu)化技術(shù)探究[J];文教資料;2006年31期

6 姜樂樂;單廣榮;王曉;張顯政;;民文數(shù)字圖書館數(shù)據(jù)庫優(yōu)化研究[J];甘肅科技縱橫;2009年02期

7 王強(qiáng);;高校綜合人力資源管理系統(tǒng)的數(shù)據(jù)庫優(yōu)化策略研究[J];電腦知識與技術(shù);2010年10期

8 劉文峰;;基于求解最優(yōu)路徑的數(shù)據(jù)庫優(yōu)化研究[J];計(jì)算機(jī)光盤軟件與應(yīng)用;2012年21期

9 烏嵐;;基于多樣約束模型的遠(yuǎn)程教育數(shù)據(jù)庫優(yōu)化查詢算法[J];科技通報(bào);2013年01期

10 吳t熇

本文編號：2300115