…a result set? This isn’t really a trick question. The “result set” is a SET created by the output of a…table from each node correspond logically to a records in a Flexviews materialized view delta table…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
…substitution to put the results back together, when necessary. When sorting or grouping are used, a final pass over the final result … | max(id) | +———+———+ | 1 | 3088896 | +———+———+ 1 row in set (0.00 sec) How to factor numbers create table dataset ( id bigint auto_increment …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…TABLE in 10k row chunks, by the way; I chose 1M because the rows were small). But how to…result of loading the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…a result, one of the most common questions we hear is how to build high-performance systems to…put these into the database in a little meta-table…a custom table, which is really constructed behind the scenes from the name-value tables in a…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…in set (9 min 5.40 sec) I repeated the run a few times with very similar results. OK so what if we set…in memory) which is getting a lot of random writes. OK. Now lets move to testing MEMORY tables for the same queries: mysql> set…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…thing to do is grab ‘mysqladmin variables’ and put it in the text file. I don’t spend a …plan, and the desired modifications to the query or the table. We explain how to interpret what we’re showing… customers set up much more efficiently and with better results, due to our knowledge of what works in …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…tables on which query depends on. If not you need to re-generate the query result. Removing of stale queries in…put it separately as well. I believe Query Storage would benefit a lot from fast compression, such as QuickLZ. Results sets… hard to understand how exactly MySQL Query Cache is working in …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…set don’t get forward-ported for free, so customers pay if they want a version that is ported to a newer server. In a…to open-source are not a potluck dinner where everyone brings something and puts it on the table…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…to restrict result set. For example: key(a,b,c) SELECT * FROM tbl WHERE c=5 ORDER BY a,b limit 10 – In…in leading table if you have JOIN with ORDER BY … LIMIT you should try hard to have sorting column(s) to be in the leading table…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to…results…table on a separate computer, maybe a replication slave. Can you make the reorganization run in a…
