I have been writing a bit about Gearman lately, including installing it for PHP and Ubuntu, actually using it from PHP and also how I use persistent storage with Gearman. I'm moving on to look at adding jobs of different priorities.

I use Gearman entirely as a point to introduce asynchronous-ness in my application. There is a complicated and image-heavy PDF to generate and this happens on an automated schedule. To do this, I use the GearmanClient::doBackground method. This inserts a priority 1 job into my queue. …

fisl12 is likely the largest free and open source software event in Latin America. This year, it takes place in Porto Alegre, Brazil, from June 29th to July 2nd. Oracle is a gold sponsor of the event and I will attend it as a speaker. I feel honoured and excited to be there – for me it will be the first visit to the South American continent.

They already have over 3000 registered attendees, so this definitely is going to be a great conference. There is quite a number of well-known names on the speaker roster and I look forward to meeting a lot of familar faces there.

The agenda is still under development but quite impressive already – …

It's been a while since my last post on this blog; I definitely need to get back into the habit! One of the reasons for my radio silence was that I switched roles here at Oracle. After having been with the MySQL team for 9 years, I felt it was time for a change. Fortunately I did not have to look far – I'm now a member of the Oracle Linux product management team and I am having a lot of fun there.

However, I realized that while I was an active Linux user on the desktop, quite a lot has happened on the enterprise and data center side of things. Linux has really come a long way and I am glad to be back in this field, drinking from the firehose and learning a lot about recent developments and technologies. For me, this is kind of going "back to my roots", as I have been deeply involved with Linux at SuSE before I joined MySQL in 2002.

Anyway, I'm still alive and you can expect …

Apache OpenOffice.org proposal approved. SkySQL Tekes new funding. And more.

# The proposal for OpenOffice.org to become an Apache incubator project was unanimously approved.

# Rob Weir discussed how the relationship between OpenOffice.org and LibreOffice need not be a zero-sum game.

# Simon Phipps offered his thoughts on the potential positive and negative outcomes.

# Tekes, the main public funding agency for research, development, and innovation in Finland, …

The SELF Linux show ramps up to full swing tomorrow. We will have the new MySQL 5.5 shirts as well as Linux shirts. Please stop by say hi and get a shirt while they last!
I was glad to see the support for MySQL on day one, can't wait until tomorrow.
http://www.southeastlinuxfest.org/

Mythbusters: How to configure InnoDB buffer poll on large MySQL servers

Yesterday I wrote about the dangers in using top on systems with 100+ GB of RAM, not to mention future systems with 1+ TB. A related topic is, how should I configure MySQL on such a large system?

There is a classic rule of thumb that on a dedicated MySQL server one should allocate 80% of memory to the InnoDB buffer pool. On a 128GB system that is 102.4 GB. This means that I would leave 25.6 GB of RAM "unused". So surely on these large systems, this old piece of advice cannot hold anymore. If the database was previously running on a server that in total had less than that altogether, it seems wrong to leave so much memory just unused. Let's label the old rule of thumb tentatively a "myth" and ask mythbusters to figure out a new MySQL configuration …

We all know that a megabyte in binary system is not the same as one million bytes (in decimal system). But have you actually cared much about it? I have to admit I haven't. I know there is a small rounding error, but by and large I always treated 2^10 = 1 kB = 1024 bytes and 10^3 = 1 kB = 1000 as the same thing. (Update: Opening sentence was edited to remove units MB and MiB since it seems even I managed to use them backwards! The math in this article is correct. The rest of the article uses MB, GB and TB mostly to refer to binary magnitudes, which is apparently incorrect. See comments for wikipedia links and discussion.)

More importantly, when you move into larger numbers, rounding errors usually become even less important. Unfortunately, in this case they become bigger:

read more

While Oracle deserves some praise for its donation of OpenOffice.org code to the Apache Foundation, it is disappointing again to see a legitimate open source market contender that has been marginalized by miscommunication and mismanagement of the project by a large vendor.

OpenOffice.org, warts and all, was probably the most significant competition for Microsoft Office for years and in many ways demonstrated the advantages of open source, helping usher in wider use of it, as well as greater usability. OO.o was in fact my reason for originally investigating and moving to open source software more than a decade ago. Regardless of past mismanagement of community and technology, that competitive factor has been diminished greatly since Oracle took ownership of OO.o. Now, after prompting a fork — as has …

Linus announces Linux 3.0. Attachmate maintains commitment to SUSE Linux. And more.

# Linus Torvalds announced the release candidate of Linux 3.0.

# Attachmate CEO Jeff Hawn maintained that the company is committed to SUSE Linux.

# OpenX raised $20m series D funding.

# Cloudera proposed Flume as an Apache incubator project.

# Isidorey unveiled CloudSandra: a NoSQL database-as-a-service based on Apache Cassandra.

# Wayne Beaton …

The MySQL Developer Tools team is pleased to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.34. This is a maintenance release containing 100 bug fixes; ranging from stability improvements on all supported platforms – including some that prevented startup in certain environments – to minor but significant usability corrections.

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve the functionality and stability of MySQL Workbench – we appreciate all your ideas for improving MySQL Workbench.  Please keep sending us your ideas!

MySQL Workbench 5.2 GA

• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, …