Just to remind you: tonight at 19:00 we'll meet at our usual place - please see me previous announcement for details. According to the RSVPs I received, we should be around 20 people. Paul McCullagh will talk about the PBXT Storage Engine, so this sounds like a fun evening. See you there!

Just to remind you: tonight at 19:00 we'll meet at our usual place - please see me previous announcement for details. According to the RSVPs I received, we should be around 20 people. Paul McCullagh will talk about the PBXT Storage Engine, so this sounds like a fun evening. See you there!

Spent some time on a tool for converting T-SQL stored procedures to MySQL during the weekend. It is looking quite good, but new problems keep popping up all the time. Like the differences in WHILE statement syntax, different naming of database objects etc.

Guess at some time I will have to be satisfied with a tool that leaves som problems unsolved, but not quite yet... I'll spend some more time on it before I release it.

Glom is an interesting graphical database front-end I’ve been meaning to try out for some time. Someone asked about graphical database front-ends on the #mysql IRC channel recently, and that prompted me to install Glom and learn how to use it. My overall impressions? It lands squarely in the middle of its target audience’s needs, but still has a quirk here and there. With a bit of polish it will be a fine product, and it’s already a winner over Microsoft Access and Filemaker, two similar programs with which you might be familiar.

Yesterday, Webyog announced that they have open sourced the very popular SQLyog database management tool. I've known about this good news for quite some time and have been itching to spread the good news. Whenever a company decides to make the leap from closed-source to open-source products, that is good news to me. It's also something that shouldn't be cast off as an easy decision for a company to make.

Rohit Nadhani, co-founder of Webyog, contacted me a few months ago and we talked about their plans to open-source a community edition of SQLyog. He's a bright guy. Very bright. But he shares the same concerns that any business owner has when pondering an entrance into the open source market. It's a frightening thing to "let go" of the business and development model you have used for years. I applaud him and Webyog for their efforts and their gumption over the last few months.

I did …

So often it seems that I am seeing someone struggling to find out what is wrong with their PHP script. They see the following error message:

Warning: mysql_fetch_assoc():
supplied argument is not a valid MySQL result resource
in /var/www/htdocs/somefile.php on line 18

and have no clue what this means. The line number has no bearing on where the real problem is, and there may be a whole cascade of these messages. Let's assume the code looks something like this:

mysql_connect ("server", "user", "password");
mysql_select_db ("dbname");
$result = mysql_query ("SELECT something FROM mytable");
while ($row = mysql_fetch_assoc ($result))
{
...
}

Where did the error occur? The answer is it could be any number of places. Let's make a list:

1. The server name is wrong.
2. MySQL is not running on the server
3. The script is being run on a host that is not …

You know, sometimes, when things start rolling, they really start to snowball. Such is the case with the newly-formed Community Doxygen Project. Yesterday, I wrote about some things that I've been working on recently. One of which was an effort to introduce doxygen into the MySQL source code documentation arena.

Since then, three community members — David Shrewsbury, Ronald Bradford, and Frank Mash — have stepped up to the challenge and become part of the Community Doxygen Project team. So, what will this team be doing over the next few months? Well, we will be attempting to pinch, pull, and push the MySQL source code into a consistent, Javadoc comment …

Those who were present at the 1st Belgian MySQL UG might have overheard that I had spend the better part of tuesday , fighting with an unstable MySQL cluster, ndb nodes dying with no reason whatsoever and no traces in the MySQL logfiles.

I found the issue wednesday evening, it wasn't even MySQL related.

Aug 30 12:30:30 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1f0/0)
 Aug 30 12:30:30 DB-A last message repeated 6 times
 Aug 30 12:30:43 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1d2/0)
 Aug 30 12:30:44 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1f0/0)
 Aug 30 12:30:44 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1f0/0)
 Aug 30 12:30:44 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1d2/0)
 Aug 30 12:30:44 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0xf0/0)
 Aug 30 12:30:45 DB-A kernel: __alloc_pages: 0-order allocation failed (gfp=0x1d2/0)
 Aug 30 …

Suboptimal ORDER BY implementation, especially together with LIMIT is often the cause of MySQL Performance problems.
Here is what you need to know about ORDER BY ... LIMIT optimization to avoid these problems

ORDER BY with LIMIT is most common use of ORDER BY in interactive applications with large data sets being sorted. On many web sites you will fine top tags, recently registered users etc - which would often require ORDER BY with LIMIT in the back end. In general this type of ORDER BY looks like: SELECT ..... WHERE [conditions] ORDER BY [sort] LIMIT N,M

Make sure it uses index It is very important to have ORDER BY with LIMIT executed without scanning and sorting full result set, so it is important for it to use index - in this case index range scan will be started and query execution stopped as soon as soon as required amount of rows generated.

…

A lot of time, I hear discussions about which reporting tool is the easiest to use for certain special tasks. Most of the time, I just ignore these “threads” because it’s not my cup of tea as a developer of ETL solutions.
However, it has to be said, often the solution to complex reporting requirements is to be found in ETL.
When you find yourself struggling with complex reports that need any of the following:

• compare different records
• aggregate beyond simple sums and averages.
• report on a non-existing records (report 0 sales, etc)
• …

Well, in those cases you need ETL.

Let’s take for example the case of the reporting on non-existing sales: how can you report that there has been 0 sales for a certain product during a certain week? Well, you can create an aggregate table in your ETL that contains the following:

• Dimensions
  …