Bug #68233 Feature request for the "Change the Storage Engine of All Tables" utility plugin
Submitted: 31 Jan 2013 7:59 Modified: 25 Mar 2013 17:08
Reporter: Philip Olson Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.46 OS:Any
Assigned to: CPU Architecture:Any
Tags: plugin

[31 Jan 2013 7:59] Philip Olson
Two feature requests for the following option:

  Plugins->Utilities->Change the Storage Engine of All Tables

1. Report that data was changed
2. Add an optional select box similar to the engine list available in preferences

1. Reporting the data means if, for example, changing the engine from "MyISAM" to "InnoDB" succeeded, it'd say something like "The storage engine was changed for 3 tables." or it could provide more details like mention the former/current engines. If nothing changed (e.g., InnoDB was already the engine for all tables) then it could instead say that.

2. Preferences->Model: MySQL->Default Storage Engine -- has a dropdown list of possible storage engines. It may be a good idea to offer this list to the above plugin, instead of (or in addition to) a text box. And maybe also add the text box option to the aforementioned preference.

How to repeat:
See the description.

Suggested fix:
As described above, or in a similar fashion.
[25 Mar 2013 17:08] Armando Lopez Valencia
Thanks for your request.