… and with measurements every 1 sec to see how bad are drops. So there is more or less stable performance only for… much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… the lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling…? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in the last 4-6 months? Best…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… – o_profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes… expensive if virtual memory gets fragmented. A while ago I measured over 10 times slow down over time as memory becomes… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… or miss takes. If you approach application performance optimization from the standpoint of response time measurements, which you should, you will eventually… good instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, and people… to look at absolute magnitude, not ratios. For performance analysis, you need to measure elapsed time, not just the number of times…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… anyway, I decided to check peak performance of all caches compared to MySQL Server, by measuring just the time it takes cache to return the data. In the real life applications performance is… and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
…with this in MySQL (and general Web performance management) ? Not So good. In most cases organizations focus on performance rather than performance stability … response time. In number of my talks about performance measurements I suggested to measure 95 percentile over short period of times for …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… dispersion, an amazingly useful metric for discovering periods of poor performance), and more. Analyze the distribution of service times. Service time… 50 microseconds, maybe a bit longer. This is common in MySQL servers I work with when they’re running a simple… to derive pretty much everything else about a system’s performance (via measuring response times), scalability (via the four fundamental metrics I…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… the system to predict in performance, the model baron has published for example is good for measuring scalability of the system as… to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS… benchmark is long-term performance, but as a side project, I thought it would be interesting to measure the single-threaded insert… workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long…
