September 23, 2014

Generating test data for MySQL tables

One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or global/session variables. Sometimes, we are given access to the server […]

Calvin Sun on MySQL at Twitter, Percona Live 2014 and Facebook

Twitter’s Calvin Sun (@Calvinsun2012) is looking forward to the fast-approaching Percona Live MySQL Conference and Expo this April 1-4 in Santa Clara, Calif. He’ll be speaking, yes, but he’s also looking forward to learning from his peers – particularly those at Facebook. Both companies, he explained, are in the rather unique positions of unprecedented rapid […]

Percona Monitoring Plugins 1.1.1 release (enterprise-grade MySQL monitoring and graphing)

Percona announces the release of Percona Monitoring Plugins 1.1.1 to address the critical bug that appears after the 1.1 upgrade. Changelog: * Cacti mysql graphs stop working with data input field “server-id” after 1.1 upgrade (bug 1264814) * Non-integer poller errors for MySQL Query Response Time (bug 1264353) A new tarball is available from downloads […]

Drupal and MySQL Performance: Register now for Nov. 13 webinar

Drupal is one of the most popular open source CMS applications available – and it runs primarily on a MySQL backend.  Out of the box, the schema is well tuned and indexed.  However, there are some ways to tweak the default installation to get more out of the system right from start.  Similarly, there is […]

The power of MySQL’s GROUP_CONCAT

In the very early days of Percona Vadim wrote very nice post about GROUP_CONCAT. But I want to show you a bit more about it. When is GROUP_CONCAT useful? Usually while working with Support customers I recommend it when you have aggregation of many-to-many info. It makes the view simpler and more beautiful and it […]

Percona Monitoring Plugins 1.0.5 release for MySQL

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: * Added mysql-ca option to ss_get_mysql_stats.php (bug 1213857) * Added user info to […]

Percona team to attend Buenos Aires MySQL conference Oct. 15-16

This is to announce that me and Daniel Nichter (Lead of Percona Toolkit) are coming to the MYSQL NOSQL & CLOUD CONFERENCE & EXPO in Buenos Aires, Argentina on Oct. 15-16. There also will be local Percona experts in attendance. Talks from Percona include: Percona XtraDB Cluster – Basic installation and setup by Martín Arrieta […]

OSS4B – Presenting in Italy on MySQL and Percona XtraDB Cluster

I will be in Prato (Firenze), Italy Thursday and Friday (September 19th and 20th) to deliver 2 presentations at OSS4B: Installing and managing MySQL like a real devops: automation in production Introduction to Percona XtraDB Cluster If you want to learn about these projects or discuss anything related to MySQL and Percona, join the conference […]

September: A busy month for MySQL events

Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events. At first I wanted to cover all autumn events here but if I did that this post would be far too long. So instead I’m […]

MySQL 5.6 security vs ease of use

MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited access from local host (though still enough to cause DOS attack […]