(mysql.info) show-variables

 
 13.5.4.24 `SHOW VARIABLES' Syntax
 .................................
 
      SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'PATTERN']
 
 `SHOW VARIABLES' shows the values of MySQL system variables. This
 information also can be obtained using the `mysqladmin variables'
 command.
 
 With the `GLOBAL' modifier, `SHOW VARIABLES' displays the values that
 are used for new connections to MySQL. With `SESSION', it displays the
 values that are in effect for the current connection. If no modifier is
 present, the default is `SESSION'. `LOCAL' is a synonym for `SESSION'.
 
 If the default system variable values are unsuitable, you can set them
 using command options when `mysqld' starts, and most can be changed at
 runtime with the `SET' statement. See  using-system-variables,
 and  set-option.
 
 Partial output is shown here. The list of names and values may be
 different for your server.   server-system-variables, describes
 the meaning of each variable, and  server-parameters, provides
 information about tuning them.
 
      mysql> SHOW VARIABLES;
      +---------------------------------+-------------------------------------+
      | Variable_name                   | Value                               |
      +---------------------------------+-------------------------------------+
      | auto_increment_increment        | 1                                   |
      | auto_increment_offset           | 1                                   |
      | automatic_sp_privileges         | ON                                  |
      | back_log                        | 50                                  |
      | basedir                         | /                                   |
      | bdb_cache_size                  | 8388600                             |
      | bdb_home                        | /var/lib/mysql/                     |
      | bdb_log_buffer_size             | 32768                               |
      ...
      | max_connections                 | 100                                 |
      | max_connect_errors              | 10                                  |
      | max_delayed_threads             | 20                                  |
      | max_error_count                 | 64                                  |
      | max_heap_table_size             | 16777216                            |
      | max_join_size                   | 4294967295                          |
      | max_relay_log_size              | 0                                   |
      | max_sort_length                 | 1024                                |
      ...
      | time_zone                       | SYSTEM                              |
      | timed_mutexes                   | OFF                                 |
      | tmp_table_size                  | 33554432                            |
      | tmpdir                          |                                     |
      | transaction_alloc_block_size    | 8192                                |
      | transaction_prealloc_size       | 4096                                |
      | tx_isolation                    | REPEATABLE-READ                     |
      | updatable_views_with_limit      | YES                                 |
      | version                         | 5.0.19-Max                          |
      | version_comment                 | MySQL Community Edition - Max (GPL) |
      | version_compile_machine         | i686                                |
      | version_compile_os              | pc-linux-gnu                        |
      | wait_timeout                    | 28800                               |
      +---------------------------------+-------------------------------------+
 
 With a `LIKE' clause, the statement displays only those variables that
 match the pattern. To obtain a specific variable name, use a `LIKE'
 clause as shown:
 
      SHOW VARIABLES LIKE 'max_join_size';
      SHOW SESSION VARIABLES LIKE 'max_join_size';
 
 To get a list of variables whose name match a pattern, use the
 ‘`%'’ wildcard character in a `LIKE' clause:
 
      SHOW VARIABLES LIKE '%size%';
      SHOW GLOBAL VARIABLES LIKE '%size%';
 
 Wildcard characters can be used in any position within the pattern to
 be matched. Strictly speaking, because ‘`_'’ is a wildcard that
 matches any single character, you should escape it as ‘`\_'’ to
 match it literally. In practice, this is rarely necessary.
Info Catalog
(mysql.info) show-triggers
(mysql.info) show
(mysql.info) show-warnings
automatically generated byinfo2html