Author: mcbrown
Date: 2007-07-20 13:31:12 +0200 (Fri, 20 Jul 2007)
New Revision: 7161
Log:
Enabling dynamically generated table of dynamic system variables
Modified:
trunk/refman-5.0/dba-core.xml
Modified: trunk/refman-5.0/dba-core.xml
===================================================================
--- trunk/refman-5.0/dba-core.xml 2007-07-19 20:47:53 UTC (rev 7160)
+++ trunk/refman-5.0/dba-core.xml 2007-07-20 11:31:12 UTC (rev 7161)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 753; 34221 bytes
@@ -8141,760 +8141,8 @@
enumeration value corresponds to 1.
</para>
-<!-- para condition="dynamic:optvar:dynamicvarsummary" role="5.0:mysqld:all"/ -->
+ <para condition="dynamic:optvar:dynamicvarsummary" role="5.0:mysqld:all"/>
- <informaltable>
- <tgroup cols="3">
- <colspec colwidth="50*"/>
- <colspec colwidth="20*"/>
- <colspec colwidth="30*"/>
- <tbody>
- <row>
- <entry><emphasis role="bold">Variable Name</emphasis></entry>
- <entry><emphasis role="bold">Value Type</emphasis></entry>
- <entry><emphasis role="bold">Type</emphasis></entry>
- </row>
- <row>
- <entry><literal>autocommit</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>automatic_sp_privileges</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>big_tables</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>binlog_cache_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>bulk_insert_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>character_set_client</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>character_set_connection</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal>
-
- <remark>
- character_set_database can be changed, but don't
- advertise this variable as being dynamic because
- the server changes it automatically as necessary.
- </remark></entry>
- </row>
- <row>
- <entry><literal>character_set_filesystem</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>character_set_results</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>character_set_server</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>collation_connection</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
-<!--
-<remark>Don't advertise this variable as being dynamic...</remark>
- <row>
- <entry>
- <literal>collation_database</literal>
- </entry>
- <entry>
- string
- </entry>
- <entry>
- <literal>GLOBAL</literal> | <literal>SESSION</literal>
- </entry>
- </row>
--->
- <row>
- <entry><literal>collation_server</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>completion_type</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>concurrent_insert</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>connect_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
-<!--
- <remark role="todo">
- next one commented out because although it exists, it's
- not implemented.
- </remark>
- <row>
- <entry><literal>date_format</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
--->
-<!--
- <remark role="todo">
- next one commented out because although it exists, it's
- not implemented.
- </remark>
- <row>
- <entry><literal>datetime_format</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
--->
- <row>
- <entry><literal>default_week_format</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>delay_key_write</literal></entry>
- <entry><literal>OFF</literal> | <literal>ON</literal> | <literal>ALL</literal></entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>delayed_insert_limit</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>delayed_insert_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>delayed_queue_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>div_precision_increment</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>engine_condition_pushdown</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>error_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>expire_logs_days</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>flush</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>flush_time</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>foreign_key_checks</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>ft_boolean_syntax</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>group_concat_max_len</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>identity</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_autoextend_increment</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_commit_concurrency</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_concurrency_tickets</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_max_dirty_pages_pct</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_max_purge_lag</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_support_xa</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_sync_spin_loops</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_table_locks</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_thread_concurrency</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>innodb_thread_sleep_delay</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>insert_id</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>interactive_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>join_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>key_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><remark role="todo">
- missing key_cache_xxx variables?
- </remark>
-
- <literal>last_insert_id</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>lc_time_names</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>local_infile</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>log_queries_not_using_indexes</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>log_warnings</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>long_query_time</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>low_priority_updates</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_allowed_packet</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_binlog_cache_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_binlog_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_connect_errors</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_connections</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_delayed_threads</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_error_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_heap_table_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_insert_delayed_threads</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_join_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_prepared_stmt_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_relay_log_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_seeks_for_key</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_sort_length</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_tmp_tables</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>max_user_connections</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>max_write_lock_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>multi_range_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>myisam_data_pointer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>log_bin_trust_function_creators</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>myisam_max_sort_file_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>myisam_repair_threads</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>myisam_sort_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>myisam_stats_method</literal></entry>
- <entry>enum</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>net_buffer_length</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>net_read_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>net_retry_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>net_write_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>old_passwords</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>optimizer_prune_level</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>optimizer_search_depth</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>preload_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>profiling</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>profiling_history_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>query_alloc_block_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>query_cache_limit</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>query_cache_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>query_cache_type</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>query_cache_wlock_invalidate</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>query_prealloc_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>range_alloc_block_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>read_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>read_only</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>read_rnd_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>rpl_recovery_rank</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>safe_show_database</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>secure_auth</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>server_id</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>slave_compressed_protocol</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>slave_net_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>slave_transaction_retries</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>slow_launch_time</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>sort_buffer_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_auto_is_null</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_big_selects</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_big_tables</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_buffer_result</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_log_bin</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_log_off</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_log_update</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_low_priority_updates</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_max_join_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_mode</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_notes</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_quote_show_create</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_safe_updates</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_select_limit</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_slave_skip_counter</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>updatable_views_with_limit</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sql_warnings</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>sync_binlog</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>sync_frm</literal></entry>
- <entry>boolean</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>storage_engine</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>table_cache</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
- <row>
- <entry><literal>table_type</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>thread_cache_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal></entry>
- </row>
-<!--
- <remark role="todo">
- next one commented out because although it exists, it's not implemented.
- </remark>
-
- <row>
- <entry><literal>time_format</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
--->
- <row>
- <entry><literal>time_zone</literal></entry>
- <entry>string</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>timestamp</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>tmp_table_size</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>transaction_alloc_block_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>transaction_prealloc_size</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>tx_isolation</literal></entry>
- <entry>enumeration</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>unique_checks</literal></entry>
- <entry>boolean</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>wait_timeout</literal></entry>
- <entry>numeric</entry>
- <entry><literal>GLOBAL</literal> | <literal>SESSION</literal></entry>
- </row>
- <row>
- <entry><literal>warning_count</literal></entry>
- <entry>numeric</entry>
- <entry><literal>SESSION</literal></entry>
- </row>
- </tbody>
- </tgroup>
- </informaltable>
-
<formalpara role="mnmas">
<title>MySQL Enterprise</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7161 - trunk/refman-5.0 | mcbrown | 20 Jul |
