hi! i am working as a developer in an orgnization, and i have been assigned an extra duty to maintain the MySql database used for production purpose. As a database administrator what are the important things that i must keep track of to ensure that the database is healthy always!
for i think - some of these as important :
number of databases created and dropped. most used databases system language open connection aborted connection
and what shall we include under query statistics!!!!
- Memory usage. - Network response. - Growth of the extensions (I don't know MySql, but in Oracle I think it's important). - Locks. - Owners. - Indexes, constraints, ...
Check: Preformance of : add, delete, update, etc. Connections: multiple connections Time that takes to DB became ready, also after the crash how much time takes to recover and became ready. Size of DB that can be than you could choose how to change the parameters. Caesar
For a production database system I think the most important thing is to create disaster recovery. And you must have an agreement between the end user in the system about expected performance.
