How to optimize MySQL in the simplest way

1, create the index, must be based on the actual situation to create, if the connection table query, such as a master account to connect multiple sub-accounts, you can consider two or more than three multi-index;

2, reasonable use of time sorting, because most of the table with time to sort, the amount of data is quite large when the time column to add an index, fast to fly.

3, in the time of recursion, do not use multi-layered delay query, should be all taken out in memory, and then recursively processing the content, rather than go to query.

How to optimize MySQL in the simplest way