I’ve just put together my abstracts for O’Reilly’s MySQL Conference in April 2008. Some of them might sound familiar…

Learn to watch your database like a fitness diet. Trim down the SQL queries, use the right hardware, and monitor the right metrics to keep it running fast.

There are healthy databases and their are unhealthy ones. We?ll take a look at what you feed your database, and how to keep it fit with just the right diet of hardware, configuration, and SQL query tuning.

1. Introduction - Diet of a Champion Database
2. Disk, Memory, CPU - Body by Intel
3. Applications - Lean & Fit
4. SQL Queries - High Fiber, Low Fat
5. Conclusions

Last week I wrote about my efforts to measure MySQL's replication speed precisely. The most important ingredient in that recipe was the user-defined function to get the system time with microsecond precision. This post is about that function, which turned out to be surprisingly easy to write.

Devis just lost its bid on a big US government software contract through the GSA (General Services Administration). That's just competition. But how it lost that contract is exceptionally frustrating if you're a US taxpayer:

GSA told Devis at its debriefing that contractor risk was not a determining factor in the award decision, despite the fact that a majority of the evaluation panel found the [winning] Symplicity proposal to be "unacceptable" and offering "little confidence" of successful performance.

I'm all for a software proposal that stinks at the outset. How about you? :-)

Taking this one step further, I'm positive that the US federal government is also not taking into account just how risky every purchase of proprietary software is. Every dime of my tax dollars that is spent locking up government files (Microsoft Office) …

The Linux Business Campus Nuremberg (LBCN) presents annual awards for innovative ideas, well-considered concepts and promising business plans in the field of Open Source and Free Software.

The European Open Source Business Award is presented for innovative business concepts after detailed examination by an expert jury comprising LBCN campus coaches and selected figures from the venture capital scene. The annual award seeks entrepreneurs with innovative open source software business ideas which can revolutionize the markets and set new

This award was presented for the first time in January 2007 as a highlight at the Heise congress on ?Open Source Meets Business? (http://www.heise.de/open/news/meldung/84306).

The next award presentation will take place in the old city hall in Nuremberg on Wednesday, 23 January 2008.

…

A

A

A

MySQL AB is building on its European organisation with a new sales office in Milan, Italy to focus on supporting corporate customers.

On November 8 in Milan, the database vendor's first public event in Italy will take place. The Italian MySQL team invites users and customers to learn about the company, its products and services.

More information about the 'MySQL in Italia' event is available here (in Italian).

Last week I wrote about my efforts to measure MySQL’s replication speed precisely. The most important ingredient in that recipe was the user-defined function to get the system time with microsecond precision. This post is about that function, which turned out to be surprisingly easy to write. The manual section on user-defined functions provides very good instructions on how they work and how to build them. But just for the record, on Ubuntu 7.

In the spirit of the MySQL Pluggable Storage Engines the proxy has a plugin infrastructure now.

The main goal was to cleanup the code so what the admin part and the proxy itself can be loaded at runtime.

The new code-layout looks like

• mysql-proxy.c (codename: the cauldron)
  • takes care of the command line options
  • signal handling
  • win32 service handling (not done yet)
• libmysql-proxy.so
  • provides the mainloop and everything for the socket and protocol handling
• libadmin.so
  • the old admin interface
• libproxy.so
  • the well known proxy itself

Now you can plugin your own modules if you like and only load those modules that you really want.

The next step is making the …