The SQL execution efficiency of some controllers on the thinkPHP website is low. the method used to monitor which SQL results in the SQL execution efficiency of some controllers on the thinkPHP website is low, the method used to monitor which SQL results from thinkphpsql thinkPHP website some controllers have low SQL execution efficiency. the method used to monitor which SQL results from
The SQL execution efficiency of some controllers of thinkPHP website is low. how can I monitor the resulting SQL?
Thinkphp SQL optimization
Share:
------ Solution --------------------
You can use the slow query analysis provided by mysql. for details, refer to Baidu.
------ Solution --------------------
Enabling slow query and analysis logs is the most direct
My. ini
Log-slow-queries = YOU_LOG_DIR.mysqlslowquery.log
Long_query_time = 1 // records that have exceeded the number of seconds
