The databases are an indispensable in web page development, developers often can be decanted from different programming languages (PHP, Python, Ruby on Rails, etc) but in the end almost all use MySQL as a principal and indispensable for managing data. Personally I think it's relatively easy to write functional code in a few hours and join a good design, which together form a useful application, but such combination tend to not scale well due to its high dependency on the database, so in the vast majority of times we would rather invest time in analyzing and optimizing the data structure you are using. These are some common mistakes that are often committed in MySql.
Use InnoDB instead of MyISAM
Are the two database engines most famous and the use of one or the other is a very important decision. MyISAM is used by default but not the best option if you are thinking of a pilot project is a good choice, but in most cases is not the best solution, we will mention some of the key ways that is further recommended the use of InnoDB.
- MyISAM does not support foreign keys
- Data Integrity
- In each script MyISAM locks the whole table so that each "INSERT" or "UPDATE" to block the table, a small scale but is not usually noted as a requirement of the database is greater than the decrease performance is considerable.