MySQL Forums
Forum List  »  InnoDB

Re: Power failure and innodb
Posted by: Rick James
Date: March 05, 2014 10:42PM

> I tried to delete ib_logfile0

Yikes! That file is vital to recovery after a power failure.

> innodb_log_file_size | 50331648

It's not unreasonable to make that 1GB. (Be sure to find the instructions on how to change that value.)

How much RAM do you have? You have only 1GB in the buffer_pools.

If you can create a reproducable loss/corruption, file a bug at bugs.mysql.com

> innodb_flush_log_at_trx_commit | 1

That's probably the ultimate in durability.

Are you using BEGIN...COMMIT? Or are you using autocommit=0?

Options: ReplyQuote


Subject
Views
Written By
Posted
8138
January 27, 2014 09:45AM
2717
January 28, 2014 08:42AM
2760
February 24, 2014 06:21AM
2216
March 05, 2014 08:15AM
Re: Power failure and innodb
2071
March 05, 2014 10:42PM
1937
March 07, 2014 07:46AM
1438
February 02, 2015 09:33AM
1413
February 02, 2015 11:43AM
1520
February 03, 2015 05:09AM
1472
February 03, 2015 07:04PM
1890
February 04, 2015 01:03PM
1160
June 04, 2015 07:35AM
2590
March 31, 2014 06:16AM
1455
March 18, 2015 11:12AM


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.