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 …

Woah. What idiots. Let's just say that Netgear management didn't read "Who did you make smile today?".

(If you need Netgear Customer Support, call 888?638?432 - press 41. Don't leave a comment here!)

I have a bunch of Netgear switches at home, I've been getting them mostly because of the neat slim form factor.

One of them have been working intermittently for the last 6 months; every week or two it just "hangs". Netgear claims to have "a solid warranty: switch - 5 years, power supply - 2 years", so hey - I should call them, right? Well, wrong!

First I wait on hold and when finally through they tell that they can't …

I just made a snapshot of the development branch of the innotop MySQL and InnoDB monitor, and released it as version 1.3.0. This code will eventually become version 1.4. Here's what's new.