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

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.

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.

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.