Well, it's documented here:
http://dev.mysql.com/doc/internals/en/flush-tables.html
"Every time a thread releases a table, it checks if the refresh
version of the table (updated at open) is the same as the current
refresh_version. If not, it will close it and broadcast a signal on
COND_refresh (
Hi.
On Fri 2002-07-26 at 16:33:40 +0100, [EMAIL PROTECTED] wrote:
> Does anybody have any PHP examples of how to use the mySQL HANDLER command in
> place of a select statement? From the manual it appears as a high speed version
> of SELECT.
Not to sound harsh, but IMHO, if you have to ask, you
At 16:33 +0100 7/26/02, Steve Howie wrote:
>Does anybody have any PHP examples of how to use the mySQL HANDLER command in
>place of a select statement? From the manual it appears as a high
>speed version
>of SELECT.
Use HANDLER ... OPEN, then treat HANDLER ... READ like a SELECT, then
use HANDL
Hi!
On Nov 30, Ian Collins wrote:
> Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table
> READ, etc) are low level and the use is pretty hairy!
> However, the following is a fairly basic problem, and if it cannot be
> overcome, one would question the validity of having HA
Hi!
On Nov 19, Ian Collins wrote:
> If you open a table using HANDLER,
>
> e.g, HANDLER MYTABLE OPEN;
>
> then during the course of your application truncate that table,
>
> e.g, TRUNCATE TABLE MYTABLE;
>
> then you get some really wierd behaviour (my wierd behaviour was the
> applicatio
Ian Collins writes:
> If you open a table using HANDLER,
>
> e.g, HANDLER MYTABLE OPEN;
>
> then during the course of your application truncate that table,
>
> e.g, TRUNCATE TABLE MYTABLE;
>
> then you get some really wierd behaviour (my wierd behaviour was the
> application rolling on a
