…regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates …- It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue …
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory …from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… i converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, which almost… should increase your tmp_table_size and/or max_heap_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… heard before. The argument is this: “you can create an InnoDB temporary table and use it only within one transaction, and then if… the temporary table into a non-temporary InnoDB table: master > delimiter // master > create procedure test_temp() begin -> start transaction; -> create temporary table test.t(a int) engine=innodb…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… MyISAM temporary table. What i decided to do is to see how much overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table and types which can… set to accommodate needs of your temporary table. Do not forget about it especially if running only Innodb tables so you may think there…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… copy the data to a temporary table is constant. The reason is that when using merge sort, InnoDB has to scan the clustered… ALTER TABLE are ignored to enforce uniqueness where necessary when copying the data to a temporary table; ALTER TABLE and OPTIMIZE TABLE always process tables containing…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
….GLOBAL_TEMPORARY_TABLES or TEMPORARY_TABLES would crash threads working with temporary tables. Bug fixed #951588 (Laurynas Biveinis). A crash could leave behind an InnoDB temporary table with temporary indexes… with skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB_PATCHES…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…, you can’t recreate the “dos2″ table, and you can’t turn the orphaned temporary table back into its former self unless you’re handy with a hex editor and have a good knowledge of InnoDB… look inside the InnoDB data directory for this database to get the actual filename of the temporary table rather than the temporary table name that…
