queries have been logged to update the cache tables: mysqlbinlog mysql-bin.000099 | grep -ci 'update cache' find in mysql binary logs how many update queries were executed;

binlog,

binary

log,

update

cache,

mysqlbinlog

5 months, 1 week ago ShahidMahmud 3 |

byte-count / size of update cache queries in binlogmysqlbinlog mysql-bin.000010 | grep -i 'update cache' | wc -cbyte-count for queries containing the words 'UPDATE cache'. Shows size of each binlog file dedicated to the 'UPDATE cache' queries.

mysqlbinlog,

mysql,

binlog,

binary

log,

cache

size

5 months, 1 week ago ShahidMahmud 3 |