修复 MySQL 中 Table_locks_waited 高的问题
当我查看数据库信息时，我看到以下内容。 Table_locks_waited 较高。我该如何缓解这个问题？
When I'm looking at info of my database I see the following. Table_locks_waited is high. How do I go about mitigating this problem?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，您应该运行：
这将显示等待的查询与能够立即获取锁的查询的比率。也许你有更高的写入和读取混合，这导致 mysql 必须比最佳状态更频繁地等待，但整体性能无法用单个统计数据进行分析。
我的第一个建议是更改您的表，以便对承受事务负载首当其冲的表使用 Innodb 引擎。 Innodb 具有行锁定而不是表锁定，并且还具有聚集索引和查询数据缓存，这些在许多情况下往往会提高性能。
First you should run:
This will show you the ratio of queries that wait to those that are able to get locks immediately. Probably you have a higher mix of writes to reads, that is causing mysql to have to wait more frequently than is optimum, but overall performance can't be analyzed with a single statistic.
My first suggestion would be to alter your tables so that you are using the Innodb engine for the tables that are bearing the brunt of the transaction load. Innodb has row locking rather than table locking, and also has clustered indexes and query data caching that tend to improve performance in many cases.