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…
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… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables… downtime. As you know, MySQL locks tables for most ALTER operations, but pt-online-schema-change performs the ALTER without any locking… have completely redesigned and rebuilt the pt-summary and pt-mysql-summary tools. The changes are not so obvious to the user…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done …Live MySQL Conference and Expo (register now!). Specifically, there are the following sessions at the conference on Percona XtraBackup and tools …
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… good quality. We used following tools for evaluations: randgen (lp:randgen), kewpie (lp:kewpie) and for stressing and performance: sysbench and tpcc-mysql.
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
…. You dont know your 9x percentile response time performance until you use it against your work load…schema changes or query changes instead of a tool to gage scaling limitations of server x. (Kinda… sharded datastore. A possible solution is to use mysql proxy and an alterate server with a snapshotted…
Post: Black-Box MySQL Performance Analysis with TCP Traffic
February 23, 2012 By 2 Comments
…’ve been formulating a series of tools and practices that can provide deep insight into system performance simply by looking at TCP packet headers, and when they arrive and depart from a system. This works for MySQL…’s available from the white paper section of our website: MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
There are some tools we commonly use doing performance review and optimization and we often ask each other where … now you can find our favorite MySQL Performance Review Tools on the site. This is just list of tools which came from the top… this list we focused on Open Source tools which are helpful for “in time” performance audit – for example you see no graphing…
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 … Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could… which did not seems to give any significant performance benefit, may be even reducing performance few percents. I also tried running with…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
…we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we…- valgrind, oprofile, dtrace and similar tools One should know C/C++ to be able to understand performance issues discovered and prototype …
