slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory basedir 

A value that matches the value of system variable sysvar  is replaced with the string @@GLOBAL. sysvar . 

## Parameters 

## Return Value 

## Example 

## 28.4.5.5 The format_statement() Function 

• path VARCHAR(512) : The path name to format. 

A VARCHAR(512) CHARACTER SET utf8  value. 

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 | +---------------------------------------------------------+ 

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 ( ... ). 

This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. 

## Parameters 

## Configuration Options 

• statement LONGTEXT : The statement to format. 

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_truncate_len , @sys.statement_truncate_len 

The maximum length of statements returned by the format_statement()  function. Longer statements are truncated to this length. The default is 64. 

## Return Value 

## Example 

A LONGTEXT  value. 

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: 

mysql> SET @stmt = ’SELECT variable, value, set_time, set_by FROM sys_config’; mysql> SELECT sys.format_statement(@stmt); 

