SQL語法優化

• 顯示各語法執行時間

set profiling=1;
SET profiling_history_size = 0;
SET profiling_history_size = 100;

＊＊＊ＳＱＬ語法＊＊＊

show profiles;

• 查看某個語法細節

show profile for query [profiles.Query_ID];