There are times when we want to query a database structure for a particular table name. Or you want to find which tables a particular column name is defined. Or in my case, I wanted to find all tables that has column A and column B defined … how do I do it? If you […]

Kay and Jan announced and commented the changes. The repository is now on Bazaar, and there are rules for …

First off, let me wish you all a Happy 2009, and my apologies for being a bit slack with blogging in the last two months of 2008. It’s been a bunch of busy weeks, but I’m fully expecting to remedy that in this year.

Second, let me welcome you to this series on refactoring MySQL applications. I will cover best practices and useful tips, as well as show working examples of potential loopholes and solutions.

So, you are a DBA or a developer, and you’re faced with a problem. Your years-old application (perhaps you inherited it from a former co-worker) is now starting to keel over, and your choice of responses is limited.

Let’s start by saying that there are other ways to reach performance, but in some cases refactoring may be the only way that is possible to pursue, for one reason or another. Let’s take the refactoring way, focusing on SQL rather than applications, as there’s a lot that can be done on this side. …

There is a really easy way to figure out ...

Look at the size of of the devrooms , if at all , a project gets at Fosdem
It's really interresting to see the Embedded room move to a 500 seat room which it really needed when the first openMoko talk was held there in a previous edition.

The FDO , Drupal, Mozilla, Centos/Fedora and Suse rooms stay in similar size rooms as last year.. But it seems lik the BSD and PostgreSQL room which was pretty crowded moved to a bigger location.

The Ruby room also seems to move to a bigger room. Fosdem has a couple of new rooms too it seems this freed up room for new groups such as the MySQL Crowd

Obviously these sizes aren't a real match to the size of a community, as the new rooms might need (and probably will need) a reshuffle for next year ;)

…

Use the code below:

This short tutorial shows you how to install libxml2 on Ubuntu Linux Server. The process is very simple. For this tutorial, I'll be installing libxml2 version 2.6.29. Note: Do not use versions older than 2.5.10. Linux kernel is 2.6.15-26-powerpc. I have used a Mac Mini (powerpc/ppc architecture). GCC version number is 4.0.3. Your configuration may be different from mine but the installation steps below should work fine for most configurations with little or no change at all (including other Linux distributions and even unixes e.g. MacOS X).

This short tutorial shows you how to install libmcrypt on Ubuntu Linux Server. The process is very simple. For this tutorial, I'll be installing libmcrypt version 2.5.8. Linux kernel is 2.6.15-26-powerpc. I have used a Mac Mini (powerpc/ppc architecture). GCC version number is 4.0.3. Your configuration may be different from mine but the installation steps below should work fine for most configurations with little or no change at all (including other Linux distributions and even unixes e.g. MacOS X).

This short tutorial shows you how to install Apache Portable Runtime (apr) Library on Ubuntu Linux Server. The process is very simple. For this tutorial, I'll be installing apr version 0.9.14. Linux kernel is 2.6.15-26-powerpc. I have used a Mac Mini (powerpc/ppc architecture). GCC version number is 4.0.3. Your configuration may be different from mine but the installation steps below should work fine for most configurations with little or no change at all (including other Linux distributions and even unixes e.g. MacOS X).

This short tutorial shows you how to install zlib on Ubuntu Linux Server. The process is very simple. For this tutorial, I'll be installing zlib version 1.2.3. Linux kernel is 2.6.15-26-powerpc. I have used a Mac Mini (powerpc/ppc architecture). GCC version number is 4.0.3. Your configuration may be different from mine but the installation steps below should work fine for most configurations with little or no change at all (including other Linux distributions and even unixes e.g. MacOS X).

Turning the system beep off (for BASH)