Method for monitoring MYSQL table space through ZABBIX

A technology of table space and monitoring items, which is applied in hardware monitoring, structured data retrieval, instruments, etc., to achieve the effects of high intelligence, convenient use, and labor saving

Inactive Publication Date: 2015-11-25
INSPUR SOFTWARE CO LTD
View PDF3 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

From the initial few servers to a huge data center, manpower alone can no longer meet the requirements in terms of technology, business, management, etc., so stan

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] A method for monitoring the MYSQL table space through ZABBIX of the present invention will be described in detail below.

[0041] A kind of method of monitoring MYSQL table space by ZABBIX of the present invention, method is as follows:

[0042] Find the database server to be monitored in the zabbix system, create a new monitoring item (item), the type is "Zabbix agent (passive)", the key value (key) is mysql.schema.size[mysql user name, mysql password, database name, table name].

[0043] According to the difference between the database name and the table name, it is divided into three categories:

[0044] 1. When the parameter "database name" is "all", the parameter "table name" is invalid, which means the size of all tables in the entire mysql, for example: mysql.schema.size[root,root,all];

[0045] 2. When the parameter "database name" is not "all" and the parameter "table name" is "all", it means the total size of all tables under the database, for example: mysql...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method for monitoring an MYSQL table space through a ZABBIX. The method includes the following steps of transmitting parameters including an MYSQL user name, an MYSQL password, a database name and a table name to a mysqlsize.sh script by establishing a monitoring item with the key value of mysql.schema.size, and transmitting the data to the ZABBIX and writing the data in a database after the script obtains the data. Compared with the prior art, the method has the advantages that the total size of all MYSQL tables on any server in a cluster, the sizes of all tables of a certain database and the size of a certain table in a certain database can be monitored in real time and displayed on a Web interface in real time, and when the size of the table space exceeds a designated size, warning information is produced and a user is reminded. The method further has the advantages of being reasonable in concept, convenient to use, capable of saving labor, high in intelligent degree and the like, and has quite good use value.

Description

technical field [0001] The invention relates to the field of computer automatic operation and maintenance and monitoring, in particular to a method for monitoring MYSQL table space through ZABBIX. Background technique [0002] With the continuous development of the information age, IT operation and maintenance has become an important part of the connotation of IT services. In the face of increasingly complex businesses and increasingly diverse user needs, ever-expanding IT applications require more and more reasonable models to ensure that IT services can be continuously guaranteed in a flexible, convenient, safe and stable manner. The most important guarantee factor is IT operation and maintenance. From the initial few servers to a huge data center, manpower alone can no longer meet the requirements in terms of technology, business, management, etc., so standardization, automation, architecture optimization, process optimization and other factors to reduce IT service costs...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06F11/30G06F11/34
CPCG06F11/3006G06F11/3409G06F16/21G06F16/2282
Inventor 周庆勇付迅
Owner INSPUR SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap