Solid has released solidDB for MySQL 5.0.51-0081. There are a significant number of bug fixes in this release. For the full detailed list of bug fixes and enhancements, please see the ChangeLog. The download is at http://dev.soliddb.com/download

Jeff Gould has written an excellent piece on the big question arising from Sun's acquisition of MySQL: how will Sun make enough money on the deal to justify the $1 billion valuation? Gould's analysis is generally solid, but he misses a few key points.

First off:

Only time will tell. But in my humble opinion, MySQL's open source business model will make Sun's road to payback a lot steeper than if it had bought a software company with conventional revenues and profits.

Ah, the good old days! Just one problem: those days are gone. Pining for an acquisition of the old way of selling and distributing software is like pining for Mayberry: you can want it, but those days are never coming back. VCs aren't investing in proprietary Mayberry anymore. Except …

EXT3 has performance problems as the filesystem gets fragmented-although this is counter intuitive to the design of EXT3-fragmentation really happens.

Really there is no safe de-fragmenter tool out there for ext3. There is this one but I will not use it.

Fragmentation can get so bad that performance from EXT-3 can drop 7 fold!!

Here is some good info on fragmentation and a comparison of various other file systems.

Now for filefrag, I use this to see how bad an innodb file is fragmented.


TABLE.ibd: 4020 extents found, perfection would be 298 extents


Our wiz of a system administrator Kevin M., who I am teaching to become a mySQL DBA got me hooked on this utility: and he came up with a good …

This release contains bug fixes and new features. It also contains a new tool: my implementation of Paul Tuckfield's relay log pipelining idea. I have had quite a few responses to that blog post, and requests for the code. So I'm releasing it as part of Maatkit.

How To Install MySQL 4.1 And PHP4 On Debian Etch

MySQL 4 and PHP 4 are quite old, but you might have PHP applications on your server that require PHP4 and MySQL 4. The problem is that Debian Etch comes with MySQL 5 only, and its PHP4 packages depend on MySQL 5 and don't work with MySQL 4. This guide shows how you can install MySQL 4.1 on Debian Etch along with PHP4 packages that work with MySQL 4.1.

How To Install MySQL 4.1 And PHP4 On Debian Etch

MySQL 4 and PHP 4 are quite old, but you might have PHP applications on your server that require PHP4 and MySQL 4. The problem is that Debian Etch comes with MySQL 5 only, and its PHP4 packages depend on MySQL 5 and don't work with MySQL 4. This guide shows how you can install MySQL 4.1 on Debian Etch along with PHP4 packages that work with MySQL 4.1.

"sakila" is the sample database shipped with MySQL (pronounced as my ess-kew-ell). In the context of Sun Microsystems announcing the agreement to acquire MySQL, I'd like to dedicate this entry to show how this sample database can be exposed as a RESTful Web service endpoint and deployed on GlassFish using Jersey Tooling Plugin (0.4.1 with Jersey 0.4) in NetBeans IDE.

Lets get started!

1. Install MySQL & …

REvoltion Computing obtains funding. Fonality strikes deal with Dell for SMB telephony. SpringSource partners with Capgemini. (and more)

Intel Capital Makes Series A Investment in REvolution Computing, Intel Capital / REvolution Computing (Press Release)

SpringSource Announces Partnership with Capgemini, SpringSource / Capgemini (Press Release)

MuleSource Announces MuleCon 2008, MuleSource (Press Release)

GroundWork Open Source Appoints Tara Spalding as Vice President of Marketing, GroundWork Open Source (Press Release)

…

mysqlreport v3.4a is ready which, like the recently released v3.4, fixes a bug in the relative reports. This time, it was the InnoDB reports which were not correct when made relative. Changes in v3.4a are:

• Fixed bug: InnoDB report values were wrong in relative reports because 13 InnoDB status values needed to be excluded from being made relative. (thanks Debbie)
• Changed InnoDB Buffer Pool Read ratio to Read hit %

The Guide to Understanding mysqlreport has been accordingly updated, too.

I have been noticeably absent on my comments in this topic, something I was pinged about yet again today by another colleague.
Did I have nothing to say? No. It’s just I’ve not been able to say much, or actually do anything in the past 7 days due to strong bought of the flu which has kept me in bed near 5 days straight (coincidently aligning perfectly with MySQL’s recent ACM. Go figure that luck).

So what are my thought’s here. (Ok, I’m going to waffle a bit with my point of view, but my key technical points for those of you that just want that, scroll down to the next section heading)

Overall I believe it’s a good thing, on the surface and at the moment. As mentioned MySQL was on an IPO path, I’d would have liked the option to buy my own MySQL shares, be part of a company that got to that point (have worked for 2 failed startup Internet companies previously). I think there would have been many a proud MySQL …