# SHOW PROCESSLIST is deprecated? **URL:** \ **Category:** Percona Server for MySQL\ **Tags:** new-release\ **Created:** [January 7, 2024, 7:35pm UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629 "2024-01-07T19:35:51Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [January 7, 2024, 7:35pm UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/1 "2024-01-07T19:35:51Z")
It says here that “SHOW PROCESSLIST” is deprecated: > **[Percona Server for MySQL - Percona Server for MySQL 8.0.35-27 (2023-12-27)](https://docs.percona.com/percona-server/8.0/release-notes/8.0.35-27.html#deprecations)** > > Get started with Quickstart Guide for Percona Server for MySQL. > **Deprecations** > The following items are deprecated in this release and using any of these items may cause a warning: > > - INFORMATION\_SCHEMA.PROCESSLIST and the SHOW PROCESSLIST command However, it doesn’t seem to be the case here: [https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-35.html](https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-35.html) > INFORMATION\_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL release. As such, **the implementation of SHOW PROCESSLIST which uses that table** is also deprecated. They just say that the implementation of `SHOW PROCESSLIST` using `information_schema` is deprecated, but not the implementation using `performance_schema`. See also top description at: [https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html](https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html) Can you please clarify? ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [January 8, 2024, 2:49am UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/2 "2024-01-08T02:49:45Z")
Hello @nunop, Please refer to the documentation for the command where it mentions the depreciation warning: [https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html](https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html) > As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, unlike the default SHOW PROCESSLIST implementation, does not require a mutex and has better performance characteristics. You might find that note in 8022 release note. Thanks, K ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [January 8, 2024, 8:35am UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/3 "2024-01-08T08:35:58Z")
Thanks. I read that before, and I referred to that description in my first post above. That message is saying that the default **implementation** is deprecated, and that a **new implementation** is available to use. > As of MySQL 8.0.22, an **alternative implementation** for SHOW PROCESSLIST **is available** based on the Performance Schema processlist table, which, unlike **the default** SHOW PROCESSLIST **implementation** , does not require a mutex and has better performance characteristics. Not the whole `SHOW PROCESSLIST` being deprecated, as the Percona change log at [Percona Server for MySQL 8.0.35-27 (2023-12-27) - Percona Server for MySQL](https://docs.percona.com/percona-server/8.0/release-notes/8.0.35-27.html#deprecations) makes it seem. ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [January 8, 2024, 9:54am UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/4 "2024-01-08T09:54:49Z")
Hi @nunop, I understand that that text from both the documentation as they’re are saying the same thing. MySQL doc is descriptive while the Percona doc is making 2 bulletpoints. Are you trying to highlight that there is no explicit mention of “`SHOW PROCESSLIST`” is re-implemented using `performance_schema`? aaha… I was typing above text and realized what you mean > “SHOW PROCESSLIST - is not deprecated, just the implementation has changed to use performance\_schema.” and documentation is sort of misleading there. Thanks, K ---
**Author:** ![nunop](https://avatars.discourse-cdn.com/v4/letter/n/5fc32e/32.png) [@nunop](https://forums.percona.com/u/nunop)\ **Post date:** [January 8, 2024, 10:03am UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/5 "2024-01-08T10:03:25Z")
When I read Percona’s change log: > **Deprecations** > The following items are deprecated in this release and using any of these items may cause a warning: > > - INFORMATION\_SCHEMA.PROCESSLIST and the SHOW PROCESSLIST command I understand this as `SHOW PROCESSLIST` being deprecated, and that I should stop using it, as using “any of these items may cause a warning”. I’m simply saying that it may need more clarification to say that `SHOW PROCESSLIST` will continue to work, as that’s what MySQL’s change log and documentation says. ---
**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\ **Post date:** [January 8, 2024, 4:59pm UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/6 "2024-01-08T16:59:14Z")
correct, that’s what I understood. This could be a documentation bug, though I couldn’t raise the bug report yet. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [January 8, 2024, 7:41pm UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/7 "2024-01-08T19:41:00Z")
@nunop Thank you for bringing this to our attention. I’ve opened a bug with our documentation team. [https://perconadev.atlassian.net/browse/DOCS-101](https://perconadev.atlassian.net/browse/DOCS-101) ---
**Author:** ![Modestas\_Mockus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/modestas_mockus/32/9024_2.png) [@Modestas\_Mockus](https://forums.percona.com/u/Modestas_Mockus)\ **Post date:** [January 19, 2024, 11:47am UTC](https://forums.percona.com/t/show-processlist-is-deprecated/27629/8 "2024-01-19T11:47:01Z")
results are different from both schema, in performance shchema some strange hanging process with “DELETE FROM mysql.wsrep\_cluster\_members” > SQL \> select \* from information\_schema.processlist order by id asc; > ±—±----------------±-------------------±-------------------±--------±-----±-------------------------±-------------------------------------------------------------±--------±----------±--------------+ > | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME\_MS | ROWS\_SENT | ROWS\_EXAMINED | > ±—±----------------±-------------------±-------------------±--------±-----±-------------------------±-------------------------------------------------------------±--------±----------±--------------+ > | 1 | system user | | NULL | Sleep | 957 | wsrep: aborter idle | NULL | 956903 | 0 | 0 | > | 2 | system user | | NULL | Sleep | 957 | innobase\_commit\_low (-1) | NULL | 956903 | 0 | 0 | > | 8 | event\_scheduler | localhost | NULL | Daemon | 953 | Waiting on empty queue | NULL | 952795 | 0 | 0 | > | 10 | system user | | NULL | Sleep | 953 | innobase\_commit\_low (-1) | NULL | 952794 | 0 | 0 | > | 11 | system user | | NULL | Sleep | 953 | innobase\_commit\_low (-1) | NULL | 952793 | 0 | 0 | > | 12 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952793 | 0 | 0 | > | 13 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952792 | 0 | 0 | > | 14 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952792 | 0 | 0 | > | 15 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952792 | 0 | 0 | > | 17 | system user | | NULL | Sleep | 953 | innobase\_commit\_low (-1) | NULL | 952792 | 0 | 0 | > | 18 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952791 | 0 | 0 | > | 19 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952791 | 0 | 0 | > | 20 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952790 | 0 | 0 | > | 21 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952790 | 0 | 0 | > | 22 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952790 | 0 | 0 | > | 23 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952790 | 0 | 0 | > | 24 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952789 | 0 | 0 | > | 25 | system user | | NULL | Sleep | 953 | wsrep: applier idle | NULL | 952789 | 0 | 0 | > | 96 | dev-mm | 10.10.121.10:40590 | performance\_schema | Query | 0 | executing | select \* from information\_schema.processlist order by id asc | 0 | 0 | 0 | > ±—±----------------±-------------------±-------------------±--------±-----±-------------------------±-------------------------------------------------------------±--------±----------±--------------+ > 19 rows in set, 1 warning (0.0041 sec) > Warning (code 1287): ‘INFORMATION\_SCHEMA.PROCESSLIST’ is deprecated and will be removed in a future release. Please use performance\_schema.processlist instead > SQL \> select \* from performance\_schema.processlist; > ±—±----------------±-------------------±-------------------±--------±-----±-----------------------±---------------------------------------------±--------±----------±--------------±-----------------+ > | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME\_MS | ROWS\_SENT | ROWS\_EXAMINED | EXECUTION\_ENGINE | > ±—±----------------±-------------------±-------------------±--------±-----±-----------------------±---------------------------------------------±--------±----------±--------------±-----------------+ > | 1 | system user | NULL | NULL | Sleep | 972 | wsrep: aborter idle | NULL | 971355 | 0 | 0 | PRIMARY | > | 2 | system user | NULL | NULL | Sleep | 972 | | DELETE FROM mysql.wsrep\_cluster\_members | 971355 | 0 | 2 | PRIMARY | > | 8 | event\_scheduler | localhost | NULL | Daemon | 968 | Waiting on empty queue | NULL | 967248 | 0 | 0 | PRIMARY | > | 10 | system user | NULL | NULL | Sleep | 968 | | DELETE FROM mysql.wsrep\_cluster\_members | 967246 | 0 | 3 | PRIMARY | > | 11 | system user | NULL | NULL | Sleep | 968 | | DELETE FROM mysql.wsrep\_cluster\_members | 967246 | 0 | 2 | PRIMARY | > | 19 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967244 | 0 | 0 | PRIMARY | > | 12 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967246 | 0 | 0 | PRIMARY | > | 24 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967242 | 0 | 0 | PRIMARY | > | 14 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967245 | 0 | 0 | PRIMARY | > | 15 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967245 | 0 | 0 | PRIMARY | > | 17 | system user | NULL | NULL | Sleep | 968 | | DELETE FROM mysql.wsrep\_cluster\_members | 967244 | 0 | 2 | PRIMARY | > | 18 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967244 | 0 | 0 | PRIMARY | > | 20 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967243 | 0 | 0 | PRIMARY | > | 21 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967243 | 0 | 0 | PRIMARY | > | 22 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967242 | 0 | 0 | PRIMARY | > | 23 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967242 | 0 | 0 | PRIMARY | > | 13 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967245 | 0 | 0 | PRIMARY | > | 25 | system user | NULL | NULL | Sleep | 968 | wsrep: applier idle | NULL | 967242 | 0 | 0 | PRIMARY | > | 96 | dev-mm | 10.10.121.10:40590 | performance\_schema | Query | 0 | executing | select \* from performance\_schema.processlist | 0 | 18 | 38 | PRIMARY | > ±—±----------------±-------------------±-------------------±--------±-----±-----------------------±---------------------------------------------±--------±----------±--------------±-----------------+ > 19 rows in set (0.0033 sec)