【原创】查找原始MySQL死锁ID
如果遇到死锁了，怎么解决呢？找到原始的锁ID，然后KILL掉一直持有的那个线程就可以了，但是众多线程，可怎么找到引起死锁的线程ID呢？MySQL发展到现在，已经非
如果遇到死锁了，怎么解决呢？找到原始的锁ID，然后KILL掉一直持有的那个线程就可以了，服务器空间， 但是众多线程，可怎么找到引起死锁的线程ID呢？ MySQL 发展到现在，已经非常强大了，这个问题很好解决。 直接从数据字典连查找。
我们来演示下。
线程A，我们用来锁定某些记录，假设这个线程一直没提交，或者忘掉提交了。 那么就一直存在，但是数据里面显示的只是SLEEP状态。
线程B， 我们用来进行普通的更新，网站空间，但是遇到问题了，此时不知道是哪个线程把这行记录给锁定了？
上面的信息很繁多，也看不清楚到底哪里是哪里。
不过现在，我们只要从数据字典里面拿出来这部分信息就OK了。
原来是线程16忘掉COMMIT了。
本文出自 “上帝，网站空间，咱们不见不散！” 博客，请务必保留此出处
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1376
52
what is mysql innodb
Apr 14, 2023 am 10:19 AM
InnoDB is one of the database engines of MySQL. It is now the default storage engine of MySQL and one of the standards for binary releases by MySQL AB. InnoDB adopts a dual-track authorization system, one is GPL authorization and the other is proprietary software authorization. InnoDB is the preferred engine for transactional databases and supports transaction security tables (ACID); InnoDB supports row-level locks, which can support concurrency to the greatest extent. Row-level locks are implemented by the storage engine layer.
How MySQL sees InnoDB row format from binary content
Jun 03, 2023 am 09:55 AM
InnoDB is a storage engine that stores data in tables on disk, so our data will still exist even after shutdown and restart. The actual process of processing data occurs in memory, so the data in the disk needs to be loaded into the memory. If it is processing a write or modification request, the contents in the memory also need to be refreshed to the disk. And we know that the speed of reading and writing to disk is very slow, which is several orders of magnitude different from reading and writing in memory. So when we want to get certain records from the table, does the InnoDB storage engine need to read the records from the disk one by one? The method adopted by InnoDB is to divide the data into several pages, and use pages as the basic unit of interaction between disk and memory. The size of a page in InnoDB is generally 16
How to handle mysql innodb exception
Apr 17, 2023 pm 09:01 PM
1. Roll back and reinstall mysql. In order to avoid the trouble of importing this data from other places, first make a backup of the database file of the current library (/var/lib/mysql/location). Next, I uninstalled the Perconaserver 5.7 package, reinstalled the original 5.1.71 package, started the mysql service, and it prompted Unknown/unsupportedtabletype:innodb and could not start normally. 11050912:04:27InnoDB:Initializingbufferpool,size=384.0M11050912:04:27InnoDB:Complete
How to solve phantom reading in innoDB in Mysql
May 27, 2023 pm 03:34 PM
1. Mysql transaction isolation level These four isolation levels, when there are multiple transaction concurrency conflicts, some problems of dirty reading, non-repeatable reading, and phantom reading may occur, and innoDB solves them in the repeatable read isolation level mode. A problem of phantom reading, 2. What is phantom reading? Phantom reading means that in the same transaction, the results obtained when querying the same range twice before and after are inconsistent as shown in the figure. In the first transaction, we execute a range query. At this time, there is only one piece of data that meets the conditions. In the second transaction, it inserts a row of data and submits it. When the first transaction queries again, the result obtained is one more than the result of the first query. Data, note that the first and second queries of the first transaction are both in the same
MySQL storage engine selection comparison: InnoDB, MyISAM and Memory performance index evaluation
Jul 26, 2023 am 11:25 AM
MySQL storage engine selection comparison: InnoDB, MyISAM and Memory performance index evaluation Introduction: In the MySQL database, the choice of storage engine plays a vital role in system performance and data integrity. MySQL provides a variety of storage engines, the most commonly used engines include InnoDB, MyISAM and Memory. This article will evaluate the performance indicators of these three storage engines and compare them through code examples. 1. InnoDB engine InnoDB is My
How to deal with deadlock problems in C++ development
Aug 22, 2023 pm 02:24 PM
How to deal with deadlock problems in C++ development Deadlock is one of the common problems in multi-threaded programming, especially when developing in C++. Deadlock problems may occur when multiple threads wait for each other's resources. If not handled in time, deadlock will not only cause the program to freeze, but also affect the performance and stability of the system. Therefore, it is very important to learn how to deal with deadlock problems in C++ development. 1. Understand the causes of deadlocks. To solve the deadlock problem, you first need to understand the causes of deadlocks. Deadlock usually occurs when
Prevention and solution of deadlock and starvation in golang function concurrency control
Apr 24, 2024 pm 01:42 PM
Deadlock and starvation in Go: Preventing and solving deadlock: Coroutines are waiting for each other and cannot perform operations. Use the runtime.SetBlockProfileRate function to detect. Prevent deadlocks: Use fine-grained locking, timeouts, and lock-free data structures to prevent deadlocks. Starvation: The coroutine continues to be unable to obtain resources, and fair locks are used to prevent starvation. Fair lock practice: Create a fair lock and wait for the coroutine to try to acquire the lock for the longest time to acquire the lock first.
Deadlock prevention and detection mechanism in C++ multi-threaded programming
Jun 01, 2024 pm 08:32 PM
Multi-thread deadlock prevention mechanism includes: 1. Lock sequence; 2. Test and set up. The detection mechanism includes: 1. Timeout; 2. Deadlock detector. The article takes an example of a shared bank account and avoids deadlock through lock sequence. The transfer function first requests the lock of the transfer out account and then the transfer in account.
