… book High Performance MySQL, will take on the volunteer role.) You should have some understanding of MySQL and Percona‘s extensions, and of way…: * Product features (we made a start at http://www.percona.com/docs/wiki/percona-xtradb:features:start) * Release notes * Installation instructions for…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given… production. The pmp-check-mysql-deadlocks plugin can help you detect such problems, in conjunction with Percona Toolkit’s pt-deadlock-logger… drift on a replica. The pt-table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… anyone can follow. A full performance audit is far more extensive than this article can cover, and might wander into Apache… 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc… that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
… to implicit extension to CHAR. The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has… of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the BLOB… discussed below. We at Percona took the eBay patch, ported it to 5.5, tested it extensively and fixed all the bugs…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris†Bug #47621: change the fix of http://bugs.mysql.com…-site. Once you install Percona-release repo the upgrade becomes as easy as yum update MySQL-server-percona MySQL-client-percona The latest source code… Bugs in Percona XtraDB Storage Engine for MySQL. For general questions use our Pecona-discussions group, and for development question Percona-dev group…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… of MySQL is probably closer to stock MySQL than it is to Percona Server. I haven’t run extensive benchmarks against RDS 5.5, Percona Server 5.5, and MySQL 5… huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless you use Percona Server; but it’s still not…
Page: Consulting for MySQL
July 31, 2006 By
Percona offers consulting (and training, and support, and development) services for MySQL and LAMP applications. We can help with all areas of… possible. Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL, help fixing bugs promptly as…
Post: Percona Welcomes Patrick Crews
October 3, 2011 By 2 Comments
… very happy to welcome Patrick Crews to the Percona development team. Patrick joins Percona at a very exciting time for the development team. We are getting regular releases of Percona Server and Percona Xtrabackup out the door, we have been heavily using… been doing QA in the MySQL world for a while now, and has extensive experience with both MySQL and Drizzle. His work has…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a… more than 5 years timeframe. It did not have any extensive test suite we could use for validation. As you might… to MySQL 5.0 on the master. To do this we set up replication from Percona Server 5.1 back to MySQL 5…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… haven’t announced any new members in a while, the Percona team has continued to grow steadily behind the scenes. Our… a consultant and contractor before joining Percona, and has many years of experience in Oracle, MySQL, Unix systems administration, programming, and networking… better to watch him do it! Like Ewen, Piotr has extensive knowledge of other technologies such as Unix (IBM AIX Certified…
