Server System Variables The maximum number of characters permitted in random passwords generated for  CREATE USER , ALTER USER , and  SET PASSWORD  statements. For more information, see Random Password Generation. The maximum permitted result length in bytes for the  GROUP_CONCAT()  function. The default is 1024. YES  if the  zlib  compression library is available to the server,  NO  if not. If not, the  COMPRESS()  and UNCOMPRESS()  functions cannot be used. YES  if  mysqld  supports dynamic loading of plugins,  NO  if not. If the value is  NO , you cannot use options such as  --plugin-load  to load plugins at server startup, or the  INSTALL PLUGIN  statement to load plugins at runtime. YES  if the server supports spatial data types,  NO  if not. This variable is a synonym for  have_ssl . As of MySQL 8.0.26,  have_openssl  is deprecated and subject to removal in a future MySQL version. For information about TLS properties of MySQL connection interfaces, use the  tls_channel_status table. YES  if statement profiling capability is present,  NO  if not. If present, the  profiling  system variable controls whether this capability is enabled or disabled. See Section 13.7.7.31, “SHOW PROFILES Statement” . 804 • have_profiling • have_openssl • have_geometry • have_dynamic_loading • have_compress • group_concat_max_len Type Integer Default Value 20 Minimum Value 5 Maximum Value 255 Command-Line Format --group-concat-max-len=# System Variable group_concat_max_len Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes Type Integer Default Value 1024 Minimum Value 4 Maximum Value (64-bit platforms) 18446744073709551615 Maximum Value (32-bit platforms) 4294967295