June 18, 2013

Comment: Adaptive checkpointing

John, We can check the checkpoint age even if we use normal MySQL. From the output of SHOW INNODB STATUS, =========================== — LOG — Log sequence number 0 1059494372

Comment: How to calculate a good InnoDB log file size

… BST 2010 100601 9:39:04 InnoDB: ERROR: the age of the last checkpoint is 9434190, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB: largest such row.