The latest from the MySQL community

Planet MySQL dropped my blog for a while.  It came back, but not fully.  Several blogs are showing just an A as their content on Planet MySQL.  Maybe this will get their attention.

Planet PHP on the other hand has lost me and other completely.  They both happened about the same time.  I thought it was Wordpress.com, but it was not just Wordpress blogs and both the Phorum Planet and Chris Shiflett’s Planet have had no issues.

So, I wonder if the Planet PHP and Planet MySQL sites are running the same code for aggregating and something about is broken with some feed types.  Maybe this will get them looking.  The world is missing my wonderful content …

How do you teach a thinking pattern? In my previous job I worked with a data analyst, who was really good at thinking about how our data correlates among itself. He was good at the data analysis, good at thinking up relationships, and good at coming up with complex comparisons.

However, he wrote some pretty funky SQL. We had him take a course in basics of MySQL, and from time to time I’d take a gander in the slow query logs and pick a few queries and point out the good and bad things. Most of these are optimization tips, such as “Indexes don’t apply to columns when you’re applying a function to that column”.

But it’s hard to try to think outside of your own box, and even running EXPLAIN on every query won’t necessarily tell you how you can fix a query. The problem is that there’s no way to know if you have optimized the query as much as possible. Even experienced DBAs

I was often frustrated when repeating …

I seem to be getting a lot of requests on my webserver of the form: "GET /<directory-path>/pmapper-3.2-beta3/incphp/globals.php?__SESSION[PM_INCPHP]=<some-url>?" where replace the <directory-path> and the <some-url> with a path on your server and some random website respectively. It appears to be a probe to test for some vulnerability but I don't have the full request logged, only the request up

... I didn't get two-way sync done, and I didn't get the Nibble algorithm done. That much I expected. But I also didn't get the current work released tonight because I'm paranoid about breaking things. I'm trying to go through all the tools and write at least a basic test for them to be sure they can do the simplest "unit of work" (such as mk-find running and printing out that it finds the mysql.columns_priv table).

It's good that I'm doing this. I found that mk-heartbeat suddenly doesn't work on my Ubuntu 7.10 laptop. It goes into infinite sleep. Can anyone repro this and/or diagnose? The same code works fine on my Gentoo servers at work.

Hopefully I'll be able to release something very soon. Release early/often is fine, but "knowingly release brokenness" isn't in my code of conduct :)

That is the good news. The bad news is, it is still affected by CVE-2007-5925, which allows remote authenticated users to cause a denial of service (database crash). Jörg Brühe wrote on the packagers mailinglist that is because the sources for 5.0.51 were cloned before the fix got in. I do not know exactly how their release model works, but looks like it needs to be improved, especially because 5.0.52 is not affected.

To make it even worse, bug #32125 which has a patch for the problem, was set to private a few days ago. Because we already have the patch in our MySQL packages since exactly three weeks, it …

I was reminded the other day how SQL Server was annoying in regards to table structure changes. All I wanted to to was copy a table (with structure intact - keys, dependancies) with its data.How hard could that be?MS SQL in ActionFirst, I needed to do a complete DDL on TableOne and replace every instance of the word "TableOne" with "TableTwo". It works, even though it is bulky and takes time,

When I was playing some Windows games before, there used to be eggs like a combination of certain keys would produce messages like the program pays tribute to blah, blah, blah. I wish MySQL has something like that... that if I press certain combination of keys that instead of the language in English, it would become a combination of English and unknown language. Just a thought.

When you look at the new feature set of MySQL, they are just so serious in trying to become the no. 1 database out there. Where is the fun??

SELECT OUTFILE should be able to write to a popen pipe. And it should be able to write to a URL. And it should be able to do XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

LOAD DATA INFILE should be able to read from an popen pipe. And it should be able to read from a URL. And it should be able to understand XML, JSON, YAML, and the various known database dump formats, and various known script pickling and serialization formats.

In the MySQL command line client, it should be able to source a URL on the command line. Inside the MySQL command line client, it should be able to source from a URL and from a popen, and tee to a URL and a popen.

It's been an interesting experience. Most of my classmates are from a rather different pool of "computer geek" than either the west coast "open source gods", or from big corporate IT. Most of them are from very small IT/dev shops. There are two guys from a Texan WISP. There is a guy who's the sole IT guy from an out of control academic dev project that is about to centralize all their random Oracle, Access, and MS-SQL databases into MySQL. There is the IT guy from a company that makes venetian blinds. The IT guy from a company that manufactures farm trailers and horse trailers. There is a semifreelance investigative reporter who wants to use MySQL for storing and sharing collected government data. There is an academic from a bio/gen research dept who's moving to MySQL.

As for the class, going in, I was afraid it was going to be a lot of memorization of configuration parameters, deep explanations of the query optimizer, and lots of very …

A