Simple way to optimize MySQL

Reference Blog

My notebook to the MySQL import txt data, there is a table imported for nearly 4 hours, and a number of tables are related to each other, so when you do a joint query you will find that the problem is much, I was a joint query two tables on the crash, So optimizing MySQL is a matter of urgency.

The usual method is to build an index that loses memory to speed up queries. Of course all other operations except the query operation will be slow.

And MySQL has a simple statement to optimize the table.

OPTIMIZE TABLE sample;

I have optimized my table and the results affect the behavior of 0 ... Also drunk

Simple way to optimize MySQL