… the 2 log files (ib_logfile0 and ib_logfile1) 4) restart mysql I can see the new log file create as 64M… in the ib_logfiles! 130319 0:10:26 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information…: Loaded 0 events 130319 0:10:27 [Note] mysql\bin\mysqld.exe: ready for connections. Version: ’5.1.33-community’ socket: ” port: 3306 MySQL Community…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…on your recovery speed needs but 256M seems to be a good balance between reasonable recovery time…or two in case of full OS crash than set this value. It can …t reclaim. This option was added in MySQL 4.1 and now stable enough to use…. in locking in 5.0 and even more to come with MySQL 5.1 and row…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1… controlled by the new variable innodb_fast_recovery Fixed bugs: MySQL Bugs: #45357: 5.1.35 crashes with Failing assertion: index->type & DICT….36†This fixes also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The…
