Bug #106528 | list of unused indexes on sys.schema_unused_indexs | ||
---|---|---|---|
Submitted: | 21 Feb 2022 14:34 | Modified: | 23 Feb 2022 20:14 |
Reporter: | Izzy Fayon | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: SYS Schema | Severity: | S2 (Serious) |
Version: | 5.7.35 | OS: | Ubuntu (18.4) |
Assigned to: | MySQL Verification Team | CPU Architecture: | ARM |
[21 Feb 2022 14:34]
Izzy Fayon
[23 Feb 2022 20:14]
MySQL Verification Team
Hi SYS database contains useful views giving you often useful info but it is not 100% and depends on the other things. You cannot just kill the indexes you see int unused_indexs view. What you should do is utilize the modern function to disable (temporary) indexes and monitor performance and drop them only if you see no performance changes... and also - one by one :D For further help about optimizing mysql server contact either our support team or our community forum for help. Thanks