This is the fourth in a series of articles on profiling MySQL. My past three articles have explained how to measure the work a query causes MySQL to do. In this article I introduce a tool I've written to do the work for you and produce a compact, readable report of that work, with all the math already done, and the measurements labelled and grouped for ease of comprehension. With this tool you can understand query performance at a glance.

Novell Delivers Integrated Stack for SUSE Linux Enterprise Built with Mixed Source Software and Systems from IBM, Novell (Press Release)

European Consortium to Prove Quality of Open Source Software, SQO OSS (Press Release)

Pentaho Marks Second Anniversary with 1.5 Million Downloads, Pentaho (Press Release)

Centeris Sponsors New Interoperability Event, TechX World, Centeris (Press Release)

Open Country Enhances Systems …

Zmanda Recovery Manager (ZRM) for MySQL is a robust and intelligent solution for live backup and recovery of local and remote MySQL databases. In case you are not familiar with it, take a look at ZRM for MySQL project page.

Key features in 1.1 release
- Backup images can be compressed and encrypted using platform tools
- Custom plugin interfaces for
- Backup encryption
- Pre backup actions
- Post backup actions
- Flexible scheduling
- Binary log parser
- Secure file transfer
- Automatic HTML and Text backup report generation
- Backup reports are available as RSS feed

This is an open source community project. Feel free to check out the project wiki, go to …

This post originally appeared on O’Reilly’s blog. This post originally appeared on O’Reilly’s blog. MySQL provides some tools to monitor and troubleshoot a MySQL server, but they don’t always suit a MySQL developer or administrator’s common needs, or may not work in some scenarios, such as remote or over-the-web monitoring. Fortunately, the MySQL community has created a variety of free tools to fill the gaps. On the other hand, many of these are hard to find via web searches.

Noel Yuhanna, database guru over at Forrester Research, has published a new report "Six Database Initiatives That Can Save Money."  Several of the initiatives are directly related to using open source technology and also fit with our recent MySQL Enterprise announcement, especially the new MySQL Network Monitoring & Advisory Service. 

While it's obvious that eliminating hefty license fees for closed source databases is going to save money, Noel's other ideas can boost the savings even further.  For example, we've seen many customers engage in consolidation or standardization strategy whereby they replace old Informix, Sybase or other obsolete …

I realized earlier that having the MySQL Camp Free Ride offer open for only 24 hours is a bit harsh, and needlessly short. I’ve extended the deadline to midnight, Friday, October 20 to give everyone a chance.

I’ve also clarified that the offer is open to all, not only to students.

Good luck!

So a bunch of stuff has happenned (or happenning) that I’ve been wanting to blog about for a bit. Some stuff had to wait, others it’s just been me being slack.

Anyway, anyone who hangs closely around the MySQL circles probably now knows about MySQL Enterprise. There’s been a fair bit of talk about this internally for a little while now. When it was being talked about a bit wider within the company some of the initial communication was (in my mind) rather unclear. So I took the “what’s the worst way somebody could interpret this” viewpoint and replied with my thoughts. The idea behind this was to simulate what some of the loud-mouthed trolls of the non-shifted question mark e on a qwerty keyboard mapped to dvorak kind may do.
After a few phone calls (some at strange hours) my worst fears were not realised - we were still not being …

As email is *sooo* non-”Web 2.0″, i reply in blog form….
Rusty’s Bleeding Edge Page talks about a “Writing an x86 hypervisor: all the cool kids are doing it!” session that sounds really cool (better not be on at the same time as my talk… :)

I don’t (currently) intend to be one of the cool kids though.

He also mentions a session entitled “First-timer’s Introduction to LCA”. A couple of possible suggestions (or thoughts, and stuff I’ve seen):

• be careful if you intend to bitch endlessly about a piece of software - it’s quite likely you’re talking to the person who wrote it (or a chunk of it)
• sometimes it can be really good to just listen and ask a few good questions to understand. there are a lot of really smart people about
• you will (at some point) ask a really dumb …

I don’t normally blog about events that I’m not going to be attending, but this seemed like too cool an offer to pass up. Proven Scaling will be offering one free ticket to MySQL Camp - thats free airfare and hotel, for the rather cool MySQL Camp un-conference.

From what I can tell, there’ll be a lot of rather cool people attending, its from the 10-12 November, at the Google campus (yes, you get to tour that place, and eat free food). And maybe if you’re super nice to Jeremy, he might be flexible with the flights, and you might also want to go to the Mountain View Ubuntu Summit. Having been to one of these before (Ubuntu Down …

Josh Greenbaum at ZDNet suggests that the war of the ecosystems is on, and that Oracle is looking weak. I don't agree, but think Josh's commentary is interesting:

The partner front is the new flash point in the battle of the ecosystem. When it comes to IBM vs. Microsoft vs. SAP vs. Oracle, it turns out that a large coterie of happy, incented, and otherwise engaged partners that are out legitmizing an ecosystem vendor's ecosystem -? and selling the products and services they develop that fill in that ecosystem's white spaces - has become a major competitive weapon. And SAP is absolutely committed to making the most of this weapon in their four-way fight against their partner/competitors IBM, Oracle, and Microsoft.True enough, though I think each of the big ecosystem vendors is missing out on the most important partner for the future: open source.

Oracle is in a …