I'm pleased to announce the release of DBD::mysql 4.005! This release contains various fixes, per Changelog:

• 
  
• Fixed mysql_warning issue < 4.1 (reminders, patches, help from ROAM, (issue 25713)
  
• makerealclean patch from ROAM (issue #25714)
  
• sqlstate cleanup patch from ROAM
  
• Replaced all references to dbis->debug to use DBIc_TRACE_LEVEL(imp_xxh)
  
• Fix to dbd_st_destroy - added back previously removed 'free everything' code which
  had been moved to dbd_st_finish, causing a crash upon freeing of bind values
  after all rows resulting from one execution of a query have been fetched. This meant
  that next attempt to execute the prepared statement would segfault. This
  work thanks to Rainer Weikusat!
  
• Removed all 'FindNewTable' calls in all tests. Just use 't1' for all tests to
  …

To be honest I'm not a big fan of Stored Procedures, At least not in the form they are currently implemented in MySQL 5.0

Only SQL as a Language Which is ancient ugly for algorithmic programming and slow. It is also forces you to use a lot of foreign constructs to "original" MySQL style - to process data via cursors, handle error via Handlers etc. If you spent last 10 years writing Stored Procedures for Oracle or DB2 it may be cool and convenient for you, but not for me

Lack of Debugging I like to be able to debug software, if not full blown debugger I'd like to have things like echo and var_dump. Due to the context of execution these are not easy though. Of course you can code a little helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough.

Bad Parser Error Messages MySQL Parser is in general far from perfect when it …

So I was surfing around Apple's website this afternoon and found this new Windows download called Safari.  Wondering what it is I downloaded and installed it.  Turns out it's a great memory stress tool.  Check out this screenie of it using nearly 300 megs on my Vista x64 system.

This is great!  I was able to see how all my other apps work in low memory situations.  As useful as that is, right before I was going to write this blog entry I discovered this wonderful app also renders web pages.  Holy cow!!  This is too much.  What are those Apple guys going to think of next?

MySQL AB today announced that Gumtree.com -- one of the world?s fastest growing online community websites, and the UK?s biggest site for local community classifieds -- has selected and standardized on MySQL Enterprise to support its exponential growth and scalability requirements.

This is my second article about hacking MySQL. If you are interested in this topic, you may want to read my previous Hacking MySQL: SIGNAL support (I)

The problem

If I tell you there is a function called TRUNCATE, what do you think it does? which are its arguments?

For me, the obvious behaviour would be something like:

mysql> SELECT TRUNCATE(123.45);
+--------------------+
| TRUNCATE(123.45)   |
+--------------------+
|                123 |
+--------------------+
1 row in set (0.08 sec)

But the actual behaviour is this:

mysql> SELECT TRUNCATE(123.45);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

This is because …

How good are your SQL and/or general coding skills? I have a specific challenge I'd like your help solving. I am not sure it's possible, but I'd love to be proven wrong.

So I was surfing around Apple's website this afternoon and found this new Windows download called Safari.  Wondering what it is I downloaded and installed it.  Turns out it's a great memory stress tool.  Check out this screenie of it using nearly 300 megs on my Vista x64 system.

This is great!  I was able to see how all my other apps work in low memory situations.  As useful as that is, right before I was going to write this blog entry I discovered this wonderful app also renders web pages.  Holy cow!!  This is too much.  What are those Apple guys going to think of next?

I sort of agree with Jeremy Cole. This new marketing push using Planet MySQL seems like a cheap advertising stunt.

First, what’s with the highlighted post? Why is it highlighted? Seems like and advertisment.

Which brings up a number of significant questions:

1. Where’s my cut? I write content that’s pushed to Planet MySQL which wouldn’t be attractive for running ads if it wasn’t a collection Plof intelligent authors writing about MySQL.

2. Can competitors run ads on Planet MySQL? Can Oracle run an ad on INNODB? Can Solid run an ad?

Planet MySQL is a community oriented site. Seems like we should keep it that way.

…

Last week I spent some time with Don Marti talking about open source on his podcast for LinuxWorld. Topics include economy of open source, Bitkeeper, and some on the more interesting storage engines that have been released for MySQL.

Catching up over the weekend I noticed Tim's
comment on parallel processing, and followed that over to Nat's
comments about threads.

What does this mean to MySQL? Over a year ago we launched a multi-
concurrency tool, mysqlslap, so that we could start to take apart
the server under high loads. At the time we had five different tools
internally, all written in different languages, all not supplied with
the main binary, and all were hard to use. From this we have been
able to find bugs like the Innodb autoincrement lock (which Heikki is
actively working on), and the lock around temp tables (which Monty is
working on). Its also been …