• Two days in Frankfurt, two days in Munderkingen and two days in Heidelberg between December 5th and 17th. Mostly just ordinary working and travel days.
• Visited Sandro Groganz of Init Marketing in Munderkingen. Worked from Sandro's house after a nice dinner on Sunday.
• Caught up with (and was interviewed by) Rory MacDonald of Init Marketing while he was vacationing near Ulm. The interview was focused on Mozilla and should go online in the new year on http://www.initmarketing.tv
• Visited Georg Richter of …

Somehow these interviews did not pop up on PlanetMySQL this past week so I link them here for your holiday reading. These are a couple interviews by Lenz Grimmer and one by yours truly.

Interview with Lars Heill, Release Engineering Manager
Born in Northern Norway 41 years ago and Lars has lived in Trondheim for the last 22 years. He is a Physicist by education, has a master degree on semiconductor heterojunctures and has earned a PhD on high temperature superconductors. He worked briefly on nuclear power fuel optimization and petroleum related rock mechanics before joining Clustra in the year 2000, which was acquired by Sun Microsystems in 2002. Clustra was a database software vendor that specialized in clustered, high-availability databases that were required by telecoms and service providers.

…

There's any number of ways to integrate your application with Memcached to take advantage of Memcached's power. Here's a list of some of them (and because I am most familiar with PHP in this case so that's what I've listed, and by no means is it exhaustive):

1. Using the PECL PHP Memcached libraries you can write direct queries to Memcached with failover to your SQL queries.
2. Using the memcached UDFs so that you can write SQL queries into MySQL/Using the memcached storage engine
3. Using MySQL Proxy to interface with Memcached
4. Using …

During the course of my daily work I occasionally search for mysql queries which are cool and helpful. I once found the following query on http://forge.mysql.com/:

SELECT table_name article_attachment,
engine,
ROUND(data_length/1024/1024,2) total_size_mb,
ROUND(index_length/1024/1024,2) total_index_size_mb,
table_rows
FROM information_schema.tables
WHERE table_schema = ‘dbname’
ORDER BY 3 desc;

A generally  lite version is:

select table_schema, table_name, (data_length)/pow(1024,2) AS ‘Data Size in Meg’, (index_length)/pow(1024,2) AS ‘Index Size in Meg’  from tables order by 3 desc;

You can add or remove columns etc and but this query shows the table size (data wise) index size, approx number of rows, size in MB etc. If you would like to know what else is available to add to this query, just do a “desc tables” while using the …

Installing Nginx With PHP5 And MySQL Support On Fedora 10

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a Fedora 10 server with PHP5 support (through FastCGI) and MySQL support.

Hi All,

I’ve been thinking about contributing to the MySQL community for a while and given we’re at the end of 2008, starting 2009, I thought …. maybe this is actually the right preposition for the coming year. There will be many changes in my life in the next week and a half, amongst which a change of countries and jobs, thus this will be the third biggest challenge for me in the ninth year of this third millennium.

Running out of disc space is not a good situation. However, if it does happen, it would be nice to have some control over what happens.

We use MyISAM. When you run out of disc space, MyISAM just sits there and waits. And waits, and waits, apparently forever, for some space to become available.

This is not good, because an auditing/logging application (which ours is) may have lots of available servers which it could send its data to - getting an error from one would simply mean that the data could be audited elsewhere.

But if the server just hangs, and waits, the application isn't (currently) smart enough to give up and try another server, so it hangs the audit process too. Which means that audit data starts to back up, and customers wonder why they can't see recent data in their reports etc.

There has to be a better way. I propose

• A background thread monitors the disc …

Today I recommended that a customer begin using MySQL 5.1 for development of their new product. There is virtually no risk of doing this, and in fact, the risk of not doing so is quite material. Upgrading the database later would be silly when you could start using it now and find out [...]

So we all know about the good old LAMP stack... Linux, Apache, MySQL, and PHP. It's a beautiful thing. I recently just started early development on a web application and instead of using Tomcat, Struts, Spring, Hibernate, or any of the Java-based frameworks that I am familiar with I've decided to take a step back to my programming past and use PHP with MySQL. Except this time, I'm using a Mac...

Let's start with my setup. I have a MacBook with OS X 10.5 (Leopard) so if you are running anything older this may not apply. Apache 2 and PHP 5 are shipped with 10.5 and I will talk about enabling them later.

The only piece we are missing is MySQL, and lucky us, they now make Mac binaries that you can find at www.mysql.com. Download the binary for the Mac (if you want to build the source get the tar.gz) and do the normal Mac install procedure. Once …

Now that MySQL 5.1 has finally been labeled and released as "GA", we have noticed quite a significant increase in the download numbers for 5.1. I find this quite promising, despite the comments from some people that suggested to stay away from it for now. I performed updates of 5.0 to 5.1 several times already, and did not observe any serious problem so far. But then again, I am by no means a power user, so your mileage may vary...

I assume that many of the users are already using some older versions of MySQL and will have to perform an upgrade from the previous version to the new one. As many things have been changed and improved between 5.0 and 5.1, an upgrade needs to be planned carefully. The MySQL reference manual has an entire chapter devoted to this subject. The best …