…. If you’re talking about using a temporary table to store an interim result set, and then use that to ultimately produce the…. There are other drawbacks to using temporary tables in this way, for example when using replication, a temporary table could vanish if the slave… secondary index. But the result was that it created a temporary table to count the movies per production year for each…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction… transaction. The same issue can arise if slave host is using different storage engine for the respective table on master databases…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging… from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona…
Comment: Using index for ORDER BY vs restricting number of rows.
April 11, 2013 By 8 Comments
… 5 Follow was index。 the explain: type:index，Extra:Using index; Using temporary; Using filesort i am chinese, so my english is bad…..sorry…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… (Alex Yurchenko). Dropping a non-existing temporary table would be replicated when TOI was used in wsrep_OSU_method variable. This bug was fixed for the case when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table. Bug…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
Hi everyone I am using wordpress and drupal, and i converted databases from MyISAM to … results for temp table , server has 4G ram, which almost uses, as many sites of both drupal and wordpress are running… of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks… the configuration and spend most time showing how you can use the wealth of information Performance Schema gathers to understand some… of focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… captures, I was able to correlate most load peaks with temporary increases in user activity, so it became a matter of… by pt-stalk come in handy, but if you’ve used them, you know it can be a daunting task to…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…: Query Server_id: 1 End_log_pos: 288 Info: use `test`; drop temporary table test.t *************************** 7. row *************************** Log_name: mysql-bin…. In summary, I still don’t see any way to use temporary tables with MySQL statement-based replication without some risk of…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… put to temporary tables – BLOB/TEXT columns are not supported with MEMORY storage engine so must use on disk MyISAM temporary table. What… | NULL | NULL | 1000000 | Using temporary | +—-+————-+——-+——+—————+——+———+——+———+—————–+ 1 row in set (0.01 sec) As you can see I’m using ORDER BY NULL clause…
