Justin Bolter has a nice screencast on using the NetBeans PHP support to build a Flickr slideshow application. A nice way to get a sense of the PHP features in NetBeans.

We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced.

The -percona release includes:

PLAIN TEXT CODE:

1. | innodb_check_defrag.patch                        | Session status to check fragmentation of the last InnoDB scan                            | 1.0     | Percona <info@percona.com>       | GPL     | The names are Innodb_scan_*                      …

I just read the news.

I don't know about you, but I was pretty much expecting this. Even though it may cost me my job, I am glad they bit the bullet and cut 15%. We're just burning too much cash and the size of the company didn't match its current market cap.

How do I feel? Relieved, in a way, because I knew it was coming. Am I affected? I have no idea. Nobody's telling the peeps yet, that will happen in the next few weeks.

Software is getting seriously reorganized. NetBeans is now part of the cloud computing platform. Why? My blog, my opinion: because I think Sun gets it that what Sun can offer in this space is a developer platform. Amazon Web Services is a bunch of cogs and wheels targeted at system …

This is the 123rd edition of Log Buffer, the weekly review of database blogs. Welcome.

Let’s begin with some SQL Server, where it was a week of technical tips. Alexander Kuznetsov looks at defensive database programming. “In most cases LIKE conditions should by followed by ESCAPE clauses,” he asserts, continuing, “You have a choice: you can either have a CHECK constraint disallow special characters, or you can fix the procedure,” thus error-proofing your logic. Readers Alejandro Mesa and Adam Machanic suggest a couple refinements.

On …

Sun Microsystems slashes jobs in major restructuring. SpringSource gets Groovy with G2One. Novell goes after Red Hat. Sonatype confirms Marc Visser as new CEO. Neil Young’s new car. And more.

Press releases
Sun Microsystems Aligns Business with Global Economic Climate and Amplifies Growth Opportunities Across Open Source Platforms Sun Microsystems

SpringSource Acquires G2One Inc SpringSource

Novell Announces New Program to Aid Transition to SUSE Linux Enterprise Server Novell

Zenoss Adds …

I recently found myself wishing for an async library for MySQL. My goal is to be able to fire off queries to a group of federated servers in parallel and aggregate the results in my code.

With the standard client (DBD::mysql), I'd have to query the servers one at a time. If there are 10 servers and each query takes 0.5 seconds, my code would stall for 5 seconds. But by using an async library, I could fire off all the queries and fetch the results as they become available. The overall wait time should not be much more than 0.5 seconds.

While I found little evidence of anyone doing this in practice, my search led me to the perl-mysql-async project on Google Code. It's a pure-Perl implementation of the MySQL 4.1 protocol and an asyncronous client that uses …

After almost 3 years working in Support then Training, it's time to move on. I haven't blogged much in a while, but it's something I plan to work on more now I sit on the other side.

After almost 3 years working in Support then Training, it's time to move on. I haven't blogged much in a while, but it's something I plan to work on more now I sit on the other side.

Hearing that the MySQL database server is delivering corrupt data is not how I like to start the day, but that was the greeting when I arrived to work a couple days ago.

The claim was that an INSERT...SELECT query buried in a batch process was producing a different result than running the same query manually via the mysql client.

Since this is a production system, and a busy one at that, we don't keep the general log enabled. Restarting the server to enable logging is not an option during peak loads either.

Luckily, I stumbled on a DTrace script out there in internet land and it let me see exactly what was happening. I wish I can remember where I got it so I could give due credit. Here is the script:

#!/usr/sbin/dtrace -qs
pid$1::*dispatch_command*:entry
{
printf("%d::%s\n",tid,copyinstr(arg2));
}

Thats it. Just execute it on your Solaris 10 …

Hearing that the MySQL database server is delivering corrupt data is not how I like to start the day, but that was the greeting when I arrived to work a couple days ago.

The claim was that an INSERT...SELECT query buried in a batch process was producing a different result than running the same query manually via the mysql client.

Since this is a production system, and a busy one at that, we don't keep the general log enabled. Restarting the server to enable logging is not an option during peak loads either.

Luckily, I stumbled on a DTrace script out there in internet land and it let me see exactly what was happening. I wish I can remember where I got it so I could give due credit. Here is the script:

#!/usr/sbin/dtrace -qs
pid$1::*dispatch_command*:entry
{
printf("%d::%s\n",tid,copyinstr(arg2));
}

Thats it. Just execute it on your Solaris 10 …