Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here).

Bugs Fixed:

• Unfortunately, the relatively new --utc option for pt-heart was still broken because “MySQL interprets date as a value in the current time zone and converts it to an internal value in UTC.” Now the tool works correctly with --utc by specifying “SET time_zone='+0:00'“, and older versions of the tool can be made to work by specifying --set-vars "time_zone='+0:00'". Bug fixed …

MySQL Community BOF at OSCON

Moderated by: Dave Stokes
7:00pm Wednesday, 07/24/2013
Location: D136

There will be a Birds Of a Feather seesion for all interested in MySQL, the MySQL Community, and all the surrounding technology that relies on MySQL. Lets talk about the current and future of MySQL — where you think it should be heading — and network with others. All levels of audience experience are welcome.

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the AskMonty Knowledgebase for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.32

Release Notes Changelog …

Thu, 2013-07-18 16:22dbart

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the AskMonty Knowledgebase for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.32

Release Notes …

The binary version for MySQL Cluster 7.3.2 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or Oracle’s Software Delivery Cloud for the commercial version.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.3.2 (compared to 7.3.1) is available from the 7.3.2 Change log.

Be sure to check out my other posts on mysqldump:
– Scripting Backups of MySQL with Perl via mysqldump
– Splitting a MySQL Dump File Into Smaller Files Via Perl

Part 1 of 2: (part two)
If you have used MySQL for a while, you have probably used mysqldump to backup your database. In part one of this blog, I am going to show you how to create a simple full and partial backup using …

On July 24 at 10 a.m. PDT, I will be delivering a Webinar on Advanced MySQL Query Tuning. I will focus on optimizing the common slow queries with group by and order by. Those queries usually create temporary tables and perform a “filesort” operation. I will show how to optimize those queries so that they will be running significantly faster, which will increase the application performance and decrease MySQL load.

I presented a similar topic in April at the Percona Live MySQL Conference and Expo 2013. This webinar, however, will be more advanced and will also cover some additional topics like “loose and …

If you’ve run into the following error, then there area couple quick fixes:

Errno: 1593
Fatal error: The slave I/O thread stops because master and slave
have equal MySQL server UUIDs; these UUIDs must be different for
replication to work.

To give some background first, starting in MySQL 5.6, the server generates a true UUID in addition to the –server-id supplied by the user. This is ultimately to help with new replication features.

From a under-the-hood view, when starting, the MySQL server automatically obtains a UUID as follows (per the manual):

1. Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir is the server’s data directory); exit on success.
2. Otherwise, generate a new UUID and save it to this file, creating the file if necessary.
…

Hi,

We are excited to announce that we just released a new version of XAMPP that includes the new PHP 5.5 version: 1.8.3. This version of PHP does not support Windows 2003 or Windows XP, it is necessary a newer version: Vista, Windows 7, Windows 8, Windows 2008 and Windows 2012.

http://www.apachefriends.org/en/xampp.html

This version of XAMPP includes the following upgrades and fixes:

• New updated versions for all platforms: Windows, Linux, Linux x64 and OS X.
• Updated main components: PHP to 5.5.0, MySQL to 5.6.12 and phpMyAdmin to 4.0.4.1
• Added support for OpenSSL 1.0.1 on Windows. Linux and OS X already support that version.
• PHP now ships the PHP OPCache module by default
• Mercury Mail properly stores configuration in Windows
• Fix for XAMPP removing Windows services not …

Percona is glad to announce the release of Percona Toolkit 2.2.4 on July 17th, 2013 (Downloads are available here and from the Percona Software Repositories).

New Features:

• pt-query-digest --output json includes query examples as of v2.2.3. Some people might not want this because it exposes real data. New option, --output json-anon, has been implemented. This option will provide the same data without query examples. It’s …