… if a feature that will permit to skip some bases (innodb or myisam) in the cluster will be announced soon ? Because actually…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…) Reads though would not be blocked, ie there is no MYISAM like table lock priority problem with pending WRITE query blocks…’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… about using MyISAM (not using it that is) and that if not using InnoDB you aren’t too smart. However, InnoDB brings a lot of cons to the table which are missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB…
Comment: Should you move from MyISAM to Innodb ?
March 9, 2012 By 53 Comments
… on innodb though mainly because of row locking and no overhead as compare to MyIsam. I change 90% of my tables to innodb… confirm where should i use Innodb. Big table ie. users? comments? etc… i just compared MyIsam to Innodb while loading users from 145000 rows and found quite a significant speed gain from MyIsam. Will this…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 9, 2012 By 9 Comments
Quick question… does the pt-online-schema-change tool work at tables using the MyISAM storage engine? Would it work to convert a table from MyISAM to InnoDB?
Comment: Should you move from MyISAM to Innodb ?
March 5, 2012 By 53 Comments
Thank you for this article. But I see here lot of “cons” about Innodb and lot of “pros” about MyISAM. So it sounds more like “use MyISAM” 
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… using the innobackupex-1.5.1 command. I have the innodb_file_per_table directive set in the my.cnf configuration…. But I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is there something which I am… any directive in the my.cnf file to access the InnoDB table? Please help. Thanks in advance. Abhilasj
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… speak about Innodb tables and backup with Xtrabackup or LVM we do not really need it. What we need is MyISAM tables flushed and read only so they can be copied and Innodb tables can be written to…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… Google Patches II, where InnoDB file writes can be altogether disabled using a global variable setting? For InnoDB based databases, this allows…-queries, and no actual flushing of data (I intentionally disregard MyISAM tables here). Any caveats I’m not aware of? Would…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… has an InnoDB-only solution that avoids blocking. I think the problems for FTWRL come from having to support MyISAM and I hope that the distributions (Percona, MariaDB, MySQL) also provide a solution. See “START TRANSACTION WITH CONSISTENT INNODB SNAPSHOT…
