Re: Qcache and "read data from master"

2005-02-09 Thread Victor Pendleton
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 choo

Qcache and "read data from master"

2005-02-09 Thread Olivier Kaloudoff
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