…Using temporary; Using filesort | | 1 | SIMPLE | t | ref | k | k | 4 | test.test.i | 1 | Using where; Using index | +—-+————-+——-+——+—————+——+———+————-+——+———————————+ 2 rows in set (0.00 sec) In…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
…temporary) compared compiling patched version for them. There was as hope MySQL…MySQL Community Version vs Monthly rapid updates for MySQL Enterprise version – to me this means…use something MySQL considers Enterprise Quality ? What is really better for distribution users ? Does MySQL…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
…used in practice. I tested full table scan of the table completes in…temporary sort files on tmpfs (/dev/shm) to avoid disk IO as a variable as my data set fits in… 10 rows in set (0.56 sec) Not bad ! Even though MySQL does… In practice this means…in some conditions. What …
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
…I also would like to hear what you do yourself, and why 
… manage memory smarter knowing it does not need to look for …in your application and you ended up with a lots of connections creating large temporary tables and so MySQL…actually mean the buffer pool (or other caches) which you can safely use …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… Distributed set processing (theory) What is SQL? As you probably … nodes. A single temporary table is used to store the results…in parallel. All joins, aggregation and filtering is done at the storage node level. This means that Shard-Query does…, but right now only MySQL storage nodes are supported. …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…What could be the reason of this growth and what…temporary stores records to be inserted in…helpful: mysql> select * from innodb_rseg; …in default REPEATABLE-READ isolation mode. This means…does not work in all cases. If you’re running XtraDB you can also use innodb_use_purge_thread to use…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…what can you do to keep space requirements to minimum ? First do not place logs in LVM, I mean…trouble makers. Third,Use dedicated LVM volume for MySQL Instance. This …undo space. For example MySQL on disk temporary files and tables …in mind you can allocate undo space for any physical volume – it does…
