mysql administration need help

[bakardi]

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!!!!

 

[fluteplr]

Wrong Forum. This forum is for Microsoft SQL Server not MySQL. Try the MySQL forum.

 

[SQLSister]

But in answer to your question, the single biggest thing you need is to implement a good backup and recovery plan. With this at least you can recover from almost anything else that might befall you!