content_image/696939.jpg content_image/696940.jpg
<img src='content_image/696939.jpg'>

Password hash values displayed in the IDENTIFIED WITH  clause of output from SHOW CREATE USER  may contain unprintable characters that have adverse effects on terminal displays and in other environments. Enabling print_identified_with_as_hex  causes SHOW CREATE USER  to display such hash values as hexadecimal strings rather than as regular string literals. Hash values that do not contain unprintable characters still display as regular string literals, even with this variable enabled. 

• profiling 

If set to 0 or OFF  (the default), statement profiling is disabled. If set to 1 or ON , statement profiling is enabled and the SHOW PROFILE  and SHOW PROFILES  statements provide access to profiling information. See Section 13.7.7.31, “SHOW PROFILES Statement” . 

This variable is deprecated; expect it to be removed in a future MySQL release. 

• profiling_history_size 

The number of statements for which to maintain profiling information if profiling  is enabled. The default value is 15. The maximum value is 100. Setting the value to 0 effectively disables profiling. See Section 13.7.7.31, “SHOW PROFILES Statement” . 

This variable is deprecated; expect it to be removed in a future MySQL release. 

• protocol_compression_algorithms 

<img src='content_image/696940.jpg'>

The compression algorithms that the server permits for incoming connections. These include connections by client programs and by servers participating in source/replica replication or Group Replication. Compression does not apply to connections for FEDERATED  tables. 

protocol_compression_algorithms  does not control connection compression for X Protocol. See Section 20.5.5, “Connection Compression with X Plugin”  for information on how this operates. 

