Not the answer you need?
Register and ask your own question!

Mysql binary log query

vedarthkvedarthk EntrantInactive User Role Beginner
I am reading MySQL binary log, my mysql-bin.index contains :

/var/log/mysql/mysql-bin.000177
/var/log/mysql/mysql-bin.000178
/var/log/mysql/mysql-bin.000179
/var/log/mysql/mysql-bin.000180
/var/log/mysql/mysql-bin.000181
/var/log/mysql/mysql-bin.000182
/var/log/mysql/mysql-bin.000183
/var/log/mysql/mysql-bin.000184
/var/log/mysql/mysql-bin.000185
/var/log/mysql/mysql-bin.000186
/var/log/mysql/mysql-bin.000187
/var/log/mysql/mysql-bin.000188
/var/log/mysql/mysql-bin.000189
/var/log/mysql/mysql-bin.000190
/var/log/mysql/mysql-bin.000191
/var/log/mysql/mysql-bin.000192
/var/log/mysql/mysql-bin.000193
/var/log/mysql/mysql-bin.000194
/var/log/mysql/mysql-bin.000195
/var/log/mysql/mysql-bin.000196
/var/log/mysql/mysql-bin.000197
/var/log/mysql/mysql-bin.000198
/var/log/mysql/mysql-bin.000199
/var/log/mysql/mysql-bin.000200
/var/log/mysql/mysql-bin.000201
/var/log/mysql/mysql-bin.000202
/var/log/mysql/mysql-bin.000203
/var/log/mysql/mysql-bin.000204
/var/log/mysql/mysql-bin.000205
/var/log/mysql/mysql-bin.000206
/var/log/mysql/mysql-bin.000207
/var/log/mysql/mysql-bin.000208
/var/log/mysql/mysql-bin.000209
/var/log/mysql/mysql-bin.000210
/var/log/mysql/mysql-bin.000211
/var/log/mysql/mysql-bin.000212
/var/log/mysql/mysql-bin.000213
/var/log/mysql/mysql-bin.000214
/var/log/mysql/mysql-bin.000215

Before few days the file had names with index starting from mysql-bin.000163, I was not abel to find any information online when does MySQL rotates binary log files, I want to get first data modification query on the database.

Is there a way to do that using binary logs ?

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.