MySQL - Best Practices

mysql

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.

What are the best practices?

  • Use proper indexing for your tables so that MySQL can lookup rows faster by value rather by performing table scans.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License