A while back I announced on the PDO mailinglist that I would review the tests the mysqlnd team wrote. These tests are currently MySQL specific and I was hoping that we could adopt them for the other drivers. I spend less time than I originally envisioned on the review, mostly because the last 2 months were a bit more exhausting at work than I had anticipated. So I ended up sleeping more and working less. Anyways, at this point it seems to me like the tests themselves are too MySQL specific to be easily portable to other RDBMS and that the time is therefore better spend simply writing new tests and using the mysqlnd tests as inspiration. However, I feel like the current structure of the test suite is not optimal yet, though I might not fully grasp the current approach.

So I think the next …

MySQLPreacher has only started ten days ago, but despite it has limited viewers so far it would still like to wish all readers a great new year full of joy and happiness, with no deadlocks or failing backups, no overloaded slowquery logs. Hope it will be a year with an enviable uptime!

Hi All,

I’ve been thinking about contributing to the MySQL community for a while and given we’re at the end of 2008, starting 2009, I thought …. maybe this is actually the right preposition for the coming year. There will be many changes in my life in the next week and a half, amongst which a change of countries and jobs, thus this will be the third biggest challenge for me in the ninth year of this third millennium.

Upgraded VirtualBox and booted up my OpenSolaris VM. VirtualBox 2.1.0 finally fixes the bug where if 127.0.0.1 was in resolv.conf on the host - no DNS for you in the guest (unless in the guest you were running a DNS server).

Haven’t tried it yet… but OpenGL Accelleration makes at least a checkbox appearance in VirtualBox 2.1…. so that could be rather awesome.

Going a lot better with OpenSolaris 2008.11 than previous releases.. It looks like it might be quite easy to get to the stage of building Drizzle on it.

Just figured out how to change to Dvorak! Yay, I can type again! (Go to Input Methods preference panel and add US/DVORAK as a language, move it to the top, and enable the input method application and do it that way).

Currently installing sunstudioexpress. Why not gcc? I’m pretty sure the version in OpenSolaris is still ancient (so won’t build drizzle) and Sun Studio does produce different warnings …

More and more people are lending advice to the MySQL guys at Sun (not even mentioning the level of fact based slapping its getting along the way). I think there is one important thing missing in this advice, Sun has its feet in 3 RDBMS products: MySQL, Drizzle and PostgreSQL. Even if they paid a 1B USD for the first, the other two are important to remember as well. Actually Drizzle is mentioned a lot in this advice, but PostgreSQL is oddly absent. IMHO MySQL serves a market quite perfectly at this point and I do not see this changing in the next few years.

There are annoyances all around, but the fact of the matter is that we know them well and they do not stop us from …

After what many hours trying to netboot the T1000 to install Solaris Express, I wondered “how hard is it for debian?”.

Easy. get the sparc64 boot.img, put it on TFTP server, add “filename “boot.img”;” or similar to dhcp, boot the T1000 from the service console something like this “bootmode bootscript=”boot net:dhcp”\n restart -c” and install away!

As for Solaris?

Well… dhcpd.conf:

option space SUNW;
option SUNW.root-mount-options code 1 = text;
option SUNW.root-server-ip-address code 2 = ip-address;
option SUNW.root-server-hostname code 3 = text;
option SUNW.root-path-name code 4 = text;
option SUNW.swap-server-ip-address code 5 = ip-address;
option SUNW.swap-file-path code 6 = text;
option SUNW.boot-file-path code 7 = text;
option SUNW.posix-timezone-string code 8 = text;
option SUNW.boot-read-size code 9 = unsigned integer 16;
…

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…

Finding free quality wallpaper is hard and its even harder to find quality wallpaper for Christmas. Here is a couple sources I came across with a pretty good selection. If you have any suggestions of other sources for the holiday season drop a comment.

Source: CSSBuilt - 29 Beautiful Christmas Wallpapers
Source: CSS Count - 30 List of Stunning Christmas Wallpapers

Well… there’s:

• database
• table name

(both of these are quite obvious).

But then you have:

• temporary tables

Well… two types of temporary tables:

• those created in the course of query execution, typically in /tmp/
• those created during ALTER TABLE, typically in the database directory

You may have seen these “#sql-foo.frm” etc files around.

but you can also CREATE TABLE `#sql-foo` (you know, because that’s a good string to use in your app). In fact, you can (and shouldn’t) create a table with the exact same name as the temporary #sql table and use it in your app.

So really the primary key for a table is: string database name, string table name, bool is_tmp. Oh, and the /tmp/ temporary tables just to screw with your braiiiinn.

In drizzle, this is what the storage engine API is …

GlassFish and MySQL student contest winners are announced!

Kolli Bharath from Dhirubhai Ambani Institute of Information and Communication Technology, India (review, project) and Tomas Augusto Muller, Universidade de Santa Cruz do Sul, Brazil (review, …