… wish developers improve documentation), but finally I ended up with next load statement: /usr/local/monetdb/bin…10s 3y, 17.61s, 1.69s 4y, 37.57s, 2.12s 10y, 79.77s, 29.14s UPDATE (5-Oct-2009…have less 10.000 distinct values. I tried that, and it affected only these queries. Results with changes:…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…date using (date_id) WHERE DepDelay>10 AND Year BETWEEN 2000 AND 2008… both “scale-up” and “scale-out”, but once again, the “scale-out” results are the …GROUP BY dest.CityName ORDER BY 2 DESC; Finally, Shard-Query performance … using (flight_id) WHERE Year BETWEEN 2009 and 2011 GROUP BY Carrier,dest…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 9 Comments
… that resulted in a NOT_FOUND result. So …2009-06-11 21:54:48.050834 to 2009-06-11 21:56:21.669302 # bytes 38 2… ################################################################ # 100us ############# # 1ms #### # 10ms # 100ms # 1s # # 10s+ get TEST_KEY\G Interestingly… could be cleaned up a little, etc…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… ==== # 1 0x088084BF139954D8 0.1009 90.2% 1 0.100881 SELECT dual # 2 … really compact results to see what… 2009-07-01 23:55:41.334082 to 2009-… # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE …report — what is up with the …
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… R900, Four Quad Core E7320 Xeon, 2.13GHz, 32GB Memory, 16X2GB, 667MHz… operation> Next, looking the sequential result in more long term. …followings is sequential throughput [tps] up to 3500 sec. The … tunings of XtraDB. —————————————– (Added 2009.10.29)
