I've opened a 'feature request' bug on this at http://bugs.mysql.com/bug.php?id=37107

Many third party tools designed for MySQL are designed such that referential integrity constraints may only be defined on InnoDB tables. Up until recently, this was fine as a hard coded limitation because only InnoDB supported referential integrity. Unfortunately, the reality now is that many storage engines, especially pluggable ones have many varied capabilities. There is no SQL accessible method for determining exactly what specialized capabilities any given engine has. The INFORMATION_SCHEMA.ENGINES metadata table includes XA, TRANSACTIONS, and SAVEPOINTS columns, but these don't go nearly far enough.

We need a table that lets engines expose exactly what capabilities they feature.

TABLE ENGINE_CAPABILITIES
ENGINE VARCHAR(64)
…

Welcome the the 99th edition of Log Buffer, the weekly review of database blogs.

Since PGCon recently happened right here in Ottawa, let’s start with some posts about it, and about PostgreSQL. Josh Berkus came to the conference with his Database Soup. It sounds like he enjoyed himself: “So, that’s pgCon. It was exciting and fun. All of you PG geeks who missed it should be kicking yourselves about now, and putting in budget requests for next year.” He has day one highlights; day two highlights, and also …

I just saw that Atlassian, the provider of the essential community tools like Confluence wiki and JIRA ticket system, updated their wiki on the importance of monitoring the “lifeblood of your organization”.

They even outline the important monitoring tasks you need, and stress that it will help when dealing with their own world class support.

Monitoring involves a number of essential tasks, including those listed below:

• Monitoring log files.
• Checking for HTTP-availability and performance (e.g. by getting the same page every five minutes and displaying the time on a graph).
• Looking at many different parameters such as load, connections, IO, database-trends, and so …

I'm pleased to announce the release of Memcached UDFs for MySQL. This release contains the ability to now pass expiration values. For instance, you can:

select memc_set('keyabc', 'somevalue')

or

select memc_set('keyabc', 'I die in 10 seconds', 10);

The functions that now have this ability are:

memc_set()
memc_set_by_key()
memc_append()
memc_append_by_key()
memc_prepend()
memc_prepend_by_key()
memc_add()
memc_add_by_key()
memc_replace()
memc_replace_by_key()

You can download the latest archive from http://patg.net/downloads/memcached_functions_mysql-0.5.tar.gz

Also, mercurial repository at …

On the way to

http://jan.kneschke.de/2008/5/18/mysql-proxy-replicating-into-memcache

I have another small side project:

• translating Row based log-records into Statement ones.

Our support team was asking for it since a while and it was a nice PoC that I can decode RBR events nicely.

Running MySQL 5.1 (with binlog_format = ROW) I issued:

mysql> INSERT INTO cols_pk VALUES \
     ( 3, "varchar", "char" ), ( 4, NULL, NULL );

... and have let mysql-binlog-dump decode the row-based log-events into SQL statements:

$ ./mysql-binlog-dump \
  --binlog-file=/home/jan/datadir/mysql-bin.000010

-- mysql-binlog-dump.c:256: db = test
BEGIN

-- mysql-binlog-dump.c:220:
CREATE TABLE test.cols_pk (
  field_0 INT NOT NULL,
  field_1 VARCHAR(64) DEFAULT NULL,
  field_2 …

Properties:

Description:

If you have slow query logs enabled (with --log-slow-queries), this variable will help interpret all those queries that are not using indexes as slow queries.

Usage:

While …

My last post, titled T-Dose CFP, got a comment from Bobby that people reading my feed from Planet MySQL couldn't possibly understand my post because of the lack of context.

So let me repost it..

Geekdinner is an unformal dinner where geeks meet , here in Belgium , but also at other places around the world, Every couple of months we meet , have dinner and chat about geeky stuff , such as tech conferences, mysql, drupal, jboss and other topics.

One of these topics was T-Dose , The Technical Dutch Open Source Event, which has their Call For Papers / Presentations available , so if you want to present there .. you have to tell them.

Bert Boerland gave a talk about Drupal there last year and Some Abstract Type, aka Geert Vanderkelen , MySQL/ Sun has also been spotted there …

Last week in Prague, I met with Mark Shuttleworth of Canonical at the Ubuntu Developer Summit for version 8.10.

myself, Mark Shuttleworth, Arseniy Kuznetsov (Sun, NetBeans), Matt Zimmermann (Canonical CTO)

As you would expect, we discussed Canonical’s and MySQL’s offerings to the market. And we pondered on possibilities for joint customers to have the best of both worlds: Wouldn’t it be great if MySQL users on Ubuntu could get the “best bits” from MySQL through the software delivery mechanisms of Ubuntu?

Mark drew the above picture on a piece of paper (which I used Omni Graffle to capture in .png form), and we decided to explore how the “curved orange” part of the customer experience could be improved.

A big thank you to all those who attended the memcached webinar today on which I was a panelist. I was told that there were more than 560 registrants.

The feedback I received directly and indirectly shows that there is a lot of interest about memcached. In the future, I hope to work again with MySQL/Sun on more memcached related webinars.

If you attended the webinar and have some suggestions, comments or questions, please contact me at fmashraqi at yahoo dot com or post a comment on this blog.

Special thanks to Jimmy Guerrero, Monty Taylor, Rich Taylor, Edwin DeSouza and Alex Roedling for their hard work in arranging the webinar. Also thanks to Brian Aker, Matt Ingenthron and Trond Norbye for their assistance at various phases.

In case you missed the webinar:

• webinar recording: …

One year ago, we announced that we would open source the entire Solaris Cluster product suite. Today, we are delivering on that promise six months ahead of schedule by releasing over two million lines of source code for the Solaris Cluster framework!

Read the official press release and listen to a podcast with Meenakshi Kaul-Basu, Director of Availability Products at Sun.

This third, and final, source code release follows the initial open sourcing of the Solaris Cluster agents in June, 2007 and Solaris Cluster Geographic Edition in December, 2007. As with the previous releases, the …