sys Schema Stored Functions slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory basedir Parameters Return Value Example 28.4.5.5 The format_statement() Function Parameters Configuration Options Return Value Example 5204 mysql>  SET @stmt = ’SELECT variable, value, set_time, set_by FROM sys_config’; mysql>  SELECT sys.format_statement(@stmt); By default,  format_statement()  truncates statements to be no more than 64 characters. Setting @sys.statement_truncate_len  changes the truncation length for the current session: A  LONGTEXT  value. The maximum length of statements returned by the  format_statement()  function. Longer statements are truncated to this length. The default is 64. • statement_truncate_len ,  @sys.statement_truncate_len format_statement()  operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 28.4.2.1, “The sys_config Table” ): • statement LONGTEXT : The statement to format. This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len  configuration option, and returns the result. No truncation occurs if the string is shorter than  statement_truncate_len . Otherwise, the middle part of the string is replaced by an ellipsis ( ... ). A  VARCHAR(512) CHARACTER SET utf8  value. • path VARCHAR(512) : The path name to format. mysql>  SELECT sys.format_path(’/usr/local/mysql/data/world/City.ibd’); +---------------------------------------------------------+ | sys.format_path(’/usr/local/mysql/data/world/City.ibd’) | +---------------------------------------------------------+ | /usr/local/mysql/data/world/City.ibd | +---------------------------------------------------------+ A value that matches the value of system variable  sysvar  is replaced with the string  @@GLOBAL. sysvar .