On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution… find unexpected differences in performance like this, so it pays to test all different solutions, and measure the resulting performance! Q: Bill, back…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need to measure that also… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal… will cover optimizer reports, query profiling, and session status to measure performance. The query patterns will include: Exclusion Join Random Selection Greatest…
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 28 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 74 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…
