May 24, 2012

Post: Magic Innodb Recovery self healing

on per table basics. Also if MySQL crashes during recovery lower values of innodb_force_recovery normally would notinnodb_force_recovery=4. So I decided to check if I’m to get lucky second time today. And Indeed Restarting Innodb with innodb_force_recovery=0 allowed

Post: How InnoDB handles REDO logging

InnoDB can log. You can request that InnoDB force its REDO records to the transaction log but notis equal or higher the record is skipped. This behavior can be seen by enabling the innodb_recovery_stats option in Percona Server, which allows

Comment: When is it a time to upgrade memory ?

InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodbis not a support platform for mysql and that I am not a DBA. Please do not