Bug #77746 mysql_upgrade should report progress
Submitted: 16 Jul 2015 16:34 Modified: 17 Jul 2015 11:11
Reporter: Morgan Tocker Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[16 Jul 2015 16:34] Morgan Tocker 
Description:
When the mysql_upgrade utility runs, it is possible that it might need to make quite substantial changes that take considerable time.

It would be nice if it reported things like run time, similar to how mysqlpump does in 5.7.8.  In addition to this, it would be nice to get a summary of:

- number of databases and tables checked
- number fixed

This can be useful information to a DBA that manages a fleet of mysql installs and is not interactively watching the upgrade process all the time, but wants to know how successful it has been before deploying to more servers.

How to repeat:
Feature Request.
[17 Jul 2015 11:52] Simon Mudd 
Two further thoughts.

* For logging purposes it would be convenient to actually confirm the version of the master being connected to. Otherwise there's no later way to verify that.
* Keeping a persistent log of the activity is often handy for later diagnosis or auditing. currently the output goes to stdout/stderr so if not explicitly requested it's easy to lose. I would be interested in seeing logging to syslog (mysqld can now log there) or to some sort of log file so that a record can be kept of the upgrade activity.