The latest from the MySQL community

By Tim O'Reilly

Yesterday, I talked about the overall state of the computer book market. In this installment: category visualizations and trends showing which technologies are winning and which are losing in the book market. Here's a treemap view of the quarter on quarter differences between Q4 of 2006 and the same period last year:

As I've previously described in Book Sales as a Technology Trend Indicator, in a Treemap visualization, the size of a square indicates the relative size of the category, and its color indicates the rate of change. A category that is bright green is up significantly. One that is bright red is heading strongly in the …

I am happy to announce version 0.4 of mylvmbackup, a tool to perform consistent backups of a MySQL server's tables using Linux LVM snapshots.

For this release I'd like to especially thank Robin H. Johnson from the Gentoo project, who contributed another batch of useful changes and informed me that mylvmbackup is now in productive use to perform backups of the MySQL databases that power the project's Bugzilla bug tracking system. I am always glad to read about such use cases - how do you utilize mylvmbackup in your environment?

• The option handling has been improved. mylvmbackup now starts by using the builtin defaults, followed by the default configuration file (/etc/mylvmbackup.conf, followed by an alternative configuration file (specified via CLI …

At the MySQL Mini Conference in Sydney this week we discussed how to use EXPLAIN EXTENDED to view the rewrites undertaken by the MySQL optimizer.  IN particular, to see if MySQL performs a merge of the query into the view definition, or if it creates a temporary table.

It can be tricky to optimize queries using views, since it's often hard to know exactly how the query will be resovled - will MySQL push merge the text of the query and the view, or will it use a temporary table containing the views result set and then apply the query clauses to that?

In general, MySQL merges query text except when the view definition includes a GROUP BY or UNION.  But to be sure we can use EXPLAIN EXTENDED.  This also helps when we get confusing output in the EXPLAIN output.

For instance if we have a view definition like this:

CREATE VIEW user_table_v AS
     …

In case anyone has seen spurious problems using MySQL version 5.0.32 (and presumably the identical 5.0.33 community version) you might want to take a look at MySQL Bugs #25653 and #25596. They are about a little (but serious) InnoDB bug.

If you do not yet use this version, you might consider waiting for a fixed release to become available.

In case anyone has seen spurious problems using MySQL version 5.0.32 (and presumably the identical 5.0.33 community version) you might want to take a look at MySQL Bugs #25653 and #25596. They are about a little (but serious) InnoDB bug.

If you do not yet use this version, you might consider waiting for a fixed release to become available.

I find the new iPhone to be conceptually very interesting. Now, I am very new to the world of PDAs— I have only just started using one, a cast-off Palm Pilot from someone, and already I am thinking of things that it should be able to do but doesn't, or I haven't learned how yet. I suspect that very shortly I will be wondering how I got along without a PDA all these years.

Now, this new iPhone from Apple (I hope that they win the name from Cisco, as I have never ever heard of a Cisco iPhone but the name seems to naturally fit alongside iPod and other Apple products) will apparently be running a version of OSX. I find this very intriguing, because it opens up all sorts of interesting possibilities, including perhaps being able to run MySQL on it, or at least a client, perhaps a small database replicated from a fixed or not-as-mobile source.

At first glance and after hearing various reports, it sounds like a very capable …

At LCA I'm currently in Tridge's session on CTDB - Clustered TDB. This is a clustered version of his little database library, for clustered Samba.
Due to the different semantics it has a different API from TDB.
There's some very interesting stuff in there - obviously, it's not a general purpose database. It's asynchronous, event driven. No locking across the network. It aims for speed rather than reliability. In the case of Samba, it can afford for that specific data to be lost in extreme situations. It's not file data!

Brian, did you see this stuff already?

Aras is the latest company to announce that they are going open source in an attempt to lower their costs and increase their appeal to corporate customers.  The interesting twist is that Aras is not some obscure project dreamed up by a bunch of Linux heads; it's corporate software for product life cycle management, project collaboration, workflows, change management and the like.  Aras' customers include folks like Rolls Royce, Tellabs, Ingersoll-Rand and L3 Communications.  In other words, serious corporate users.  Interestingly enough Aras' suite was all built using the Microsoft's SOA platform, which, as readers may know, is not open source.  Or perhaps I should say is not yet open source.

I believe that open source and hosted applications (software as a service) will become much more common in the next five and the dominant form for corporate software …

I downloaded and setup the VPC image for the new January CTP "Orcas" of Visual Studio.  I plan to use these bits to better integrate our provider into the new Entity Framework.  But before that can happen, what is any self-respecting developer going to do with a fresh install of the next version of Visual Studio?  Why try to build MySQL with it!

We use CMake as our project file generation tool and so the first step was to install it and a couple other items into the VPC.  That done, I tried to generate the project files.  CMake errored out saying that it could not find Visual Studio 8.  A quick edit of the VS8 template file for CMake and that was fixed. 

Ten minutes after booting the VPC for the first time, I'm …