…-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using replication, a temporary table could vanish if the… a secondary index. But the result was that it created a temporary table to count the movies per production year for each kind…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…_options variable. Accepted values are in the range [0, 255] …when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table…CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… replication processes. This is safe to do even when temporary tables are open.) Then I created a temporary table on the master, inserted some rows into it…’s no way to get the CREATE TEMPORARY TABLE statement to be logged inside the transaction. And when it comes to a replication slave…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables… practice, if your temporary tables are moderately sized). …tables may not scale proportionally with table size, even when all data fits in memory MEMORY temporary tables…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…temporary table name that was displayed in the error message. Once you do that, you can run something like this: CREATE TABLE…temporary tables or rename them. This looks somewhat like closed bug 13378, but I think there’s something of an inconsistency present when…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…_RESULT hint if you need to release table locks early. It comes at cost of creating temporary table though which can be quite high…. Using FEDERATED Tables can work for some cases in others script can be more efficient especially when multiple servers are involved and you… services and so on – in this case the overhead of creating yet another temporary table is not so large.
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…this benchmark. We have 4 tables: 1) Table with ENUM: CREATE TABLE cities_enum ( id int…20 or 30 bytes are being read. For Full Table Scan operation difference often… is great example of the case when Innodb is much faster than MyISAM… MySQL to store Join result in temporary table to do the sort, all …
Comment: Slow DROP TABLE
June 17, 2009 By 21 Comments
… cases where tables are created in /tmp : – when you use “create temporary table” – when MySQL need a temporary table which use BLOB or TEXT column – when MySQL need a temporary table which is bigger than tmp_table_size…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… are however some cases when you really do not need events in binary log – even for backup recovery, for example dealing with temporary tables…=BLACKHOLE to ensure all Innodb tables are created as BLACKHOLE. However you can’t do the same with MyISAM tables, because MyISAM can’t…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…is the fact – situation when data fits in memory and when it does not are very different. If … 53.01 sec) Also remember – not all indexes are created equal. Some indexes may be placed in …with in temporary table etc. Prefer full table scans to index accesses – For large data sets full table scans are …
