How can this happen?

mysql> DROP TABLE t;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE t;
Query OK, 0 rows affected (0.00 sec)

Well, just use a temporary table.

mysql> CREATE TABLE t (i INT);
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> CREATE TEMPORARY TABLE t (d DATE);
Query OK, 0 rows affected (0.01 sec)

mysql> DROP TABLE t;
Query OK, 0 rows affected (0.00 sec)

mysql> DROP TABLE t;
Query OK, 0 rows affected (0.00 sec)

I will add more such silly/hard/cool/whatever questions from time to time here.

Here's my presentation on Memcached and MySQL:

You can download the sample files here:

• memcached-demo.tar.gz [4MB]

Here's my presentation on Memcached and MySQL:

You can download the sample files here:

• memcached-demo.tar.gz [4MB]

Mike Olson is on the entrepreneurial prowl again. The co-founder of Sleepycat, who sold his company to Oracle and recently left Oracle for a brief stint as a relaxed person, is back in action.

I talked a day ago with a company that has talked to Mike about an executive ...

Three weeks ago Milking The GNU was  suggesting to SUN a few directions for MySQL. They were articulated around 4 messages:

1. Give the  business of dealing w/  large customers customers  to RedHat
2. Plug MySQL into the cloud so that to tackle with the long tail and beat up ORCL and MSFT
3. Keep MySQL community happy and growing
4. Start everything quickly so that to mitigate those bad Q3 numbers

Well, it took less than a month  for SUN to react. Here is a dramatized version of the answers implicitly given by Jonathan at the light of recent SUN's announcements:

1- I'm going to keep the RedHat business for myself, …

Sun advances GlassFish. Red Hat announces JBoss momentum. Mandriva releases Linux update. (and more)

Sun Microsystems Announces Technology Preview of Open Source Sun GlassFish Enterprise Server and New Sun GlassFish Communications Server, Sun Microsystems (Press Release)

Red Hat Continues Middleware Industry Momentum, Red Hat (Press Release)

Mandriva presents its latest distribution: Mandriva Linux 2008 Spring, Mandriva (Press Release)

Hyperic Announces MySQL …

Kickfire has announced (as of April 14th, 2008) record breaking results in the TPC-H(tm) Price/Performance category at 300GB and also in overall performance in the non-clustered category at 300GB.
You can find the official results here on the TPC(tm) (Transaction Processing Performance Council) website:
http://www.tpc.org/tpch/results/tpch_price_perf_results.asp
http://www.tpc.org/tpch/results/tpch_price_perf_results.asp?resulttype=noncluster

While the amazingly low price of the Kickfire Database Appliance 2400 will grab you (only about twice the price of a typical 4U MySQL database server) -- the amazing performance per watt is truly incredible. The 3RU Kickfire appliance used in the 300GB volume test consumes …

More competition for Mtron is right around the corner.

The Mtron PRO 7000 at 32GB is $1,129 or $35 per GB and can write at 90MB/s.

The Super Talent MasterDrive DX at 64GB is $1299 or $20 per GB and can do 70MB/s throughput.

So the Super Talent drive is about 22% slower but 42% cheaper.

Though I don’t think the MTBF is high enough for DB operations.

That and there’s no published IOPS specification. Kind of important….

…

There's an article about social networking and online retailers in this month's Internet Retailer.

I've been saying for some time that open source is not a price tag, or at least is much more than that. In criticizing Oracle's "lite"/express approach to competing with MySQL years ago, I insisted that "free, as in price, is just one part of the open source puzzle. But it's not necessarily the most important one."

I stand by that claim, and received confirmation from Untangle this week.

Untangle is an open-source network gateway company. It started out as a proprietary software company, but turned to open source for growth. This doesn't always work well for companies, largely because many get the model and/or culture wrong.

Untangle, however, has done it right, and …