Shulou(Shulou.com)06/01 Report--

The following content mainly brings you some details of commonly used mysql scripts, the knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.

Check the lock:

More checkchecklock.shemaking binds Bash while truedo mysql-u root-p123456 _-H

> ~ / script/html/ `date + "% Y%m%d" `w11.html sleep 1donemore check_lock.sql SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query Now () FROM information_schema.innodb_lock_waits w INNER JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id INNER JOIN information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id

Check the process

Check_proc.sh #! / bin/bashwhile truedo mysql-u root-p123456H

> ~ / script/html/proc_ `date + "% Y%m%d%H" `. Html sleep 2donecat check_proc.sql select now (), id,user,host,db,command,time,state,info from information_schema.processlist where command not in ('Sleep','Binlog Dump') and INFO not like'% information_schema.processlist%'

For the above updates on some of the common mysql scripts, if you need to know more, you can continue to follow our industry promotion. If you need professional answers, you can contact the pre-sale and after-sale ones on the official website. I hope this article can bring you some knowledge updates.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.