Server System Variables 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. 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. 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. 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. 860 • protocol_compression_algorithms • profiling_history_size • profiling Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --protocol-compression- algorithms=value Introduced 8.0.18 System Variable protocol_compression_algorithms Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Set Default Value zlib,zstd,uncompressed Valid Values zlib zstd uncompressed