About charlesnagy

I'm out of many things mostly automation expert, database specialist, system engineer and software architect with passion towards data, searching it, analyze it, learn from it. I learn by experimenting and this blog is a result of these experiments and some other random thought I have time to time.

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