Programmer Think

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 ...

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 ...

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 ...

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 ...