…temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table is open and is then restarted, the temporary table… -> insert into test.ins(a) select * from test.t; -> drop temporary table test.t; -> commit; -> end// master > delimiter; Now calling the stored procedure…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…table and two fairly small dimension tables, which is normal. Here is the query: select…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…of user variables, stored procedures, prepared … take a look into solving this problem…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: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…and others use FLUSH TABLES WITH READ LOCK to temporary…SELECT queries to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…select * from lt limit 10; +—-+————-+——-+——-+—————+———+———+——+——+————-+ | id | select_type | table…temporary table and so how much rows will be stored to temporary table. Sometimes it is enough to perform sorting or use temporary table…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 15 Comments
…temporary table to store result set, however this is not correct – both UNION ALL and UNION distinct use temporary table…temporary table can only be seen in SHOW STATUS – EXPLAIN does not want to tell you this shameful fact: mysql> explain (select…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…: select * from table where A=xxx and B between 100 and …table. It also will help the query you’re mentioning allowing group by to be performed without temporary table…and store as VARBINARY(16) for performance reasons. In any case you would likely to get table… topic which goes into a lot more details…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…selectivity might show benefit from using indexes. In fact even MySQL optimizer currently does not take it into…Store portion of data you’re going to work with in temporary table etc. Prefer full table…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…into trouble. Just one is enough. Lock priorities. By default MySQL treats updates as higher priority operations. You can use SELECT…tables to avoid concurrency issues. Temporary tables used in batch processing and…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… of the SELECT portion of the statement are stored in a table. Storing the results of a SQL statement into a table (even a temporary table) is called…, sorting, distinct or other conditions must be fully computed and stored in a temporary table before they can be accessed, which is very expensive…
