… are other drawbacks to using temporary tables in this way, for example when using replication, a temporary table could vanish if the slave restarts… a secondary index. But the result was that it created a temporary table to count the movies per production year for each kind_id. It was more efficient in this case to force MySQL…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table…fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started …CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
…from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G…TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables, 44% were created…tmp_table_size and/or max_heap_table_size to reduce the number of disk-based temporary tables …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… End_log_pos: 207 Info: create temporary table test.t(a int) engine=innodb *************************** 3. row *************************** Log_name: mysql-bin.000007 Pos: 207 Event…_pos: 211 Info: use `test`; create temporary table test.t(a int) engine=innodb *************************** 3. row *************************** Log_name: mysql-bin.000011 Pos: 211 Event…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. Which… MEMORY temporary tables can be 10-100 times faster than disk based MyISAM tables Hopefully MySQL will implement support of dynamic rows for MEMORY tables…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… better as you can query temporary tables too: mysql> select sum(data_length+index_length) from information_schema.global_temporary_tables where engine=’memory’; +——————————-+ | sum… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… is not completely gone – it still exists in the temporary tables that were created as part of the ALTER operation and can be… the temporary table name that was displayed in the error message. Once you do that, you can run something like this: CREATE TABLE recovery… I think there’s something of an inconsistency present when MySQL won’t allow us to change an FK-referenced column…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result…_RESULT hint if you need to release table locks early. It comes at cost of creating temporary table though which can be quite high… services and so on – in this case the overhead of creating yet another temporary table is not so large.
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… temporary are always in the first line So it is impossible to tell at which stage MySQL actually perform the sort or creates temporary table and so how much rows will be stored to temporary table. Sometimes it is…
