MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:February 9 2005 1:27pm
Subject:Re: Qcache and "read data from master"
View as plain text  
I believe it may be because the tables in the Query cache have been 
modified causing the cached  results to become invalid.

Olivier Kaloudoff wrote:

> Hi,
>     I noticed the following behaviour on mysql 4.1.8
> and two servers;
>     to setup replication, I did the required grant on
> the master, and choose to use "LOAD DATA FROM MASTER" on the
> slave.
>     As we monitor the Qcache usage on the master, it
> happend that Qcache was reset to 0 Queries during this operation.
>     I would like to know if this behaviour is expected, and
> would be interrested if someone can explain me why this is necessary ?
> Olivier

Qcache and "read data from master"Olivier Kaloudoff9 Feb
  • Re: Qcache and "read data from master"Victor Pendleton9 Feb