In November, I wrote about the command
SHOW ENGINE INNODB MUTEX and
sought feedback as to how it continues to be used post
The outcome from this feedback is that the MySQL team has decided to remove this command from MySQL 5.7.
These decisions are not light ones for the team to make. I wanted to thank everyone for their feedback, and also share why this decision was an important one for the future of MySQL:
- By design, data collection for
SHOW ENGINE INNODB MUTEXwas always enabled, with no switch to disable it. We believe that for some workloads being able to disable the collection is useful, and in the case of
performance_schemathis is possible.
performance_schemaoverlaps with this …