Skip to end of metadata
Go to start of metadata

Symptom


MySQL InnoDB restores with the file_per_table option can take a long time to terminate after a restore is complete. 

Cause


After a restore of InnoDB file_per_table databases completes, the tasks will continue to display as running, while the MySQL temporary instance log info is dumped into the cdp.log file.

A large number of InnoDB tables using file_per_table can cause a significant delay in completing the task.

Resolution


Now, the MySQL restore will only dump the MySQL temporary instance log files to the CDP Server if the CDP Server is unable to start the MySQL temporary instance.

Related Articles


Page: Adding a MySQL Instance to a Policy in Data Center Console (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: CDP for Databases (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Adding a MySQL Instance to a Policy (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Browsing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Allowing Remote Connections to MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Editing MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Enabling and Disabling MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Testing MySQL Instance Connection (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Deleting MySQL Instance (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: MySQL Restore in Large Deployment (CDP) Labels: mysql
Page: MySQL InnoDB File Per Table Restore (CDP) Labels: mysql
Page: MySQL Test Connection Fails when the Instance is Started with skip-innodb (CDP) Labels: mysql
Page: Solved Issue with Publishing MySQL Password (CDP) Labels: mysql
Page: MySQL Instance with a Non-Default tmp Directory (CDP) Labels: mysql
Page: Adding a MySQL Instance to a Policy on a PVC Container (CDP) Labels: enterprise_edition, advanced_edition, mysql
Page: Protecting MySQL (CDP) Labels: mysql
Page: Multi-Threaded MySQL Restore (CDP) Labels: mysql
Page: System Requirements - CDP for Databases (CDP) Labels: mysql, sql, exchange
Page: Protecting MySQL MariaDB and Percona Server (CDP) Labels: mysql
Labels:
mysql mysql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.