Re: Session locks up and will not die - maybe a MySQL bug
Re: Session locks up and will not die - maybe a MySQL bug
- Subject: Re: Session locks up and will not die - maybe a MySQL bug
- From: Denis Stanton <email@hidden>
- Date: Mon, 24 Nov 2003 15:02:41 +1300
Hi Marek
On Monday, November 24, 2003, at 11:53 AM, Marek Wawrzyczny wrote:
The problem the email mentions does not appear to be purely MySQL.
I have come to believe that the too many open files problem, however it
may come about, is secondary. I think this only shows up after one or
more of my WO session has become stuck. I must fix that, and when I do
I expect the too many open files thing will not recur.
I did observe that MySQL 4.0.14 sets open_files_limit = 0 but MySQL
4.0.16 sets open_files_limit = 510
Finally, the author of the email goes on to modify kernel source and
recompiles the kernel to fix his problem where his client application
is running out of file descriptors (not MySQL). The article suggests
that:
The author did things to fix the problem that don't seem appropriate to
my situation
a) If MySQL is the problem, you should see "Too many files open"
messages in your MySQL logs.
b) If you are NOT seeing these messages in your MySQL logs, then there
is a problem purely with your WO application.
Dumb question, but where are these logs?
Denis
Denis Stanton
email@hidden
Home: (09) 533 0391
mobile: 021 1433622
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.