[MySQL] using Profiles to view the execution time consumption of the create statement
1. view the status value of profiles
1. Check whether profiles is enabled. By default, profiles is disabled.
Mysql> show variables like '% pro % ';
I checked that there was nothing in profiles, so the profile in the company server was not opened. I checked the mysql variable and it was OFF.
2. Open profiles and Test
1. Enable profiles
2. check the status value, which is ON
3. Test
Mysql> create table test_cpny.listed_cpny_fin_rpt_prd
Mysql>
Mysql>
5. check again
It seems that the time is spent | Sending data | 29.96599 | above!
Supplement:
Profiling_history_size
The number of statements for which to maintain profiling information ifProfiling is enabled. The default value is 15. The maximum value is 100. Setting the value to 0 when tively disables profiling. See Section 13.7.5.32,"Show profiles Syntax ".