A little while ago I blogged about (and open sourced) an Impala-powered soccer visualization demo, designed to demonstrate just how responsive Impala queries can be. Since not everyone has the time or resources to run the project themselves, we’ve decided to host it ourselves on an EC2 instance. You can try the visualization; we’ve also opened up the Impala web interface, where you can see query profiles and performance numbers, and Hue (username and password are both ‘test’), where you can run your own queries on the dataset.

Deploying Impala on EC2

While there are …

Earlier, I talked about the transactional semantics we are introducing to MongoDB. As I hinted at the end of the post, we are actually doing more. We are introducing multi-statement transactions. That’s right, multiple queries, updates, deletes, and inserts will be able to run inside of a single transaction. We are working on the details of the semantics as we develop our beta, but at a high level, think of it as having the same semantics as TokuDB and InnoDB’s multi-statement transactions in MySQL.

So how will it work? We introduce three new commands:

db.runCommand({"beginTransaction", "isolation": "mvcc"})

This begins a transaction with the isolation level of MVCC, which means queries will use a snapshot of the system. This is essentially the same as “repeatable-read” in MySQL. Isolations of …

5.6 has redefined MySQL performance and usability. Some great talks at the Percona Live MySQL Conference and Expo will provide insight into the new features and benefits of this major release. The conference is April 22-25, 2013 at the Santa Clara Convention Center and Hyatt Santa Clara.

Monday evening features the conference Welcome Reception where attendees can relax over food and beverages in the exhibition area following the day’s tutorials. After the Welcome Reception, at 6:30 pm, Oracle is hosting a reception to celebrate MySQL 5.6 going GA which is open to the public (but space is limited and pre-registration is required).

The MySQL 5.6 content continues Tuesday morning when …

This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.

Changed Defaults in MySQL 5.6

Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6

MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.

back_log

read more

MySQL 5.6 is out now and that is good news. I have already been using pre-GA versions on some production servers with good success and now that the few wrinkles I have seen have been ironed out, I am sure a lot of people will find the new features in 5.6 well worth waiting for.

However, that does lead to the question of: “what next?”

I still have several things that I would like to see in MySQL in no specific order of preference such as:

• Session transaction state exposed as a variable to allow you to determine if you have started a transaction or not, and thus allowing you to use BEGIN WORK, ROLLBACK or COMMIT as needed.  This information is available via the C API I believe but not via SQL.  Something like @@in_transaction = 1.  Makes modular programming easier.
• Table space management. The default behaviour now in 5.6 is to move to innodb_file_per_table = 1, but really on a large …

Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

">

read more

Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

">

read more

One of the great things of mysqlnd as a base library for PHP's MySQL support are the collected statistics. mysqlnd collects about 160 different statistical values about all the things going on. When having such an amount of raw data it, obviously, is quite hard to draw conclusions out of it. Therefore I recently created a PHP library sitting on top of this feature to collect all data, run some analysis and then provide some guidance and made it available from the JSMysqlndAnalytics GitHub repo (see there also for instructions for using Composer).

Using the library is relatively simple as the short instructions show. The library consists of two main parts. On the one side the "Collector"  this is a wrapper around …

Is multiple write threads possible with SBT interface ??

There's a lot of activity in the MySQL ecosystem currently. I've written an article for The H which takes a look at MySQL and the various forks and spinoffs to give an overview of where MySQL's community and close competition is currently at.
http://www.h-online.com/open/features/MySQL-and-the-forks-in-the-road-1829242.html