Sleeping connections

Why is it so important to close connections to databases if there’s no explicit need to keep them open (which usually the case)?

Symptoms

  • 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

PHP-APC collector for Diamond published

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.

Configuration

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

PHP-FPM collector for Diamond published

I’ve created the php-fpm status collector for Diamond. It’s available on github under Diamond-PhpCollectors: https://github.com/charlesnagy/Diamond-PhpCollectors

Collected metrics

Configuration

First of all you will need to enable status page in php-fpm.conf.

PHP-FPM

The following line should be in the config file.

Reload php-fpm service.

Nginx

In the … Continue reading