Re: Bug in MySQL API ?!?

[Paul DuBois]

At 15:45 +0100 2/4/02, Skriniar Gregor wrote:
>Dear all,
>
>I experienced some problems with using MySQL API:
>My problem is that if I don't use database a long time it is disconnected and

That's how it's supposed to behave.  What's the bug?

If your application really needs to hold the connection open for
abnormally long times, you could have it send the server a trivial
query every now and then.  (Say, "SELECT 1")

>when I try to connect again at first I use method mysql_ping(), 
>which reopens connection and that's the point. Please see next code 
>of MySQL API:

[clipped]