In the last past month I got a lot of question about how to learn to fundaments of being a DBA/DBO. So I decided to write a (hopefully) comprehensive post about this.
First of all as always it depends. Lately I see an upcoming trend to make sharp … Continue reading
Why is it so important to close connections to databases if there’s no explicit need to keep them open (which usually the case)?
- Icinga reports high usage of allowed connections (>90%) on master MySQL server.
- No running queries or any specific in processlist. All the connections are sleeping … Continue reading
I just faced a problem with Joomla 2.5 install when the web install get stuck after the 1st step (language selection). After I searched the internet I found a lot of forums describing the same problem. I read a lot of strange ideas about fixing this with different apache and … Continue reading
We went out to Marken last weekend. There was a big storm coming we had to run to the car all the way down. This photo was taken about 5 minutes before the actual falling rain and ice.
Last weekend I went out to Zandvoort am See I had the luck to be able to get some great photos. A young couple played in the sunset on a bank in the sea.
I always hear newer and newer exotic way to store different types of data in MySQL. People are trying to solve the problem of storing complex and not necessary strictly structured data in databases which is fine. But I never understood why to try to be tricky with the simplest … Continue reading
HTML5 was a real big improvement in the webdevelopment. We don’t need ugly JS hacks anymore for the simplest stuff. We can use the built-in functions of the webbrowsers instead. Anybody who didn’t check the new tags and attributes what the new standard provides I highly recommend to do it. … Continue reading
I’ve created the php-apc status collector for Diamond. It’s available on github under Diamond-PhpCollectors: https://github.com/charlesnagy/Diamond-PhpCollectors
This collector is for collecting APC (Alternative PHP Cache) statistics for Graphite.
To be able to use the plugin first of all you will need to put the included stats_apc.php to the www directory … Continue reading
I’ve created the php-fpm status collector for Diamond. It’s available on github under Diamond-PhpCollectors: https://github.com/charlesnagy/Diamond-PhpCollectors
$ curl http://localhost/fpm_status
start since: 2926
accepted conn: 113
listen queue: 0
max listen queue: 0
listen queue len: 128
idle processes: 2
active processes: 1
total processes: 3
max active processes: 1
max children reached: 0
First of all you will need to enable status page in php-fpm.conf.
The following line should be in the config file.
pm.status_path = /fpm_status
Reload php-fpm service.
In the … Continue reading
Some photos about the nights in Amsterdam taken yesterday evening.
- Nikon D80
- Sigma 18:50 1:2.8
- B+W circulary polarising filter
- Giotto’s tripod