Occurrence and handling of Mysql deadlock

preface How should we troubleshoot and analyze Mysql deadlock? There is an insert on duplicate deadlock problem on the front line of. Based on this deadlock problem, this paper will share the troubleshooting and analysis process, hoping to be helpful to you. Deadlock Case recovery Table structure: CREATE TABLE `song_rank` ( `id` int(11) NO ...

Posted by robkir on Sat, 19 Feb 2022 05:29:52 +0100

show engine innodb status and innodb lock monitoring

innodb monitor overview innodb monitor is a built-in monitoring module of innodb. You can view it with show engine innodb status. innodb monitor output can be output in the error log To view finer grained innodb lock information, you need to open innodb_status_output_locks Type of innodb monitor There are two types of innodb monitor: innod ...

Posted by AcousticJames on Sat, 12 Feb 2022 07:35:04 +0100

Deep understanding of MySQL logs

1.Error LogRecord the Error, Warning, Note and other information during MySQL operation. If there is a system Error or a record has a problem, you can view the Error log.MySQL's error log defaults to hostname Err is stored in the MySQL log directory and can be viewed through the following statementDuring default installation, the error log is u ...

Posted by jassh on Thu, 13 Jan 2022 05:12:04 +0100

It's over. Why doesn't my business take effect?

preface We should write about affairs at ordinary times. We encountered a pit when writing affairs before, but it didn't take effect. Later, we checked and reviewed the failure scenarios of various affairs. We thought we might as well make a summary, so that we can have confidence in the next troubleshooting. First, let's review the relevant k ...

Posted by insight on Wed, 29 Dec 2021 16:42:51 +0100