CN104462612A - Method and device for monitoring database information - Google Patents

Method and device for monitoring database information Download PDF

Info

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
Application number
CN201510005055.6A
Other languages
Chinese (zh)
Inventor
初贤哲
乔鑫
李丽芳
石立军
于琦
杨磊
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Beijing Electronic Information Industry Co Ltd
Original Assignee
Inspur Beijing Electronic Information Industry Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur Beijing Electronic Information Industry Co Ltd filed Critical Inspur Beijing Electronic Information Industry Co Ltd
Priority to CN201510005055.6A priority Critical patent/CN104462612A/en
Publication of CN104462612A publication Critical patent/CN104462612A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/3003Monitoring arrangements specially adapted to the computing system or computing system component being monitored
    • G06F11/302Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, 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

A kind of method and apparatus of monitor data library information
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.
CN201510005055.6A 2015-01-05 2015-01-05 Method and device for monitoring database information Pending CN104462612A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (2)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
陈玉: "电信企业后台数据库服务器自动预警方案的研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 *

Cited By (16)

* Cited by examiner, † Cited by third party
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