ShahidMahmud

copy
9
1
Data Base Size in MB from Information SchemaSELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;Get Data Base Size in MB from Information Schema in mysql

4 years, 11 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, 11 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, 11 months ago ShahidMahmud 3 |

copy
1
0
byte count for queries which do NOT contain the 'UPDATE cache' linemysqlbinlog mysql-bin.000099 | grep -iv 'update cache' | wc -c

4 years, 11 months ago ShahidMahmud 3 |

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

4 years, 11 months ago ShahidMahmud 3 |