Yes. Any customer that is comfortable with the Community Edition of the server but
desiring Oracle Support can get it. This gives you 7/24 support for Oracle for the world’s most popular open source database.

For details, see page ten of http://www.oracle.com/us/support/library/057419.pdf

…

Don't miss Giuseppe Maxia (aka "The Data Charmer") at these sessions:Wednesday, 4/13 at 1:00 pm - Dealing with large data with MySQL partitioning and replicationWednesday, 4/13 at 4:00 pm - MySQL Sandbox: A Toolkit For Productive Laziness

Learn from our database replication and clustering experts at these conference sessions:Monday, 4/11 at 9:00 am - MySQL Replication Advanced Techniques by Giuseppe MaxiaMonday, 4/11 at 1:30 pm - Learn how to cure MySQL replication deprivation with Tungsten by Robert Hodges Tuesday, 4/12 at 11:55 am - The Art of Sandboxing - Reducing Complex Systems to Manageable Boxes by Giuseppe MaxiaWednesday,

I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now I’m revisiting this subject with couple of more annoying examples I ran into during last couple of days.

mysql> drop database test;
ERROR 1010 (HY000): Error dropping database (can't rmdir './test/', errno: 17)

First question you should ask is what is error 17 ? Do to this you can run external utility perror:

[pz@test ~]$ perror 17
OS error code  17:  File exists

It would be already a lot handy if one would walk through all error messages where error code is used and add the text description right into the code. ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./test/’, errno: 17 “File exists”) would already be a lot more helpful.

…

Spring came in like a lion here in the Northeast, with an April Fools' Day mini-blizzard, even though Lion itself isn't due to be released until summer at the earliest. While I waited for more hospitable weather to emerge, I've been huddled indoors working on a Kickstarter project with my son, and I will now shamelessly plug it: It's a high-powered replacement for the Wii sensor bar, designed to let you sit comfortably at the other end of a room while you use your Wii. You can read more about it here if you're interested.

Meanwhile, there were the usual interesting developments in the developer world.

Google: Now promoting gray as a moral choice

Like most major technology companies, it can sometimes …

I’ll be giving a 40-50 minute long webinar on 26th of April on data recovery for MySQL.

Almost every long serving DBA has been faced with the task of recovering data from a database, whether it be via user error such as a erroneously dropped table or from Hardware or Software failure. In this Webinar we will give you a walk through guide on how to restore your data after physical or logical failure, using practical examples to demonstrate how to tackle this challenging problem. Attendance is free.

What you can learn by attending:

* Prepare for recovery (prerequisites)
* Preparing your data
* Identifying the structure and state of tables
* Retrieving data
* Restoring from recovered data

During this Webinar the Percona-InnoDB-Recovery-Tool will be used on Linux.

To register:
…

Tokutek, the leading innovator in high-performance and agile schema storage engines, announced today that its team members will be speaking at both the IOUG Collaborate 11 in Orlando, FL, on April 11, 2011 and the O’Reilly MySQL Conference in Santa Clara, CA, on April 12. Tokutek will also be exhibiting at booth # 612 at the O’Reilly MySQL Expo.

IOUG Collaborate 11 (FL) April 11, 2011

Date: Monday, April 11
Time: 10:30 am – 11:30 am
Speaker: Zardosht Kasheff, Software Developer, Tokutek
Topic: Understanding Indexing
Location: Room 306A, Orange County Convention …

 Sometimes I want to trace transactions that have taken long time to execute. If a transaction is holding row locks for 30 seconds, all other clients requesting locks for the same rows will be blocked for up to 30 seconds (or will get Lock Wait Timeout errors if you set innodb_lock_wait_timeout lower). This is serious.

 The important step to solve such issues is identifying what kinds of queries are executed by problematic transactions. But tracking long running transactions is not as easy as tracking just slow queries. Suppose you execute the following transaction.

[client1]$ mysql --host=mysql_server db1
mysql> BEGIN;
mysql> SELECT * FROM t1 WHERE id=2 FOR UPDATE;
... (do nothing for 10 seconds)
mysql> UPDATE t1 SET value=20 WHERE id=2;
mysql> COMMIT;

 This transaction takes more than 10 seconds to complete, but each query finishes very quickly. So nothing is written …

Purpose

What does purge exactly do and why is it needed? If you have ever wondered then read on. It is really a type of garbage collector. When a user issues a DML like “DELETE FROM t WHERE c = 1;”, InnoDB doesn’t remove the matching record. This is what happens under the hood:

1. It marks the record as deleted by setting a bit in the control bits of the record.
2. Stores the before image of the modified columns to the UNDO log
3. Updates the system columns DB_TRX_ID and DB_ROLL_PTR in the clustered index record. DB_TRX_ID identifies the transaction that made the last change, and DB_ROLL_PTR points to the new UNDO log record. This UNDO log record contains the old values of DB_TRX_ID and DB_ROLL_PTR, possibly pointing to an older transaction and undo log entry.

From …

People keep asking me “what is going to happen to MySQL now that Oracle has screwed MySQL?” I bluntly disagree that any such thing has happened. This blog post is just my personal view and does not reflect my employer’s opinion, but Oracle might have saved MySQL from what I can see. There is no evidence that supports the hysterical doomsday theories. (Witness MySQL 5.5, probably the best MySQL release in history. Not exactly what I’d call “screwing.”)

I believe that a product with such a large, diverse, and important market presence needs a variety of companies involved with it in many different ways. One of the absolutely key things is a company to make money from it. MySQL needs Oracle, because no one else involved is both capable and trying to make MySQL, the product, a large-scale commercial success. It looks like Oracle is doing what I wish Sun could have done.

Now, is Oracle going to be community friendly, …