With release 2.7.0 the popular database web front-end phpMyAdmin starts to adopt more and more of the new features of MySQL 5.0. But there are still some hurdles on the way. If you use VIEWs on huge tables, phpMyAdmin can for example easily lock up your database.

The problem is, that phpMyAdmin tries to get an exact row count for MySQL VIEWs in many places. It achieves this by executing a SELECT COUNT(*) FROM view_name against the VIEW. This happens for example on the database overview page (that shows up by default whenever you select a database from the menu) or even for the list of tables in the left frame. Other database administration tools that use a similar strategy as phpMyAdmin could also be affected.

The disastrous consequences of the row count

This is of course a very dangerous feature for complex …

What do y'all think of the idea of a 3d printer? Aaron uses one at work. They call them "C&C machines." I don't recall what C&C stands for, but it basically takes a 3d model from a computer and cuts it into a piece of metal. I've been thinking about building such a beast.

Since there are a lot of data related to such a task, I figured I could get mysql and maxdb involved. Feedback?

What do y'all think of the idea of a 3d printer? Aaron uses one at work. They call them "C&C machines." I don't recall what C&C stands for, but it basically takes a 3d model from a computer and cuts it into a piece of metal. I've been thinking about building such a beast.

Since there are a lot of data related to such a task, I figured I could get mysql and maxdb involved. Feedback?

One benchmark I have always wanted to see performed is a comparison of SATA vs SCSI as it related to MySQL server performance. While I am pretty sure SCSI would come out on top in most comparisons, I always thought it would be interesting to see how wide the performance gap is compared to the difference in costs.

Seeing as I lack the resources to do such a comparison, I have been content to sit and wait for such a comparison to be made, and gently nudged some of the people who may have the resources to do such a comparison.

In the meantime, here’s a couple of pages from a StorageReview article on Western Digital’s new 150Gb Raptor:

Multi-User Performance - Compares the IO results for the Raptor vs 10K and 15K SCSI drives in a multi-user environment.

…

I'm quite certain I don't have a shot at this, but here goes.  Find all the details here.

[Update #2/3: My mistake. It was 3.23 that it was only in mysql-max, so the article is correct. Second comment (under update) still stands :-) Cheers to those that provided the feedback (Markus, LenZ, Thomas) Next time I'll know how to get peer review quickly :-)]

I've been on holidays for a while now (and will be until 16th Jan. w00t!). One of my new found past-times has been contributing to Wikipedia. I spotted this on the InnoDB article:

"InnoDB is a storage engine for MySQL, included as standard in all current MySQL AB distributions. "

Technically I think InnoDB was only in the mysql-max distributions until 5.0.
Is it fair to say that 4.1 is not current *although* it is still listed as a generally available (GA) release?

I guess you could argue either way, but it could be made clearer. Second opinion wanted.

…

Happy New Year everybody!

Like most MySQL employees, I work from home when I'm not travelling. And you may have seen the photo with the hammock, but I do actually have a desk.

It used to be in a separate room, but we made it into a room for our daughter Phoebe. So I moved to another room, which was subsequently hijacked for my wife's home teaching business. All good causes, mind you, but my desk ended up next to the kitchen and the lounge room. Easy access to the fridge, but by no means optimal - particularly now with Phoebe - a fab distraction any time.

    

So over these past holidays, I shifted downstairs. It looks a bit bare still and we'll be doing some more work on the place, but it's pretty good already. …

Happy New Year everybody!

Like most MySQL employees, I work from home when I'm not travelling. And you may have seen the photo with the hammock, but I do actually have a desk.

It used to be in a separate room, but we made it into a room for our daughter Phoebe. So I moved to another room, which was subsequently hijacked for my wife's home teaching business. All good causes, mind you, but my desk ended up next to the kitchen and the lounge room. Easy access to the fridge, but by no means optimal - particularly now with Phoebe - a fab distraction any time.

    

So over these past holidays, I shifted downstairs. It looks a bit bare still and we'll be doing some more work on the place, but it's pretty good already. …

Daniel D. sent me some good info on analyzing MaxDB kernel trace output.

I still need to read it a few times and try it out myself, but here is the link so you can follow along :)

http://wiki.colliertech.org/index.php/MaxDB:kernel_trace

Daniel D. sent me some good info on analyzing MaxDB kernel trace output.

I still need to read it a few times and try it out myself, but here is the link so you can follow along :)

http://wiki.colliertech.org/index.php/MaxDB:kernel_trace