Check create timestamp of binary logs

python-check-binlogs.py

#!/usr/bin/python

import os, time
from struct import unpack
from datetime import datetime

d = '/home/mysql/backup_data/backup_str/binlogs'
x = 180
oldest = int(time.time())-(90*24*60*60)

l = os.listdir(d)
l.sort()
for f in l:
	b = open(os.path.join(d, f), 'rb')
	if b.read(4) != '\xfebin': continue
	b.seek(4)
	ts = unpack('I', b.read(4))[0]
	print "%s %s" % (str(f), str(datetime.fromtimestamp(ts).strftime('%Y-%m-%d %H:%M:%S')))
	#print "%s %d" % (f, ts)
	b.close()
	if ts >= oldest:
		print "Reached our threshold, quitting\n"
		break