Configuring MySQL Server, with the dozens of options available, has always been perceived as a bit of a black art. In MySQL Database 5.6, configuring your MySQL server for optimal performance is easier than ever before.

In the MySQL for Database Administrators course you can learn more.

MySQL 5.6 is configured to work faster out of the box in a wide range of installation scenarios and it is easier than ever to set up the server by adjusting only a small number of settings which cause others to be set. In addition, you get a new default my.cnf file with instructions guiding your through adjusting key settings. The …

This weekend, on 1-2 February, FOSDEM 2014 will take place in Brussels, Belgium.
There will be MySQL talks on Saturday in the MySQL Devroom and a MySQL Community dinner afterward.

30 people have already signed up for the community dinner, we’re almost at the amount of people from last year.

Last orders for the MySQL Community dinner will be accepted on Wednesday 29 January, so if you plan to attend, make sure to buy your tickets now. After that day, we won’t be able to add more people to the list.

I also wanted to thank the sponsors. Without them, this community dinner would not have been made …

The MySQL manual says: "In standard SQL, a query that includes a GROUP BY clause cannot refer to nonaggregated columns in the select list that are not named in the GROUP BY clause."

I got questioned about that last week, and this week I see that there's a proposed change in behaviour for MySQL 5.7, so I guess it's a good time to try to figure out what's going on in this part of the world.

I checked the manuals for most current DBMSs and confirmed that the ONLY_FULL_GROUP_BY kind of behaviour is required by DB2, …

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, …

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, …

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, …

This docs describes the installation and configuration of DBD::mysql, the Perl DBI (database interface) driver for the MySQL database. It is used to connect perl scripts to mysql database and perform operations. The modules can be downloaded from http://search.cpan.org/ i.e. DBI and DBD::mysql. Manual installation illustrated below.

The build-essential packages are required. If not available install using the command apt-get install build-essential.

DBI Manual Installation

root@debian1:/opt# tar -zxvf DBI-1.631.tar.gz
root@debian1:/opt# cd DBI-1.631/
root@debian1:/opt/DBI-1.631# perl Makefile.PL
root@debian1:/opt/DBI-1.631# make
root@debian1:/opt/DBI-1.631# make install

DBD::MySQL manual Installation

root@debian1:/opt# tar -zxvf DBD-mysql-4.026.tar.gz
root@debian1:/opt# cd …

This is a maintenance release, fixing a build update problem on Win64, along with various other fixes and the new comment field on the session manager..

Get it from the download page.

I know it was officially announced Monday, but I just wanted to take a moment and let everyone know MariaDB Enterprise 1.0 is now available, in case you missed the previous article.

What does MariaDB Enterprise consist of?

“MariaDB Enterprise is composed of several components including MariaDB Manager, which is a set of management tools and an API with which you can easily provision, monitor, and manage a highly available MariaDB Galera Cluster for multi-master, synchronous replication. Galera is a powerful technology that can eliminate single points of failure for your database infrastructure, but it is relatively new and can be a challenge to configure for administrators who aren’t familiar with it.”

https://mariadb.com/..MariaDB Enterprise – Getting Started …

We are considering enabling the SQL mode ONLY_FULL_GROUP_BY by default in MySQL 5.7. Here is a quick example to demonstrate how this change will impact you:

Sample Data:

CREATE TABLE invoice_line_items (id INT NOT NULL PRIMARY KEY auto_increment, 
invoice_id INT NOT NULL,
description varchar(100)
);

INSERT INTO invoice_line_items VALUES 
 (NULL, 1, 'New socks'),
 (NULL, 1, 'A hat'),
 (NULL, 2, 'Shoes'),
 (NULL, 2, 'T shirt'),
 (NULL, 3, 'Tie');

Default behaviour in MySQL 5.6 and below:

mysql> SELECT id, invoice_id, description 
FROM invoice_line_items GROUP BY invoice_id;
+----+------------+-------------+
| id | invoice_id | description |
+----+------------+-------------+
|  1 |          1 | New socks   |
|  3 |          2 | Shoes       |
|  5 |          3 | Tie         |
+----+------------+-------------+
3 rows in set (0.00 sec)

Proposed default behaviour in MySQL 5.7:

mysql> SELECT id, …