show status会锁表？

mysqllog

在一个群里看到有个问，但没人回答，有同样的疑问，来这问问

查看mysql服务器一些状态时，应该是要在某个时刻内得到一个统一的值，那就应该锁住相关表！

TomLeng

顶，我也想知道

飞鸿无痕

同样想知道！

cenalulu

这段东西可能可以解答你的疑问，不过是针对innodb的information_schema相关表的

For performance reasons, and to minimize the chance of misleading JOINs between the INFORMATION_SCHEMA tables, InnoDB
collects the required transaction and locking information into an intermediate buffer whenever a SELECT on any of the tables is is-
sued. This buffer is refreshed only if more than 0.1 seconds has elapsed since the last time the buffer was used. The data needed to
fill the three tables is fetched atomically and consistently and is saved in this global internal buffer, forming a point-in-time
“snapshot”. If multiple table accesses occur within 0.1 seconds (as they almost certainly do when MySQL processes a join among
these tables), then the same snapshot is used to satisfy the query.