… system performance simply by looking at TCP packet headers, and when they arrive and depart from a system. This works for MySQL… in highly secure environments. I’ve finally written up a paper that shows some of my techniques for detecting problems in… project first. It’s available from the white paper section of our website: MySQL Performance Analysis with Percona Toolkit and TCP/IP Network…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
… performance and reliability from their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server’s performance…MySQL suffers from complete lockups due to checkpointing and furious flushing to disk. Additional Resources > Commercial Support > Documentation > White Papers…
Post: Percona Server Fast-Restart White Paper Posted
January 10, 2011 By 2 Comments
I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-… or rebooting the server, it can be back to full performance in a couple of minutes. That’s minutes, not hours… I/O performance so MySQL restarts take an eternity. Read the white paper for the details; it is posted in the white paper section…
Post: Percona white paper: Forecasting MySQL Scalability
November 16, 2010 By 6 Comments
Ewen and I have just published Percona’s latest white paper, Forecasting MySQL Scalability with the Universal Scalability Law. This is essentially… two simple metrics can provide amazingly rich insight into system performance and scalability, in combination with Little’s Law and queueing…
Post: White Paper: Flashcache and MySQL on Virident drive
September 19, 2011 By 2 Comments
Our latest MySQL white paper is Improving Percona Server performance with Flashcache on the Virident tachIOn Drive. (Virident funded the …-heavy workloads, but more research is needed to understand its performance characteristics on write-heavy workloads. We explain the details of…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… read those white papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident
February 7, 2011 By 2 Comments
… and numbers are certified by Percona. I personally really enjoyed performance and stability provided by tachIOn card, and you actually saw… the list of our recommendations for customers looking to improve performance or building high-performance solution based on MySQL.
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
Preparing Choosing Storage Systems for MySQL talk for Percona Live in Washington,DC I ran into great paper called Sane SAN 2010… between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL is making…
Post: Followup on performance metrics: slides, video
July 11, 2011 By 6 Comments
… extract an amazing amount of information about a system’s performance, scalability, queueing, and more by just measuring request arrivals and… this into a more complete description of how to analyze MySQL’s performance and scalability through nothing more than TCP/IP packet… treating this presentation as a first draft of a white paper that lays out the techniques and the results very clearly…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… possible, limiting the system complexity, and lowering the price-to-performance ratio. The outcome of the research, which was sponsored by… — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-performance ratio and increase the utilization…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper.
