[dancer-users] High CPU usage on DB

[Zahir Lalani]

Hi All

Posting this to the Dancer list as there is possibly a connection.

We have a fairly complex query we run from our web app and it normally runs just fine. However, we have noticed that after while the system slows down and we see the postgres server on 100% CPU. It is not out of memory and not thrashing the disk. We have 2 app servers each with 10 workers. We use the Dancer database module to create a connection, and so in this case we have 20 connections to the DB. When we see the performance issue, a restart of Starman cures the problem. We never have to do anything in the DB, just dropping those Starman connections is enough to resolve.

I don't understand enough about how the DBI connections work - does the above ring any bells for anyone?

Z
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.preshweb.co.uk/pipermail/dancer-users/attachments/20161208/230f9bdc/attachment.html>