This article is also available in Chinese: 中文版. Browse all English articles. Have you ever run into a mysqld process that has been starting for a long time and still won’t come up? When that happens, you can use perf top to check what the M…
This article is also available in Chinese: 中文版. Browse all English articles. Since MySQL 5.6, the MySQL replication team has been working to reduce replication lag. The first step was schema-level parallel application of the binlog, but sch…
This article is also available in Chinese: 中文版. Browse all English articles. Large transactions are a notorious problem in MySQL: they cause not only replication lag but also stability problems. A previous article, MySQL Large Transaction C…
This article is also available in Chinese: 中文版. Browse all English articles. If you use and operate MySQL, you’ve surely run into a strange slow query like this: An INSERT that’s normally instant took 1.3s, and the slow-query log shows no l…