Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.
Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”
Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.
Here on the …[Read more]