CN104615660A - Method and system for monitoring database performance - Google Patents
Method and system for monitoring database performance Download PDFInfo
- Publication number
- CN104615660A CN104615660A CN201510002733.3A CN201510002733A CN104615660A CN 104615660 A CN104615660 A CN 104615660A CN 201510002733 A CN201510002733 A CN 201510002733A CN 104615660 A CN104615660 A CN 104615660A
- Authority
- CN
- China
- Prior art keywords
- performance data
- data
- performance
- target database
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
- G06F11/3433—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment for load management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and system for monitoring database performance and is applied to a system comprising a target database and a data load library. The method comprises the following steps that performance data of the target database are obtained on time by the target database, and the performance data are sent to the data load library; the data load library analyzes the performance data to obtain an analysis result, and the analysis result is saved. The method for monitoring the database performance grabs the performance data of the target database through the timed task and analyzes and demonstrates the performance data through the data load library, the impact on the target database is small, the consumption of resources and time can be effectively controlled, and customized monitoring on the database performance can be achieved.
Description
Technical field
The present invention relates to field of computer technology, be specifically related to a kind of method and system of monitor database performance.
Background technology
Along with developing rapidly of infotech, the application system of enterprise becomes increasingly complex, and database is as the ingredient on application system basis, and its importance is self-evident.For enterprise; once the performance of database corruption or database reduces; the application system running speed depending on database directly can be caused slowly even cannot to use, not only can affect the service efficiency of application system, even can cause the loss of corporate client and profit.
For avoiding the problems referred to above to occur, usually to the monitoring of database availability and performance, ensureing that the health of database is run, guaranteeing the normal operation of the operation system depending on database, reduce the down time of system.For oracle database, by oracle enterprise management platform monitoring management native database, grid controls the database in monitoring management consolidated network.But oracle enterprise management platform interface can only manage the machine, grid controls to need install middleware and create data bank, cannot realize customizing.
Summary of the invention
The invention provides a kind of method and system of monitor database performance, the defect of monitoring in prior art, cannot be carried out customizing to database performance to solve.
The invention provides a kind of method of monitor database performance, be applied in the system comprising target database and data load bank, said method comprising the steps of:
The performance data of described target database timing acquisition self, sends to described data load bank by described performance data;
Described data load bank is analyzed described performance data, obtains analysis result, and preserves described analysis result.
Alternatively, described data load bank is analyzed described performance data, after obtaining analysis result, also comprises:
Described data load bank is carried out view to described analysis result and is represented.
Alternatively, the performance data of described target database timing acquisition self, is specially:
Described target database passes through timed task, the performance data of timing acquisition self.
Alternatively, before the performance data of described target database timing acquisition self, also comprise:
Described target database creates described timed task.
Alternatively, described performance data is the performance data in rush hour.
Present invention also offers a kind of system of monitor database performance, comprising:
Target database, for the performance data of timing acquisition self, sends to described data load bank by described performance data;
Data load bank, for analyzing described performance data, obtains analysis result, and preserves described analysis result.
Alternatively, described data load bank, also represents for carrying out view to described analysis result.
Alternatively, described target database, specifically for passing through timed task, the performance data of timing acquisition self.
Alternatively, described target database, also for creating described timed task.
Alternatively, described performance data is the performance data in rush hour.
The present invention captures the performance data of target database by timed task, and by data load bank performance data analyzed and show, less on the impact of target database, can effectively control resource consumption and time loss, and realize monitoring the customization of database performance.
Accompanying drawing explanation
Fig. 1 is the method flow diagram of a kind of monitor database performance in the embodiment of the present invention;
Fig. 2 is the system architecture schematic diagram of a kind of monitor database performance in the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
It should be noted that, if do not conflicted, each feature in the embodiment of the present invention and embodiment can be combined with each other, all within protection scope of the present invention.In addition, although show logical order in flow charts, in some cases, can be different from the step shown or described by order execution herein.
Embodiments provide a kind of method of monitor database performance, be applied in the system comprising target database and data load bank, corresponding method flow, as shown in Figure 1, comprises the following steps:
Step 101, the performance data of target database timing acquisition self.
Particularly, target database passes through timed task, the performance data of timing acquisition self.Wherein, performance data can be the performance data in rush hour.
It should be noted that, before the performance data of target database timing acquisition self, also need to create timed task in target database.
Step 102, performance data is sent to data load bank by target database.
Step 103, data load bank is analyzed performance data, obtains analysis result, and preserves described analysis result.
Step 104, data load bank is carried out view to analysis result and is represented.
For mysql database, for realizing the method for above-mentioned monitor database performance, need to perform following concrete operations:
1, mysql database is installed
Particularly, rpm can be used to wrap and to install, be i.e. [root@oel58 ~] #rpm-ivhMySQL-server-5.5.29-2.rhel5.i386.rpm
2, by performing to issue orders, installing and depending on dbimysql dbd module:
3, initialization data storehouse
Particularly, perform myawr.sql parts, and by performing to issue orders, increase configuration information:
INSERT INTO`myawr_host`(id,host_name,ip_addr,port,db_role,version,running_thread_threshold,times_per_hour)VALUES(6,'db2.11','192.168.2.11',3306,'master','5.5.27',10000,0)；
4, by performing to issue orders, deployment task:
grant all on*.*to'superuser'@'localhost'identified by"111111"；
It should be noted that, before following script is deployed to task, need to run to issue orders:
*****perl/root/myawr/myawr.pl-u superuser-p 111111-lh localhost-P3306-tu myuser-tp 111111-TP 3306-th 192.168.137.9-n eth0-d sda3-I 6>>/root/myawr/myawr_pl.log 2>&1
5, by performing to issue orders, report is generated:
perl myawrrpt.pl-u myuser-p 111111-P 3306-lh 192.168.137.9-I 6
perl myawrsrpt.pl-u myuser-p 111111-P 3306-lh 192.168.137.9-I 6-s 29
The embodiment of the present invention captures the performance data of target database by timed task, and by data load bank performance data analyzed and show, less on the impact of target database, can effectively control resource consumption and time loss, and realize monitoring the customization of database performance.
Based on the method for above-mentioned monitor database performance, the embodiment of the present invention additionally provides a kind of system of monitor database performance, as shown in Figure 2, comprises
Target database 210, for the performance data of timing acquisition self, sends to data load bank 220 by performance data.
Particularly, above-mentioned target database 210, specifically for passing through timed task, the performance data of timing acquisition self.
Wherein, performance data can be the performance data in rush hour.
Further, above-mentioned target database 210, also for creating timed task.
Data load bank 220, for analyzing performance data, obtains analysis result, and preserves analysis result.
Further, above-mentioned data load bank 220, also represents for carrying out view to analysis result.
The embodiment of the present invention captures the performance data of target database by timed task, and by data load bank performance data analyzed and show, less on the impact of target database, can effectively control resource consumption and time loss, and realize monitoring the customization of database performance.
In conjunction with the software module that the step in the method that embodiment disclosed herein describes can directly use hardware, processor to perform, or the combination of the two is implemented.Software module can be placed in the storage medium of other form any known in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technical field.
The above; be only the specific embodiment of the present invention, but protection scope of the present invention is not limited thereto, is anyly familiar with those skilled in the art in the technical scope that the present invention discloses; change can be expected easily or replace, all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should described be as the criterion with the protection domain of claim.
Claims (10)
1. a method for monitor database performance, is characterized in that, is applied in the system comprising target database and data load bank, said method comprising the steps of:
The performance data of described target database timing acquisition self, sends to described data load bank by described performance data;
Described data load bank is analyzed described performance data, obtains analysis result, and preserves described analysis result.
2. the method for claim 1, is characterized in that, described data load bank is analyzed described performance data, after obtaining analysis result, also comprises:
Described data load bank is carried out view to described analysis result and is represented.
3. the method for claim 1, is characterized in that, the performance data of described target database timing acquisition self, is specially:
Described target database passes through timed task, the performance data of timing acquisition self.
4. method as claimed in claim 3, is characterized in that, before the performance data of described target database timing acquisition self, also comprise:
Described target database creates described timed task.
5. the method as described in any one of Claims 1-4, is characterized in that, described performance data is the performance data in rush hour.
6. a system for monitor database performance, is characterized in that, comprising:
Target database, for the performance data of timing acquisition self, sends to described data load bank by described performance data;
Data load bank, for analyzing described performance data, obtains analysis result, and preserves described analysis result.
7. system as claimed in claim 6, is characterized in that,
Described data load bank, also represents for carrying out view to described analysis result.
8. system as claimed in claim 6, is characterized in that,
Described target database, specifically for passing through timed task, the performance data of timing acquisition self.
9. system as claimed in claim 8, is characterized in that,
Described target database, also for creating described timed task.
10. the system as described in any one of claim 6 to 9, is characterized in that, described performance data is the performance data in rush hour.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510002733.3A CN104615660A (en) | 2015-01-05 | 2015-01-05 | Method and system for monitoring database performance |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510002733.3A CN104615660A (en) | 2015-01-05 | 2015-01-05 | Method and system for monitoring database performance |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104615660A true CN104615660A (en) | 2015-05-13 |
Family
ID=53150103
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510002733.3A Pending CN104615660A (en) | 2015-01-05 | 2015-01-05 | Method and system for monitoring database performance |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104615660A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407085A (en) * | 2016-11-24 | 2017-02-15 | 中国银行股份有限公司 | Performance monitoring method and apparatus |
| CN106445794A (en) * | 2015-08-04 | 2017-02-22 | 北京京东尚科信息技术有限公司 | Method and device for providing load information |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6052694A (en) * | 1998-03-18 | 2000-04-18 | Electronic Data Systems Corporation | Method and apparatus for logging database performance characteristics |
| CN101031125A (en) * | 2006-03-02 | 2007-09-05 | 中兴通讯股份有限公司 | Method for accounting base-station performance data |
| US7617313B1 (en) * | 2004-12-27 | 2009-11-10 | Sprint Communications Company L.P. | Metric transport and database load |
| US20100198796A1 (en) * | 2009-02-04 | 2010-08-05 | Oracle International Corporation | Treemap visualizations of database time |
| CN102156729A (en) * | 2011-03-29 | 2011-08-17 | 北京京东世纪贸易有限公司 | System and method for monitoring database servers |
| CN102571499A (en) * | 2012-02-14 | 2012-07-11 | 广州亦云信息技术有限公司 | Monitoring method of cloud database server cluster |
| CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线（北京）科技有限公司 | General method for monitoring status of light database |
| US8375001B2 (en) * | 2008-10-03 | 2013-02-12 | Telefonaktiebolaget Lm Ericsson (Publ) | Master monitoring mechanism for a geographical distributed database |
| CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
| CN103793526A (en) * | 2014-02-24 | 2014-05-14 | 浪潮电子信息产业股份有限公司 | Method for monitoring SQL statement performance |
| CN103823852A (en) * | 2014-02-14 | 2014-05-28 | 北京国双科技有限公司 | Method and device for processing database server logs |
-
2015
- 2015-01-05 CN CN201510002733.3A patent/CN104615660A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6052694A (en) * | 1998-03-18 | 2000-04-18 | Electronic Data Systems Corporation | Method and apparatus for logging database performance characteristics |
| US7617313B1 (en) * | 2004-12-27 | 2009-11-10 | Sprint Communications Company L.P. | Metric transport and database load |
| CN101031125A (en) * | 2006-03-02 | 2007-09-05 | 中兴通讯股份有限公司 | Method for accounting base-station performance data |
| US8375001B2 (en) * | 2008-10-03 | 2013-02-12 | Telefonaktiebolaget Lm Ericsson (Publ) | Master monitoring mechanism for a geographical distributed database |
| US20100198796A1 (en) * | 2009-02-04 | 2010-08-05 | Oracle International Corporation | Treemap visualizations of database time |
| CN102156729A (en) * | 2011-03-29 | 2011-08-17 | 北京京东世纪贸易有限公司 | System and method for monitoring database servers |
| CN102567531A (en) * | 2011-12-30 | 2012-07-11 | 互动在线（北京）科技有限公司 | General method for monitoring status of light database |
| CN102571499A (en) * | 2012-02-14 | 2012-07-11 | 广州亦云信息技术有限公司 | Monitoring method of cloud database server cluster |
| CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
| CN103823852A (en) * | 2014-02-14 | 2014-05-28 | 北京国双科技有限公司 | Method and device for processing database server logs |
| CN103793526A (en) * | 2014-02-24 | 2014-05-14 | 浪潮电子信息产业股份有限公司 | Method for monitoring SQL statement performance |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106445794A (en) * | 2015-08-04 | 2017-02-22 | 北京京东尚科信息技术有限公司 | Method and device for providing load information |
| CN106407085A (en) * | 2016-11-24 | 2017-02-15 | 中国银行股份有限公司 | Performance monitoring method and apparatus |
| CN106407085B (en) * | 2016-11-24 | 2019-03-15 | 中国银行股份有限公司 | A kind of method for monitoring performance and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10764202B2 (en) | Container-based mobile code offloading support system in cloud environment and offloading method thereof | |
| US10713183B2 (en) | Virtual machine backup using snapshots and current configuration | |
| US10592825B2 (en) | Application placement among a set of consolidation servers utilizing license cost and application workload profiles as factors | |
| CN104158910B (en) | A kind of high in the clouds Web applications automatically dispose system | |
| US9699252B2 (en) | Deployment of virtual machine disks from a shared network file system | |
| CN104506589A (en) | Resource migration scheduling method based on super fusion storage | |
| WO2009149451A3 (en) | Controlling resource allocation for backup operations | |
| US20170322826A1 (en) | Setting support program, setting support method, and setting support device | |
| CA2674319A1 (en) | Methods and systems for solving problems with hard-coded credentials | |
| EP3051408B1 (en) | Data operating method and device | |
| US10402100B2 (en) | Techniques for path optimization in storage networks | |
| WO2015119638A1 (en) | Automatic collection and provisioning of migration resources | |
| EP2656207A2 (en) | Multi-machine deployment and configuration of multi-tiered applications | |
| CN104360892A (en) | System and method for creating virtual machine | |
| US10936354B2 (en) | Rebuilding a virtual infrastructure based on user data | |
| US10389823B2 (en) | Method and apparatus for detecting network service | |
| CN104391697A (en) | System and method for managing cloud resources of application program | |
| KR20140019413A (en) | Conservative garbage collecting and tagged integers for memory management | |
| US20130160009A1 (en) | Control computer and method for deploying virtual machines | |
| CN104615660A (en) | Method and system for monitoring database performance | |
| US20170060616A1 (en) | Migration controlling method and migration controller | |
| CN101968765B (en) | Software version detection method of large sized weaponry informatization system | |
| US9886271B2 (en) | Change method, apparatus, and recording medium | |
| US9317273B2 (en) | Information processing apparatus and information processing method | |
| CN110908676A (en) | Integrated office system based on super-fusion technology and implementation method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150513 |
|
| RJ01 | Rejection of invention patent application after publication |