There have been number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get production battle tested and there is inflow of real world production performance data hitting MySQL Support Team at Oracle. For number of Simple workloads I would expect to see some slowdown – MySQL 5.6 Optimizer got a lot smarter and the more plans have to be considered for the query the more time the query optimization is likely to take. I also would expect newer code to benefit from “polishing” and clean up to achieve the best performance possible. At Percona we surely will be doing fine tuning for our Percona Server 5.6 release.

Another thing to remember about MySQL 5.6 is – it comes with …

SkySQL and Monty Program are on the road with our joint Meetup in Amsterdam where Monty Widenius - the origninal creator of MySQL - will unveil his vision of the future of the MySQL database via MariaDB.

Seppo Jaakola from Codership will give a presentation about Galera Cluster for MySQL and MariaDB.

In addition we will have speakers from Booking.com as well as Anders Karlsson from SkySQL who will talk about Big Data.

read more

What better time to start learning about the world's most popular open-source database - now that MySQL 5.6 has been released. With its increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.

Virtual Developer's Day for MySQL

The first Virtual Developer Day for MySQL will take place on March 12 at 9:00 a.m. US, Pacific Time. The event will include presentations and hands-on labs to educate MySQL users on essential skills and the latest features in MySQL 5.6. Register  here.

MySQL for Beginners Training

In the MySQL for Beginners …

During the last year, I was asked a number of times when/if MariaDB will support identifying dynamic columns by names instead of numbers. I am happy to say that named Dynamic Columns feature is in MariaDB 10.0.1 release. Now, after some literary effort, here is updated documentation: Dynamic Columns in MariaDB.

Howto kill a process in Mysql

If you have a “hanging” process in MySQL and want to kill it, you use show processlist to identify the process you want to kill get get the id. Then a simple kill ID will do the job.

mysql> show processlist;

+-----+------+-----------+---------+---------+-------+-------+------------------+
| Id  | User | Host      | db      | Command | Time  | State | Info             |
+-----+------+-----------+---------+---------+-------+-------+------------------+
| 882 | user | localhost | test    | Sleep   | 27111 |       | NULL             |
| 893 | user | localhost | test    | Sleep   |   453 |       | NULL             |
| 901 | user | localhost | NULL    | Query   |     0 | NULL  | show processlist |
+-----+------+-----------+---------+---------+-------+-------+------------------+
3 rows in set (0.00 sec)

mysql> kill 882

The same can be done using mysqladmin …

I'm pleased to announce the release of Spider storage engine version 3.0(beta) and Vertical Partitioning storage engine version 0.18(beta).
Thank you for waiting such a long time! This release includes my 1 year development.
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql

Please use the following for downloading binary file.
http://spiderformysql.com/download_spider.html

The main changes in this version are following.
Spider
- Support link to oracle tables.
  Connection from Spider to Oracle is now available by using …

This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a 'Senior' Employee.

Events
Oracle's upcoming webinars:
MySQL Security Enhancements and Important Security Tips for ISVs and OEMs on Thursday, February 21st.

MySQL Performance and Scalability in Spanish Thursday, February 28th.

read more

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server,MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \
        --sandbox_directory=msb_5_5_29 \
        --install_version=5.5 \
        --sandbox_port=5529 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
...
no_run                         =
no_show                        =
do you agree? ([Y],n) Y
loading grants
... sandbox server started
Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

…

In the same time of passionate debat of the best distribution MySQL vs MariaDB on a 120K Euro server(here), i wanted to share the story of drop of InnoDB insert performance for one of our client having a tables between 10 to 100 Billions rows.

In most case this size of table is just a no go in relationnel database.

So why it used to work so far  ?

c1 int, c2 tinyint, c3 mediumint, c4 binary(1), c5 float .
c2 avg cardinality 1000
c3 avg cardinality 10000
Very simple log table with optimized column type :

• Partition by range on c1 where c1 increase with loading date
• InnoDB compression 8K block size  

A first good metric when inserting 1 row

• Into a 1G partition we touch about 400 …