Accidentally me and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/… week. And following Baron‘s example I also run the same load against MonetDB. Reading comments to Baron‘s post I tied to…_ontime/${YEAR}_$i.txt.tr’ INTO TABLE ontime FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘\”‘” ontime The load time for each chunk was about…
Comment: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… could easily get obliterated very quickly. That said, I believe Baron is trying to construct something out mysql performance counters because… by X = (C2 – C1) / (T2 – T1) and is therefore a *time-averaged* quantity formed by the ratio of those intervals. Thus, in Baron… formal statistics that Tom writes about is typically associated with post-processing of performance data that goes on at a much…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…_country` > ?) OR (`guest_language` = ? AND `guest_country` = ? AND `score` >= ?)) ORDER BY `guest_language`, `guest_country`, `score` LIMIT ?, 2 /*next chunk boundary… copying the table are beyond the scope of this blog post (Baron blogged about chunking), but in general the SQL statements should…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
…(Baron) recently blogged about how InnoDB performs a checkpoint , I thought… needs to operate on consistent pages, Innodb achieves this by using the double write buffer to ensure consistent page… – in search of stability, as seen in his post, Percona Server with XtraDB allows much larger logs beyond…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… are estimates of the level of availability offered by the various solutions. Level of availability Simple replication…full documentation, monitoring, alerting, backups, migration to production and post migration monitoring. Of course, it is the safest…between an HA project and a DBA task. — Baron…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… be needed on other platforms. The rest of this blog post is about how to set up and use the tools… in /root/collected/ by default. Use the “sift” tool to examine it. I’ll demo on my laptop: [baron@ginger]$ sift collected… them for sensitive details. When I finish these, I’ll post them on Percona.TV, our MySQL video/screencast blog site…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… to mock and frustrate those who would tune by ratio. They are capable of creating any …partially useful you can do with Key_reads: [baron@localhost ~]$ mysqladmin ext -ri10 | grep Key_reads | Key_reads…that now. This topic deserves an entire blog post, because there are many subtleties including the …
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… and cause trouble at other times. In this blog post I want to examine cloud-based I/O. …in progress at the time the samples were taken. [baron@ginger logstats]$ diskstats -g sample -i 6000 sda3-…ness and utilization correctly. The %util that is displayed by iostat is confusing, and you have to do …
Comment: Four ways to optimize paginated displays
October 17, 2008 By 27 Comments
Baron, I had a slow query that involved pagination, so I investigated after reading your post on the matter. The result of… result of the pagination at all (the query uses ORDER BY, GROUP BY, WHERE and LIMIT and orders on a non-indexed…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
Reading Barons post about Kickfire Appliance and of course talking to them directly … that bad considering abstraction of storage engine which requires “row by row” processing which means function calls for each row. Lets…. And now if we look at the memory amount consumed by table we can see the filtering speed is about 600MB…
