splunk mysql monitor

/directory to ensure that [Root @ client100 ~] # Cd/var/log/zabbix/cache/ [Root @ client100 cache] # ll-Rw-r -- 1 zabbix 0 Mar 22 07:25 FromDualAgentCache.192.168.1.100.cache # Note: it is normal that the file is not written, because the program automatically clears the file, but if the file keeps increasing, it indicates that the configuration is incorrect, data not sent (6) The following error is reported. The processing method is as follows: 12933: 06:52:06. 005-INFO: FromDual Performance

action self. scaning. setLabel (msg) def ErrorMessage (self, errlist): # error message index = self. list. insertStringItem (sys. maxint, errlist [0]) self. list. setStringItem (index, 1, errlist [1]) self. list. setStringItem (index, 2, errlist [2]) self. list. setStringItem (index, 3, errlist [3]) self. list. refreshItem (index) def DeleteItems (self): self. list. deleteAllItems () class AutoWidthListCtrl (wx. listCtrl, ListCtrlAutoWidthMixin): def _ init _ (self, parent): wx. listCtrl. _ ini

(Switch) add, delete, modify, query, and view log records in MySql, and mysql log records Reprint address: http://blog.51cto.com/hades02/1641652 First, enter show global variables like '% general %' in the command line, and then the following window appears. The general_log field is the switch, which is usually OFF by default, so monitoring is not enabled yet, then general_log file To

Scripts to monitor long transactions#!/bin/bashMysql-n-uroot-p ' password '-e ' select Now (), (Unix_timestamp (now ())-Unix_timestamp (a.trx_started)) Diff_sec,b.id,b.user, B.host,b.db,d.sql_text from Information_schema.innodb_trx a inner joinInformation_schema. Processlist bOn a.trx_mysql_thread_id=b.id and B.command = ' Sleep 'INNER JOIN performance_schema.threads c on b.id = c.processlist_idINNER JOIN performance_schema.events_statements_current D

(status)(from Show status return information)Current number of connections: threads_connected (status)(from Show status return information)Number of active connections: threads_running (status)(from Show status return information)Number of Cache connections: Threads_cache (status)(from Show status return information)5. Traffic statistics (taken from show status return information)Bytes_received (bytes accepted), bytes_sent (number of bytes sent)6. Number of connections (taken from show status r

Tag:jsonturn monitoring printresult acedump.sqlmaster #!/bin/envpython#-*-encoding:utf-8-*-importtimeimportosimport Sysimportjsonimportreimportthreadmysql_stat_list=[]classmysqlmonitorinfo () : def__init__ (self): passdefis_slave (self): m= "mysql-e ' showslave Status\g ' data= Os.popen (M). ReadLines () ifdata ==[]: return ',falseelse: returndata,true defstat_info (self): data,isslave =self.is_slave () ifis Slave:str_ string={} fordindata[1:]: ds=d.

Tags: Zabbix1, write the monitoring master-slave shell script check_mysql_replication.sh, put under/etc/zabbix/#!/bin/bash/usr/bin/mysql-uzabbix-p password-e ' show slave status\g ' |grep-e "slave_io_running| Slave_sql_running "|awk ' {print $} ' |grep-c Yes2. Authorizing Zabbix users from the library:Grant replication Client on * * to ' zabbix ' @ ' localhost ' identified by ' password ';3, edit/etc/zabbix/zabbix-agentd.conf, add the following conten

Tags: shell #!/bin/bash #check mysql_slavestatus #crontab time09:00 mysqlport= ' Netstat-na|grep "LISTEN" |grep "3306" |awk ' {print$4} ' |awk-f: ' {print$2} ' mysqlip= ' ifconfig|awk ' nr==2{print$2} ' |awk-f: ' {print$2} ' status=$ (mysql-hxxx- uxxx-pxxx-s/tmp/mysql.sock-e "Showslavestatus\g" |grep -i "Running") io_env= ' echo $STATUS |grepIO|awk ' { print$2} ' sql_env= ' echo $STATUS |grepSQL|awk ' {print$ 2} ' data= ' date+ "%y-%m-%d%h:%m:%s" '

Zabbix Monitor nginx,php-fpm and MySQL memory usage and number of processes with custom scripts

Label:Detailed Spotlight on MySQL monitor MySQL serverThe previous chapter details the spotlight on Unix monitoring Linux server, and today again see spotlight on MySQL How to monitor MySQL server. Note: http://www.cnblogs.com/Jav

connect the monitored machine query status Configuring MySQL on the monitored side to authorize the cacti hostMysql-uroot-pGrant Process,super on - cacti ' @ '% ' identified by ' cacti ';Grant Process,super ' cacti ' @ ' 10.254.166.60 ' identified by ' cacti ';Flush privileges; The meaning of this commandAllow only hosts with IP 10.254.166.60 to access native data with account cacti password cacti

][success] Percona mysql handlers GT [new][success] Percona MySQL Query time his Togram (Count) GT [new][success] Percona MySQL Query Response time (microseconds) GT [new][success] Percona InnoDB Buffer Pool efficiency GT [new]host template[success] Percona MySQL Server HT [New]Open Devices--> Select Host (not created)

[new] [Success] X Get MySQL stats/mysql Transaction Handler IM [new] [Success] X Get MySQL stats/mysql handlers IM [new] 。。。。。。When adding Divice, the template selects "X DB Server HT", the SNMP version is 2, the other does not have to be modified, save savesCreate a graphic: "Create Graphs for this Host" and you wi

First, the relevant instructionsThe production line uses the Zabbix 2.4.5 to monitor all business and system networks, of course, also need to monitor the MySQL database related information, Zabbix with the MySQL monitoring template can monitor

Tags: monitor mysql master and slave1.shell Monitor Master-Slave synchronizationWrite a shell script that monitors Slave's two yes (Slave_io and slave_sql processes), and if only one or 0 Yes is found, it indicates a master-slave problem.___________________________________________________________vim/sh/mysql_slave.sh #!/bin/bash #check mysql_slavestatus #crontab

Tags: 51cto auth command 0 Rows Permissions des end client SQL192.168.254.127 (Zabbix)192.168.254.128 (MySQL) ZABBIX_AGENTD Client SettingsCreate a normal user Zabbix on MySQL data, password Zabbix[Email protected] scripts]# mysql-uroot-pEnter Password:Welcome to the MySQL Monitor