…temp tables)? For performance, it’s hard to make a general rule, because there are different types of subqueries (correlated, non-correlated, derived tables…tables. It seemed to prefer an index-scan of 7 rows in the `kind_type` table to…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup has implemented Encrypted Backups. This feature can be used to…temp files behind due to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 16, 2007 By 22 Comments
… rows to satisfy my LIMIT. I then add a WHERE condition to filter out the rows BEFORE sorting them. Postgres will bitmap-index-scan… query in the temp table – I sort and limit the temp table and fetch it – I perform all my joins from the temp table (no freaky IN() from php) It went from a few minutes to a few tens of…
