MYSQL DB Creation is slow because of TABLE_SCHEMA table
Posted by: Nilay Mehta
Date: September 25, 2017 11:15AM

Hello There,

We are maintaining a SaaS-based system for which we have to create MySQL database runtime and also we have to destroy the same.

Right now our DB creation has become very very slow and after investigating we found 2 places are not cleaning up the data after dropping the database.


1) mysql.db table, Here I found few of the entries which are not removed but the physical database is removed.

2) information_schema.SCHEMA_PRIVILEGES
I can see there are 17,247,262 records in this table but out of which 12,909,078 records are from the dropped databases.

I suspect because of this many records in the information_schema.SCHEMA_PRIVILEGES the overall process of DB creation has become slow.

Please let me know how can I clean up the data from information_schema.SCHEMA_PRIVILEGES .

If you have any other thought then please do share.


Regards,
Nilay Mehta
Technical Architect
HiddenBrains.com

Options: ReplyQuote


Subject
Written By
Posted
MYSQL DB Creation is slow because of TABLE_SCHEMA table
September 25, 2017 11:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.