…) 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… writes to the slave can be done by simply pausing replication.
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… recommend using these. There are also replicate-do-table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table options which act… tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb tables you… to ensure all Innodb tables are created as BLACKHOLE. However you can’t do the same with MyISAM tables, because MyISAM can’t…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… most popular transactional storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of… INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? … of others due to statement level MySQL Replication which among other requirements, needs all auto-…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… tables which is being read to be Innodb – even if writes are done in MyISAM table. So why was this done, being… I’m not using replication and have my binary log disabled ? If replication is not used you can enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… balanced or replication of mixed table types which is quite complicated. I prefer to pick one storage engine (typically Innodb) and when… logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really. MyISAM for many…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM and Innodb in the same terms, in fact they are quite different for Replication. As you probably know MyISAM uses buffered…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… for query execution – either row level locks for Innodb or table locks for MyISAM and any DDL statements. If you happen to… MyISAM slaves used for long reporting queries can have queries running for hours which stalls replication progress for this time. As MySQL Replication… one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one after another on the slave…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… only Innodb tables – Innodb when Innodb does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication… take LVM Snapshot (assuming you’re only using Innodb tables and not touching your MyISAM system tables) and use this position to…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… rather typical for systems to start as MyISAM but as system growths to move to Innodb. The reason of the move could… cross storage engine replication is not my favorite approach but sometimes it is less of the evils. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… of rows in tens of thousands tables) Innodb was better choice mainly because of thouse other… sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise…fall back to. Also be worried about replication with different storage engines. Then performance improvements…
