mardi 3 mars 2015

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?


what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ?


I know the below points exist means, there won't be any reset happen in binlogs.




  1. I would like to know whats the maximum value for the bin-log files.




  2. In case, the expire_log_days not provided, then it should not replace the first file, throws 'file-exist' error. The logs will be kept forever unless you specify an expiry.




  3. If the binary log master index files having the entry, I don't think it will replace.




Then what will happen eventually?





Aucun commentaire:

Enregistrer un commentaire