<>
MySQL5.0 After that, I started to support profiling, For diagnosing a sql Resource consumption during execution , Through profiling To view slow sql How slow is it , So as to carry out reasonable optimization

* see profiling Whether it supports and opens show variables like '%profil%'
Variable_name Value
have_profiling( Yes no profiling) YES
profiling( Open or not profiling) ON
profiling_history_size(profiling Lines per display ) 15
* If it's above profiling The value of is 0 perhaps OFF, So on profile set profiling=1
* Start using profiling # Execute one sql select count(*) from vc # use profiling SHOW PROFILES

Query_ID: Queried ID
Duration: Execution time
Query: Specific implementation sql
You can find the one we just executed in the result sql
# adopt Query_ID see sql Specific implementation # Or through Show profile all for query 174 Find out more Show
profilefor query 174

Status: Indicates the implementation of this article sql Stage experienced
Duration: Time consumption of each stage

Technology
©2019-2020 Toolsou All rights reserved,
java Several common runtime exceptions and simple examples The shortest path of maze BFS algorithm (python realization )TypeScript Data types in is enough SSM Project's excel File upload and add to database ( Essence )2020 year 6 month 26 day C# Class library Exception handling help class Result Encapsulation of return result information Theory and formula derivation of univariate linear regression and multiple linear regression mysql Recursively finds all child nodes of the parent class c Language rose advertising code ( Essence )2020 year 8 month 9 day C# Basic knowledge reflex