mysql tables not closing properly
Posted: Sat Nov 30, 2002 5:26 pm
I’ve got a database that seems to be misbehaving and I’m hoping that some one might be able to point me in right direction for a solution. The details are as follows:
When I run a Check table and quiet often get a warning connection not closed or other users have the table open with MySql claiming that up to three connections are open.
I now that no one else has a connection open as at this stage I have taken the server off line.
The server details are as follows:
OS X 10.2 (also happening on an OS X 10.1 server).
The database is been accessed through PHP (PEAR DB library).
John Joske
When I run a Check table and quiet often get a warning connection not closed or other users have the table open with MySql claiming that up to three connections are open.
I now that no one else has a connection open as at this stage I have taken the server off line.
The server details are as follows:
OS X 10.2 (also happening on an OS X 10.1 server).
The database is been accessed through PHP (PEAR DB library).
John Joske