mysql tables not closing properly

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jjoske
Forum Newbie
Posts: 1
Joined: Sat Nov 30, 2002 5:26 pm

mysql tables not closing properly

Post by jjoske »

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
Post Reply