Got up at 3:30am to make a 6:10 direct flight from Boston to San Fransicso this morning. Excited to get there and be a part of the MySQL action. Will be spending the day up in San Fransicso doing a little sightseeing and then headed down to Santa Clara in the evening.
Much to my delight the Logan airport WiFi, which has always required a registration (including $$), seems to have let me in without issue so I can get some stuff done while I wait for boarding.
I just got an e-mail from a desperate MySQL user who stumbled
across a discussion on the forums that I had some time ago
with MySQL's Oleksandr Byelkin. The user hit the same problem I
had (and have) when using VIEWs: Whenever MySQL has
to use ALGORITHM=TEMPTABLE it's virtually impossible
to use the VIEW on all but very small tables.
This issue affects mainly VIEWs that make use of a
UNION or GROUP BY. The problem is that
the MySQL optimizer currently doesn't push down
WHERE conditions from outer queries into subqueries
and thus also VIEWs (at least not in these cases, I
don't know if there are other situations where a pushdown
occurs). This means that before MySQL can start to solve the
final outer query, it has to build a temporary table using all
the rows …
In a few hours, I'll hop a plane to Santa Clara for the 2006 MySQL Users Conference. There will be many great MySQL people so I'm sure there will be excellent blog coverage the entire week. I'll try to post a few thoughts myself.
Oh, and in case anyone missed it, the Visual Express products are now free permanently. On Windows, I expect Visual C++ Express to be the preferred "free" tool for building MySQL. As of right now, we build MySQL on Windows using Visual Studio 2003.
My talk at the MySQL Users Conference is officially called
"Advanced User Defined Functions in MySQL 5,"
but if it weren't too late I'd change the name and call it "SQL
as a Glue Language."
Sometimes logic should be as close to the data as possible; this
is why triggers exist in SQL. MySQL 5 gives you a full-fledged
programming language (SQL/PSM), lots of utility functions, and
(this is where the "glue" comes in) the ability (using UDFs) to
plug into existing C and C++ libraries with ease.
I hope to see you all there Tuesday at 4:30, and then at Jeremy &
Hartmut's UDF Hackfest Tuesday night.
In their morning keynote presentation at the MySQL Users Conference, company founders Monty Widenius and David Axmark announced the winners of the 2006 MySQL Community Awards.
It is possible to explicitly insert values into an AUTO_INCREMENT in MySQL, but sometimes these inserts cause confusing behavior. In this article I’ll explain that behavior. Background Suppose I have the following table: create table number ( number int not null auto_increment primary key ) ; Now suppose I insert some values into the primary key explicitly, bypassing the AUTO_INCREMENT feature: insert into number(number) values (-100); select * from number; +--------+ | number | +--------+ | -100 | +--------+ So far, so good.
It?s been a while that I touched Roxen Webserver for the last time. For some reason (*) I had a look at http://www.roxen.com/ and just downloaded the latest version.
I used to work a lot with Roxen, in the previous company, we even were Germany?s partner for Roxen. And since Roxen is -like MySQL- a Swedish company, their webserver is simply part of the family.
I always loved Roxen, since they introduced things to the .com market years before they got popular. For example, they had RXML (Roxen Extended Markup Language) before XML was known to the public. And they had a modular approach years before Apache got all the mod_whatever stuff.
And the underlying programming language, Pike, is one of the most underestimated software tools I ever came …
[Read more]I've recently discovered a few things about how the mysql client library does things that seem a bit silly to me, so I'm going to share them with you.
calling stored procedures multiple times using native prepared statements causes the connection to drop.
I recommend that you use the following attribute when working with PDO::MYSQL, available in the current PHP 5.1.3 release candidates and snapshots:
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES,
true);
This causes the PDO native query parser to …
[Read more]You have heard about MySQL Cluster, but you were always afraid to get into it because ?Cluster? seems to be a magic and complicated topic? Then this article is for you. In a couple of minutes, you can run your own Cluster.
Sometimes, I need to demonstrate how MySQL cluster works. I usually set up a single machine cluster which of course won?t make sense in production scenarios, but for an introduction into MySQL cluster it?s fine. And it?s very easy to deploy the system on multiple machines later.
This article will show you how you can set up your own Cluster. All you need is a UNIX machine and the mysql-max package (version 4.1 or 5.0) which is downloadable from the MySQL website.
Run ?SHOW ENGINES? to see that the cluster storage engine is included in your installation. If it says ?DISABLED? or ?YES? …
[Read more]I've spoken at a variety of conferences and meetings over the past few years. For many of the gatherings the organizers work diligently at getting users to fill out some kind of quick feedback form for each session. I've always wondered about those forms, particularly when I've given a session.
The other day I got an email from the PHP Quebec folks with a document attached with the information gathered from those forms for my talk on MySQL Cluster. Ratings from 1-5 on a few different questions (like "How well did the presenter know the subject?) and then a number of feedback notes from the folks who attended.
I wish all conference organizers had that kind of time and dedication to get the feedback back to the presenters. In cases where the feedback is praising it's good for a speaker to know they did a good job and were on the mark. In instances where there were …
[Read more]
