raid fifa wrote:
Is this a bug of mysql_ping() ? or any other advice?
Probably not. I think you'll find that it *does* time out, just after a
longer period than you'd prefer. Timeouts of 30, 60 and 120 seconds are
common in network code, because it's not possible to rel
Hi guys,
I used mysql_ping() function in my program. But when I unplug the network wire
between client and MySQL server, my program has no response as mysql_ping() can
not return value and hanged there.
Is this a bug of mysql_ping() ? or any other advice?
thanks
Hello,
I am having issues with the MySQL C API. I have googled, and it seems
many other people are having this issue too, but unfortunately I have
yet to find a solution.
It seems that whenever anything calls mysql_ping(), it causes a
Segmentation fault. I am currently using MySQL 4.1.10a
Hi again,
This is intresting, the documentation indeed mentions that mysql_ping
indicates "Zero if the connection to the server is alive" and not that
"zero if the server is alive", as I *naturally expected* also, so it
is kind of tricky this one. I would expect the sam
Hello.
I've found that mysql_ping doesn't work properly with TCP connection (in
your test case you put the hostname to "127.0.0.1"). My program was
working with "localhost" - connection through the Unix socket. You may
want to add you comments to my bug repor
Hi,
The previous subject made me wonder about mysql_ping () in a multithread
environment. Since it implements restoring connectivity, should it also
be protected by a mutex?
Regards and thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I did some extensive testing and it looks like that only the first
mysql_ping () fails to reconnect or very possibly returns the wrong
result. I am currently using v4.1.14.
Regards,
Lefteris
Begin
MySQL is up and running
Restart MySQL and
k right for you?
Regards,
Lefteris
Gleb Paharenko wrote:
Hello.
In my opinion it depends on the value of reconnect flag (the part of
MYSQL structure). I've written a simple program which connects to MySQL
server,
waits a bit and executes mysql_ping. While it is waiting, MySQL server
is being res
Hello.
In my opinion it depends on the value of reconnect flag (the part of
MYSQL structure). I've written a simple program which connects to MySQL
server,
waits a bit and executes mysql_ping. While it is waiting, MySQL server
is being restarted. If mysql.reconnect = 1, mysql_ping() re
Hi,
Is mysql_ping () suppose to restore a db connection even after a db restart?
Thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 03:52 3-6-2002, Mark Matthews shared with all of us:
>>So - indeed - I'm probably barking up the wrong tree, by looking at
>>mysql_ping(),
>>but I basically want to mimmick the behavior, so the there's no
>>connection error
>>for the webserver inv
OTECTED]>
Sent: Monday, June 03, 2002 4:30 AM
Subject: Re: mysql_ping()
> Hi Gelu,
>
> At 23:10 2-6-2002, Gelu Gogancea shared with all of us:
>
> >I'm sorry ... i didn't read carefully you mail
>
> No problem.
>
> >Anyway, my opinion is that you shou
> I may be totally off, but couldn't you just try to open a
> socket to the
> relevant port - if it goes OK, you're fine. If not, well...
> example code in PHP:
>
> if($fp = fsockopen($host_domain, $port, $errno, $errstr, $timeout)){
> // - juhuu!
> }else{
> // - boohoo...
>
>
> What I want to know, is:
> 1) after reading the header, how should one respond?
> 2) Is a command necessary, or can one close after succesfully
authenticating?
> 3) Is there a sign-off?
>
> Ie - what does a minimal valid connection look like?
I may be totally off, but couldn't you just try to
vel socket function, which has a hard timeout and
> set that to
> 10 secs.
>
> The drawback is that I have to set max_connect_errors to a very high
> value and pray
> we never get there or run a flush hosts via a crontab every now and then.
>
> So - indeed - I'm probab
Hi Gelu,
At 23:10 2-6-2002, Gelu Gogancea shared with all of us:
>I'm sorry ... i didn't read carefully you mail
No problem.
>Anyway, my opinion is that you should use(i don't know if is possible) the
>mysql_options to set time out.
That works if only mysqld is down and the machine is rea
s via a crontab every now and then.
So - indeed - I'm probably barking up the wrong tree, by looking at
mysql_ping(),
but I basically want to mimmick the behavior, so the there's no connection
error
for the webserver involved.
See it as Net::SMTP, using a sim
- Original Message -
From: "Melvyn Sopacua" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: "MySQL General" <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 10:27 PM
Subject: Re: mysql_ping()
> >So... you don'
Cc: "MySQL General" <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 11:27 PM
Subject: Re: mysql_ping()
> Hi Gelu,
>
> At 21:52 2-6-2002, Gelu Gogancea shared with all of us:
>
>
> >Indeed, mysql_simple_command (with COM_PING command like argument ) is
used
>
opacua" <[EMAIL PROTECTED]>
To: "MySQL General" <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 8:31 PM
Subject: mysql_ping()
> Hi,
>
> I've got a function/method in php, where socket communication is used,
> to determin if a host is live - however - the
Hi Gelu,
At 21:52 2-6-2002, Gelu Gogancea shared with all of us:
>Indeed, mysql_simple_command (with COM_PING command like argument ) is used
>by C API mysql_ping, to check connection.MYSQL struct it's used like
>handler.
>For a connection you must use in o
Hi,
Indeed, mysql_simple_command (with COM_PING command like argument ) is used
by C API mysql_ping, to check connection.MYSQL struct it's used like
handler.
For a connection you must use in order:
mysql_init(),-initialise MYSQL struct
mysql_options(),- optio
At 19:53 2-6-2002, Gelu Gogancea shared with all of us:
>mysql_ping check connection to server.
>In documentation at "8.4.3.163 mysql_ping()" you can find more details about
>that.
Yeah right.
Did you actually take a look?
Reading the source gives me more information. I
Hi,
mysql_ping check connection to server.
In documentation at "8.4.3.163 mysql_ping()" you can find more details about
that.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
whole thing off,
while I really don't need it, cause all relevant mysql servers are on
internal networks) is another matter.
What I'd like to do, is mimmick mysql_ping() behavior, so that it's a valid
connection. However - I'm not that farmiliar with C and it's scattered ove
On Friday 26 October 2001 11:12, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am experiencing seg faults in seemingly innocent code with MySQL version
4.0.0
> and the embedded library, libmysqld.
> The fault only happens when calling particular functions, specifically
> mysql_ping
Hi!
On Oct 26, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am experiencing seg faults in seemingly innocent code with MySQL version 4.0.0
> and the embedded library, libmysqld.
> The fault only happens when calling particular functions, specifically
> mysql_ping() and mysql_query(
Hello,
I am experiencing seg faults in seemingly innocent code with MySQL version 4.0.0
and the embedded library, libmysqld.
The fault only happens when calling particular functions, specifically
mysql_ping() and mysql_query(). There might be others, but these are the only
ones I've fou
hello
i have mysql ver 3.22.29 installed.
My problem is that i m using mysql_ping at a lot of places (i.e before every
query) to check whether i have connection or not , in a program which is
running in deamon every 10 seconds i.e i dont close the connection anywhere,
just connect once and keep
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 1:15 PM
To: [EMAIL PROTECTED]
Subject: C API -- using mysql_ping()
If a connection has been closed by the mySQL server, like in a timeout
condition, does the API function mysql_ping() awake the connection again if
the re
If a connection has been closed by the mySQL server, like in a timeout
condition, does the API function mysql_ping() awake the connection again if
the reconnect flag was set, or will it just return a lost server error?
In other words, if I'm testing to see if a long-unused connection is
31 matches
Mail list logo