17 May
2010
17 May
'10
3:34 p.m.
On 17-05-2010 10:51:56 -0400, Matthew Jones wrote:
To manage the rest of the database I have a series of scripts that check to see if the database is using a stupid amount of memory (80%+ of physical memory on the machine) or to see if the database is deadlocked (this happens several times a day). If either of these situations exist then I SIGHUP the merovingian and mserver processes... when the database comes back up and gets primed then it will be using a reasonable amount of memory for about 8 hours or so.
Do you really mean SIGHUP here? Does merovingian get stuck/deadlocked too, or just the database? SIGHUP to merovingian will just make it reopen its logfiles.