Today, while on the MySQL manual page, I typed in ’select’ in the search manual box to confirm the SELECT syntax.

The result was not what I expected, the “SELECT” command. Instead I only got two options “Speed of SELECT …” and “Optimizing SELECT and …”.

Ok, well that’s not what I want, there is a suggestion box to the right so I pick the top option “mysql select”. Not only is this worse with “Type Conversion in …”, “Searching on Two Keys” I also get 3 totally useless “Keymatch” records

Download MySQL -http://dev.mysql.com/downloads/
MySQL Training - http://www.mysql.com/training/ KeyMatch
Buy MySQL Enterprise -http://shop.mysql.com/enterprise/

I know in the past just entering ‘SELECT’ worked, because I’ve been presently writing tests on JOIN syntax and I wanted to link in my blog …

When you eventually will buy Sun ..

Oh nooos.. I started this post last week and now it al seems in vain :(

Steven has some clues on what could have happened, I think he is right on the spot on with his Solaris prediction ..

He wonders why IBM would spend even another dime on Solaris, actually even today I can't even see why Sun is spending any more money on developing Solaris. But even with no acquisition his prediction of the future of Open Solaris imvho is spot on:

OpenSolaris will likely live on as a purely community-based operating system. After failing to gain any real traction against Linux, I expect it to become like the BSD operating systems: useful in niches and with a strong, core group of developers, but never to become a major operating system power.

As for Sparc, well I told it …

wchar_t was introduced long ago as wider version of char that should be enough while doing programs that grok Unicode. Unfortunately, as with all other C types the standard doesn't define the length. Thus some platforms have 2 byte others 4 byte wchar_t. I decided to check what are the sizes using an internal build tool at SUN/MySQL. And here are the results.

I suppose you have already heard from Ulf what MySQL Connector/C++ is. Today Ulf was looking at the test cases and out of the blue asked whether we support named pipes. Well, it wasn't tested but one can pass OPT_NAMED_PIPE to the connect method of the driver (or the MySQL_Connection constructor).

I am having MySQL performance problems with my current schema. Here is a rundown of what the inserter does:

- get's the filename, filesize and hash for a file
- checks the objects database to see if that combination already exists
- if it exists, skip to next step
- if it does not exisit, insert it
- insert the information in the file table

Here is the create table definition for the tables:

CREATE TABLE `objects` (
`objectid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(256) COLLATE latin1_bin DEFAULT NULL,
`filesize` bigint(20) unsigned DEFAULT NULL,
`hash` varchar(32) COLLATE latin1_bin DEFAULT NULL,
PRIMARY KEY (`objectid`),
UNIQUE KEY `nsh` (`filename`,`filesize`,`hash`)
) ENGINE=MyISAM AUTO_INCREMENT=7037849 DEFAULT CHARSET=latin1 COLLATE=latin1_bin

CREATE TABLE `files` (
`path` …

Let me tell you what I think is wrong, oh so wrong, with SQL_MODE. And there has been numerous debates and ideas around this for a long time, and many comments on how this really should work. So I assume that you are now all waiting for my very opinionated opinion.
And the problem is that we (the MySQL Server that is) allows it to be set just about everywhere, it's dynamic. This is do NOT like. not one bit. And let me tell you why.

If I work in a small project, like when I'm playing around with my own websites or my own small projects, I am both the DBA and the developer. So there isn't much argumentation going on, I know what I am about to do. But still, I want the database to determine the consistency of data, and the application to be just that: an application that conforms to the rules I have set up in the database schema.

This is similar to my arguments for FOREIGN KEYs. In a small project, I know my …

This is not a long blogg posting, I just want to point to the simple libmysqld demo application for Windows that I have created. It's available on sourceforge as as I said, this is Windows only so far. I might well go ahead and do a Linux version of it eventually, but right now, this i sfor windows.
But I don't think that matters much, this is not meant to be a terribly useful application in and of itself, rather, this is a minimal application built to demonstrate a concept.

If you are interested in libmysqld, then have a look at the webinar I did couple of weeks, and if you are at the MySQL User Conference, then pop by my …

First off, I have not been much of a of for Sparc in a number of years. Partly because I didn't feel like paying for the machines, and partly because I am not much of a fan of Solaris (the user space for development has a lot to be desired). In the last few months we have been working on getting Drizzle to work on Sparc/Solaris which has been an interesting adventure.

MySQL never compiled on Solaris without warnings, and it almost never could pass the full regression test system.

With Drizzle, I felt like if we were going to say we ran on Sparc/Solaris that I wanted to be able to say that we supported it without a bunch of exceptions.

It took us months... and I mean months to get things cleaned up for it. In the process I've gained a bit more respect for the platform (keep in mine... I was a big fan of SunOS, the predecessor to Solaris).
…

A few days ago, I have published a tutorial on building a Connector/C++ client application on Windows using Visual Studio. Its time for a Linux How-To. My I-Do-Everything (IDE) choice on Linux is NetBeans 6.5. NetBeans is open-source and free. A version with C and C++ support is lightweight (24MB download) and the code-completion feature has ruled out Katy (kate) for writing Connector/C++ tests.

I am happy with every fast editor that offers syntax highlighting and supports a mouse. NetBeans does both. I do not know how to write Unix Makefiles. NetBeans does. A perfect match for Dummies and Little Idiots to build a C++ client application for MySQL using the …

A few days ago, I have published a tutorial on building a Connector/C++ client application on Windows using Visual Studio. Its time for a Linux How-To. My I-Do-Everything (IDE) choice on Linux is NetBeans 6.5. NetBeans is open-source and free. A version with C and C++ support is lightweight (24MB download) and the code-completion feature has ruled out Katy (kate) for writing Connector/C++ tests.

I am happy with every fast editor that offers syntax highlighting and supports a mouse. NetBeans does both. I do not know how to write Unix Makefiles. NetBeans does. A perfect match for Dummies and Little Idiots to build a C++ client application for MySQL using the …