简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

专栏：MySQL内核与性能优化

WBOY
Release： 2016-06-07 15:19:11
Original
1022 people have browsed it

[数据库] 禁止死锁检测来提升高并发MySQL性能 在一个高并发的MySQL服务器上，事务会递归检测死锁，当超过一定的深度时，性能的下降会变的不可接受。FACEBOOK早就提出了禁止死锁检测。我们做了一个实验，在禁止死锁检测后，TPS得到了极大的提升，如下图所示：

[数据库] 禁止死锁检测来提升高并发MySQL性能

在一个高并发的MySQL服务器上，事务会递归检测死锁，当超过一定的深度时，性能的下降会变的不可接受。FACEBOOK早就提出了禁止死锁检测。 我们做了一个实验，在禁止死锁检测后，TPS得到了极大的提升，如下图所示： 禁止死锁检测后，即使死锁发生，也不会回滚事务，而是全部等待到超时 Patch比较简单，直接在死锁检测前加一层判断即可： if (innobase_deadloc...

mysql facebook patch 服务器

zhaiwx1987 2011-11-09 14:22 阅读(1105) 评论(0)

Related labels：
mysql Column optimization Kernel performance database Detection deadlock prohibit
source：php.cn
Previous article：mysql中文乱码的解决 Next article：比起主流的30秒，10秒广告能获得2倍的效果
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
CSS bottom border on navigation bar I have a navigation bar and I have added a red line at the bottom when any item in the lis...
From 2024-04-06 15:04:41
0
2
347
Fix image and name position I'm trying to code a website, but the image and name (Administracija) appear on the left s...
From 2024-04-05 10:41:36
0
1
3578
Center dropdown menu in navigation bar I made this CSS/HTML. .navbar{width:100%;background-color:rgb(151,44,44);overflow:auto;}.n...
From 2024-04-04 18:24:52
0
1
338
How to query multiple select elements stored in database Querying areas of expertise (stored as an array of any selected items) does not work. I'm ...
From 2024-04-04 13:18:46
0
1
304
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！