mysqladmin

MySQL always crashes First, you should try to find out whether the problem mysqld daemon is dead or whether your problem is related to your customer. You can use mysqladmin version to check how long your mysqld server has been running normally. If mysqld is dead, you can go to the file "mysql-data-directory/'hostname '. find the cause in err. Some common errors when using MySQL MySQL server has gone away The common cause is that the server times out a

Zabbix monitors mysql and zabbixmysqlI. System Environment Operating System: centos 7 Zabbix version: 3.2.5Ii. Install the zabbix Client # Wget http://repo.zabbix.com/zabbix/3.2/rhel/7/x86_64/zabbix-release-3.2-1.el7.noarch. rpm # Yum-y install zabbix-release-3.2-1.el7.noarch # Yum-y install zabbix-agent Configuration File /Etc/zabbix/zabbix_agentd.confIii. Single Point Mysql monitoring module 3.1 Template App MySQL Zabbix provides an official Template for monitoring mysql App MySQL. You can se

. if there is no conflict, consider it comprehensively.Query from start to endAfter the installation is complete, mysql automatically generates five accounts and the password is blank.Three administrator accounts: root @ localhost, root@127.0.0.1, root @ hostnameTwo anonymous accounts: ''@ localhhost,'' @ hostname# Mysql> Use mysql to use mysql> Show tables; displays TABLES> DESC TABLE_NAE; display table format> SELECT Host, User, Password FROM user; displays the specified columns in the table.>

(Transfer) Use mysqladminext to learn about the MySQL running status www. orczhou. comindex. php201403some-tricky-about-mysqladmin-extended-statusmysqladmin is an important MySQL client, the most common is to use it to close the database, in addition, the command can also understand the MySQL running status, process information, Use mysqladmin ext to understand the MySQL running status http://www.orczhou.co

the following Number of updates performed by Com_update:mysql Number of queries executed by Com_select:mysql Com_insert:mysql the number of inserts performed Com_delete: Number of deletions performed Com_rollback: Number of actions performed for rollback bytes_received: Number of bytes accepted Bytes_sent: Number of bytes Sent Slow_queries: Number of slow query statements 1, create MySQL performance monitoring script #!/bin/bash #Create by Zhengdazhi 20

Three ways to monitor MySQL with Zabbix 1. Just install Agent2. Enable template monitoring 3. Enable template monitoring for custom scriptsMySQL is the default monitor template in Zabbix. The default is already in the zabbix2.2 and above versions. Templates Name: Template App MySQL. If not then go to Zabbix official download Url:https://zabbix.org/mw/images/d/d4/template_app_mysql-2.2.0.xml, then configure the Web interface on the front-end of the Zabbix server- > Templates page, select Import,

/bashMysqladmin=mysqladminmysql_sock= "/tmp/mysql.sock"mysql_user=******mysql_pwd=********Args=1If [$#-ne "$ARGS"];thenecho "Please input one arguement:"FiCase $ inUptime)result= ' ${mysqladmin}-u${mysql_user}-p${mysql_pwd}-S $MYSQL _sock status|cut-f2-d ":" |cut-f1-d "T" 'Echo $result;;Com_update)result= ' ${mysqladmin}-u${mysql_user}-p${mysql_pwd}-S $MYSQL _sock extended-status |grep-w "com_update" |cut-d

Tags: mysql mysqldmin command line tool GUI toolConnect to MySQL serverMySQL client Mysqld Receive connection request:Local communication: The client is on the same host as the server side, and also communicates based on the 127.0.0.1 (localhost) address or the LO interface;Linux OR Unix:unix Sock,/tmp/mysql.sock,/var/lib/mysql/mysql.sockWindows:memory, PipeRemote communication: The client is on a different host than the server, or uses a non-loopback address to communicate on the same hostTCP s

Tag:mysql monitor statusresult [[emailprotected]scripts]#catcheckmysqlperformance.sh#!/bin/sh #Create bysfzhang2014.02.20mysql_sock= "/data/mysql/3306/mysql.sock" MYSQL_PWD= ' cat/ Data/mysql/3306/.mysqlpassword ' ARGS=1if[$#-ne "$ARGS" ];then echo "Pleaseinputonearguement:" ficase$1 Inuptime) result= ' mysqladmin-uroot-p${mysql_pwd}-s $MYSQL _sockstatus|cut-f2-d ":" |cut -f1-d "T" ' echo$ result;; com_update) result= '

Tags: Zabbix mysql monitor######################################################Monitor MySQL ( default monitor template is not available, then agentd.conf to open the custom key, write your own script )Add at the end of the zabbix_agentd.conf (note related file paths, and script permissions, etc.)Vim zabbix_agentd.confUserparameter=mysql.version,mysql-vUserparameter=mysql.ping,mysqladmin-uroot-p123456-s/tmp/mysql.sock Ping | Grep-c AliveUserparameter

Terminator is. \ G: Execute the command no matter what the command Terminator is, and display the execution result in a vertical bar (it looks intuitive ). \ Q: Exit mysql \! Shell command: execute shell command \ in mysql \! Ll/root // view the price information under root. ⑤ Server commands Mysqladmin-uroot-h localhost password 'redhat' // The password option changes the user password. Mysqladmin version