MySQL - Best Practices
What are the best practices?
- Use appropriate storage engine
- Use columns that are no longer than necessary.
- Pay special attention to columns that are used to join tables.
- Define columns as NOT NULL if possible.
- Use proper indexing for your tables so that MySQL can lookup rows faster by value rather by performing table scans.
- Use PROCEDURE ANALYSE
page revision: 3, last edited: 06 May 2017 15:49