postgres High CPU - Nagios Freeze
Posted: Fri Aug 29, 2014 4:15 pm
Hi,
Anybody help me ?
Server 10 Cores - Xeon 2.2Ghz - 10GB RAM
Hosts : 2,465 Services: 12,500
The GUI when use the bulk import its very slow..and freeze all system.
HTOP:
postgres : nagiosxi nagiosxi [local] SELECT 53% CPU
postgres : nagiosxi nagiosxi [local] SELECT 22% CPU
Why postgres consume CPU ?
Regards!
Sergio
--------------------------MERGED------------------------
Update..
I see a lot of process..
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php...
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
.... x 50..
and
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT.....
The CPUs goes to 80% ...and the Web Interface go down....
Any idea ?
Regards!
Sergio
--------------------------MERGED------------------------
Hi,
Anybody ?
Regards!
Sergio
Anybody help me ?
Server 10 Cores - Xeon 2.2Ghz - 10GB RAM
Hosts : 2,465 Services: 12,500
The GUI when use the bulk import its very slow..and freeze all system.
HTOP:
postgres : nagiosxi nagiosxi [local] SELECT 53% CPU
postgres : nagiosxi nagiosxi [local] SELECT 22% CPU
Why postgres consume CPU ?
Regards!
Sergio
--------------------------MERGED------------------------
Update..
I see a lot of process..
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php...
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
/usr/bin/php /usr/local/nagiosxi/scripts/handle_nagioscore_event.php....
.... x 50..
and
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT
postgres: nagiosxi nagiosxi [local] INSERT.....
The CPUs goes to 80% ...and the Web Interface go down....
Any idea ?
Regards!
Sergio
--------------------------MERGED------------------------
Hi,
Anybody ?
Regards!
Sergio