1.开启连接池 2.用truncate 代替 delete table 3.前模糊 》》》后模糊(使用索引) where col like “%abc” 转换成 where reserve(col) like “cba%”