## 27.12.14.2 Performance Schema variables_info Table 

The value listed for the variable in mysqld-auto.cnf . 

persisted_variables  has these indexes: 

•Primary key on ( VARIABLE_NAME ) 

TRUNCATE TABLE  is not permitted for the persisted_variables  table. 

The variables_info  table shows, for each system variable, the source from which it was most recently set, and its range of values. 

The variables_info  table has these columns: 

## • VARIABLE_NAME 

The variable name. 

## • VARIABLE_SOURCE 

The source from which the variable was most recently set: 

## • COMMAND_LINE 

The variable was set on the command line. 

## • COMPILED 

The variable has its compiled-in default value. COMPILED  is the value used for variables not set any other way. 

## • DYNAMIC 

The variable was set at runtime. This includes variables set within files specified using the init_file system variable. 

## • EXPLICIT 

The variable was set from an option file named with the --defaults-file  option. 

## • EXTRA 

The variable was set from an option file named with the --defaults-extra-file  option. 

## • GLOBAL 

The variable was set from a global option file. This includes option files not covered by EXPLICIT , EXTRA , LOGIN , PERSISTED , SERVER , or USER . 

## • LOGIN 

The variable was set from a user-specific login path file ( ~/.mylogin.cnf ). 

## • PERSISTED 

The variable was set from a server-specific mysqld-auto.cnf  option file. No row has this value if the server was started with persisted_globals_load  disabled. 

