I’ve been working on a project that requires us to shutdown and startup our development databases to save costs.. I’ve come up with a python script to perform the tasks. This could be modified to your own requirements. Here is the code:
Displays extensive information from the standard InnoDB Monitor about the state of the InnoDB storage engine. There are four types of InnoDB monitors: • The standard InnoDB Monitor displays the following types of information: • Work done by the main background thread • Semaphore waits • Data about the most recent foreign key and…
There is no excerpt because this is a protected post.
How to calculate the table and database size in MySQL and