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

People claim that MongoDB is not transactional. It actually is, and that’s a good thing.

In MongoDB 2.2, individual operations are Atomic. By having per database locks control reads and writes to collections, write operations on collections are Consistent and Isolated. With journaling on, operations may be made Durable. Put these properties together, and you have basic ACID properties for transactions.

The shortcoming with MongoDB’s implementation is that these semantics apply to individual write operations, such as an individual insert or individual update. If a MongoDB statement updates 10 rows, and something goes wrong with the fifth row, then the statement will finish execution with four rows updated and six …

Welcome to my blog. I am Anitha and  is currently leading the testing team for MySQL Server in Oracle. This is a great place to be and I love every moment of my work on this great product with a bright  group of colleagues. In this blog I plan to write about testing in MySQL , testing in general and some other topics that are of interest to me.