MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: InnoDB: Database was not shut down normally after changing innod_db_log_file_size
Posted by: Rick James
Date: October 05, 2013 12:16PM

Sorry, I don't have a 'straight' answer. Here are some comments.

> Database was not shut down normally!
Only a graceful shutdown should be done when changing log_file_size.

I am skeptical about innodb_fast_shutdown = 0. I feel that the logfiles have important information, and crash recovery is not clean.

> Initializing buffer pool, size = 8.0M
An old default. Much to small a setting for innodb_buffer_pool_size for all but trivial installations.

> Log file ./ib_logfile0 did not exist: new to be created
Yes. You removed them to cause it to rebuild with a new size.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
InnoDB: Database was not shut down normally after changing innod_db_log_file_size
1968
Area sistemi Ripartizione Informatica
October 04, 2013 02:36AM
Re: InnoDB: Database was not shut down normally after changing innod_db_log_file_size
1130
Rick James
October 05, 2013 12:16PM
Re: InnoDB: Database was not shut down normally after changing innod_db_log_file_size
2278
Area sistemi Ripartizione Informatica
October 07, 2013 03:01AM


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.