'clear' may make the server unusable in MySQL 5.6

Reported by Giuseppe Maxia on 2012-03-21
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Sandbox
High
Giuseppe Maxia

Bug Description

in MySQL 5.6 there are tables in the 'mysql' schema that should be converted to innodb to function properly.
If that has been done, a 'clear' command makes those tables unusable, as they can't live without the ibdata* files.

Suggested fix: the 'clear' command should convert those tables back to myisam.

Changed in mysql-sandbox:
status: New → Confirmed
assignee: nobody → Giuseppe Maxia (giuseppe-maxia)
importance: Undecided → High
Giuseppe Maxia (giuseppe-maxia) wrote :

This issue was fixed by changing the way a cleanup works.
The installer takes a dump of the mysql schema, which is then restored after a clear

Changed in mysql-sandbox:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers