Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL… or a foreign key. This is the output of our tool when run on the same table, correctly identifying the redundancy…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… MySQL performance at low concurrency is important for you. I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6… 1 and the same tool is not possible. Want to talk more about performance? Come to Percona Live MySQL Conference and Expo April…
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 …
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… popular hosting provider’s datacenter. This application is a popular blogging service, running on a generic midrange Dell-class server. The…’s look at the performance this server is getting from its disks. I’m using the Aspersa diskstats tool to pull this… file so we can see performance throughout the day. If you’re not familiar with the diskstats tool, the columns are the…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… about business intelligence tools, particularly OLAP (or online analytical processing) tools using MySQL and other free open source software. OLAP tools are a part… bar charts is possible. Focusing on ROLAP. This is the MySQL performance blog, and as such an in depth discussion of MOLAP technology…
Post: Basic performance and diagnostic tools on Solaris
February 14, 2011 By 7 Comments
…’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic tools to find one’s way around a Solaris system and discover the system, get fundamental performance, configuration, and status information, and so on. Here’s a quick list of some key tools. Many of the tools you…
Comment: Duplicate indexes and redundant indexes
August 21, 2006 By 38 Comments
MySQL Index Analysis Tool… Back in January I posted a simple MySQL duplicate index finder tool. Because I read requests for such a tool on the MySQL Performance Blog I decided to open a new project on Google’s code hosting service as well as a new blog to track it. S…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… of threshold-based alerts later in this blog post, and explain the need to be…tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql…, there are several others that can be performed with existing plugins, so there was no …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…we do a performance audit (it’s our most popular service). I thought I should write a blog post …here are the lowest common denominator. We often use tools to gather a lot of the data for us… there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition)….
Post: Why not make a tool to improve existing configurations?
February 10, 2012 By 4 Comments
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love … it performs worse than before. So in the end, although our tool is excellent for creating a starting my.cnf, my old blog post about the ultimate my.cnf tuner tool, which…
