MySQL Forums
Forum List  »  InnoDB

Mysql service hangs on ALTER TABLE only on one particular database
Posted by: Noel Abela
Date: October 21, 2015 05:29AM

We have mysql community 5.6.23 installed on Hyper-V virtual server with 16GB ram
on Windows Server2012 R2 Standard, Mysql is on drive C: and mysql data is on drive E: which is on RAID 11

when we change a table structure in one particular database, the mysql service stops on executing the sql script.
The sql command is

After this situation, the mysql service cannot be re-started any more.

We tried to re-install the mysql server again to point to the already existing data, but not even the new installation service could be started.

The only way to get the service started again was to re-copy the whole data folder of mysql

Has anyone met with this situation before?
Many Thanks in advance.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.