MySQL - Best Practices

mysql

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