May 24, 2012

Comment: How to calculate a good InnoDB log file size

…: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

Post: Bug#12704861

you can find it in the bzr tree if youusetext of Marko’s commit message for the fix as it’s interesting reading for those of us who are into InnoDBBLOBs, orbigBLOB pointers must be a fresh insert. row_upd_clust_rec(): When columns are

Post: Heikki Tuuri Innodb answers - Part I

rows whose latest committed version does not match the WHERE condition in a search. Please use this with care: you MUST use rowIf you are not seeing ‘thread thrashing’ (lots of threads waiting for semaphores in SHOW INNODB STATUS), you

Comment: How to calculate a good InnoDB log file size

…:54:18 InnoDB: ERROR: the age of the last checkpoint is xxxxx, InnoDB: which exceeds the log group capacity yyyyy. 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. then it…