Tom Cannaerts

Tom Cannaerts

Hi there! My name is Tom. I'm a Linux System Administrator and PHP Developer. My job is to keep PHP websites running as smooth as possible. Being both on the 'dev' and 'ops' side gives me a broad skillset across the entire stack.

From my hand: SoundTouchPhp

So I’ve had the joys of playing around with some Bose SoundTouch 10 at work. These are Sonos-like Wifi speakers that can be controlled over the network. Turns out, these things even have a documented (!) HTTP API, allowing you to control them from your own applications, rather than Bose supplied apps. As this obviously […]

The importance of index cardinality

Today was one of these days that I learned a lot of something I already knew… index cardinality. I was working with a collegue in an attempt to optimize a project that has been acting up lately and was passed on to us. The website itself is a Drupal website with a custom module that […]

Optimizing queries with MySQL EXPLAIN

The MySQL explain command is one of the most useful commands when debugging or optimizing queries on MySQL. It will tell you how MySQL is processing that data it needs to run your query. To use the command, simply put EXPLAIN (or EXPLAIN EXTENDED) in front of your query. For each table (or derived table), […]

Run multiple versions of PHP using fcgid and suexec

Run multiple versions of PHP using fcgid and suexec

When hosting multiple sites on the same server, you sometimes might just want to be able to run different versions of PHP. Add multiple users to the problem (like in a typical shared hosting environment) and you probably might also want to prevent a user from accessing files of another user. You may also want […]

Efficient data processing in PHP

Last weekend, I was at PHP Benelux and attended a talk of Juozas Kaziuk─Śnas titled “Process any amounts of data. Any time”. What it comes down to, is that by using the right techniques, you could process virtually any amount of data without killing your webserver. The thing is, the talk did not really teach […]