I think MySQL 5.6 has many excellent features that are worth the cost of upgrading and then I read about MySQL 5.7.2 and the improvements keep on coming. Alas the notes are also full of references to bugs behind the support paywall so in many cases I wasn't able to learn more about the changes. Some of the changes are for feature requests from us or are rewrites of diffs from the FB patch. There are many interesting changes. I expect some of them to be backported to 5.6 by the community.

• better scaling for concurrent connection create. We started to fix this but the change was a bit too complex for the FB patch. It is nice to see an official fix. Domas has also …

I think MySQL 5.6 has many excellent features that are worth the cost of upgrading and then I read about MySQL 5.7.2 and the improvements keep on coming. Alas the notes are also full of references to bugs behind the support paywall so in many cases I wasn't able to learn more about the changes. Some of the changes are for feature requests from us or are rewrites of diffs from the FB patch. There are many interesting changes. I expect some of them to be backported to 5.6 by the community.

• better scaling for concurrent connection create. We started to fix this but the change was a bit too complex for the FB patch. It is nice to see an official fix. Domas has also …

Continuent and our client base are growing fast. We are looking for brilliant people to join us. We’re looking for passionate people that can make things happen. You'll be working with a team filled with top notch talent, and you’ll be competing in an evolving market of database clustering and replication. A career at Continuent means you'll be working with an amazing team with tons of benefits

To expand on Jervin’s Default RDS Account Privileges, RDS for MySQL provides a number of routines and triggers defined the the ‘mysql’ meta schema. These help in various tasks because the SUPER privilege is not provided.

SELECT routine_schema,routine_name
FROM information_schema.routines;
+----------------+-----------------------------------+
| routine_schema | routine_name                      |
+----------------+-----------------------------------+
| mysql          | rds_collect_global_status_history |
| mysql          | rds_disable_gsh_collector         |
| mysql          | rds_disable_gsh_rotation          |
| mysql          | rds_enable_gsh_collector          |
| mysql          | rds_enable_gsh_rotation           |
| mysql          | rds_kill                          |
| mysql          | rds_kill_query                    |
| mysql          | …

It was just a few days ago that we announced, with celebratory enthusiasm, Tungsten Replicator 2.1.1, and today we are at it again, with Tungsten Replicator 2.1.2.

What happened? In a surfeit of overconfidence, we released Tungsten 2.1.1, with faith on the test suite and its result. The faith was justified, as the test suite was able to catch any known problem and regression. The overconfidence was unjustified, because, due to a series of unfortunate events, some sections of the test suite were accidentally disabled, and the regression that was lurking in the dark was not caught.

Therefore, instead of having a quiet post-release week-end, the whole team has worked round the clock to plug the holes. There …

A few weeks ago we released MySQL Connector/Python v1.0.12. Bugs were fixed, and LOAD DATA LOCAL INFILE should now work correctly. The announcement can be read on the MySQL forums.

Some useful links:

• Documentation: http://dev.mysql.com/doc/connector-python/en/index.html
• Release Notes: http://dev.mysql.com/doc/relnotes/connector-python/en/index.html
• Downloads: …

I was searching looking for the PRIVILEGES that comes with the primary MySQL account on RDS, but it looks like this is not documented anywhere nor blogged about yet. So for the sake of other users, here it is:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'revin'@'%' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxx' WITH GRANT OPTION

In case you ask, for what, I was looking for what privileges I can grant other users via the primary account.

MySQL Connect 2013 is coming up with several interesting new sessions. Some sessions that I am participating in got accepted for the conference, so if you are going there, you might find the following sessions interesting. For your convenience, the sessions have hCalendar markup, so it should be easier to add them to your calendar.

MySQL Sharding, Replication, and HA (September 21, 5:30-6:30pm in Imperial Ballroom B)

This session is an opportunity for you to meet the MySQL engineering team and discuss the latest tools and best practices for sharding MySQL across distributed server farms while maintaining high availability.

Come …

I am working on a customer’s system where the requirement is to store a lot of timeseries data from different sensors.

For performance reasons we are going to use SSD, and therefore there is a list of requirements for the architecture:

• Provide high insertion rate
• Provide a good compression rate to store more data on expensive SSDs
• Engine should be SSD friendly (less writes per timeperiod to help with SSD wear)
• Provide a reasonable response time (within ~50 ms) on SELECT queries on hot recently inserted data

Looking on these requirements I actually think that TokuDB might be a good fit for this task.

There are several aspects to consider. This time I want to compare TokuDB vs InnoDB on an initial load time and space consumption.

Let’s …

Following my blog on InnoDB sessions, let's focus today on what you will have the opportunity to learn from MySQL users sharing their real-world experiences along with best practices they've developed.

You should obviously not miss our exciting panel on "Current MySQL Usage Models and Future Developments" featuring Davi Arnaut from LinkedIn, Daniel Austin from PayPal, Mark Callaghan from Facebook and Calvin Sun from Twitter.

The conference sessions will include:

MySQL at Twitter - Calvin Sun and Liang Guo, Twitter
Saturday, 11.30 am, Imperial Ballroom A

…