I've been following the info from Kaj's info/feedback session at FOSDEM. I was going to write my thoughts as a comment, but I think it can benefit from being a post by itself.

What strikes me is that the items raised and "voted on by hand" are all existing and actually long-standing issues., most even pre-date MySQL's acquisition by Sun. Given this, why would raising the same issues once more have a different result this time? Doing the same thing again tends to yield similar results, but changing other parameters may change the outcome. Which parameters, specifically, are to be changed?

The good intentions of those involved are not in question. However, it just doesn't appear to deliver. Announcements are not cool. Ongoing statements "we want a shorter release cycle"... sorry guys, that's old news; I fully trust …

I covered this one before .. but as it struck twiced today .. I think it's worth repeating. Both my collegue Karl and Trent ran into the same problem , within hours hours of eachother, a missing or failing reverse dns mapping that caused performance issues .. and a lot of log entries..

Karl denies having a second life in Perth but I`m not really sure about that ...

But I guess they both have to agree... Everything is a fscking DNS problem.
(I noticed other people using that spelling this weekend, on stage in the Janson)

Technorati Tags: dns dns problem …

Building on top of my last post, the PHP extension for the new client and protocol library is ready as well! You can download the tarball on the Launchpad download page. The PHP extension exposes the same set of client functions that the C library provides currently, and is mostly just a wrapper to provide the PHP specific handling. To install, you’ll need the PHP development packages installed (if you have ‘phpize’ command you’re all set). After extracting the tarball, just run:

phpize
./configure
make
make install

And then add the following line to your php.ini:

extension=”drizzle.so”

I realize there is no documentation at this point, we’re working on that (please get in …

This is #4 in a series of blog postings about MySQL Performance Schema.

What does the new PERFORMANCE SCHEMA cost?

In my last three postings, I’ve shown shown lots of monitoring / diagnostic new features, and made it obvious there’s a lot more. At this point any wise viewer will wonder whether such a marvel can really be free. Well, it is, in the two senses of the word: “free like GPL” and “free like borshch”.

The “free like GPL” sense is easy to explain. Anybody can download the source as soon as we put it in the public trees, i.e. “soon”. Naturally Enterprise people can expect far more besides the server code (more about that later), but everybody gets the server code.

The “free like borshch” phrase evokes an East European beet soup (see http://en.wikipedia.org/wiki/Borscht) which is cheap enough that a cook can just throw it in with the rest of the dinner for no visible extra charge. …

I’m happy to announce the first release of the new libdrizzle. This is a complete rewrite of the protocol and client interface for the Drizzle project and provides new functionality that the old library based on MySQL code did not offer. Oh, and this new library supports both Drizzle and MySQL protocols, so you can use it with MySQL servers as well!

So, what’s different?

• BSD License.
• Complete non-blocking I/O support.
• Concurrent query interface, letting you run multiple queries at the same time on any number of servers.
• Improved buffering support. Instead of just result and row buffering, you can also buffer per field, or not at all (reading fields in chunks). This can be very useful for streaming large blobs through your client.
• Complete server …

Last week, I was at the NetApp office in North Sydney for the presentation on NetApp SnapManager for Oracle. It was good opportunity to learn more about NetApp snapshots while working on a project for one of our clients in Sydney. It was an especially interesting topic as I have some experience using Veritas Checkpoints (see my presentation on test systems refreshes), and it was interesting to see what’s different and new in the NetApp implementation. But I digress.

I learned that NetApp can provide access to the same LUNs via either Fiber-Channel (FC) or iSCSI. And this is when the interesting argument surfaced. Apparently, some companies aim to have the technology stack on their …

About a week ago, Nat posted Open Source NG Databases on O'Reilly Radar. That caught my interest because I'm playing with some "alternative" databases for some of our data at Craigslist. Don't get me wrong, MySQL is great. But MySQL isn't well suited to every use case out there either. (I'll talk more about this at the MySQL Conference.)

Meanwhile, I left a comment on that posting about CouchDB and have been playing with it a bit more since then--mostly loading in test data, figuring out the data footprint, performance, etc.

Overall, I'm impressed and encouraged. I agree with what …

Introduction
When people think about Percona’s microslow patch immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query may take less than a second to execute, but a huge number of such queries may significantly load a server. On one hand logging causes sequential writes which can’t impair performance much, on other hand when every query is logged there is a plenty of write operations and obviously performance suffers. Let’s investigate how much.

I took DBT2, an OSDL’s implementation of TPC-C.
Hardware used
The benchmark was run on a DELL server running CentOS release 4.7 (Final)
There are four CPUs Intel(R) Xeon(R) CPU 5150 @ …

Sometime you may need to recover a table when all you have is the .ibd file. In this case, if you try to load it into a new instance, your likely to encounter some errors about the table id not matching. And there is not really a way around this.

However, I’ve found two work-arounds for this:

Note: You will need the .ibd file and the CREATE TABLE statement for each table you want to recover using these methods.

1. Simulate the internal InnoDB table counter. That is, create work tables (with innodb_file_per_table enabled) until you have the internal pointer of table id equal to (1 - id_of_ibd_table_you_need_to_restore). (See Method #1)
2. Manually hex edit the .ibd file, changing the table id. (See Method #2)

*Note: There are some internal structures with this meta information, so you’ll need to dump/import that data after you get it loaded, so you avoid unpleasantries that will inevitably …

Reaction to Marten Mickos’s departure from Sun. On open letter to President Obama. Lots of announcements from Sun, the LIMO Foundation and WS02. Mozilla offers to help EC investigation of Microsoft. Black Duck raises funding and gets a new CEO. The state of Red Hat. And more.

Mickos fallout
Kaj Arno maintained that “MySQL’s culture and business philosophy will live on in Sun.” He added: “In fact, you could say MySQL now becomes mainstream at Sun. Former MySQLers continue in key positions, in some cases with a mandate to generalise and apply MySQL related learnings on other open source products.”

For example, Charles Babcock …