…, you can split them up into smaller units, and when you put those units back together the result is the same as… logical maximum conclusion, splitting a problem up into many small problems and then putting the results back together again. This set logic… = dim_date.date_id where dim_date.Year IN (2008,2009) group by 1; –PARALLEL OPTIMIZATIONS: * Base level table name: `aggregation…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… 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/… InforBritgh and MonetDB executes it immediately with result 117023290 rows Now some random queries …
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
…43ms 28us # Hosts 2694 # Time range 2009-06-11 21:54:47.089744 to 2009-06-11 21:56:22.136503 # …TODO). Memc_miss is for any cmd that resulted in a NOT_FOUND result. So in this case, 15% of all … Some things are TODO; the report format could be cleaned up a little, etc. But we’re releasing early and …
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
…profile here to illustrate that you can get really compact results to see what’s going on inside your server. …33ms 737us # Hosts 8 # Time range 2009-07-01 23:55:41.334082 to 2009-07-01 23:56:33.929945 # …available. Look at the top of the report — what is up with the 12% of queries that say No_index_…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… used in the Shard-Query tests. For the baseline, the results and response times were captured with the T command. The…. There are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the most striking. — Q4…_id) JOIN dim_flight using (flight_id) WHERE Year BETWEEN 2009 and 2011 GROUP BY Carrier,dest.CityName ORDER BY 3…
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 …
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…. For example a test (http://mysqlha.blogspot.com/2009/03/pbxt-is-fast-no-kidding.html) by…means that PBXT transactions are not SERIALIZABLE. A result of this is that statement-based replication is … PBXT architecture. It’s job is to clean up after a transaction. Basically it recognizes which record…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… SSD (see here: http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-…_method=O_DIRECT 9) We get the best results with filepertable. Especially if you find your tables … comfortably averages 3500 queries a second with peaks up to 10000 queries being handled well. The query …
