Percona Server 5.7 shutdowns for 10 or more minutes on a server with over than 2M tables.
- Load dump, pointed in the hidden comment
- Run mysqldump --all-databases --no-data >/dev/null
- Watch that "Dictionary memory allocated" is 16702202333 or higher in the SHOW ENGINE INNODB STATUS output
- Shutdown the server, measure time
Data from the MySQL Sandbox test:
This is only repeatable with provided structure. Tried 2M encrypted tables: shutdown is fast. Also accessing table definitions before shutdown is a must.
This is also repeatable with upstream, but I am not creating a report there yet, because test case contains sensitive data.