The branch, master has been updated via 62800876ff7d4be58d2149a1d6987ebd8d381826 (commit) via d2bee66fc4183e6a0fc04964b8096f5b1ee36f7d (commit) from 1129eb5ae34780361b33fbcae68000cc3d9aba8a (commit)
- Log ----------------------------------------------------------------- commit 62800876ff7d4be58d2149a1d6987ebd8d381826 Author: Michal Čihař mcihar@novell.com Date: Wed Mar 16 11:52:34 2011 +0100
Coding style, use small icon
commit d2bee66fc4183e6a0fc04964b8096f5b1ee36f7d Author: Samiran Raj Boro srajbr@gmail.com Date: Wed Mar 16 11:51:09 2011 +0100
server variables documentation link in server_variables.php
- $doclink is not used anymore as we dont use the value after echo the link - $VARIABLE_DOC_LINKS is first check isset() because it might not be stored in our ./libraries/server_variables_doc.php
if any new variables are introduced in new version of MySQL it must be added to server_variable_doc.php to display the link
-----------------------------------------------------------------------
Summary of changes: ChangeLog | 1 + libraries/server_variables_doc.php | 348 ++++++++++++++++++++++++++++++++++++ server_variables.php | 11 ++ 3 files changed, 360 insertions(+), 0 deletions(-) create mode 100644 libraries/server_variables_doc.php
diff --git a/ChangeLog b/ChangeLog index 0bd7a8a..e570b21 100644 --- a/ChangeLog +++ b/ChangeLog @@ -147,6 +147,7 @@ - rfe #1168350 [interface] Add clear button to SQL edit box. - [core] Update library PHPExcel to version 1.7.6 - bug #3206876 [core] Work without mbstring installed. +- rfe #3196075, patch #3212068 [interface] Add links to variables documentation.
3.3.10.0 (not yet released) - patch #3147400 [structure] Aria table size printed as unknown, diff --git a/libraries/server_variables_doc.php b/libraries/server_variables_doc.php new file mode 100644 index 0000000..3e8faa8 --- /dev/null +++ b/libraries/server_variables_doc.php @@ -0,0 +1,348 @@ +<?php +/** + * Used to create server variables documentation links + * $VARIABLE_DOC_LINKS[string $name] = array(string $anchor, string $chapter, string $type); + * string $name: name of the system variable + * string $anchor: anchor to the documentation page + * string $chapter: chapter of "HTML, one page per chapter" documentation + * string $type: type of system variable + */ +$VARIABLE_DOC_LINKS = array(); +$VARIABLE_DOC_LINKS['auto_increment_increment'] = array('auto_increment_increment','replication-options-master','sysvar'); +$VARIABLE_DOC_LINKS['auto_increment_offset'] = array('auto_increment_offset','replication-options-master','sysvar'); +$VARIABLE_DOC_LINKS['autocommit'] = array('autocommit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['automatic_sp_privileges'] = array('automatic_sp_privileges','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['back_log'] = array('back_log','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['basedir'] = array('basedir','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['big_tables'] = array('big-tables','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['bind_address'] = array('bind-address','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['binlog_cache_size'] = array('binlog_cache_size','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['binlog_direct_non_transactional_updates'] = array('binlog_direct_non_transactional_updates','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['binlog_format'] = array('binlog-format','server-options','sysvar'); +$VARIABLE_DOC_LINKS['binlog_stmt_cache_size'] = array('binlog_stmt_cache_size','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['bulk_insert_buffer_size'] = array('bulk_insert_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_set_client'] = array('character_set_client','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_set_connection'] = array('character_set_connection','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_set_database'] = array('character_set_database','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_set_filesystem'] = array('character-set-filesystem','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['character_set_results'] = array('character_set_results','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_set_server'] = array('character-set-server','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['character_set_system'] = array('character_set_system','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['character_sets_dir'] = array('character-sets-dir','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['collation_connection'] = array('collation_connection','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['collation_database'] = array('collation_database','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['collation_server'] = array('collation-server','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['completion_type'] = array('completion_type','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['concurrent_insert'] = array('concurrent_insert','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['connect_timeout'] = array('connect_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['datadir'] = array('datadir','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['date_format'] = array('date_format','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['datetime_format'] = array('datetime_format','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['debug'] = array('debug','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['debug_sync'] = array('debug_sync','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['default_storage_engine'] = array('default-storage-engine','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['default_week_format'] = array('default_week_format','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['delay_key_write'] = array('delay-key-write','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['delayed_insert_limit'] = array('delayed_insert_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['delayed_insert_timeout'] = array('delayed_insert_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['delayed_queue_size'] = array('delayed_queue_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['div_precision_increment'] = array('div_precision_increment','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['engine_condition_pushdown'] = array('engine-condition-pushdown','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['error_count'] = array('error_count','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['event_scheduler'] = array('event-scheduler','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['expire_logs_days'] = array('expire_logs_days','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['external_user'] = array('external_user','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['flush'] = array('flush','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['flush_time'] = array('flush_time','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['foreign_key_checks'] = array('foreign_key_checks','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ft_boolean_syntax'] = array('ft_boolean_syntax','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ft_max_word_len'] = array('ft_max_word_len','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ft_min_word_len'] = array('ft_min_word_len','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ft_query_expansion_limit'] = array('ft_query_expansion_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ft_stopword_file'] = array('ft_stopword_file','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['general_log'] = array('general-log','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['general_log_file'] = array('general_log_file','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['group_concat_max_len'] = array('group_concat_max_len','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_compress'] = array('have_compress','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_crypt'] = array('have_crypt','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_csv'] = array('have_csv','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_dynamic_loading'] = array('have_dynamic_loading','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_geometry'] = array('have_geometry','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_innodb'] = array('have_innodb','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_openssl'] = array('have_openssl','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_partitioning'] = array('have_partitioning','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_profiling'] = array('have_profiling','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_query_cache'] = array('have_query_cache','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_rtree_keys'] = array('have_rtree_keys','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_ssl'] = array('have_ssl','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['have_symlink'] = array('have_symlink','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['hostname'] = array('hostname','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['identity'] = array('identity','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ignore_builtin_innodb'] = array('ignore-builtin-innodb','innodb-parameters','option_mysqld'); +$VARIABLE_DOC_LINKS['init_connect'] = array('init_connect','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['init_file'] = array('init-file','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['init_slave'] = array('init_slave','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['innodb_adaptive_flushing'] = array('innodb_adaptive_flushing','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_adaptive_hash_index'] = array('innodb_adaptive_hash_index','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_additional_mem_pool_size'] = array('innodb_additional_mem_pool_size','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_autoextend_increment'] = array('innodb_autoextend_increment','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_autoinc_lock_mode'] = array('innodb_autoinc_lock_mode','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_buffer_pool_instances'] = array('innodb_buffer_pool_instances','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_buffer_pool_size'] = array('innodb_buffer_pool_size','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_change_buffering'] = array('innodb_change_buffering','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_checksums'] = array('innodb_checksums','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_commit_concurrency'] = array('innodb_commit_concurrency','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_concurrency_tickets'] = array('innodb_concurrency_tickets','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_data_file_path'] = array('innodb_data_file_path','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_data_home_dir'] = array('innodb_data_home_dir','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_doublewrite'] = array('innodb_doublewrite','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_fast_shutdown'] = array('innodb_fast_shutdown','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_file_format'] = array('innodb_file_format','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_file_format_check'] = array('innodb_file_format_check','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_file_format_max'] = array('innodb_file_format_max','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_file_per_table'] = array('innodb_file_per_table','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_flush_log_at_trx_commit'] = array('innodb_flush_log_at_trx_commit','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_flush_method'] = array('innodb_flush_method','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_force_recovery'] = array('innodb_force_recovery','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_io_capacity'] = array('innodb_io_capacity','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_lock_wait_timeout'] = array('innodb_lock_wait_timeout','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_locks_unsafe_for_binlog'] = array('innodb_locks_unsafe_for_binlog','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_log_buffer_size'] = array('innodb_log_buffer_size','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_log_file_size'] = array('innodb_log_file_size','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_log_files_in_group'] = array('innodb_log_files_in_group','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_log_group_home_dir'] = array('innodb_log_group_home_dir','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_max_dirty_pages_pct'] = array('innodb_max_dirty_pages_pct','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_max_purge_lag'] = array('innodb_max_purge_lag','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_mirrored_log_groups'] = array('innodb_mirrored_log_groups','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_old_blocks_pct'] = array('innodb_old_blocks_pct','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_old_blocks_time'] = array('innodb_old_blocks_time','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_open_files'] = array('innodb_open_files','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_purge_batch_size'] = array('innodb_purge_batch_size','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_purge_threads'] = array('innodb_purge_threads','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_read_ahead_threshold'] = array('innodb_read_ahead_threshold','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_read_io_threads'] = array('innodb_read_io_threads','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_replication_delay'] = array('innodb_replication_delay','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_rollback_on_timeout'] = array('innodb_rollback_on_timeout','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_spin_wait_delay'] = array('innodb_spin_wait_delay','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_stats_on_metadata'] = array('innodb_stats_on_metadata','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_stats_sample_pages'] = array('innodb_stats_sample_pages','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_strict_mode'] = array('innodb_strict_mode','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_support_xa'] = array('innodb_support_xa','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_sync_spin_loops'] = array('innodb_sync_spin_loops','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_table_locks'] = array('innodb_table_locks','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_thread_concurrency'] = array('innodb_thread_concurrency','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_thread_sleep_delay'] = array('innodb_thread_sleep_delay','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_use_native_aio'] = array('innodb_use_native_aio','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_use_sys_malloc'] = array('innodb_use_sys_malloc','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_version'] = array('innodb_version','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['innodb_write_io_threads'] = array('innodb_write_io_threads','innodb-parameters','sysvar'); +$VARIABLE_DOC_LINKS['insert_id'] = array('insert_id','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['interactive_timeout'] = array('interactive_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['join_buffer_size'] = array('join_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['keep_files_on_create'] = array('keep_files_on_create','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['key_buffer_size'] = array('key_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['key_cache_age_threshold'] = array('key_cache_age_threshold','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['key_cache_block_size'] = array('key_cache_block_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['key_cache_division_limit'] = array('key_cache_division_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['language'] = array('language','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['large_files_support'] = array('large_files_support','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['large_page_size'] = array('large_page_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['large_pages'] = array('large-pages','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['last_insert_id'] = array('last_insert_id','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['lc_messages'] = array('lc-messages','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['lc_messages_dir'] = array('lc-messages-dir','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['lc_time_names'] = array('lc_time_names','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['license'] = array('license','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['local_infile'] = array('local_infile','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['lock_wait_timeout'] = array('lock_wait_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['locked_in_memory'] = array('locked_in_memory','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['log'] = array('log','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['log_bin'] = array('log_bin','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['log-bin'] = array('log-bin','replication-options-binary-log','option_mysqld'); +$VARIABLE_DOC_LINKS['log_bin_trust_function_creators'] = array('log-bin-trust-function-creators','replication-options-binary-log','option_mysqld'); +$VARIABLE_DOC_LINKS['log_error'] = array('log-error','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['log_output'] = array('log-output','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['log_queries_not_using_indexes'] = array('log-queries-not-using-indexes','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['log_slave_updates'] = array('log-slave-updates','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['log_slow_queries'] = array('log-slow-queries','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['log_warnings'] = array('log-warnings','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['long_query_time'] = array('long_query_time','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['low_priority_updates'] = array('low-priority-updates','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['lower_case_file_system'] = array('lower_case_file_system','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['lower_case_table_names'] = array('lower_case_table_names','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['master-bind'] = array('','replication-options',0); +$VARIABLE_DOC_LINKS['max_allowed_packet'] = array('max_allowed_packet','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_binlog_cache_size'] = array('max_binlog_cache_size','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['max_binlog_size'] = array('max_binlog_size','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['max_binlog_stmt_cache_size'] = array('max_binlog_stmt_cache_size','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['max_connect_errors'] = array('max_connect_errors','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_connections'] = array('max_connections','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_delayed_threads'] = array('max_delayed_threads','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_error_count'] = array('max_error_count','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_heap_table_size'] = array('max_heap_table_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_insert_delayed_threads'] = array('max_insert_delayed_threads','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_join_size'] = array('max_join_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_length_for_sort_data'] = array('max_length_for_sort_data','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_prepared_stmt_count'] = array('max_prepared_stmt_count','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_relay_log_size'] = array('max_relay_log_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_seeks_for_key'] = array('max_seeks_for_key','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_sort_length'] = array('max_sort_length','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_sp_recursion_depth'] = array('max_sp_recursion_depth','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_tmp_tables'] = array('max_tmp_tables','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_user_connections'] = array('max_user_connections','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['max_write_lock_count'] = array('max_write_lock_count','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['memlock'] = array('memlock','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['min_examined_row_limit'] = array('min-examined-row-limit','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['myisam_data_pointer_size'] = array('myisam_data_pointer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_max_sort_file_size'] = array('myisam_max_sort_file_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_mmap_size'] = array('myisam_mmap_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_recover_options'] = array('myisam_recover_options','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_repair_threads'] = array('myisam_repair_threads','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_sort_buffer_size'] = array('myisam_sort_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_stats_method'] = array('myisam_stats_method','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['myisam_use_mmap'] = array('myisam_use_mmap','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['named_pipe'] = array('named_pipe','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['net_buffer_length'] = array('net_buffer_length','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['net_read_timeout'] = array('net_read_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['net_retry_count'] = array('net_retry_count','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['net_write_timeout'] = array('net_write_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['new'] = array('new','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['old'] = array('old','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['old_alter_table'] = array('old-alter-table','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['old_passwords'] = array('old-passwords','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['open_files_limit'] = array('open-files-limit','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['optimizer_prune_level'] = array('optimizer_prune_level','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['optimizer_search_depth'] = array('optimizer_search_depth','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['optimizer_switch'] = array('optimizer_switch','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['partition'] = array('partition','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['performance_schema'] = array('performance_schema','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_events_waits_history_long_size'] = array('performance_schema_events_waits_history_long_size','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_events_waits_history_size'] = array('performance_schema_events_waits_history_size','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_cond_classes'] = array('performance_schema_max_cond_classes','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_cond_instances'] = array('performance_schema_max_cond_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_file_classes'] = array('performance_schema_max_file_classes','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_file_handles'] = array('performance_schema_max_file_handles','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_file_instances'] = array('performance_schema_max_file_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_mutex_classes'] = array('performance_schema_max_mutex_classes','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_mutex_instances'] = array('performance_schema_max_mutex_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_rwlock_classes'] = array('performance_schema_max_rwlock_classes','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_rwlock_instances'] = array('performance_schema_max_rwlock_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_table_handles'] = array('performance_schema_max_table_handles','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_table_instances'] = array('performance_schema_max_table_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_thread_classes'] = array('performance_schema_max_thread_classes','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['performance_schema_max_thread_instances'] = array('performance_schema_max_thread_instances','performance-schema-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['pid_file'] = array('pid-file','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['plugin_dir'] = array('plugin_dir','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['port'] = array('port','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['preload_buffer_size'] = array('preload_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['profiling'] = array('profiling','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['profiling_history_size'] = array('profiling_history_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['protocol_version'] = array('protocol_version','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['proxy_user'] = array('proxy_user','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['pseudo_thread_id'] = array('pseudo_thread_id','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_alloc_block_size'] = array('query_alloc_block_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_cache_limit'] = array('query_cache_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_cache_min_res_unit'] = array('query_cache_min_res_unit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_cache_size'] = array('query_cache_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_cache_type'] = array('query_cache_type','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_cache_wlock_invalidate'] = array('query_cache_wlock_invalidate','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['query_prealloc_size'] = array('query_prealloc_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rand_seed1'] = array('rand_seed1','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rand_seed2'] = array('rand_seed2','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['range_alloc_block_size'] = array('range_alloc_block_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['read_buffer_size'] = array('read_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['read_only'] = array('read_only','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['read_rnd_buffer_size'] = array('read_rnd_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['relay-log-index'] = array('relay-log-index','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['relay_log_index'] = array('relay_log_index','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['relay_log_info_file'] = array('relay_log_info_file','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['relay_log_purge'] = array('relay_log_purge','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['relay_log_recovery'] = array('relay_log_recovery','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['relay_log_space_limit'] = array('relay_log_space_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['report_host'] = array('report-host','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['report_password'] = array('report-password','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['report_port'] = array('report-port','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['report_user'] = array('report-user','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['rpl_recovery_rank'] = array('rpl_recovery_rank','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_master_enabled'] = array('rpl_semi_sync_master_enabled','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_master_timeout'] = array('rpl_semi_sync_master_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_master_trace_level'] = array('rpl_semi_sync_master_trace_level','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_master_wait_no_slave'] = array('rpl_semi_sync_master_wait_no_slave','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_slave_enabled'] = array('rpl_semi_sync_slave_enabled','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['rpl_semi_sync_slave_trace_level'] = array('rpl_semi_sync_slave_trace_level','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['safe_show_database'] = array('safe-show-database','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['secure_auth'] = array('secure-auth','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['secure_file_priv'] = array('secure-file-priv','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['server_id'] = array('server-id','replication-options','option_mysqld'); +$VARIABLE_DOC_LINKS['shared_memory'] = array('shared_memory','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['shared_memory_base_name'] = array('shared_memory_base_name','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['skip_external_locking'] = array('skip-external-locking','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['skip_name_resolve'] = array('skip-name-resolve','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['skip_networking'] = array('skip-networking','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['skip_show_database'] = array('skip-show-database','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['slave_compressed_protocol'] = array('slave_compressed_protocol','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['slave_exec_mode'] = array('slave_exec_mode','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['slave_load_tmpdir'] = array('slave-load-tmpdir','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['slave_net_timeout'] = array('slave-net-timeout','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['slave_skip_errors'] = array('slave-skip-errors','replication-options-slave','option_mysqld'); +$VARIABLE_DOC_LINKS['slave_transaction_retries'] = array('slave_transaction_retries','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['slave_type_conversions'] = array('slave_type_conversions','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['slow_launch_time'] = array('slow_launch_time','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['slow_query_log'] = array('slow-query-log','server-options','server-system-variables'); +$VARIABLE_DOC_LINKS['slow_query_log_file'] = array('slow_query_log_file','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['socket'] = array('socket','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['sort_buffer_size'] = array('sort_buffer_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_auto_is_null'] = array('sql_auto_is_null','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_big_selects'] = array('sql_big_selects','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_big_tables'] = array('big-tables','server-options','server-system-variables'); +$VARIABLE_DOC_LINKS['sql_buffer_result'] = array('sql_buffer_result','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_log_bin'] = array('sql_log_bin','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_log_off'] = array('sql_log_off','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_log_update'] = array('sql_log_update','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_low_priority_updates'] = array('sql_low_priority_updates','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_max_join_size'] = array('sql_max_join_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_mode'] = array('sql-mode','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['sql_notes'] = array('sql_notes','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_quote_show_create'] = array('sql_quote_show_create','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_safe_updates'] = array('sql_safe_updates','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_select_limit'] = array('sql_select_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sql_slave_skip_counter'] = array('sql_slave_skip_counter','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['sql_warnings'] = array('sql_warnings','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['ssl_ca'] = array('ssl-ca','ssl-options','option_general'); +$VARIABLE_DOC_LINKS['ssl_capath'] = array('ssl-capath','ssl-options','option_general'); +$VARIABLE_DOC_LINKS['ssl_cert'] = array('ssl-cert','ssl-options','option_general'); +$VARIABLE_DOC_LINKS['ssl_cipher'] = array('ssl-cipher','ssl-options','option_general'); +$VARIABLE_DOC_LINKS['ssl_key'] = array('ssl-key','ssl-options','option_general'); +$VARIABLE_DOC_LINKS['storage_engine'] = array('storage_engine','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sync_binlog'] = array('sync_binlog','replication-options-binary-log','sysvar'); +$VARIABLE_DOC_LINKS['sync_frm'] = array('sync_frm','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['sync_master_info'] = array('sync_master_info','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['sync_relay_log'] = array('sync_relay_log','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['sync_relay_log_info'] = array('sync_relay_log_info','replication-options-slave','sysvar'); +$VARIABLE_DOC_LINKS['system_time_zone'] = array('system_time_zone','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['table_definition_cache'] = array('table_definition_cache','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['table_lock_wait_timeout'] = array('table_lock_wait_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['table_open_cache'] = array('table_open_cache','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['table_type'] = array('table_type','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['thread_cache_size'] = array('thread_cache_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['thread_concurrency'] = array('thread_concurrency','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['thread_handling'] = array('thread_handling','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['thread_stack'] = array('thread_stack','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['time_format'] = array('time_format','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['time_zone'] = array('time_zone','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['timed_mutexes'] = array('timed_mutexes','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['timestamp'] = array('timestamp','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['tmp_table_size'] = array('tmp_table_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['tmpdir'] = array('tmpdir','server-options','option_mysqld'); +$VARIABLE_DOC_LINKS['transaction_alloc_block_size'] = array('transaction_alloc_block_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['transaction_prealloc_size'] = array('transaction_prealloc_size','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['tx_isolation'] = array('tx_isolation','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['unique_checks'] = array('unique_checks','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['updatable_views_with_limit'] = array('updatable_views_with_limit','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['version'] = array('version','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['version_comment'] = array('version_comment','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['version_compile_machine'] = array('version_compile_machine','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['version_compile_os'] = array('version_compile_os','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['wait_timeout'] = array('wait_timeout','server-system-variables','sysvar'); +$VARIABLE_DOC_LINKS['warning_count'] = array('warning_count','server-system-variables','sysvar'); +?> diff --git a/server_variables.php b/server_variables.php index f601fe8..d909a41 100644 --- a/server_variables.php +++ b/server_variables.php @@ -27,6 +27,11 @@ require './libraries/server_links.inc.php';
/** + * Required to display documentation links + */ +require './libraries/server_variables_doc.php'; + +/** * Displays the sub-page heading */ echo '<h2>' . "\n" @@ -55,6 +60,7 @@ $serverVarsGlobal = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES;', 0, 1); echo __('Session value') . ' / ' . __('Global value'); ?> </th> + <th><?php echo __('Documentation'); ?></th> </tr> </thead> <tbody> @@ -79,6 +85,10 @@ foreach ($serverVars as $name => $value) { $is_numeric = false; } ?></td> + <td class="value"><?php + if (isset($VARIABLE_DOC_LINKS[$name])) // To display variable documentation link + echo PMA_showMySQLDocu($VARIABLE_DOC_LINKS[$name][1], $VARIABLE_DOC_LINKS[$name][1], false, $VARIABLE_DOC_LINKS[$name][2] . '_' . $VARIABLE_DOC_LINKS[$name][0]); + ?></td> <?php if ($serverVarsGlobal[$name] !== $value) { ?> @@ -94,6 +104,7 @@ foreach ($serverVars as $name => $value) { echo htmlspecialchars($serverVarsGlobal[$name]); } ?></td> + <td class="value"></td> <?php } ?> </tr> <?php
hooks/post-receive