MySQL user performance

 1. Pre-order

 

Store the mysql in certain order. so the user don't need to use the order by, improve their query performance.

 

Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

 

2. low priority write

 

let your administrator updates to be low priority.

 

 

3. Load command

LOAD DATA [LOW_PRIORITY | CONCURRENT]