Yes, the "write if only it has not been read for some time" solution is not 100% guarantee, but is a good enough approach.
Maybe the solution to the failing innodb_information_schema test is to inject "-- sleep 0.1" just before calling wait_until_rows_count.inc? Or actually the whole wait_until_rows_count.inc is useless because as soon as it starts it will query the I_S table very often and will thus "freeze" the cache. But that will also be non-deterministic.
Hi,
Yes, the "write if only it has not been read for some time" solution is not 100% guarantee, but is a good enough approach.
Maybe the solution to the failing innodb_ information_ schema test is to inject "-- sleep 0.1" just before calling wait_until_ rows_count. inc? Or actually the whole wait_until_ rows_count. inc is useless because as soon as it starts it will query the I_S table very often and will thus "freeze" the cache. But that will also be non-deterministic.
Thanks!