Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

need help for database administration

prem_4
Occasional Advisor

need help for database administration

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!!!!
9 REPLIES
Pete Randall
Outstanding Contributor

Re: need help for database administration

How about disk space usage?


Pete

Pete
Ian Dennison_1
Honored Contributor

Re: need help for database administration

Performance in terms of wait times, also usage of memory allocated for internal processing.

Long running queries are very good, space management also. Average transaction processing time is a good measure.

Share and Enjoy! Ian
Building a dumber user
Vicente Sanchez_3
Respected Contributor

Re: need help for database administration

Hello,

- 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, ...

HTH, Vicente.
Caesar_3
Esteemed Contributor

Re: need help for database administration

Hello!

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
Pete Randall
Outstanding Contributor

Re: need help for database administration

And: regular backups and recovery practice sessions.


Pete

Pete
twang
Honored Contributor

Re: need help for database administration

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.
twang
Honored Contributor

Re: need help for database administration

Visit the link to a very good article about Mysql performance tuning.
http://www.linux-mag.com/2001-12/mysql_01.html
twang
Honored Contributor

Re: need help for database administration

no point please, a link to "How to Write Efficient MySQL Applications"
http://www.linux-mag.com/2001-06/mysql_01.html
prem_4
Occasional Advisor

Re: need help for database administration

I THANK U ALL FORM UR VALUABLE SUGGESTIONS!!!