June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… to using temporary tables in this way, for example when using replication, a temporary table could …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…

Filed Under: Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… (Teemu Ollakka). Standard MySQL port would be used when port number…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…

Filed Under: MySQL, XtraDB Cluster Tagged With: , ,

Post: Can MySQL temporary tables be made safe for statement-based replication?

May 26, 2008 By 8 Comments

…: 211 Info: use `test`; create temporary table test.t(a int) engine=innodb *************************** 3. row *************************** Log_name: mysql-bin.000011 Pos: 211 … no way to get the CREATE TEMPORARY TABLE statement to be logged inside the transaction. And when it comes to a replication …

Filed Under: Insight for DBAs Tagged With:

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… table size, even when all data fits in memory MEMORY temporary tables can be 10-100 times faster than disk based MyISAM tables Hopefully MySQL…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: Troubleshooting MySQL Memory Usage

March 21, 2012 By 5 Comments

…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…

Filed Under: Insight for DBAs, MySQL

Post: On Character Sets and Disappearing Tables

June 21, 2012 By 1 Comment

… the temporary table name that was displayed in the error message.  Once you do that, you can run something like this: CREATE TABLE recovery… temporary tables or rename them. This looks somewhat like closed bug 13378, but I think there’s something of an inconsistency present when MySQL…

Filed Under: Insight for DBAs, MySQL

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… the only real call you can get errors is when you run mysql_query , mysql_fetch_row simply reads data from memory and… services and so on – in this case the overhead of creating yet another temporary table is not so large.

Filed Under: Insight for Developers Tagged With: ,

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

… the times when when it would make a difference though. Q: Would you recommend creating an index in every table you create? Example: CREATE TABLE user_competition…. Q: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table or filesort for…

Filed Under: Insight for DBAs, MySQL

Post: Best kept MySQLDump Secret

March 23, 2012 By 13 Comments

… fact how MySQL‘s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table with modified structure, copy data to that table and when drop original table and…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…table that we’re trying to emulate: mysql: SHOW CREATE TABLE information_schema.innodb_ft_default_stopword\G *************************** 1. row *************************** Table: INNODB_FT_DEFAULT_STOPWORD Create Table: CREATE TEMPORARY TABLE…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts