The 132nd edition of Log Buffer, the weekly review of database blogs, has been published by Lisa Dobson on the Oracle Newbies Blog.

Log Buffer is a the-more-the-merrier kind of thing, so please leave a comment on Lisa’s LB with your favourite database blogs from this week. Or, get in touch with me and get started on publishing an edition on your own blog. Fun. Readers. Glory. These can be yours with when you do Log Buffer.

And now, on with Lisa’s Log Buffer #132.

Yesterday I announced the MySQL Unconference. Some folks have asked about the MySQL Camp that both Giuseppe and I previously announced.

They are one and the same. In order to minimize confusion, I’ll change things to say “MySQL Camp” instead of “Unconference”. Apologies to those who were confused!

The e1000 Nic is very common and can be found in many servers.  During my last NBD cluster engagement, on a set of 5 Dell 1950 servers equipped with a quad e1000 Nic, we were trying to tune cluster performance and one of the thing that was disapointing was that the system time, to processed interrupts from the Nics, was always low.  Since neither the ndbd processes or the mysqld processes were using a significant amount of CPU, we were wondering where the bottleneck was.

Then, Michel Donais, from the client, read the Linux driver documentation and bingo!!! Those e1000 Nics throttle interrupts by default at 8000/s.  8000… it is a big limiting factor….   design to prevent DOS attacks.  We removed the throttling and… reach more than 30,000 interrupt/s and guess what, the number of transaction per second scaled with it along with the ndbd and mysqld cpu usage.  Interesting isn’t it? Then I remembered another …

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, …

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, …

I just realized something else Chris has mentioned:

Since MySQL Proxy 0.7.0 is soon to be released, I thought another brief tutorial would be helpful.

Indeed, we are looking to properly release 0.7.0 soon™.

In case you are wondering what’s happening with MySQL Proxy and what the deal with the code’s new home is, please consider making some time for the web-seminar next week.

It’s free but registration is required.

We will also have Carlo Cabanilla talking about …

Update

Ok, as Morgan quickly found out: I'm incredibly stupid. Read his comment and you'll know why. Ok, you'll not know why but you'll know that I am.

Really cool to see Chris taking up blogging as well

He has written nice little example about inserting comments into queries to distinguish the client’s IP when they are funneled through the proxy. Reading the comments about this little trick making the query cache not work, I couldn’t help thinking that those are wrong. I vaguely remembered that in some recent version this shortcoming was fixed, so I decided to run a little test on 5.1.30 to verify:

mysql> select concat(@@version_comment, ' ', @@version); …

I was trying to connect to a MySQL server at work and I got connection fail “Too many connections”. Here’s the screen shot that I took using Navicat Lite client and Sequel Pro. I did Googling a bit and I found that most common problem is because MySQL has too many open client being connected […]

It’s been a few months since we‘ve started actively using ActiveMQ queue server in our project. For some time we had pretty weird problems with it and even started thinking about switching to something else or even writing our own queue server which would comply with our requirements. The most annoying problem was the following: some time after activemq restart everything worked really well and then activemq started lagging, queue started growing and all producer processes were stalling on push() operations. We rewrote our producers from Ruby to JRuby, then to Java and still – after some time everything was in a bad shape until we restarted the queue server.

So, long story short, after a lots of docs and source code reading we’ve found really interesting thing. There is a “feature” added in the recent ActiveMQ release …

“I am happy all week long” is the ending of a Swedish drinking song, which requires the singers to count the weekdays on their fingers. I may have my moments of darkness, but generally speaking, the lyrics of this drinking song are applicable on me.

And I want this happiness to be contagious!

I’m sitting in an Air France flight that I, despite a snow storm and contrary to all expectations, boarded just in time. I’m on my way to the Rocky Mountains to snowboard with my good friend PG, and I’m browsing through a set of notes I made during my previous long-haul flight, where I listed what I thought I had achieved in 2008. Inspired by the white wine tasting offered by Air France, I let my thoughts on that list combine with the chain letter I recently fell victim of, where one is supposed to …