nerhael
01-20-2004, 06:14 PM
Can anyone recommend a good book that would help me learn best practices for administrating a MySQL database that's large?
I'm looking for guidelines on when to use an index, how to optimize large queries etc. I've unfortunately always used the database as a programmer, and feel out of my depth administrating a DB that's quickly growing to thousands of records..
Suggestions appreciated.
Pete.
I'm looking for guidelines on when to use an index, how to optimize large queries etc. I've unfortunately always used the database as a programmer, and feel out of my depth administrating a DB that's quickly growing to thousands of records..
Suggestions appreciated.
Pete.