[MySQL] using Profiles to view the execution time consumed by the create statement _ MySQL

1. view the status value of profiles 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 ".