As Sun SPARC Enterprise T5140 is launched along with the Open Application Services solution which includes PostgreSQL, the talk I gave at PostgreSQL East 2008 on "Best Practices with PostgreSQL on Solaris" might be helpful for many new users.

If there are questions let me know.

So, I’m leaving on a jet plane, to head to the MySQL Conference & Expo 2008. Normally, this is a flight I make via Auckland or Sydney, but this time its via Singapore.

Singapore is a hub in Asia, so let me share a few tips:

• The airport is huge. Terminal 3 reminds me of being in one of Heathrow’s terminals. Leave plenty of time to walk from gate to gate (up to 20 minutes).
• US flights probably always leave from Terminal 3, around gates A16-A20. The gates are speculation, mainly because of the extra security available out there. (A18, for Los Angeles, A16 for San Francisco, I’m pretty sure I’m right).
• Within A16-A20, you’ll not notice any power sockets available for your laptop. Clearly, very negative for the business traveller.
• You can get free wireless, via the Wireless@SG access point. Just get your mobile phone to roam to …

I forgot to mention in Support the MySQL Community Photo Day that PrimeBase Technologies is providing 3 prizes for the best photos uploaded.

So, take your photo with other community supporters — they’ll also be wearing their open source t-shirts. You can upload photos to www.flickr.com/groups/mysqlcommunityphotoday.

Goodness, I thought I'd never find it. Moving a few times causes a lot of havoc. But, here it is:

So, what is it, who's on it, and what are my intentions with it?

It's a 2002 summer (Northern hemisphere) edition MySQL t-shirt ("Power & Freedom" theme), size S. It was signed at the MySQL Cancun dev staff meeting, October 2003. This was the first dev meeting with the NDB Cluster team, and assorted others. I got this shirt signed by all present (except I notice I didn't actually sign it myself ;-)
Let's see if I can decode the names...

David Axmark (co-founder), Mikael Ronstrom (NDB architect), Pekka Nousiainen (NDB dev), Lenz Grimmer (build engineer, now community relations), Mike Zinner (GUI dev …

There’s no video for Jacob Nikom’s December 2007 Boston MySQL User Group meeting, but the slides for “Measuring MySQL Server Performance” can be downloaded (2.33 MB) at http://technocation.org/files/doc/Measuring_MySQL_server_performance_03.ppt

And with that, this is (I believe) post #10,000 at Planet MySQL!

Sometimes I wonder where this whole web development thing is going...I was asked to setup some backup and recovery tools for the BerkeleyDB Java Edition (JE).Hmm... DB... I could probably argue that DB should be dropped from the name if you add Java edition to it. I suppose maybe it's Oracle's plan to drop BerkeleyDB for the newer improved BerkeleyDB Java Edition (JE). Maybe that's why there

Dealing with hierarchies in a relational database is a pest. There's Oracle's CONNECT BY PRIOR, and the SQL standard defines IBM's recursive UNION, but still... wouldn't it be nice if a hierarchy (or even a full-on graph, like social networks have) could just be managed cleanly relationally?

This is something Kim and I have been dabbling with. The engine is called OQGRAPH (OQ for Open Query) now because just graph caused some symbol conflict hassles. Anyway, following is a brief demo of how it works.

First, let's insert some data...

mysql> INSERT INTO gstest (origid,destid) VALUES (1,2),(1,3),(2,4);

Get it back out plain...

mysql> SELECT origid AS node, destid AS edge FROM gstest;
+-------------+
| node | edge |
+-------------+
|    1 |    3 |
|    1 |    2 |
|    2 |    4 |
|    3 | NULL |
|    4 | NULL |
+-------------+

(Hey, notice something? the engine …

I reported "Processlist shows status NULL when server is purging/managing query cache" in April 2007, while I was still in MySQL support engineering. This issue actually made tracking down other bugs and customer issues take longer. About a year later, MySQL 6.0 codebase apparently has the progress info. By the way, we are essentially talking about a one-line fix, adding something like thd->proc_info="Flushing table from cache"; at the appropriate spot.

In the mean time, three bugfix meetings have spent time on this item (judging by the tags), those are meetings where MySQL (re-)prioritises some bugs for fixing. That's an awful lot of time to waste euh spend on this thing. The bug entry itself is still open as "feature request", and I presume MySQL support and bug engineers are still wasting time due to the insufficient reporting in 5.0 and 5.1. In the …

We were doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish results which are very interesting.
This is obviously not audited TPC-H run, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only measured Power to keep things simple.

We tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box w 16G of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL as only one query is ran concurrently, same can be told about 8 hard drives which this box had.
MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely long running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL,though at least we get to see performance of individual queries.
We also packaged the toolset we used for benchmarks so you can …

It’s been six weeks since the completion of the acquisition of MySQL by Sun Microsystems. In this time, on the MySQL News and Press Releases there has only been one (1) Press Release here.
In the six weeks between the announcement and completion of the acquisition MySQL made ten (10) Press Releases, and the six weeks preceding this including the Christmas break there was (six) Press Releases.

On the Sun Press Releases in this period there has been twenty three (23), but just the same one MySQL specific. …