topic Re: need help for database administration in Operating System - HP-UX

need help for database administration

prem_4 — Fri, 20 Jun 2003 09:35:43 GMT

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

Re: need help for database administration

Pete Randall — Fri, 20 Jun 2003 09:37:05 GMT

How about disk space usage?

Pete

Re: need help for database administration

Ian Dennison_1 — Fri, 20 Jun 2003 10:01:43 GMT

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

Re: need help for database administration

Vicente Sanchez_3 — Fri, 20 Jun 2003 10:02:31 GMT

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.

Re: need help for database administration

Caesar_3 — Fri, 20 Jun 2003 10:12:37 GMT

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

Re: need help for database administration

Pete Randall — Fri, 20 Jun 2003 10:16:44 GMT

And: regular backups and recovery practice sessions.

Pete

Re: need help for database administration

twang — Fri, 20 Jun 2003 10:53:26 GMT

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.

Re: need help for database administration

twang — Fri, 20 Jun 2003 11:06:41 GMT

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

Re: need help for database administration

twang — Fri, 20 Jun 2003 11:09:59 GMT

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

Re: need help for database administration

prem_4 — Sat, 21 Jun 2003 08:02:39 GMT

I THANK U ALL FORM UR VALUABLE SUGGESTIONS!!!