I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vs. vCache with a 10% dirty threshold versus the same metrics at a 50% dirty threshold. Time-based flushing has been…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
…, but when you’re moving to PXC and have a metric sh*tload of grants (on tables, on columns, …) that need…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…? In order to figure out, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat, etc all saving to…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… derived all of these metrics from two “even more fundamental” performance metrics, which I’ll call the “basic” metrics. That’s what this… thing you can derive from the two basic metrics. In fact, these two basic metrics encode a tremendous amount of information, from… performance (via measuring response times), scalability (via the four fundamental metrics I mentioned in the previous blog post), and much more…
Post: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… are equal. All together, we have the following four fundamental metrics: The observation interval. The number of queries in the interval…’s Law to derive these additional four long-term average metrics: Throughput: divide the number of queries in the observation interval… more. We derived our four long-term average metrics from the four fundamental metrics, and we derived those in turn from the…
Comment: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… my blog http://perfdynamics.blogspot.com/2011/05/fundamental-performance-metrics.html They show how to do dimensional analysis and also… modern hypervisors. The privately defined performance metrics were absolutely incomprehensible; not the least because even conventional metrics, like utilization, were privately redefined…
Comment: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… agree with the diagrammatic description. One of my low level metrics is “number” or count. As Tom says, these are sampled…#tth_sEc23). That’s why I prefer the term “performance metrics” over the oft-used “performance statistics” to remind myself that we first must have reliable and meaningful base metrics or measurements before we can do anything with them, such…
Post: Percona white paper: Forecasting MySQL Scalability
November 16, 2010 By 6 Comments
… thing alluded to in the paper is extracting the necessary metrics from network traffic. I had this idea after studying the…’s /proc/diskstats file. It turns out that two simple metrics can provide amazingly rich insight into system performance and scalability…: if you create server software, you must expose these simple metrics. (I have filed a feature request for Percona Server to…
Post: Understanding Performance Optimization Terminology
March 2, 2009 By Leave a Comment
… expectations of your boss) which drills down to two important metrics – response time also sometimes called latency and throughput also called… I’d urge you to use all 3 metrics above for evaluation (using efficiency metric which is most critical for you right… most efficient solution somebody have picked is efficient using different metric compared to what you need.
