MySQL Forums
Forum List  »  InnoDB

Innodb index change crash db
Posted by: Frwa Onto
Date: April 27, 2017 10:14PM

I have a server with 32Gb rams in it. I have given almost 70% innodb buffer pool to it. I have table with almost 40 millions data in it. Recently I tried to remove of the index and I tried to replace it with another. My whole system could not work any more all it not able to see my db.

I could see this errors alot in my application.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.

So I had to stop the db truncate the whole table and start a fresh. Is this a innodb limitation in future what can I do and what other the limitation I need to be known further?

Options: ReplyQuote

Written By
Innodb index change crash db
April 27, 2017 10:14PM

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.