copy
6
1
calculate and print size of binary logsdu -sm mysql-bin* | awk '{SUM +=$1} END {print SUM}'

4 years, 5 months ago ShahidMahmud 3 |

copy
0
1
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;

4 years, 5 months ago ShahidMahmud 3 |

copy
0
0
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.

4 years, 5 months ago ShahidMahmud 3 |