April 24, 2014

Innotop: A real-time, advanced investigation tool for MySQL

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Cacti, Zabbix, Ganglia, Nagios, etc. But each of […]

Follow these basics when migrating to Percona XtraDB Cluster for MySQL

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these […]

Percona XtraBackup 2.1.0 for MySQL alpha now available

Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL alpha on April 2, 2013. Downloads are available from our download site here. For this ALPHA release, we will not be making APT and YUM repositories available, just base deb and RPM packages This is an ALPHA quality release and is not […]

MySQL 5.6 Compatible Percona Toolkit 2.2 Released

A new Percona Toolkit series has been released: Percona Toolkit 2.2 for MySQL 5.6. Several months in the making and many new features, changes, and improvements make this a great new series. It replaces the 2.1 series for which we plan to do only one more bug fix release (as 2.1.10) then retire. 2.2 is […]

The story of one MySQL Upgrade

I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to be upgraded. It is a shared database used by tons of applications written by many people over more than 5 years […]

mysql_upgrade and Innodb Tables

Upgrading from MySQL 5.0 to MySQL 5.1 or Percona Server 5.1 you may run into issues with mysql_upgrade – it will identify some tables to be upgraded and will attempt to run REPAIR TABLE for them. This will fail with “The storage engine for the table doesn’t support repair” error message. This seems to confuse […]

Percona Server 5.0.90-build21

Dear Community, Percona Server 5.0.90, release 21 is available for use. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.90 Fixed bugs: Fixed Bug #539190 Percona-XtraDB package doesn’t allow libmysqlclient15off Fixed Bug #479106 mysql-5.0.87 + patches-5.0.86 compile fail in ubuntu 9.10 (karmic) Fixed tests mysql, mysql_upgrade, ssl* See […]

Upgrading MySQL

Upgrading MySQL Server is a very interesting task as you can approach it with so much different “depth”. For some this is 15 minutes job for others it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been […]

5.0.86-build19 Percona binaries

Dear Community, As of today the 19-th build of MySQL server with Percona patches is available. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.86 Fix from Neil Katin to userstatv2.patch fix InnoDB slowness with large queries Fixed bugs in the build: Bug #413858 in Percona patches: “Crash […]