mysql deadlock detection

Label:There are 3 ways to fix MySQL database:1. mysql Native SQL command: RepairExecute the Repair TABLE SQL statementSyntax: REPAIR TABLE tablename[,tablename1 ...] [Options]Example: mysql> use database xxx;mysql> Repair Table *;2. Using MySQL's own client tool: Mysqlcheck (no need to stop

finished before the report is output. The combined Calculation function count () assigns the result of the arg2 of the "Dispatch_command" function to @query.# querycounts.d-p ' Pgrep-x mysqld 'Tracing ... Hit Ctrl-c to end.^cSELECT * FROM Countrylanguage LIMIT 5 1Show Tables 4SELECT * FROM City 10Obviously, the output of this example is not the result of a real production system. If used in production, you will get far more results than that output.The example discussed here is just the tip of

intercept the MySQL CPU value, Cut command By default is tab-delimited, but PS aux display the string blank is a space instead of tab, we will use a space to split, Some of the string is a number of spaces, here the-f8 parameter is to intercept the 8th string (some system may be 6th), this string is the CPU utilization of MySQL!Maybe you have a question, now that you've got the CPU usage of

Tags: mysql master-slave detection script#!/bin/bash# check mysql slave statususer= "check" psw= "* * *" runtime=3600addr= "192.168.*.*" Declare-a slave_isfor IP in $ Addrdoslave_is= ($ (/usr/local/mysql/bin/mysql-h$ip-u${user}-P${PSW}-e "show slave status\g" |grep Running|a

When we use the MySQL database, we may encounter many unexpected damages to the database table, and the data is new data. We usually look for the backup data, but in general, it cannot be found. This chapter describes how to detect MySQL database table faults. The general process of fault detection and correction in the table is as follows: Check the tables with

' PortNum= ' netstat -lnt|grep3306|wc-l ' mysqlstartup= "/data/3306/mysql" logpath= "/tmp/mysql.log" if[$ portnum-eq1-a $mysqlProcessNum -eq2];thenecho "db isrunning "else $MysqlStartUp start> $LogPathsleep 10; mysqlprocessnum= ' ps-ef|grepmysqld|grep-vgrep|wc-l ' PortNum= ' netstat -lnt|grep3306|wc-l ' if[ $PortNum -ne1] [ $mysqlProcessNum -ne2];thenwhiletrue dokillallmysqld>/dev/null2>1 [$?-ne0]break sleep1done $MysqlStartUp start>> $LogPath statu

The general process of fault detection and correction for a table is as follows: Check for errors in the table. If the table checks through, complete the task, or you must fix the database table that is wrong. Copy the table files before starting the repair to keep the data secure. Start repairing database tables. If the repair fails, restore the data from the backup or update log of the database. Before you use Myisamchk or isamchk to check or fi

This article mainly introduces the PHP implementation of the MySQL master-slave database state detection function, combined with specific examples of PHP detection of multiple MySQL master-slave database connection status related implementation skills, the need for friends can refer to the next This paper describes th

Label:statusmysqllocal detection Check MySQL master-slave sync #!/bin/sh path=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin Logfile=/data/repair_mysql_sync_ ' date+%f '. Log sqlcmd1= "Showslavestatus" ## See if MySQL has started if[[ ' psaux|grepmysqld|grep-v grep ' x ' = ' x ' ]];then echothemysqlis notrunningat: ' date+%f ' '%h-%m-%s ' >>${

top and bottom two connections, it is very simple to detect. Mysql>selectcount (*) from (select*fromt1_oldunionselect *fromt1_new) ast;+----------+|count (*) |+----------+|100|+----------+1rowinset (0.06 NBSP;SEC) Here the number of records is 100, the preliminary proof that the two tables are consistent. However, there is a bug in this approach, and in some cases it is not possible to simply represent a consistent result set. such as:mysql>createtab

You may be in the process of using MySQL, all kinds of accidents cause damage to the database table, and this data is often the most recent data, it is often impossible to find in the backup data. This chapter describes how to detect the failure of a MySQL database table. The general process of fault detection and correction for a table is as follows: Check for

Paip. Improve Stability --- automatic detection of sleep mysql database dead connections and killAuthor Attilax airlong, EMAIL: 1466519819@qq.comSource: attilax ColumnAddress: http://blog.csdn.net/attilax///// Detects the leakage of the application database.The main principle is:A. When conn is called, get the localport of conn and store it as a listB. query all connections on the current machine from mysql

/mysql_ping.sh) Jul 2216:29:59master_mysqlcrontab[6138]: (Root) LIST (root) jul22 16:30:01master_mysqlcrond[6140]: (Root) CMD (/bin/bash/root/scripts/mysql_ ping.sh) JULNBSP;22NBSP;16:32:01NBSp master_mysqlcrond[6394]: (Root) CMD (/bin/bash/root/scripts/mysql_ping.sh) Jul 2216:34:01master_mysqlcrond[6429]: (Root) CMD (/bin/bash/root/scripts/ mysql_ping.sh) #脚本执行日志 [[emailprotected]_mysqlscripts]#catmysql_run.log20140722 16:28:14mysqlisrestart2014072216:30:09mysqlis Restart2014072216:34:08mysqlis

| 72553 | | NULL | 0 | 0 || 9060 | Root | localhost | Test | Query | 0 | init | Show Processlist | 0 | 0 || 9289 | Root | localhost | NULL | Sleep | 40 | | NULL | 0 | 0 |+------+------+---------------------+------+-------------+-------+--------------------------------------------- --------------------------+------------------+-----------+---------------+5 rows in Set (0.00 sec)

Installing UuencodeYum Install SharutilsCreate a shell script#!/bin/bashdate_str= ' Date +%y%m%d ' slave=$ (/disk/mysql/bin/mysql-ucheckslave-p123-h 127.0.0.1-e "show slave Status\G"|grep Running |grep Yes |WC-L) if (($slave = = 2) then echo "Slave is OK |Status=${slave} Yes |Date =${date_str} ">>/disk/bak/local/mysql_slave_status.txt exit 0else echo" Slave is down |Status=${slave} Yes "| Mail-s test3 [emai

IP:"+IP) FD=Socket.socket (socket.af_inet, socket. SOCK_STREAM) Result= FD.CONNECT_EX ((IP, 1080)) ifresult = =0:Print("Success"+IP) SQL="UPDATE wx_proxy SET valid=2 WHERE ip=\ ""+ip+"\""execsql (SQL)Else: Print("Error"+IP) SQL="UPDATE wx_proxy SET valid=-1 WHERE ip=\ ""+ IP +"\""execsql (SQL) fd.close ()defLoadip ():ifLen (IPList) >0:Print("checking....wait") returnCursor.execute ("SELECT IP from wx_proxy WHERE valid!=-1 ORDER by ID DESC") Data=Cursor.fetchall () fo