One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool…’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… Galera are in GA state, so the main focus of testing was on proper integration and packaging. Galera was in in… years of testing and evaluations for me. At this point I believe it has good quality. We used following tools for evaluations: randgen (lp:randgen), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
… and monitoring to name just a few. The tcprstat tool itself is a means of gathering raw statistics, …. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query’… many eyes have been on the code. We’ve performed tests on servers with high loads and observed minimal …
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used … own. 2*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page… performance. Interesting enough utilization in iostat never went over few percents and load was mostly CPU bound. Next I went on testing MySQL…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… with different result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade can… and use mk-upgrade tool to run comparison. The tool will run SELECT queries on both new and old MySQL installations and check… Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… find due to their nondeterministic nature. Any tool that makes finding such bugs easier, preferably … widely used for the MySQL server development: there is support for it in the MySQL Test Framework, DBQP, … after the reset. A speculative processor might perform the read first, which could leave a …
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… either by MegaCLI or by Open Management tools (see this for example). You will see … testing. I recommend this testing as part of complex IO subsystem performance testing – if you have RAID check what performance…server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…here are the lowest common denominator. We often use tools to gather a lot of the data for … there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition)…. show the difference afterwards. Or we might have a test server to run on. It varies widely; some …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… Percona can help you get up and running using these tools in no time flat. We are the only ones with… “cloud” test to show that this works over the network, in a real world environment. There is a slight performance oddity at… this, but it requires further investigation. Next I compared the performance of 20 m1.large machines cold, versus hot. I did…
