CN104462612A - Method and device for monitoring database information - Google Patents
Method and device for monitoring database information Download PDFInfo
- Publication number
- CN104462612A CN104462612A CN201510005055.6A CN201510005055A CN104462612A CN 104462612 A CN104462612 A CN 104462612A CN 201510005055 A CN201510005055 A CN 201510005055A CN 104462612 A CN104462612 A CN 104462612A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- database information
- statement
- described 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/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Mathematical Physics (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a method and device for monitoring database information applied to a system comprising a monitoring host and a monitored host. The method comprises the steps that the monitoring host acquires the database information of the monitored host regularly through a self-defined script, and the monitoring host conducts graphic display on the database information and gives an alarm when the index in the database information exceeds a preset threshold value. According to the method and device, the state of the host and the database service on the host are monitored in a self-defined mode, the database information is displayed in a graphic mode, an alarm is given when the system or service state is abnormal, and customized monitoring of the database information can be achieved.
Description
Technical field
The present invention relates to field of computer technology, be specifically related to a kind of method and apparatus of monitor data library information.
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 apparatus of monitor data library information, to solve in prior art the defect that cannot realize monitoring the customization of database information.
The invention provides a kind of method of monitor data library information, be applied in the system comprising monitoring host computer and monitored main frame, said method comprising the steps of:
Described monitoring host computer passes through custom script, the database information of monitored main frame described in timing acquisition;
Described monitoring host computer carries out image conversion display to described database information, and when the index in described database information exceedes predetermined threshold value, performs alarm operation.
Alternatively, what described database information comprised in database performance, Database Systems state and database table spatiality is one or more.
Alternatively, what described database performance comprised in database current cursor sum, session number, Database lock sum, total, the Buffer Pool hit rate of deadlock and banked cache hit rate is one or more.
Alternatively, the quantity of the data block read under described Database Systems state is included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more.
Alternatively, described database table spatiality comprise table space available size, fragment number, table space read-write number of times and table space total volume in one or more.
Present invention also offers a kind of equipment of monitor data library information, comprising:
Acquisition module, for passing through custom script, the database information of the monitored main frame of timing acquisition;
Display module, carries out image conversion display for the described database information got described acquisition module;
Alarm module, when exceeding predetermined threshold value for the index in the described database information that described acquisition module gets, performs alarm operation.
Alternatively, what described database information comprised in database performance, Database Systems state and database table spatiality is one or more.
Alternatively, what described database performance comprised in database current cursor sum, session number, Database lock sum, total, the Buffer Pool hit rate of deadlock and banked cache hit rate is one or more.
Alternatively, the quantity of the data block read under described Database Systems state is included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more.
Alternatively, described database table spatiality comprise table space available size, fragment number, table space read-write number of times and table space total volume in one or more.
The present invention carrys out the database service on monitoring host computer state and main frame by self-defining mode, database information is shown by patterned mode, and when system or service state exception, perform alarm operation, can realize monitoring the customization of database information.
Accompanying drawing explanation
Fig. 1 is the system architecture diagram of a kind of monitor data library information in the embodiment of the present invention;
Fig. 2 is the method flow diagram of a kind of monitor data library information in the embodiment of the present invention;
Fig. 3 is the device structure schematic diagram of a kind of monitor data library information 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 data library information, be applied in the system comprising monitoring host computer and monitored main frame, this system as shown in Figure 1.Corresponding method flow, as shown in Figure 2, comprises the following steps:
Step 101, monitoring host computer passes through custom script, the database information of the monitored main frame of timing acquisition.
Wherein, what database information comprised in database performance, Database Systems state and database table spatiality is one or more.
Particularly, it is one or more that database performance comprises in database current cursor sum, session number, Database lock sum, total, the Buffer Pool hit rate of deadlock and banked cache hit rate, and database current cursor comprises explicit cursor and implicit cursor, the quantity of the data block that Database Systems state reads under being included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more, first presets number, second default number and the 3rd is preset number and can be 10 articles, database table spatiality comprise table space available size, fragment number, table space read-write number of times and table space total volume in one or more.
Step 102, monitoring host computer carries out image conversion display to database information.
Step 103, monitoring host computer judges that the index in database information exceedes predetermined threshold value, if so, performs step 104; Otherwise, return step 101.
Step 104, monitoring host computer performs alarm operation.
Particularly, monitoring host computer can pass through the mode of mail or note, sends warning message.Wherein, warning message comprises the details of the database in warning period.
It should be noted that, after monitoring host computer performs alarm operation, if the index in database information recovers normal, then pass through the mode of mail or note, send alarm release information.
In addition, monitoring host computer can also obtain main machine status information by plug-in card program, and this main machine status information comprises the information such as load on host computers, memory consumption, disk I/O, network traffics and system temporary space residue situation.When the index in main machine status information exceedes predetermined threshold value, monitoring host computer can pass through the mode of mail or note, sends warning message.Wherein, warning message comprises the details of the operating system in warning period.If the index in main machine status information recovers normal, monitoring host computer passes through the mode of mail or note, sends alarm release information.
For realizing the above-mentioned functions of monitoring host computer, first, need to install on monitoring host computer to rely on bag, specific instructions is as follows:
yum install-y gcc glibc glibc-common gd gd-devel xinetd openssl-devel
After installing, create corresponding user and user's group, specific instructions is as follows:
useradd-s/sbin/nologin nagios
Afterwards, nagios software is installed in compiling, and specific instructions is as follows:
./configure--prefix＝/usr/local/nagios
make all
make install-init
make install-commandmode
make install-config
Afterwards, configuration nagios service, specific instructions is as follows:
chkconfig--add nagios
chkconfig--level 35 nagios on
chkconfig--list nagios
Secondly, monitoring host computer is installed corresponding plug-in unit, wherein, the specific instructions installing compiling plug-in unit is as follows:
./configure--prefix＝/usr/local/nagios
make&&make install
The specific instructions installing apache plug-in unit is as follows:
./configure--prefix＝/usr/local/apache2
make&&make install
The specific instructions installing php plug-in unit is as follows:
./configure--prefix＝/usr/local/php--with-apxs2＝/usr/local/apache2/bin/apxs
make&&make install
After installation apache plug-in unit, also to be configured apache plug-in unit.
Again, at monitoring host computer deploy custom script, wherein, obtaining database Global Information script is: get_db_status.sh; Obtaining table space information script is get_tablespace_status.sh.
Finally, configure mail by the mode of amendment Parameter File contacts.cfg to report to the police.
Such as:
The embodiment of the present invention carrys out the database service on monitoring host computer state and main frame by self-defining mode, database information is shown by patterned mode, and when system or service state exception, perform alarm operation, can realize monitoring the customization of database information.
Based on the method for above-mentioned monitor data library information, the embodiment of the present invention additionally provides a kind of equipment of monitor data library information, as shown in Figure 3, comprising:
Acquisition module 310, for passing through custom script, the database information of the monitored main frame of timing acquisition.
Display module 320, carries out image conversion display for the database information got acquisition module 310.
Alarm module 330, when exceeding predetermined threshold value for the index in the database information that gets at acquisition module 310, performs alarm operation.
Wherein, what database information comprised in database performance, Database Systems state and database table spatiality is one or more.
Particularly, what database performance comprised in database current cursor sum, session number, Database lock sum, total, the Buffer Pool hit rate of deadlock and banked cache hit rate is one or more, the quantity of the data block that Database Systems state reads under being included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more, database table spatiality comprise table space available size, fragment number, table space read-write number of times and table space total volume in one or more.
The embodiment of the present invention carrys out the database service on monitoring host computer state and main frame by self-defining mode, database information is shown by patterned mode, and when system or service state exception, perform alarm operation, can realize monitoring the customization of database information.
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 data library information, is characterized in that, is applied in the system comprising monitoring host computer and monitored main frame, said method comprising the steps of:
Described monitoring host computer passes through custom script, the database information of monitored main frame described in timing acquisition;
Described monitoring host computer carries out image conversion display to described database information, and when the index in described database information exceedes predetermined threshold value, performs alarm operation.
2. the method for claim 1, is characterized in that, it is one or more that described database information comprises in database performance, Database Systems state and database table spatiality.
3. method as claimed in claim 2, is characterized in that, described database performance comprises database current cursor sum, session number, Database lock is total, deadlock is total, one or more in Buffer Pool hit rate and banked cache hit rate.
4. method as claimed in claim 2, it is characterized in that, the quantity of the data block read under described Database Systems state is included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more.
5. method as claimed in claim 2, is characterized in that, it is one or more that described database table spatiality comprises in table space available size, fragment number, table space read-write number of times and table space total volume.
6. an equipment for monitor data library information, is characterized in that, comprising:
Acquisition module, for passing through custom script, the database information of the monitored main frame of timing acquisition;
Display module, carries out image conversion display for the described database information got described acquisition module;
Alarm module, when exceeding predetermined threshold value for the index in the described database information that described acquisition module gets, performs alarm operation.
7. equipment as claimed in claim 6, is characterized in that, it is one or more that described database information comprises in database performance, Database Systems state and database table spatiality.
8. equipment as claimed in claim 7, is characterized in that, described database performance comprises database current cursor sum, session number, Database lock is total, deadlock is total, one or more in Buffer Pool hit rate and banked cache hit rate.
9. equipment as claimed in claim 7, it is characterized in that, the quantity of the data block read under described Database Systems state is included in current reading mode, the quantity of the data block read under consistent reading mode, the quantity of the data block read from disk, replicate entries of reforming is to the number of times of REDO Log Buffer, for by the consumer process of replicate entries to REDO Log Buffer of reforming because entering the number of times of waiting status without available REDO Log Buffer, there is not request of data proportion in all request of data that physical file reads, logic reads the statement of the first maximum default numbers, physical read maximum second preset number statement and perform number of times maximum the 3rd preset number statement in one or more.
10. equipment as claimed in claim 7, is characterized in that, it is one or more that described database table spatiality comprises in table space available size, fragment number, table space read-write number of times and table space total volume.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510005055.6A CN104462612A (en) | 2015-01-05 | 2015-01-05 | Method and device for monitoring database information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510005055.6A CN104462612A (en) | 2015-01-05 | 2015-01-05 | Method and device for monitoring database information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104462612A true CN104462612A (en) | 2015-03-25 |
Family
ID=52908647
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510005055.6A Pending CN104462612A (en) | 2015-01-05 | 2015-01-05 | Method and device for monitoring database information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104462612A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404581A (en) * | 2015-12-25 | 2016-03-16 | 北京奇虎科技有限公司 | Database evaluation method and device |
| CN106126403A (en) * | 2016-06-16 | 2016-11-16 | 北京中亦安图科技股份有限公司 | Oracle database failure analysis methods and device |
| CN106407069A (en) * | 2015-07-30 | 2017-02-15 | Ls 产电株式会社 | Apparatus and method for managing of database in energy management system |
| CN106547664A (en) * | 2016-11-04 | 2017-03-29 | 北京车智赢软件有限公司 | C# version Redis system monitoring instruments |
| CN106599055A (en) * | 2016-11-17 | 2017-04-26 | 杭州沃趣科技股份有限公司 | Method for detecting operation state of checkpoint in database |
| CN108062272A (en) * | 2017-11-06 | 2018-05-22 | 福建省天奕网络科技有限公司 | A kind of quick-fried table detection method of database and terminal |
| CN108847977A (en) * | 2018-06-14 | 2018-11-20 | 平安科技（深圳）有限公司 | A kind of monitoring method of business datum, storage medium and server |
| CN110515813A (en) * | 2019-08-15 | 2019-11-29 | 浙江万朋教育科技股份有限公司 | Oracle monitoring system and method based on shell script |
| CN112799920A (en) * | 2021-04-13 | 2021-05-14 | 南京万得资讯科技有限公司 | Program running state monitoring method based on program log |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110099146A1 (en) * | 2009-10-26 | 2011-04-28 | Mcalister Grant Alexander Macdonald | Monitoring of replicated data instances |
| CN104253706A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Method and device for monitoring database management platform |
-
2015
- 2015-01-05 CN CN201510005055.6A patent/CN104462612A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110099146A1 (en) * | 2009-10-26 | 2011-04-28 | Mcalister Grant Alexander Macdonald | Monitoring of replicated data instances |
| CN104253706A (en) * | 2013-06-29 | 2014-12-31 | 北京新媒传信科技有限公司 | Method and device for monitoring database management platform |
Non-Patent Citations (1)
| Title |
|---|
| 陈玉: "电信企业后台数据库服务器自动预警方案的研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407069A (en) * | 2015-07-30 | 2017-02-15 | Ls 产电株式会社 | Apparatus and method for managing of database in energy management system |
| US10437792B2 (en) | 2015-07-30 | 2019-10-08 | Lsis Co., Ltd. | Apparatus and method for managing of database in energy management system |
| CN106407069B (en) * | 2015-07-30 | 2019-04-12 | Ls 产电株式会社 | Device and method for the database in management energy management system |
| CN105404581B (en) * | 2015-12-25 | 2019-03-05 | 北京奇虎科技有限公司 | A kind of evaluating method and device of database |
| CN105404581A (en) * | 2015-12-25 | 2016-03-16 | 北京奇虎科技有限公司 | Database evaluation method and device |
| CN106126403A (en) * | 2016-06-16 | 2016-11-16 | 北京中亦安图科技股份有限公司 | Oracle database failure analysis methods and device |
| CN106547664A (en) * | 2016-11-04 | 2017-03-29 | 北京车智赢软件有限公司 | C# version Redis system monitoring instruments |
| CN106599055A (en) * | 2016-11-17 | 2017-04-26 | 杭州沃趣科技股份有限公司 | Method for detecting operation state of checkpoint in database |
| CN106599055B (en) * | 2016-11-17 | 2019-09-27 | 杭州沃趣科技股份有限公司 | A kind of method of Test database checkpointing operating status |
| CN108062272A (en) * | 2017-11-06 | 2018-05-22 | 福建省天奕网络科技有限公司 | A kind of quick-fried table detection method of database and terminal |
| CN108847977A (en) * | 2018-06-14 | 2018-11-20 | 平安科技（深圳）有限公司 | A kind of monitoring method of business datum, storage medium and server |
| WO2019237532A1 (en) * | 2018-06-14 | 2019-12-19 | 平安科技（深圳）有限公司 | Service data monitoring method, storage medium, terminal device and apparatus |
| CN108847977B (en) * | 2018-06-14 | 2021-06-25 | 平安科技（深圳）有限公司 | Service data monitoring method, storage medium and server |
| CN110515813A (en) * | 2019-08-15 | 2019-11-29 | 浙江万朋教育科技股份有限公司 | Oracle monitoring system and method based on shell script |
| CN112799920A (en) * | 2021-04-13 | 2021-05-14 | 南京万得资讯科技有限公司 | Program running state monitoring method based on program log |
| CN112799920B (en) * | 2021-04-13 | 2021-08-17 | 上海万得宏汇信息技术有限公司 | Program running state monitoring method based on program log |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104462612A (en) | Method and device for monitoring database information | |
| CN109725822B (en) | Method, apparatus and computer program product for managing a storage system | |
| Hamilton | On Designing and Deploying Internet-Scale Services. | |
| US7890712B2 (en) | Method, apparatus and program product for managing memory in a virtual computing system | |
| US9031914B2 (en) | Tier-based data management | |
| US9489282B2 (en) | Selective purging of a log structure | |
| EP3051408B1 (en) | Data operating method and device | |
| CN106446159B (en) | A kind of method of storage file, the first virtual machine and name node | |
| JP6111441B2 (en) | Tracking application usage in computing environments | |
| US9342390B2 (en) | Cluster management in a shared nothing cluster | |
| US10587655B1 (en) | Compliance management system and method for an integrated computing system | |
| CN110389858A (en) | Store the fault recovery method and equipment of equipment | |
| CN110737504B (en) | Fault-tolerant method, system, terminal and storage medium for deep learning model training | |
| US20230123303A1 (en) | Adjusting resources within a hyperconverged infrastructure system based on environmental information | |
| CN109725823A (en) | Method and apparatus for managing mixing storage disk array | |
| US20160050112A1 (en) | Distributed caching systems and methods | |
| CN108647118A (en) | Copy abnormal restoring method, device and computer equipment based on storage cluster | |
| CN101901174B (en) | Method for enhancing reliability of program of multi-replica contrast mechanism based on code segment | |
| CN110647425A (en) | Database recovery method and device | |
| CN106021030A (en) | Database system and database fault processing method and device | |
| CN106612314A (en) | System for realizing software-defined storage based on virtual machine | |
| CN103577246B (en) | The method and apparatus for preventing virtual machine from escaping | |
| US20200348858A1 (en) | Method, device and computer program product | |
| CN110647289A (en) | Satellite remote sensing cloud computing platform and system | |
| US20150088826A1 (en) | Enhanced Performance for Data Duplication |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150325 |
|
| RJ01 | Rejection of invention patent application after publication |