This week we present part 2 of optimizer enhancements in MySQL 5.6, including subquery optimizations and the new optimizer trace feature. Ear Candy talks about what "hole punching" is with regards to file systems. In At the Movies we present "How to Deal with Difficult People".

Events
Galera, SkySQL and MariaDB are doing a Road Show in Stockholm on February 7th.

Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Friday, February 15th near Milan

read more

I wonder if the MySQL archaeologists out there would be willing to unearth some (presumably ancient) history for me. Why does the logging configuration merit special mention in the version_comment variable? The more I think about this, the more bizarre it seems. I enabled logging. The version reported by the server changed. No, really, is my server somehow a different version of MySQL now? 130203 15:39:55 [Note] ./bin/mysqld: ready for connections.

MySQL Tech Tour: From the Web to the Cloud
February 21, 2013, Oslo, Norway

MySQL Tech Tour: From the Web to the Cloud
February 21, 2013, Brussels, Belgium

AOUG Expertentreff Development: MySQL and Java
February 28, 2013, Vienna, Austria

MySQL Tech Tour: From the Web to the Cloud
March 20, 2013, Stockholm, Sweden

MySQL Tech Tour: From the Web to the Cloud
…

How to improve efficiency and reduce TCO with a professional LAMP StackOracle Linux + MySQL + Zend PHP
February 15, 2013, Milan, Italy

Nell’ultimo decennio lo stack LAMP (Linux, Apache, MySQL, PHP) è diventato la piattaforma web
più diffusa, adottata per l’espansione delle più importanti installazioni web di tutto il mondo. Dalle startup alle aziende di grandi dimensioni, sono ormai numerose le società che utilizzano lo stack LAMP per accrescere l’efficienza operativa e ridurre i costi, sia implementando applicazioni on-premise che scegliendo il modello cloud.

Oracle offre lo stack LAMP più completo oggi disponibile nel settore, mentre Zend è un’azienda leader nel software e nei servizi per lo sviluppo, la distribuzione e la gestione di applicazioni business-critical in PHP.

…

This weekend I am supposed to be giving a talk at FOSDEM on Libdrizzle.  Unfortunately my kids and I all fell ill on Thursday (my wife appears to be immune) so I had to cancel my plans (infecting 5000 people didn't seem wise :)

Instead I am writing this blog post about Libdrizzle and my part in it which covers some of what I was going to talk about.

History of LibdrizzleLibdrizzle started out as a from-scratch C connector for Drizzle and MySQL originally created by Eric Day.  It was designed to be high performance and use common standards to make it easy to work on.  In the summer of 2010 it was merged into the main Drizzle tree where development has been focused.  There were several attempts to split it out again but until now none were truly successful.

For a few years Brian …

Some show commands support a where clause. The column name that can be used in the expression for the where clause depends on the result of the show command. For example in show tables the column is Tables_in_foo where foo is the database name.

MariaDB [test]> show tables where Tables_in_test = ‘t';
+—————-+
| Tables_in_test |
+—————-+
| t |
+—————-+
1 row in set (0.00 sec)

This is a problem with the show databases command because databases aren’t really *in* anything. Database is a reserved word so this happens.

MariaDB [(none)]> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| test |
+——————–+
3 rows in set (0.00 sec)

MariaDB [(none)]> show databases where database=’test';
ERROR 1064 …

While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not been covered well, and since there are still a large number of MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to discuss what these implications exactly are.

To read what Metadata Locking exactly is please read this section here in the MySQL manual.

Let’s start off with having a look at the Meta Data Locking behavior prior to MySQL 5.5.3

Metadata Locking behavior prior to MySQL 5.5.3

Prior to MySQL 5.5.3 a statement that opened a …

When will it stop. These amateur programmers that simply cut/paste code really affect those good programmers in the ecosystem trying to make a decent living. I was reviewing a developed (but incomplete) PHP/MySQL system using a common framework (which in itself is irrelevant for this post).

In one source file there were 12 repetitions of the following code:

   //permissions
    $this->security_model->setUserPermissions($id);
    if (!array_key_exists($id,$this->session->userdata['permissions']) OR
        !array_key_exists('id', $this->session->userdata['permissions'][$id]) OR
        !array_key_exists('scope', $this->session->userdata['permissions'][$id]['name'])){
      $this->session->set_flashdata('alert', 'You are not authorized to go there.');
      redirect($this->agent->referrer());
    }

It’s bad enough when code is repeated and not put in a simple re factored function. When it’s …

The key to success for the database technologists is staying a step ahead of technology challenges and keep growing in order to efficiently scale to meet the needs of dynamic businesses and customers. Blogs are one way to remain abreast of technology trends and Log Buffer Edition this week once again helps database professionals in that regard in Log Buffer #305.

Oracle:

As LinkedIn grew from a startup to a post-IPO market leader, they relied on Oracle applications to support transformations, Lana Prout informs.

BPM is the promise of business transformation by maximizing the potential of turnkey business processes in any organization. But majority of organizations never realize this dream and land up restricting BPM to …

The news is already making the rounds (ex: rumors here, and confirmed here and here), but Fedora will apparently replace MySQL with MariaDB in an upcoming release.

read more