Archive for March, 2008

Innodb handler_delete and handler_update status

I woke up this morning to a nice surprise. Peter Zaitsev from MySQL Performance Blog mentioned my fix for a crash in MySQL. Thanks Peter! That reminded me that I need to write this post about another fix. A storage engine is called a “handler” in MySQL internals. Handler events are per row at the [...]

March 26, 2008 • Posted in: Geek, MySQL • No Comments

ref or null join type crash and patch

While working with a client we found a query that can crash MySQL. It has to do with ref_or_null outer joins where the table contains a null value. MySQL fails to tell the storage engine to initialize the index before reading from it. It crashes when used with MyISAM tables but it could result in [...]

March 23, 2008 • Posted in: Geek, MySQL • 2 Comments

MySQL Enterprise Registration Emails

[Updated: 2008-03-05 Jeremy writes to tell that I left out the provenscaling.com contact form submission on the 21st and the blank email with a pdf on the 27th] [Updated: 2008-03-26 Rob Young from MySQL AB sent me an email on the 17th saying, "We are currently working to implement PayPal to cut down on the [...]

March 5, 2008 • Posted in: Geek, MySQL • One Comment