…: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… the MySQL community are snobbish about using MyISAM (not using it that is) and that if not using InnoDB you aren’t too smart… use MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you should not use MyISAM. If none of the above apply, then you get the benefits of MyISAM which includes…
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” 
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
…:56:45 [ERROR] Got an error from unknown thread, storage/myisam/mi_write.c:223 120326 16:56:45 [ERROR] /usr… temporary table, using the MyISAM storage engine, and when the disk filled up, MyISAM got an error. Little-known secret: MyISAM doesn’t handle…
Comment: Should you move from MyISAM to Innodb ?
March 9, 2012 By 53 Comments
… i use. I am pretty sold out on innodb though mainly because of row locking and no overhead as compare to MyIsam… really confirm where should i use Innodb. Big table ie. users? comments? etc… i just compared MyIsam to Innodb while loading users… 145000 rows and found quite a significant speed gain from MyIsam. Will this be better once i tuned InnoDb settings? and…
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) you can consider using –no-lock option with Percona Xtrabackup. Many…
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: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… 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 to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… All – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb… I am not able to do a SINGLE DATABASE restore using the copy-back command. I am able to get the…/mysql folder. But I am able to view/access ONLY MYISAM table – but none of the InnoDB tables. Is there something…
Comment: Fixing column encoding mess in MySQL
March 14, 2012 By 32 Comments
Arggh. I have similar problem and nothing works. MyISAM tables with latin1 encoding. Tried: ALTER TABLE CONVERT TO CHARACTER … in this blog: UPDATE table SET column=CONVERT(CONVERT(column USING binary) USING utf8) WHERE id=123; And it.. Does nothing. £ sign…
