On several occasions it may be necessary to do some tasks around the process of starting or stopping a MySQL server such as:
- Perform a warmup of the database using custom scripts and
external information that the
init_fileconfiguration may not have access to. - Change configuration settings such as
innodb_log_file_sizeand adjust the on disk files that this needs. - Change configuration settings such as
log_bin(I try to use a relative paths to ensure that different instances use a common setting even ifdatadiris different, and changing from an absolute to relative path often requires adjusting the binlog index file). - Shutting down MySQL may need to be delayed if the SQL thread has open temporary tables or open transactions are still being processed.
- etc…
You may have others and many of these are likely to be site …
[Read more]