Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What should I put on my checklist when I look at MySQL database for the first time? I would appreciate your help. Thanks.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

This question is very general and I'd suggest clarifying it with more context, but I'll give it a shot.

I would look at:

  • security. What are the users that have privileges on that database? What are the privileges (i.e. read-only on specific tables, or do they have grant option permissions)?

  • entities. What are the major entities and their relationships?

  • performance. What queries are resource hogs? Are appropriate indexes in place?

  • denormalization. Is the schema purposely denormalized? If so, why and is it appropriately denormalized?

  • foreign keys. Are they enforced (do the tables use InnoDB)?

  • size. What are the biggest tables? Which tables are expected to grow the fastest?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.