…in Software RAID5. Also note that the following changes were made in the MySQL config: optimizer_…counters. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload,…89G 1.53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… Purge Your Database Data archiving is crucial. There is a difference between data that your application needs now, and data that your application… actually uses? Is the disk getting full? 3. Capture and Store Historical Data Likewise, it is vital to have something recording metrics… be very grateful that you have historical metrics to understand changes in your application, or understand what happened just prior to…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… hit, overnight. He didn’t know of anything that had changed. Reducing the load by half through the load balancer did… second, *real* queries that actually touch real tables and fetch data from them (with functions like NOW() that disable the query… just that. Catching a server having micro-freezes, and capturing diagnostic data just-in-time, is a poor man’s way to…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… called performance. There could be many variables in environment which change – load, number of concurrent users, database, the way users use… is important is however to be able to connect the data from these logs – glue them together. The easy way to… itself but you would not know unless you’re capturing the right data. If you’re looking for nice example framework for…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…a server or database upgrade, change in my.cnf or schema change can affect the overall performance …query_log plugin. Following example shows how to capture traffic with tcpdump and create a dump … database unless you don’t need the data anymore. percona-playback –input-plugin=tcpdump –tcpdump-…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… versions. First, ideally, each server must have identical set of data. One approach and most recommended is by having a slave… can easily verify that data is consistent across the master and the slave with pt-table-checksum. Capture your production queries, we… is still no alternative to doing your research for incompatibilities, changes and bug fixes or new bugs introduced that can potentially…
Comment: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… will be captured by Flexcdc and insert into flexviews_mview_signal. Is this right? The question is when no data change happened in…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… analyze. You might also be interested in gathering data that you can’t gather on the server …is likely to be easier and more reliable than changing the application code itself, especially if queries don’… issued all over the place. Finally, you can capture TCP traffic. There are several ways to do …
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… uses libpcap to capture traffic. It’s a threaded application that does the minimum possible work and uses efficient data structures. Your… release, and we want much more testing. We might also change the functionality; as we build tools around it, we discover…
Comment: Debugging problems with row based replication
May 7, 2010 By 12 Comments
… anything? Triggers, cascading foreign keys and other indirect data changes are much more safely captured using RBR than statement logs. Using non-deterministic…
