MYSQL Health Checks

[beechill4]

`Hi,

i'm new to mysql. does any one have a list of dba type checks that they use for mysql?

Thanks

 

[r937]

perhaps you might explain what you mean by "dba type checks"

r937.com | rudy.ca

 

[beechill4]

on oracle and sql server, would check for the following:

1. security breaches
2. poor performance indicators
3. backup & recovery
4. database storage

 

[r937]

i think it would be a good idea to check for those in mysql too



r937.com | rudy.ca

 

[beechill4]

thanks!

has anyone any good performance and security related scripts i could run?

 

[r937]

there are lots of examples here --

http://dev.mysql.com/doc/refman/5.0/en/optimization.html

r937.com | rudy.ca