…queries against the temp table fail. Q: Why doesn’t the query optimizer take care the execution…execution plan. (I know it doesn’t though.) Why don’t you try writing a SQL query…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…case maximum memory usage?” Various formulas are in wide use, but none of them is…those per query. Sorting and grouping and DISTINCT and UNION may/will also create temp tables; the…execute queries; mysqld creates internal structures for the query plan, for example, and keeps it around until the query …
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… enough planning something…query execution time including execution errors and warnings. So how do you exactly test your queries…table with –temp-database and –temp-table is recommended, this ensures separation of the test table from your production databases and tables…slight difference in these …
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 16, 2007 By 22 Comments
… the execution plan by itself but since it isn’t, doing it yourself is the way. Recently I had a huge search query (in… my way of doing it : – first query the active table and store the results in a temporary table. – since i use ORDER BY + LIMIT… this 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…
