Logging of net_read_timeout and/or net_write_timeout

2002-05-01 Thread Jay Lawrence
suspect somewhere in libmysql/net.c - which is where the timeouts are set. Would it be possible to have the client set these values via an SQL statement to explicitly increase the timeouts for those connections? Thanks a bunch! Submitter-Id: submitter ID Originator:Jay Lawrence

Re: Table timestamps? More specific control of SHOW TABLE STATUS command

2001-02-15 Thread Jay Lawrence
s a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. [/snip] .. Atle On Wed, 14 Feb 2001, Jay Lawrence wrote:

Table timestamps?

2001-02-14 Thread Jay Lawrence
Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few