Description:
The sys schema ps_setup_show_enabled() procedure shows not just enabled objects but disabled ones.
How to repeat:
mysql> CALL sys.ps_setup_show_enabled(FALSE, FALSE);
...
+-------------+----------------------+---------+-------+
| object_type | objects | enabled | timed |
+-------------+----------------------+---------+-------+
| EVENT | mysql.% | NO | NO |
| EVENT | performance_schema.% | NO | NO |
| EVENT | information_schema.% | NO | NO |
| EVENT | %.% | YES | YES |
| FUNCTION | mysql.% | NO | NO |
| FUNCTION | performance_schema.% | NO | NO |
| FUNCTION | information_schema.% | NO | NO |
| FUNCTION | %.% | YES | YES |
| PROCEDURE | mysql.% | NO | NO |
| PROCEDURE | performance_schema.% | NO | NO |
| PROCEDURE | information_schema.% | NO | NO |
| PROCEDURE | %.% | YES | YES |
| TABLE | mysql.% | NO | NO |
| TABLE | performance_schema.% | NO | NO |
| TABLE | information_schema.% | NO | NO |
| TABLE | %.% | YES | YES |
| TRIGGER | mysql.% | NO | NO |
| TRIGGER | performance_schema.% | NO | NO |
| TRIGGER | information_schema.% | NO | NO |
| TRIGGER | %.% | YES | YES |
+-------------+----------------------+---------+-------+
20 rows in set (0.02 sec)
...
Suggested fix:
Don't show disabled objects.