The “SHOW PROCESSLIST command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex. From MySQL 8.0.22, we have an alternative way [&]

https://www.percona.com/blog/2021/01/15/mysql-8-0-22-show-processlist-version-2-now-available-from-performance_schema/