…, anyway. The tests I loaded 1 million rows into the table. Here’s a graph of the …sum(c19), sum(c89), sum(c129) from t; select sum(c19), sum(c89), sum(c129) from t where c11 > 5; select sum(c19), sum(c89), sum…An abstracted front-end is a great idea; MySQL abstracts the storage backend, but why not …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…million “words” by duplicating the entire set multiple times. mysql> load data infile ‘/tmp/words’ into table words (chars); Query OK, 6033 rows… ffc86c559e06009a743d891ce1e4fc4f [count(*)] => 512 ) 1427 rows returned (5.0057470798492s, 4….SELECT `word`,`md5(word)`,SUM(`count(*)`) AS `count(*)`…
Post: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
…table was required (there were about 5 million of distinct pages visited during that day) which resulted in on disk temporary table… cnt>3) pv -> ; +———-+ | sum(cnt) | +———-+ | 1127031 | +———-+ 1 row in set (31.22 …table is to large is to just limit it to first number of rows: mysql…
