…with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright… developers improve documentation), but finally I ended up with next load statement: /usr/local/monetdb…less 10.000 distinct values. I tried that, and it affected only these queries. Results with …
Comment: Multi Column indexes vs Index Merge
October 20, 2009 By 31 Comments
…for a query bringing back around 7 days of results for a vehicle. Tried (date_time,vehicle_id) and…back thousands of rows under explain. Using innodb. Inserting up to 100 per second. Query select g.date_time…ios.id where g.date_time between ‘2009-10-15 00:00:00′ and ‘2009-10-15 23:59:58′ and g.vehicle…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
… range 2009-06-11 21:54:47.089744 to 2009-06-… cmd that resulted in a NOT_FOUND result. So in …# 10us ################################################################ # 100us ############# # 1ms #### # 10ms # 100ms # 1s # # 10s+ get TEST_KEY\G Interestingly, … format could be cleaned up a little, etc. …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… JOIN dim_date using (date_id) WHERE DepDelay>10 AND Year BETWEEN 2000 AND 2008 GROUP BY…are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the most striking…. dim_flight using (flight_id) WHERE Year BETWEEN 2009 and 2011 GROUP BY Carrier,dest.CityName ORDER…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
…you can get really compact results to see what’s going… Time range 2009-07-01 23:55:41.334082 to 2009-07-01 … # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS LIKE ‘…of the report — what is up with the 12% of …
