Lists the Environment configuration metrics and provides a brief description of each.
Table 5.7 Environment Configuration Metrics
| Name | Description |
|---|---|
| Basedir (Total) | The MySQL installation base directory. |
| Core File Enabled (Total) | Whether to write a core file if the server crashes. |
| Datadir (Total) | The MySQL data directory. |
| Hostname (Total) | The server sets this variable to the server host name at startup. |
| Ignore DB Dirs (Total) | A comma-separated list of names that are not considered as database directories in the data directory. |
| Init File (Total) | The name of the file specified with the --init-file option when you start the server. |
| Keep Files On Create Enabled (Total) | If a MyISAM table is created with a DATA DIRECTORY or INDEX DIRECTORY option and an existing .MYD or .MYI file is found, MyISAM always returns an error. |
| Large Files Support Enabled (Total) | Whether mysqld was compiled with options for large file support. |
| Large Pages Enabled (Total) | Whether large page support is enabled (via the --large-pages option). |
| Large Page Size (Total) | If large page support is enabled, this shows the size of memory pages. |
| Locked In Memory Enabled (Total) | Whether mysqld was locked in memory with --memlock. |
| Lower Case File System Enabled (Total) | Whether the file system where the data directory is locatedis case sensitive or not. |
| New Mode Enabled (Total) | This variable was used in MySQL 4.0 to turn on some 4.1 behaviors, and is retained for backward compatibility. |
| Old Mode Enabled (Total) | When enabled, changes the default scope of index hints to that used prior to MySQL 5.1.17. That is, index hints with no FOR clause apply only to how indexes are used for row retrieval and not to resolution of ORDER BY or GROUP BY clauses. |
| Open Files Limit (Total) | The maximum number of file descriptors available to mysqld. |
| Pid File (Total) | The path name of the process ID file. |
| Plugin Dir (Total) | The path name of the plugin directory. |
| Skip External Locking Enabled (Total) | This is OFF if mysqld uses external locking, ON if external locking is disabled. |
| SQL Mode (Total) | Sql modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. |
| Tmpdir (Total) | The path of the directory to use for creating temporary files. |