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