This blogs gives some insights into the new SQL syntax added in WL#3352
and WL#4444 and WL#4571 which all have been included in the
mysql-next-mr tree which is the base for the next milestone release
codenamed Betony.

The purpose of these new changes is to enable improved partition pruning, and
also making it possible to partition on strings. Supporting TRUNCATE on
partitions will improve partition management and the ability to use separate
key caches for different partitions makes MyISAM partitioned tables more
useful. Finally we added a new function TO_SECONDS which makes it
possible to get more fine-grained dates for partitions and subpartitions.

This information will soon find its way into documentation but if you want
to get started right away here it comes.

There are 5 additions effectively:
1) The ability to RANGE partition by …

This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL Community Team will present Gearman for MySQL. Gearman is a client/server infrastructure for generic tasks, usable on distributed servers, with little worry about the details. No matter what language you speak, Gearman can meet your needs in C, PHP, Perl, Ruby, shell scripting, and several more. Gearman can also work in conjunction with MySQL, either using UDFs, or simply through its basic architecture. Giuseppe's talk will show examples of how to use Gearman for remote installation and how to call a complicate data warehousing function written in Perl from any other language, with no knowledge of Perl at all.

For MySQL University sessions, point your browser …

The latest release of InfiniDB (out this week - 0.9.5.0) contains a new online alter table function that lets you add new columns to existing InfiniDB tables in an online fashion, meaning queries aren't blocked on the table while the alter is running.  You can still use the standard ALTER TABLE ... ADD COLUMN command, which does an offline alter, but if you want to add columns without impacting query activity, you now have that option open to you.

Doing an online column add involvRead More...

The latest release of InfiniDB (out this week - 0.9.5.0) contains a new online alter table function that lets you add new columns to existing InfiniDB tables in an online fashion, meaning queries aren't blocked on the table while the alter is running.  You can still use the standard ALTER TABLE ... ADD COLUMN command, which does an offline alter, but if you want to add columns without impacting query activity, you now have that option open to you.

Doing an online column add involvRead More...

This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL Community Team will present Gearman for MySQL. I got the time wrong in my original announcement, sorry.

This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL Community Team will present Gearman for MySQL. I got the time wrong in my original announcement, sorry.

Image by Getty Images via Daylife

Like many I was disappointed, yet not surprised, that the EC formally logged their objection to Oracle’s acquisition of Sun on account of MySQL a few days back.  And we also hear today that Oracle will be stating their position in Brussels on the 25th of this month.  To me this case has odd from the onset and as it goes on it is just getting odder.  And of course this all seems to be occuring at immense cost to Sun, Oracle and MySQL themselves.

There are several reasons why this is odd.  One of the key ones is that for some time MySQL has been quite open about their non compete focus with …

I've completed an initial round of testing InnoDB with data compression and the results are extremely promising. The testing was performed by setting up two shadows of a production database. The shadows execute the exact same queries as the production database to collect performance statistics but the query results are ignored.

The production server uses Fusion-io PCI-Express flash storage and had 290GB of data. Both shadows were running on traditional spinning disks, so I wasn't sure they would be able to keep up with the load. The first shadow was configured with MySQL 5.0.84 with the uncompressed "compact" InnoDB storage format. The second shadow was configured with MySQL 5.1.38 and the InnoDB 1.0.4 plugin with 2x compression. With compression enabled on all tables except 3 containing pre-compressed data, the InnoDB data size shrunk to 170GB, a 41% reduction.

When the shadows were first started up with empty caches, the …

Dear EC, I have an opinion on Sun/Oracle merger.

I don’t like objections, therefore I object to them. Of course, I understand, that some people want to play major parts in dramas and soap operas, others are spectating and enjoying it, but most people I know and respect simply want to be efficient and get their work done.

These people, many of whom were my colleagues back at Sun/MySQL, sometimes can be labeled as ones who don’t care about greater picture, or the common good. Unfortunately, the topic of common interest depends from religion to religion, from society to society, from person to person.

My approach to common good is doing what I want to do for the community, and not what community wants me to do. If that relation is not compatible for any of the sides, there is no relation at all. Now, what happens now, is that there is some user community (and I include all the people who are protecting their …

This Thursday (November 12th, 14:00 UTC), Giuseppe Maxia of the MySQL Community Team will present Gearman for MySQL. Gearman is a client/server infrastructure for generic tasks, usable on distributed servers, with little worry about the details. No matter what language you speak, Gearman can meet your needs in C, PHP, Perl, Ruby, shell scripting, and several more. Gearman can also work in conjunction with MySQL, either using UDFs, or simply through its basic architecture. Giuseppe's talk will show examples of how to use Gearman for remote installation and how to call a complicate data warehousing function written in Perl from any other language, with no knowledge of Perl at all.

For MySQL University sessions, point your browser …