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 …

mysql -e "select * from test.t where d < '2013-07-17 17:00:00'"
+---------------------+
| d                   |
+---------------------+
| 2013-07-17 15:34:19 |
+---------------------+

mysqldump -t --compact test t --where="d < '2013-07-17 17:00:00'"
(no output)

Where's my line?

Hint ▼

--tz-utc

>

Amazon's play in 'big data' lives large.  From S3 to EBS to EC2, Amazon has its share of acronyms and playgrounds.  Recently, Amazon launched Redshift, an analytic database utilizing ParAccel's in-memory capabilities on top of Amazon's cloud infrastructure.  While the full details of ParAccel and Amazon's collaboration remain hidden, the offspring of their work has shown promise. 

To shed light on the differences between Infobright Enterprise Edition (IEE) and Redshift, I surveyed several potential Infobright prospects who evaluated both technologies.  Overall, a single Infobright M2 2XL node performs the same as 4-5 Redshift XL nodes.  No comparisons were performed between the Infobright Community Edition and Redshift.

While Redshift is a compelling solution, there are stark contrasts between IEE and Redshift that you should consider during an evaluation.  As always, the best …

One of the new features in MySQL 5.6 is persistent table statistics. The word “persistent” makes you think that table statistics will be very stable from now on.
This is generally true, but there are some exceptions. There is a particular case where InnoDB statistics may change with no warning, even when there is no user activity on the server. Consider the following pattern (which nearly all bug or feature testcases follow):

CREATE TABLE t1 (...) ENGINE=INNODB;
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
EXPLAIN SELECT * FROM t1;
EXPLAIN SELECT * FROM t1;

With MySQL 5.6, the following is possible

• the first EXPLAIN will show that the optimizer expects table t1 to have 6 rows
• the second EXPLAIN will show that the optimizer expects table t1 to have 5 rows

For me, this was a big surprise. After all, table t1 never had 6 rows. If there was some rounding which rounded up 5 to 6, why …

Summer is flying by and it's almost time to get back to school! We will be continuing our Tungsten University series on August 22nd, with a live webcast "MySQL Multi-Master Operations Made Simple With Tungsten Replicator 2.1". 

Deployment of MySQL multi-master topologies with Tungsten Replicator has been constantly improving. Yet, earlier there were some heavy operations to sustain, and