A few days behind schedule, we can announce that the new beta - version 5.0.14 - has reached our mirrors. A bunch of improvements and fixes are incorporated in this release. The software rendering mode has been changed to using Windows GDI instead of the mesa-library. This change brings a big (and badly needed) performance boost when using MySQL Workbench without openGL rendering. There are further improvements like the brushed up property editor, new view-options on the overview page or manually resizable table-objects. Code has been cleaned up extensively and over 30 bugs has been squashed since 5.0.13. Take a look at our Releases Page to read all the dirty details.
Please check out the new release and see whats new and better.

Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Web Server running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones).

The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T2 processor) and Solaris Containers managing a consolidation of Open-Source Software components (MySQL Database and Sun Java System Web Server) provided 2.4 times better performance than the HP DL580 system (four Xeon quad-core processors) and a major virtualization software, Microsoft Windows 2003 Server EE, Microsoft SQLserver database and Microsoft IIS webserver.

The Sun SPARC Enterprise T5220 using the MySQL database in Solaris zones is …

Recently we put together a consolidation benchmark to see how an open-source stack performs against the proprietary stack from Microsoft. Solaris, MySQL, and Sun Web Server running on the open-source UltraSPARC T2 processor were pitted against a Microsoft SW stack running on a 4-socket QC Xeon server. This benchmark highlights the continued trend to incorporate MySQL open-source databases and how it works under virtualization (Solaris Zones).

The Sun SPARC Enterprise T5220 (1.4 Ghz UltraSPARC T2 processor) and Solaris Containers managing a consolidation of Open-Source Software components (MySQL Database and Sun Java System Web Server) provided 2.4 times better performance than the HP DL580 system (four Xeon quad-core processors) and a major virtualization software, Microsoft Windows 2003 Server EE, Microsoft SQLserver database and Microsoft IIS webserver.

The Sun SPARC Enterprise T5220 using the MySQL database in Solaris zones is …

I came home very tired yesterday, just walking around as a big MySQL billboard and I left with mixed feelings really.

First feelings were Happiness + Anger (=Love??). I had a nice dinner with Bruce and Magnus (PostgreSQL) on Thursday, met others at their booth and attended a few talks both Saturday and Sunday. I'm interested in their stuff, I do like PostgreSQL, just like probably everyone else in MySQL. But, I got very angry about 2 remarks made in the DevRoom: "MySQL loses data" and the infamous and idiotic "MySQL has no transactions". FFS! The latter was corrected on the spot, that REALLY pissed me off (remark made by non-PostgreSQL crew btw).
Anyway, overall, I did like what I was hearing, the project is going well, and lots of cool stuff coming in! Very nice! Funny thing though: "Who's using Partitioning?", one guy (as far as I could see) put up his finger.

Next feeling: Amazed! Drupal! I don't like PHP, bah, …

Luc just pointed me with to his recording of my talk about Drupal and MySQL HA yesterday at the Drupal Room at Fosdem

He also uploaded some other video's from the Drupal room.

More about my Fosdem 2008 experience later :)

I’ve been working with the folks working on OpenSolaris for a few months now providing advice and input on getting MySQL and the connectors (C/ODBC and C/J) installed as a standard component. Having got the basics in, the team are now looking at adding both 32-bit and 64-bit packages.

The question raised at the end of last week was whether OpenSolaris should enable 64-bit builds by default in 64-bit installations, and whether there was a noticeable performance difference that would make this worthwhile.

I did some initial tests on Friday which showed that there was a small increase (10-15%) of the packaged 64-bit installations over 32-bit under x86 using snv_81. Tests were executed using the included sql-bench tool, and this was a single execution run of each package for 5.0.56. Transactions are missing because I hadn’t enabled transactions in the tests.

For a change, let me remind you of the upcoming MySQL Users Conference in Santa Clara. It’s less than two months from now; it’ll be from Monday 14 April 2008 to Thursday 17 April 2008. Same place as last year: Santa Clara, California, USA.

My reminder is triggered by the fact that tomorrow is the last day for Early Registration, by which conference participation costs 1299 instead of 1499 dollars (or, if you skip the Monday tutorials, 999 instead of 1199 dollars). In short, early registration saves you 200 dollars.

I do think the UC is at least as interesting as last year, and I’m very happy about our …

Today’s entry is from an anonymous contributor. Keep ‘em coming!

Suppose you issue the following list of commands:

CREATE TABLE fk_relations (
  key1 INT NOT NULL PRIMARY KEY,
  key2 INT NOT NULL UNIQUE
);
INSERT INTO fk_relations VALUES (1,1), (2,2);

The table now contains (1,1) and (2,2). We then do

REPLACE INTO fk_relations VALUES (1,3);

Question 1: The table now contains (1,3) and (2,2). Explain why.
We now do:

REPLACE INTO fk_relations VALUES (1,2);

Question 2: The table now contains the single row (1,2). Why?

Question 3: What is the value of Rows affected in your client after each of the two REPLACE statements?

(more…)

As I wrote earlier, we (me and Ranger) have done an assessment of the impact of new 6.0 subquery optimizations. First, we've done a search for performance issues in MySQL's bug database. The raw list is here, and the here is a summary chart:

Search for customer issues in MySQL's issue tracker system has produced a similar picture (raw list):

Search in DBT-{1,2,3,4} open source benchmark suites produced a radically different result though (raw data is …