Weekly Checklist for MySQL DBA
|
|
S.No
|
Activity
|
Scope
|
Frequency
|
Comments
|
|
|
|
|
|
|
|||||
|
|
1
|
Reports for Database growths
|
Production DBs
|
Once
|
Nill
|
|
|
|
|
2
|
Reports for errors and issues faced
|
Production DBs
|
Once
|
Nill
|
|
|
|
|
3
|
Review of time taken for batch jobs and daily transactions
|
Production DBs
|
Once
|
Nill
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4
|
Check growth in Backups and time taken
|
Production DBs
|
Once
|
Nill
|
|
|
|
|
5
|
Check for Fragmentation & Invalid Objects
|
Production DBs
|
Once
|
Nill
|
|
|
|
|
|
Performance report (Report of the hit ratios along with the
I/O
|
At least for
|
|
Initially for super
|
|
|
|
|
6
|
super
critical
|
Min Once
|
|
|
||
|
|
used and cpu used for the database)
|
critical DBs
|
|
|
|||
|
|
|
DBs
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
7
|
Rebuild tables which are fragmented
|
Production DBs
|
Once
|
|
|
|
|
|
8
|
Verify Analyze of tables and indexes
|
Based on
|
Once
|
|
|
|
|
|
statistics
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Each Friday Weekend
|
|
|
|
|
9
|
Specified Weekend Activity should be
taken
|
Specific DBs
|
N/A
|
Activities with
|
|
|
|
|
ownership is
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
communicated.
|
|
|
No comments:
Post a Comment