…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 54 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 9 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 8 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…
Comment: Slow Query Log analyzes tools
May 13, 2008 By 83 Comments
…Slow Query Log analyzes tools | MySQL Performance Blog MySQL has simple but quite handy feature – slow query log, which … of seconds to execute. (tags: analysis article database log monitoring mysql performance tuning query slow tool) [...]
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
…on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which …being author of large amount of popular MySQL tools such as MySQL Toolkit he is surely the man … skills – many articles you find at his blog are very smart in depth and elaborate. …
