Daily DB Task List for MySQL DBA

Daily Checklist for MySQL Server Databases

	S.No	Activity	Scope	Frequency	Comments	Addl. Remarks
	1	Database Availability Check (Up /	All Production	Min. Once in	Nil	Nill
		Down?)		hour
	2	Backup Execution Status (Success /	All Production	Once	Nil	Nill
		Failure?)
					Initially can be carried out	Define thresholds
	3	Bin log usages	All Production	Min. Once	during Lean hours (Night	based on Retention
					Shifts)	Policy
					Initially can be carried out
	4	Scheduled Jobs Status & Crontab Jobs	All Production	Min. Once	during Lean hours (Night
					Shifts)
			Production DBs in		Initially can be carried out	Define thresholds
	5	Free Space Availability for the Database		Min. Once	during Lean hours (Night
			bin log mode			based on trends
					Shifts)
					Initially can be carried out	Define thresholds
	6	Free space in Database?	All Production	Once	during Lean hours (Night
						based on trends
					Shifts)
	7	Long running transactions	All Production	Once	Nill	Nill
	8	Locking & Deadlocks	All Production	Min. Once	Nill	Nill
						CPU & Memory
	9	Performance Check of DB	All Production	Once	Initially Weekly	utilization can also be
						checked