There is a new blog in the MySQL Community arena.

It is a collaborative podium for guest posts. We will host colleagues or community members who have no blog and need a temporary place for their message. The first experiment was successful, and we decided to have a more stable place for it.

We start today by hosting Trim Perhad, System QA manager of MySQL, who presents some interesting performance results.

To complement my patches to show import progress using the mysql client I have created a minor patch to mysqldump.  This new patch for MySQL 5.1.30 will show you the number of rows dumped so far every 10,000 rows when using the --verbose parameter.  The output should be similar to this:

-- Retrieving table structure for table testing...
-- Sending SELECT query...
-- Retrieving rows...
-- 20000 rows dumped

A friend suggested the creation of a "Technical Professional Purity Test", and suggested two questions:

Have you ever have you ever implemented a solution you knew would doom the client?

Have you ever yelled at your manager for interrupting your workflow?


Please, suggest more!

How?

Seriously, how do I do this?

Following constraints: T1000 has no local DVD drive. No other Solaris hosts on network.

(Note that it takes about 15 seconds to find the Debian install instructions. “Put this file on tftp server, boot.”)

With all the furor over MySQL 5.1 GA, its release schedule, its quality, etc etc I think a fundamental claim is being left un-examined. Lots of people are saying that if you leave out the new features in 5.1 and look only at the features that existed in 5.0, it’s better quality.

The implication is [...]

Today I ran into an issue which I could not figure out for quite a while. I was trying to redirect a url to another url using RewriteRule. It was supposed to be a pretty straightforward redirect which made it even more annoying than complicated ones. Hopefully somebody is able to explain what I am missing here and if my solution is a good solution or not.

I needed to redirect a url:  http://www.example.com/testpage.php?foo=bar to http://www.example.com/

So I added this to .htaccess file:

RewriteRule ^testpage\.php / [R=301,L]

This did do a 301 redirect as I wanted but query string passed so my redirected url looked like:  http://www.example.com/?foo=bar

Obviously this is not what I wanted so in order for me to fix it, I had to take a rather lame approach.  My new redirect is:

RewriteRule ^testpage\.php /? [R=301,L]

The …

In what situation will this succeed:

ALTER TABLE t1 RENAME t2;

but this fail:

RENAME TABLE t1 TO t2;

?

Highlight the white text below for the answer:

When t1 is a temporary table.

Wow… I wonder why that is, I can’t think of any good reason…

Old style of training In the 1940s and 1950s, printed typed manuals and blackboards were the accepted norms for training people. Slowly training evolved to using projectors. Today if you look at most organizations training methodology, they are using printed materials and Powerpoints that are really not that far from the blackboards and projectors from fifty years ago.

Training Today In an

I had a call with Monty the other day and I told him why I think MySQL Server Quality will never be the same again. I've been thinking a bit more about it and here is the extended list.

In particular I think MySQL Server will never be able to reach its original quality guidelines (see previous post) and even current release criterias will unlikely be ever reached with any sensible definition of what serious bugs are.

Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team was working on the server and Monty was personally reviewing all the code and knew all the code well to know all the side effects etc. Now MySQL Development is done by different team working on the …

Using the wonderful bittorrent, I got the CD image in next to no time (in contrast to the Solaris Express image I’m currently downloading via HTTP that’s taking forever).

Boot time in VirtualBox (off the ISO image) was rather quick, usual questions on keyboard layout and desired language (it’d be neater if these were GUI questions… but anyway). The GNOME desktop loaded up, popup window informed me that it had connected to the network. Awesome.

Package manager: opend quickly, using the opensolaris.org repository and it does seem to have a lot of packages… even MySQL 5.0.67 (and 4.0.24). Not 5.1 though, but it is early days (and it was just released as GA the other day).

At least one unusual thing was SUNWgrub and SUNWgrubS (where the S is for source). I assume this is some packaging oddity as I don’t ese other packages like this.

SUNWii wins the odd package name award.

The Time Slider seems …