splunk mysql monitor

locationvim/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.shhost=10.39.3.45 (native) CMD=" /data/php/bin/php (PHP installation location)cachefile="/tmp/$HOST-mysql_zabbix_stats.txt " (temporary file location) RES= ' home=~zabbix/data/mysql/bin/mysql (mysql installation location)9. Modify the PHP page according to your environment location' Root ' 't

Label: [Email protected] wyb]#CatJkmysql #!/bin/Bash Status= '/etc/init.d/mysqld status|grepRunning|WC-l ' Process=`PS-ef |grepmysqld|grep-Vgrep|WC-l ' Port= ' Lsof-i:3306|grep-I. listen|WC-l ' MySQL-uroot-p'Test'-E"show databases;">/dev/NULL 2>/dev/NULLa=$?[$a-eq0] [$port-ne0] [$process-ne0] [$status-ne0 ] Echo "MySQL is running"||Echo "MySQL is not running"

1 , grant user for MySQLGrantusage on * * to ' zabbix ' @ ' localhost ' identified by "Zabbix";2 , touch/var/lib/zabbix/.my.cnf# Zabbix Agent[MySQL]Host=localhostUser=zabbixPassword=zabbixSocket=/tmp/mysql.sock[Mysqladmin]Host=localhostUser=zabbixPassword=zabbixSocket=/tmp/mysql.sock3 , CP userparameter_mysql.conf/etc/zabbix/zabbix_agentd.d/Home=/var/lib/zabbix #where store MySQL grant user info, after Itmy

]exceptexception,e: print "Usage:python%stype" %sys.argv[0] sys.exit (1) main (type)## test the script:[[email protected] python]# python check_mysql_custom.py processlist3[[email protected] python]# python check_mysql_ custom.py Connections55876## The test shows all the MySQL in Show Status can output information:## Write a template configuration file (custom Key value):[email protected] zabbix_agentd.d]# cat Mysql_custom.confuserparameter=

The previous blog describes a case where memory spikes due to SQL query Information_schema tables.Today, by the way, a THD memory is monitored:Let's introduce the memory of MySQL:1. In-thread memory: thd->mem_root, during the execution of SQL, the requested memory is allocated from Thd->mem_root and released at the end of SQL.2. Out-of-thread memory: Object-specific mem_root; For example, table, table_share,st_transactions, etc. all have proprietary m

Python version 2.6.6#!/usr/bin/pythonImport MySQLdbDef check_mysql ():Status = TrueTryConn=mysqldb.connect (host= ' 172.7.10.8 ', user= ' summer ', passwd= ' summer ', db= ' CMS ')Cur=conn.cursor ()Cur.execute ("Show slave status;")result = Cur.fetchall ()IO_THREAD=RESULT[0][10]SQL_THREAD=RESULT[0][11]#print Io_thread,sql_threadCur.close ()Conn.close ()Status = Trueif Io_thread = = "Yes" and sql_thread = = "Yes":print ' 2 'Status = TrueElseprint ' 0 'Status = FalseExcept Exception,e:Print Except