2 /* vim: set expandtab sw=4 ts=4 sts=4: */
5 * functions for displaying server variables
7 * @usedby server_variables.php
11 if (! defined('PHPMYADMIN')) {
16 * Get Ajax return when $_REQUEST['type'] === 'getval'
18 * @param Array $variable_doc_links documentation links
22 function PMA_getAjaxReturnForGetVal($variable_doc_links)
24 $response = PMA_Response
::getInstance();
26 // Send with correct charset
27 header('Content-Type: text/html; charset=UTF-8');
28 // Do not use double quotes inside the query to avoid a problem
29 // when server is running in ANSI_QUOTES sql_mode
30 $varValue = $GLOBALS['dbi']->fetchSingleRow(
31 'SHOW GLOBAL VARIABLES WHERE Variable_name=\''
32 . PMA_Util
::sqlAddSlashes($_REQUEST['varName']) . '\';',
35 if (isset($variable_doc_links[$_REQUEST['varName']][3])
36 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
41 ' ', PMA_Util
::formatByteDown($varValue[1], 3, 3)
52 * Get Ajax return when $_REQUEST['type'] === 'setval'
54 * @param Array $variable_doc_links documentation links
58 function PMA_getAjaxReturnForSetVal($variable_doc_links)
60 $response = PMA_Response
::getInstance();
62 $value = $_REQUEST['varValue'];
65 if (isset($variable_doc_links[$_REQUEST['varName']][3])
66 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
68 '/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i',
81 $value = floatval($matches[1]) * PMA_Util
::pow(
83 $exp[/*overload*/mb_strtolower($matches[3])]
86 $value = PMA_Util
::sqlAddSlashes($value);
89 if (! is_numeric($value)) {
90 $value="'" . $value . "'";
93 if (! preg_match("/[^a-zA-Z0-9_]+/", $_REQUEST['varName'])
94 && $GLOBALS['dbi']->query(
95 'SET GLOBAL ' . $_REQUEST['varName'] . ' = ' . $value
98 // Some values are rounded down etc.
99 $varValue = $GLOBALS['dbi']->fetchSingleRow(
100 'SHOW GLOBAL VARIABLES WHERE Variable_name="'
101 . PMA_Util
::sqlAddSlashes($_REQUEST['varName'])
107 $_REQUEST['varName'],
113 $response->isSuccess(false);
116 __('Setting variable failed')
124 * @param string $name variable name
125 * @param number $value variable value
126 * @param array $variable_doc_links documentation links
128 * @return string formatted string
130 function PMA_formatVariable($name, $value, $variable_doc_links)
132 if (is_numeric($value)) {
133 if (isset($variable_doc_links[$name][3])
134 && $variable_doc_links[$name][3]=='byte'
136 return '<abbr title="'
137 . PMA_Util
::formatNumber($value, 0) . '">'
138 . implode(' ', PMA_Util
::formatByteDown($value, 3, 3))
141 return PMA_Util
::formatNumber($value, 0);
144 return htmlspecialchars($value);
148 * Prints link templates
152 function PMA_getHtmlForLinkTemplates()
154 $url = 'server_variables.php' . PMA_URL_getCommon();
155 $output = '<a style="display: none;" href="'
156 . $url . '" class="ajax saveLink">';
157 $output .= PMA_Util
::getIcon('b_save.png', __('Save')) . '</a> ';
158 $output .= '<a style="display: none;" href="#" class="cancelLink">';
159 $output .= PMA_Util
::getIcon('b_close.png', __('Cancel')) . '</a> ';
160 $output .= PMA_Util
::getImage(
163 array('style' => 'display:none', 'id' => 'docImage')
169 * Prints Html for Server Variables
171 * @param Array $variable_doc_links documentation links
172 * @param Array $serverVars global variables
173 * @param Array $serverVarsSession session variables
177 function PMA_getHtmlForServerVariables(
178 $variable_doc_links, $serverVars, $serverVarsSession
180 $value = ! empty($_REQUEST['filter'])
181 ?
htmlspecialchars($_REQUEST['filter'])
183 $output = '<fieldset id="tableFilter">'
184 . '<legend>' . __('Filters') . '</legend>'
185 . '<div class="formelement">'
186 . '<label for="filterText">' . __('Containing the word:') . '</label>'
187 . '<input name="filterText" type="text" id="filterText"'
188 . ' style="vertical-align: baseline;" value="' . $value . '" />'
192 $output .= '<table id="serverVariables" class="data filteredData noclick">'
193 . '<thead><tr class="var-header var-row">'
194 . '<td class="var-action">' . __('Action') . '</td>'
195 . '<td class="var-name">' . __('Variable') . '</td>'
196 . '<td class="var-value">'
197 . __('Session value') . ' / ' . __('Global value')
202 $output .= PMA_getHtmlForServerVariablesItems(
203 $variable_doc_links, $serverVars, $serverVarsSession
206 $output .= '</table>';
213 * Prints Html for Server Variables Items
215 * @param Array $variable_doc_links documentation links
216 * @param Array $serverVars global variables
217 * @param Array $serverVarsSession session variables
221 function PMA_getHtmlForServerVariablesItems(
222 $variable_doc_links, $serverVars, $serverVarsSession
224 // list of static system variables
225 $static_variables = PMA_getStaticSystemVariables();
229 foreach ($serverVars as $name => $value) {
230 $has_session_value = isset($serverVarsSession[$name])
231 && $serverVarsSession[$name] != $value;
232 $row_class = ($odd_row ?
' odd' : ' even')
233 . ($has_session_value ?
' diffSession' : '');
235 $output .= '<tr class="var-row' . $row_class . '">';
237 $output .= '<td class="var-action">';
239 // Edit Link active only for Dynamic System variables
240 if (! in_array(strtolower($name), $static_variables)) {
241 $output .= '<a href="#" class="editLink">'
242 . PMA_Util
::getIcon('b_edit.png', __('Edit')) . '</a>';
244 $output .= '<span title="'
245 . __('This is a read-only variable and can not be edited')
246 . '" class="read_only_var" >'
247 . PMA_Util
::getIcon('bd_edit.png', __('Edit'))
253 $output .= '<td class="var-name">';
254 // To display variable documentation link
255 if (isset($variable_doc_links[$name])) {
256 $output .= '<span title="'
257 . htmlspecialchars(str_replace('_', ' ', $name)) . '">';
258 $output .= PMA_Util
::showMySQLDocu(
259 $variable_doc_links[$name][1],
261 $variable_doc_links[$name][2] . '_' . $variable_doc_links[$name][0],
264 $output .= htmlspecialchars(str_replace('_', ' ', $name));
266 $output .= '</span>';
268 $output .= htmlspecialchars(str_replace('_', ' ', $name));
272 $output .= '<td class="var-value value'
273 . ($GLOBALS['dbi']->isSuperuser() ?
' editable' : '') . '"> '
274 . PMA_formatVariable($name, $value, $variable_doc_links)
278 if ($has_session_value) {
279 $output .= '<tr class="var-row' . ($odd_row ?
' odd' : ' even') . '">'
280 . '<td class="var-action"></td>'
281 . '<td class="var-name session">(' . __('Session value') . ')</td>'
282 . '<td class="var-value value"> '
283 . PMA_formatVariable(
285 $serverVarsSession[$name],
291 $odd_row = ! $odd_row;
293 $output .= '</tbody>';
299 * Returns Array of documentation links
301 * $variable_doc_links[string $name] = array(
307 * string $name: name of the system variable
308 * string $anchor: anchor to the documentation page
309 * string $chapter: chapter of "HTML, one page per chapter" documentation
310 * string $type: type of system variable
311 * string $format: if set to 'byte' it will format the variable
312 * with PMA_Util::formatByteDown()
316 function PMA_getArrayForDocumentLinks()
318 $variable_doc_links = array();
319 $variable_doc_links['auto_increment_increment'] = array(
320 'auto_increment_increment',
321 'replication-options-master',
323 $variable_doc_links['auto_increment_offset'] = array(
324 'auto_increment_offset',
325 'replication-options-master',
327 $variable_doc_links['autocommit'] = array(
329 'server-system-variables',
331 $variable_doc_links['automatic_sp_privileges'] = array(
332 'automatic_sp_privileges',
333 'server-system-variables',
335 $variable_doc_links['back_log'] = array(
337 'server-system-variables',
339 $variable_doc_links['basedir'] = array(
343 $variable_doc_links['big_tables'] = array(
347 $variable_doc_links['bind_address'] = array(
351 $variable_doc_links['binlog_cache_size'] = array(
353 'replication-options-binary-log',
356 $variable_doc_links['binlog_checksum'] = array(
358 'replication-options-binary-log',
360 $variable_doc_links['binlog_direct_non_transactional_updates'] = array(
361 'binlog_direct_non_transactional_updates',
362 'replication-options-binary-log',
364 $variable_doc_links['binlog_format'] = array(
368 $variable_doc_links['binlog_max_flush_queue_time'] = array(
369 'binlog_max_flush_queue_time',
370 'replication-options-binary-log',
372 $variable_doc_links['binlog_order_commits'] = array(
373 'binlog_order_commits',
374 'replication-options-binary-log',
376 $variable_doc_links['binlog_row_image'] = array(
378 'replication-options-binary-log',
380 $variable_doc_links['binlog_rows_query_log_events'] = array(
381 'binlog_rows_query_log_events',
382 'replication-options-binary-log',
384 $variable_doc_links['binlog_stmt_cache_size'] = array(
385 'binlog_stmt_cache_size',
386 'replication-options-binary-log',
389 $variable_doc_links['block_encryption_mode'] = array(
390 'block_encryption_mode',
391 'server-system-variables',
393 $variable_doc_links['bulk_insert_buffer_size'] = array(
394 'bulk_insert_buffer_size',
395 'server-system-variables',
398 $variable_doc_links['character_set_client'] = array(
399 'character_set_client',
400 'server-system-variables',
402 $variable_doc_links['character_set_connection'] = array(
403 'character_set_connection',
404 'server-system-variables',
406 $variable_doc_links['character_set_database'] = array(
407 'character_set_database',
408 'server-system-variables',
410 $variable_doc_links['character_set_filesystem'] = array(
411 'character-set-filesystem',
414 $variable_doc_links['character_set_results'] = array(
415 'character_set_results',
416 'server-system-variables',
418 $variable_doc_links['character_set_server'] = array(
419 'character-set-server',
422 $variable_doc_links['character_set_system'] = array(
423 'character_set_system',
424 'server-system-variables',
426 $variable_doc_links['character_sets_dir'] = array(
427 'character-sets-dir',
430 $variable_doc_links['collation_connection'] = array(
431 'collation_connection',
432 'server-system-variables',
434 $variable_doc_links['collation_database'] = array(
435 'collation_database',
436 'server-system-variables',
438 $variable_doc_links['collation_server'] = array(
442 $variable_doc_links['completion_type'] = array(
444 'server-system-variables',
446 $variable_doc_links['concurrent_insert'] = array(
448 'server-system-variables',
450 $variable_doc_links['connect_timeout'] = array(
452 'server-system-variables',
454 $variable_doc_links['core_file'] = array(
456 'server-system-variables',
458 $variable_doc_links['datadir'] = array(
462 $variable_doc_links['date_format'] = array(
464 'server-system-variables',
466 $variable_doc_links['datetime_format'] = array(
468 'server-system-variables',
470 $variable_doc_links['debug'] = array(
474 $variable_doc_links['debug_sync'] = array(
476 'server-system-variables',
478 $variable_doc_links['default_storage_engine'] = array(
479 'default-storage-engine',
482 $variable_doc_links['default_tmp_storage_engine'] = array(
483 'default_tmp_storage_engine',
484 'server-system-variables',
486 $variable_doc_links['default_week_format'] = array(
487 'default_week_format',
488 'server-system-variables',
490 $variable_doc_links['delay_key_write'] = array(
494 $variable_doc_links['delayed_insert_limit'] = array(
495 'delayed_insert_limit',
496 'server-system-variables',
498 $variable_doc_links['delayed_insert_timeout'] = array(
499 'delayed_insert_timeout',
500 'server-system-variables',
502 $variable_doc_links['delayed_queue_size'] = array(
503 'delayed_queue_size',
504 'server-system-variables',
506 $variable_doc_links['disconnect_on_expired_password'] = array(
507 'disconnect_on_expired_password',
508 'server-system-variables',
510 $variable_doc_links['div_precision_increment'] = array(
511 'div_precision_increment',
512 'server-system-variables',
514 $variable_doc_links['end_markers_in_json'] = array(
515 'end_markers_in_json',
516 'server-system-variables',
518 $variable_doc_links['enforce_gtid_consistency'] = array(
519 'enforce_gtid_consistency',
520 'replication-options-gtids',
522 $variable_doc_links['eq_range_index_dive_limit'] = array(
523 'eq_range_index_dive_limit',
524 'server-system-variables',
526 $variable_doc_links['engine_condition_pushdown'] = array(
527 'engine-condition-pushdown',
530 $variable_doc_links['error_count'] = array(
532 'server-system-variables',
534 $variable_doc_links['event_scheduler'] = array(
538 $variable_doc_links['expire_logs_days'] = array(
540 'server-system-variables',
542 $variable_doc_links['explicit_defaults_for_timestamp'] = array(
543 'explicit_defaults_for_timestamp',
544 'server-system-variables',
546 $variable_doc_links['external_user'] = array(
548 'server-system-variables',
550 $variable_doc_links['flush'] = array(
552 'server-system-variables',
554 $variable_doc_links['flush_time'] = array(
556 'server-system-variables',
558 $variable_doc_links['foreign_key_checks'] = array(
559 'foreign_key_checks',
560 'server-system-variables',
562 $variable_doc_links['ft_boolean_syntax'] = array(
564 'server-system-variables',
566 $variable_doc_links['ft_max_word_len'] = array(
568 'server-system-variables',
570 $variable_doc_links['ft_min_word_len'] = array(
572 'server-system-variables',
574 $variable_doc_links['ft_query_expansion_limit'] = array(
575 'ft_query_expansion_limit',
576 'server-system-variables',
578 $variable_doc_links['ft_stopword_file'] = array(
580 'server-system-variables',
582 $variable_doc_links['general_log'] = array(
586 $variable_doc_links['general_log_file'] = array(
588 'server-system-variables',
590 $variable_doc_links['group_concat_max_len'] = array(
591 'group_concat_max_len',
592 'server-system-variables',
594 $variable_doc_links['gtid_executed'] = array(
596 'replication-options-gtids',
598 $variable_doc_links['gtid_mode'] = array(
600 'replication-options-gtids',
602 $variable_doc_links['gtid_owned'] = array(
604 'replication-options-gtids',
606 $variable_doc_links['gtid_purged'] = array(
608 'replication-options-gtids',
610 $variable_doc_links['have_compress'] = array(
612 'server-system-variables',
614 $variable_doc_links['have_crypt'] = array(
616 'server-system-variables',
618 $variable_doc_links['have_csv'] = array(
620 'server-system-variables',
622 $variable_doc_links['have_dynamic_loading'] = array(
623 'have_dynamic_loading',
624 'server-system-variables',
626 $variable_doc_links['have_geometry'] = array(
628 'server-system-variables',
630 $variable_doc_links['have_innodb'] = array(
632 'server-system-variables',
634 $variable_doc_links['have_ndbcluster'] = array(
636 'mysql-cluster-system-variables',
638 $variable_doc_links['have_openssl'] = array(
640 'server-system-variables',
642 $variable_doc_links['have_partitioning'] = array(
644 'server-system-variables',
646 $variable_doc_links['have_profiling'] = array(
648 'server-system-variables',
650 $variable_doc_links['have_query_cache'] = array(
652 'server-system-variables',
654 $variable_doc_links['have_rtree_keys'] = array(
656 'server-system-variables',
658 $variable_doc_links['have_ssl'] = array(
660 'server-system-variables',
662 $variable_doc_links['have_symlink'] = array(
664 'server-system-variables',
666 $variable_doc_links['host_cache_size'] = array(
668 'server-system-variables',
670 $variable_doc_links['hostname'] = array(
672 'server-system-variables',
674 $variable_doc_links['identity'] = array(
676 'server-system-variables',
678 $variable_doc_links['ignore_builtin_innodb'] = array(
679 'ignore-builtin-innodb',
682 $variable_doc_links['ignore_db_dirs'] = array(
684 'server-system-variables',
686 $variable_doc_links['init_connect'] = array(
688 'server-system-variables',
690 $variable_doc_links['init_file'] = array(
694 $variable_doc_links['init_slave'] = array(
696 'replication-options-slave',
698 $variable_doc_links['innodb_adaptive_flushing'] = array(
699 'innodb_adaptive_flushing',
702 $variable_doc_links['innodb_adaptive_flushing_lwm'] = array(
703 'innodb_adaptive_flushing_lwm',
706 $variable_doc_links['innodb_adaptive_hash_index'] = array(
707 'innodb_adaptive_hash_index',
710 $variable_doc_links['innodb_adaptive_max_sleep_delay'] = array(
711 'innodb_adaptive_max_sleep_delay',
714 $variable_doc_links['innodb_additional_mem_pool_size'] = array(
715 'innodb_additional_mem_pool_size',
719 $variable_doc_links['innodb_api_bk_commit_interval'] = array(
720 'innodb_api_bk_commit_interval',
723 $variable_doc_links['innodb_api_disable_rowlock'] = array(
724 'innodb_api_disable_rowlock',
727 $variable_doc_links['innodb_api_enable_binlog'] = array(
728 'innodb_api_enable_binlog',
731 $variable_doc_links['innodb_api_enable_mdl'] = array(
732 'innodb_api_enable_mdl',
735 $variable_doc_links['innodb_api_trx_level'] = array(
736 'innodb_api_trx_level',
739 $variable_doc_links['innodb_autoextend_increment'] = array(
740 'innodb_autoextend_increment',
743 $variable_doc_links['innodb_autoinc_lock_mode'] = array(
744 'innodb_autoinc_lock_mode',
747 $variable_doc_links['innodb_buffer_pool_dump_at_shutdown'] = array(
748 'innodb_buffer_pool_dump_at_shutdown',
751 $variable_doc_links['innodb_buffer_pool_dump_now'] = array(
752 'innodb_buffer_pool_dump_now',
755 $variable_doc_links['innodb_buffer_pool_filename'] = array(
756 'innodb_buffer_pool_filename',
759 $variable_doc_links['innodb_buffer_pool_instances'] = array(
760 'innodb_buffer_pool_instances',
763 $variable_doc_links['innodb_buffer_pool_load_abort'] = array(
764 'innodb_buffer_pool_load_abort',
767 $variable_doc_links['innodb_buffer_pool_load_at_startup'] = array(
768 'innodb_buffer_pool_load_at_startup',
771 $variable_doc_links['innodb_buffer_pool_load_now'] = array(
772 'innodb_buffer_pool_load_now',
775 $variable_doc_links['innodb_buffer_pool_size'] = array(
776 'innodb_buffer_pool_size',
780 $variable_doc_links['innodb_change_buffer_max_size'] = array(
781 'innodb_change_buffer_max_size',
784 $variable_doc_links['innodb_change_buffering'] = array(
785 'innodb_change_buffering',
788 $variable_doc_links['innodb_checksum_algorithm'] = array(
789 'innodb_checksum_algorithm',
792 $variable_doc_links['innodb_checksums'] = array(
796 $variable_doc_links['innodb_cmp_per_index_enabled'] = array(
797 'innodb_cmp_per_index_enabled',
800 $variable_doc_links['innodb_commit_concurrency'] = array(
801 'innodb_commit_concurrency',
804 $variable_doc_links['innodb_compression_failure_threshold_pct'] = array(
805 'innodb_compression_failure_threshold_pct',
808 $variable_doc_links['innodb_compression_level'] = array(
809 'innodb_compression_level',
812 $variable_doc_links['innodb_compression_pad_pct_max'] = array(
813 'innodb_compression_pad_pct_max',
816 $variable_doc_links['innodb_concurrency_tickets'] = array(
817 'innodb_concurrency_tickets',
820 $variable_doc_links['innodb_data_file_path'] = array(
821 'innodb_data_file_path',
824 $variable_doc_links['innodb_data_home_dir'] = array(
825 'innodb_data_home_dir',
828 $variable_doc_links['innodb_disable_sort_file_cache'] = array(
829 'innodb_disable_sort_file_cache',
832 $variable_doc_links['innodb_doublewrite'] = array(
833 'innodb_doublewrite',
836 $variable_doc_links['innodb_fast_shutdown'] = array(
837 'innodb_fast_shutdown',
840 $variable_doc_links['innodb_file_format'] = array(
841 'innodb_file_format',
844 $variable_doc_links['innodb_file_format_check'] = array(
845 'innodb_file_format_check',
848 $variable_doc_links['innodb_file_format_max'] = array(
849 'innodb_file_format_max',
852 $variable_doc_links['innodb_file_per_table'] = array(
853 'innodb_file_per_table',
856 $variable_doc_links['innodb_flush_log_at_timeout'] = array(
857 'innodb_flush_log_at_timeout',
860 $variable_doc_links['innodb_flush_log_at_trx_commit'] = array(
861 'innodb_flush_log_at_trx_commit',
864 $variable_doc_links['innodb_flush_method'] = array(
865 'innodb_flush_method',
868 $variable_doc_links['innodb_flush_neighbors'] = array(
869 'innodb_flush_neighbors',
872 $variable_doc_links['innodb_flushing_avg_loops'] = array(
873 'innodb_flushing_avg_loops',
876 $variable_doc_links['innodb_force_load_corrupted'] = array(
877 'innodb_force_load_corrupted',
880 $variable_doc_links['innodb_force_recovery'] = array(
881 'innodb_force_recovery',
884 $variable_doc_links['innodb_ft_aux_table'] = array(
885 'innodb_ft_aux_table',
888 $variable_doc_links['innodb_ft_cache_size'] = array(
889 'innodb_ft_cache_size',
892 $variable_doc_links['innodb_ft_enable_diag_print'] = array(
893 'innodb_ft_enable_diag_print',
896 $variable_doc_links['innodb_ft_enable_stopword'] = array(
897 'innodb_ft_enable_stopword',
900 $variable_doc_links['innodb_ft_max_token_size'] = array(
901 'innodb_ft_max_token_size',
904 $variable_doc_links['innodb_ft_min_token_size'] = array(
905 'innodb_ft_min_token_size',
908 $variable_doc_links['innodb_ft_num_word_optimize'] = array(
909 'innodb_ft_num_word_optimize',
912 $variable_doc_links['innodb_ft_result_cache_limit'] = array(
913 'innodb_ft_result_cache_limit',
916 $variable_doc_links['innodb_ft_server_stopword_table'] = array(
917 'innodb_ft_server_stopword_table',
920 $variable_doc_links['innodb_ft_sort_pll_degree'] = array(
921 'innodb_ft_sort_pll_degree',
924 $variable_doc_links['innodb_ft_total_cache_size'] = array(
925 'innodb_ft_total_cache_size',
928 $variable_doc_links['innodb_ft_user_stopword_table'] = array(
929 'innodb_ft_user_stopword_table',
932 $variable_doc_links['innodb_io_capacity'] = array(
933 'innodb_io_capacity',
936 $variable_doc_links['innodb_io_capacity_max'] = array(
937 'innodb_io_capacity_max',
940 $variable_doc_links['innodb_large_prefix'] = array(
941 'innodb_large_prefix',
944 $variable_doc_links['innodb_lock_wait_timeout'] = array(
945 'innodb_lock_wait_timeout',
948 $variable_doc_links['innodb_locks_unsafe_for_binlog'] = array(
949 'innodb_locks_unsafe_for_binlog',
952 $variable_doc_links['innodb_log_buffer_size'] = array(
953 'innodb_log_buffer_size',
957 $variable_doc_links['innodb_log_compressed_pages'] = array(
958 'innodb_log_compressed_pages',
961 $variable_doc_links['innodb_log_file_size'] = array(
962 'innodb_log_file_size',
966 $variable_doc_links['innodb_log_files_in_group'] = array(
967 'innodb_log_files_in_group',
970 $variable_doc_links['innodb_log_group_home_dir'] = array(
971 'innodb_log_group_home_dir',
974 $variable_doc_links['innodb_lru_scan_depth'] = array(
975 'innodb_lru_scan_depth',
978 $variable_doc_links['innodb_max_dirty_pages_pct'] = array(
979 'innodb_max_dirty_pages_pct',
982 $variable_doc_links['innodb_max_dirty_pages_pct_lwm'] = array(
983 'innodb_max_dirty_pages_pct_lwm',
986 $variable_doc_links['innodb_max_purge_lag'] = array(
987 'innodb_max_purge_lag',
990 $variable_doc_links['innodb_max_purge_lag_delay'] = array(
991 'innodb_max_purge_lag_delay',
994 $variable_doc_links['innodb_mirrored_log_groups'] = array(
995 'innodb_mirrored_log_groups',
998 $variable_doc_links['innodb_monitor_disable'] = array(
999 'innodb_monitor_disable',
1000 'innodb-parameters',
1002 $variable_doc_links['innodb_monitor_enable'] = array(
1003 'innodb_monitor_enable',
1004 'innodb-parameters',
1006 $variable_doc_links['innodb_monitor_reset'] = array(
1007 'innodb_monitor_reset',
1008 'innodb-parameters',
1010 $variable_doc_links['innodb_monitor_reset_all'] = array(
1011 'innodb_monitor_reset_all',
1012 'innodb-parameters',
1014 $variable_doc_links['innodb_old_blocks_pct'] = array(
1015 'innodb_old_blocks_pct',
1016 'innodb-parameters',
1018 $variable_doc_links['innodb_old_blocks_time'] = array(
1019 'innodb_old_blocks_time',
1020 'innodb-parameters',
1022 $variable_doc_links['innodb_online_alter_log_max_size'] = array(
1023 'innodb_online_alter_log_max_size',
1024 'innodb-parameters',
1026 $variable_doc_links['innodb_open_files'] = array(
1027 'innodb_open_files',
1028 'innodb-parameters',
1030 $variable_doc_links['innodb_optimize_fulltext_only'] = array(
1031 'innodb_optimize_fulltext_only',
1032 'innodb-parameters',
1034 $variable_doc_links['innodb_page_size'] = array(
1036 'innodb-parameters',
1038 $variable_doc_links['innodb_print_all_deadlocks'] = array(
1039 'innodb_print_all_deadlocks',
1040 'innodb-parameters',
1042 $variable_doc_links['innodb_purge_batch_size'] = array(
1043 'innodb_purge_batch_size',
1044 'innodb-parameters',
1046 $variable_doc_links['innodb_purge_threads'] = array(
1047 'innodb_purge_threads',
1048 'innodb-parameters',
1050 $variable_doc_links['innodb_random_read_ahead'] = array(
1051 'innodb_random_read_ahead',
1052 'innodb-parameters',
1054 $variable_doc_links['innodb_read_ahead_threshold'] = array(
1055 'innodb_read_ahead_threshold',
1056 'innodb-parameters',
1058 $variable_doc_links['innodb_read_io_threads'] = array(
1059 'innodb_read_io_threads',
1060 'innodb-parameters',
1062 $variable_doc_links['innodb_read_only'] = array(
1064 'innodb-parameters',
1066 $variable_doc_links['innodb_replication_delay'] = array(
1067 'innodb_replication_delay',
1068 'innodb-parameters',
1070 $variable_doc_links['innodb_rollback_on_timeout'] = array(
1071 'innodb_rollback_on_timeout',
1072 'innodb-parameters',
1074 $variable_doc_links['innodb_rollback_segments'] = array(
1075 'innodb_rollback_segments',
1076 'innodb-parameters',
1078 $variable_doc_links['innodb_sort_buffer_size'] = array(
1079 'innodb_sort_buffer_size',
1080 'innodb-parameters',
1082 $variable_doc_links['innodb_spin_wait_delay'] = array(
1083 'innodb_spin_wait_delay',
1084 'innodb-parameters',
1086 $variable_doc_links['innodb_stats_auto_recalc'] = array(
1087 'innodb_stats_auto_recalc',
1088 'innodb-parameters',
1090 $variable_doc_links['innodb_stats_method'] = array(
1091 'innodb_stats_method',
1092 'innodb-parameters',
1094 $variable_doc_links['innodb_stats_on_metadata'] = array(
1095 'innodb_stats_on_metadata',
1096 'innodb-parameters',
1098 $variable_doc_links['innodb_stats_persistent'] = array(
1099 'innodb_stats_persistent',
1100 'innodb-parameters',
1102 $variable_doc_links['innodb_stats_persistent_sample_pages'] = array(
1103 'innodb_stats_persistent_sample_pages',
1104 'innodb-parameters',
1106 $variable_doc_links['innodb_stats_sample_pages'] = array(
1107 'innodb_stats_sample_pages',
1108 'innodb-parameters',
1110 $variable_doc_links['innodb_stats_transient_sample_pages'] = array(
1111 'innodb_stats_transient_sample_pages',
1112 'innodb-parameters',
1114 $variable_doc_links['innodb_status_output'] = array(
1115 'innodb_status_output',
1116 'innodb-parameters',
1118 $variable_doc_links['innodb_status_output_locks'] = array(
1119 'innodb_status_output_locks',
1120 'innodb-parameters',
1122 $variable_doc_links['innodb_strict_mode'] = array(
1123 'innodb_strict_mode',
1124 'innodb-parameters',
1126 $variable_doc_links['innodb_support_xa'] = array(
1127 'innodb_support_xa',
1128 'innodb-parameters',
1130 $variable_doc_links['innodb_sync_array_size'] = array(
1131 'innodb_sync_array_size',
1132 'innodb-parameters',
1134 $variable_doc_links['innodb_sync_spin_loops'] = array(
1135 'innodb_sync_spin_loops',
1136 'innodb-parameters',
1138 $variable_doc_links['innodb_table_locks'] = array(
1139 'innodb_table_locks',
1140 'innodb-parameters',
1142 $variable_doc_links['innodb_thread_concurrency'] = array(
1143 'innodb_thread_concurrency',
1144 'innodb-parameters',
1146 $variable_doc_links['innodb_thread_sleep_delay'] = array(
1147 'innodb_thread_sleep_delay',
1148 'innodb-parameters',
1150 $variable_doc_links['innodb_undo_directory'] = array(
1151 'innodb_undo_directory',
1152 'innodb-parameters',
1154 $variable_doc_links['innodb_undo_logs'] = array(
1156 'innodb-parameters',
1158 $variable_doc_links['innodb_undo_tablespaces'] = array(
1159 'innodb_undo_tablespaces',
1160 'innodb-parameters',
1162 $variable_doc_links['innodb_use_native_aio'] = array(
1163 'innodb_use_native_aio',
1164 'innodb-parameters',
1166 $variable_doc_links['innodb_use_sys_malloc'] = array(
1167 'innodb_use_sys_malloc',
1168 'innodb-parameters',
1170 $variable_doc_links['innodb_version'] = array(
1172 'innodb-parameters',
1174 $variable_doc_links['innodb_write_io_threads'] = array(
1175 'innodb_write_io_threads',
1176 'innodb-parameters',
1178 $variable_doc_links['insert_id'] = array(
1180 'server-system-variables',
1182 $variable_doc_links['interactive_timeout'] = array(
1183 'interactive_timeout',
1184 'server-system-variables',
1186 $variable_doc_links['join_buffer_size'] = array(
1188 'server-system-variables',
1191 $variable_doc_links['keep_files_on_create'] = array(
1192 'keep_files_on_create',
1193 'server-system-variables',
1195 $variable_doc_links['key_buffer_size'] = array(
1197 'server-system-variables',
1200 $variable_doc_links['key_cache_age_threshold'] = array(
1201 'key_cache_age_threshold',
1202 'server-system-variables',
1204 $variable_doc_links['key_cache_block_size'] = array(
1205 'key_cache_block_size',
1206 'server-system-variables',
1209 $variable_doc_links['key_cache_division_limit'] = array(
1210 'key_cache_division_limit',
1211 'server-system-variables',
1213 $variable_doc_links['language'] = array(
1217 $variable_doc_links['large_files_support'] = array(
1218 'large_files_support',
1219 'server-system-variables',
1221 $variable_doc_links['large_page_size'] = array(
1223 'server-system-variables',
1226 $variable_doc_links['large_pages'] = array(
1230 $variable_doc_links['last_insert_id'] = array(
1232 'server-system-variables',
1234 $variable_doc_links['lc_messages'] = array(
1238 $variable_doc_links['lc_messages_dir'] = array(
1242 $variable_doc_links['lc_time_names'] = array(
1244 'server-system-variables',
1246 $variable_doc_links['license'] = array(
1248 'server-system-variables',
1250 $variable_doc_links['local_infile'] = array(
1252 'server-system-variables',
1254 $variable_doc_links['lock_wait_timeout'] = array(
1255 'lock_wait_timeout',
1256 'server-system-variables',
1258 $variable_doc_links['locked_in_memory'] = array(
1260 'server-system-variables',
1262 $variable_doc_links['log'] = array(
1266 $variable_doc_links['log_bin'] = array(
1268 'replication-options-binary-log',
1270 $variable_doc_links['log-bin'] = array(
1272 'replication-options-binary-log',
1274 $variable_doc_links['log_bin_basename'] = array(
1276 'replication-options-binary-log',
1278 $variable_doc_links['log_bin_index'] = array(
1280 'replication-options-binary-log',
1282 $variable_doc_links['log_bin_trust_function_creators'] = array(
1283 'log-bin-trust-function-creators',
1284 'replication-options-binary-log',
1286 $variable_doc_links['log_bin_use_v1_row_events'] = array(
1287 'log_bin_use_v1_row_events',
1288 'replication-options-binary-log',
1290 $variable_doc_links['log_error'] = array(
1294 $variable_doc_links['log_output'] = array(
1298 $variable_doc_links['log_queries_not_using_indexes'] = array(
1299 'log-queries-not-using-indexes',
1302 $variable_doc_links['log_slave_updates'] = array(
1303 'log-slave-updates',
1304 'replication-options-slave',
1306 $variable_doc_links['log_slow_admin_statements'] = array(
1307 'log_slow_admin_statements',
1308 'server-system-variables',
1310 $variable_doc_links['log_slow_slave_statements'] = array(
1311 'log_slow_slave_statements',
1312 'replication-options-slave',
1314 $variable_doc_links['log_throttle_queries_not_using_indexes'] = array(
1315 'log_throttle_queries_not_using_indexes',
1316 'server-system-variables',
1318 $variable_doc_links['log_slow_queries'] = array(
1322 $variable_doc_links['log_warnings'] = array(
1326 $variable_doc_links['long_query_time'] = array(
1328 'server-system-variables',
1330 $variable_doc_links['low_priority_updates'] = array(
1331 'low-priority-updates',
1334 $variable_doc_links['lower_case_file_system'] = array(
1335 'lower_case_file_system',
1336 'server-system-variables',
1338 $variable_doc_links['lower_case_table_names'] = array(
1339 'lower_case_table_names',
1340 'server-system-variables',
1342 $variable_doc_links['master_info_repository'] = array(
1343 'master_info_repository',
1344 'replication-options-slave',
1346 $variable_doc_links['master_verify_checksum'] = array(
1347 'master_verify_checksum',
1348 'replication-options-binary-log',
1350 $variable_doc_links['master-bind'] = array(
1352 'replication-options',
1354 $variable_doc_links['max_allowed_packet'] = array(
1355 'max_allowed_packet',
1356 'server-system-variables',
1358 $variable_doc_links['max_binlog_cache_size'] = array(
1359 'max_binlog_cache_size',
1360 'replication-options-binary-log',
1363 $variable_doc_links['max_binlog_size'] = array(
1365 'replication-options-binary-log',
1368 $variable_doc_links['max_binlog_stmt_cache_size'] = array(
1369 'max_binlog_stmt_cache_size',
1370 'replication-options-binary-log',
1373 $variable_doc_links['max_connect_errors'] = array(
1374 'max_connect_errors',
1375 'server-system-variables',
1377 $variable_doc_links['max_connections'] = array(
1379 'server-system-variables',
1381 $variable_doc_links['max_delayed_threads'] = array(
1382 'max_delayed_threads',
1383 'server-system-variables',
1385 $variable_doc_links['max_error_count'] = array(
1387 'server-system-variables',
1389 $variable_doc_links['max_heap_table_size'] = array(
1390 'max_heap_table_size',
1391 'server-system-variables',
1394 $variable_doc_links['max_insert_delayed_threads'] = array(
1395 'max_insert_delayed_threads',
1396 'server-system-variables',
1398 $variable_doc_links['max_join_size'] = array(
1400 'server-system-variables',
1402 $variable_doc_links['max_length_for_sort_data'] = array(
1403 'max_length_for_sort_data',
1404 'server-system-variables',
1406 $variable_doc_links['max_long_data_size'] = array(
1407 'max_long_data_size',
1408 'server-system-variables',
1410 $variable_doc_links['max_prepared_stmt_count'] = array(
1411 'max_prepared_stmt_count',
1412 'server-system-variables',
1414 $variable_doc_links['max_relay_log_size'] = array(
1415 'max_relay_log_size',
1416 'server-system-variables',
1419 $variable_doc_links['max_seeks_for_key'] = array(
1420 'max_seeks_for_key',
1421 'server-system-variables',
1423 $variable_doc_links['max_sort_length'] = array(
1425 'server-system-variables',
1427 $variable_doc_links['max_sp_recursion_depth'] = array(
1428 'max_sp_recursion_depth',
1429 'server-system-variables',
1431 $variable_doc_links['max_tmp_tables'] = array(
1433 'server-system-variables',
1435 $variable_doc_links['max_user_connections'] = array(
1436 'max_user_connections',
1437 'server-system-variables',
1439 $variable_doc_links['max_write_lock_count'] = array(
1440 'max_write_lock_count',
1441 'server-system-variables',
1443 $variable_doc_links['metadata_locks_cache_size'] = array(
1444 'metadata_locks_cache_size',
1445 'server-system-variables',
1447 $variable_doc_links['metadata_locks_hash_instances'] = array(
1448 'metadata_locks_hash_instances',
1449 'server-system-variables',
1451 $variable_doc_links['memlock'] = array(
1455 $variable_doc_links['min_examined_row_limit'] = array(
1456 'min-examined-row-limit',
1459 $variable_doc_links['multi_range_count'] = array(
1460 'multi_range_count',
1461 'server-system-variables',
1463 $variable_doc_links['myisam_data_pointer_size'] = array(
1464 'myisam_data_pointer_size',
1465 'server-system-variables',
1468 $variable_doc_links['myisam_max_sort_file_size'] = array(
1469 'myisam_max_sort_file_size',
1470 'server-system-variables',
1473 $variable_doc_links['myisam_mmap_size'] = array(
1475 'server-system-variables',
1478 $variable_doc_links['myisam_recover_options'] = array(
1479 'myisam_recover_options',
1480 'server-system-variables',
1482 $variable_doc_links['myisam_repair_threads'] = array(
1483 'myisam_repair_threads',
1484 'server-system-variables',
1486 $variable_doc_links['myisam_sort_buffer_size'] = array(
1487 'myisam_sort_buffer_size',
1488 'server-system-variables',
1491 $variable_doc_links['myisam_stats_method'] = array(
1492 'myisam_stats_method',
1493 'server-system-variables',
1495 $variable_doc_links['myisam_use_mmap'] = array(
1497 'server-system-variables',
1499 $variable_doc_links['named_pipe'] = array(
1501 'server-system-variables',
1503 $variable_doc_links['net_buffer_length'] = array(
1504 'net_buffer_length',
1505 'server-system-variables',
1507 $variable_doc_links['net_read_timeout'] = array(
1509 'server-system-variables',
1511 $variable_doc_links['net_retry_count'] = array(
1513 'server-system-variables',
1515 $variable_doc_links['net_write_timeout'] = array(
1516 'net_write_timeout',
1517 'server-system-variables',
1519 $variable_doc_links['new'] = array(
1521 'server-system-variables',
1523 $variable_doc_links['old'] = array(
1525 'server-system-variables',
1527 $variable_doc_links['old_alter_table'] = array(
1531 $variable_doc_links['old_passwords'] = array(
1535 $variable_doc_links['open_files_limit'] = array(
1539 $variable_doc_links['optimizer_prune_level'] = array(
1540 'optimizer_prune_level',
1541 'server-system-variables',
1543 $variable_doc_links['optimizer_search_depth'] = array(
1544 'optimizer_search_depth',
1545 'server-system-variables',
1547 $variable_doc_links['optimizer_switch'] = array(
1549 'server-system-variables',
1551 $variable_doc_links['optimizer_trace'] = array(
1553 'server-system-variables',
1555 $variable_doc_links['optimizer_trace_features'] = array(
1556 'optimizer_trace_features',
1557 'server-system-variables',
1559 $variable_doc_links['optimizer_trace_limit'] = array(
1560 'optimizer_trace_limit',
1561 'server-system-variables',
1563 $variable_doc_links['optimizer_trace_max_mem_size'] = array(
1564 'optimizer_trace_max_mem_size',
1565 'server-system-variables',
1567 $variable_doc_links['optimizer_trace_offset'] = array(
1568 'optimizer_trace_offset',
1569 'server-system-variables',
1571 $variable_doc_links['partition'] = array(
1575 $variable_doc_links['performance_schema'] = array(
1576 'performance_schema',
1577 'performance-schema-system-variables',
1579 $variable_doc_links['performance_schema_accounts_size'] = array(
1580 'performance_schema_accounts_size',
1581 'performance-schema-system-variables',
1583 $variable_doc_links['performance_schema_digests_size'] = array(
1584 'performance_schema_digests_size',
1585 'performance-schema-system-variables',
1587 $variable_doc_links['performance_schema_events_stages_history_long_size']
1589 'performance_schema_events_stages_history_long_size',
1590 'performance-schema-system-variables',
1593 $variable_doc_links['performance_schema_events_stages_history_size'] = array(
1594 'performance_schema_events_stages_history_size',
1595 'performance-schema-system-variables',
1597 $variable_doc_links['performance_schema_events_statements_history_long_size']
1599 'performance_schema_events_statements_history_long_size',
1600 'performance-schema-system-variables',
1603 $variable_doc_links['performance_schema_events_statements_history_size'] = array(
1604 'performance_schema_events_statements_history_size',
1605 'performance-schema-system-variables',
1607 $variable_doc_links['performance_schema_events_waits_history_long_size'] = array(
1608 'performance_schema_events_waits_history_long_size',
1609 'performance-schema-system-variables',
1611 $variable_doc_links['performance_schema_events_waits_history_size'] = array(
1612 'performance_schema_events_waits_history_size',
1613 'performance-schema-system-variables',
1615 $variable_doc_links['performance_schema_hosts_size'] = array(
1616 'performance_schema_hosts_size',
1617 'performance-schema-system-variables',
1619 $variable_doc_links['performance_schema_max_cond_classes'] = array(
1620 'performance_schema_max_cond_classes',
1621 'performance-schema-system-variables',
1623 $variable_doc_links['performance_schema_max_cond_instances'] = array(
1624 'performance_schema_max_cond_instances',
1625 'performance-schema-system-variables',
1627 $variable_doc_links['performance_schema_max_file_classes'] = array(
1628 'performance_schema_max_file_classes',
1629 'performance-schema-system-variables',
1631 $variable_doc_links['performance_schema_max_file_handles'] = array(
1632 'performance_schema_max_file_handles',
1633 'performance-schema-system-variables',
1635 $variable_doc_links['performance_schema_max_file_instances'] = array(
1636 'performance_schema_max_file_instances',
1637 'performance-schema-system-variables',
1639 $variable_doc_links['performance_schema_max_mutex_classes'] = array(
1640 'performance_schema_max_mutex_classes',
1641 'performance-schema-system-variables',
1643 $variable_doc_links['performance_schema_max_mutex_instances'] = array(
1644 'performance_schema_max_mutex_instances',
1645 'performance-schema-system-variables',
1647 $variable_doc_links['performance_schema_max_rwlock_classes'] = array(
1648 'performance_schema_max_rwlock_classes',
1649 'performance-schema-system-variables',
1651 $variable_doc_links['performance_schema_max_rwlock_instances'] = array(
1652 'performance_schema_max_rwlock_instances',
1653 'performance-schema-system-variables',
1655 $variable_doc_links['performance_schema_max_socket_classes'] = array(
1656 'performance_schema_max_socket_classes',
1657 'performance-schema-system-variables',
1659 $variable_doc_links['performance_schema_max_socket_instances'] = array(
1660 'performance_schema_max_socket_instances',
1661 'performance-schema-system-variables',
1663 $variable_doc_links['performance_schema_max_stage_classes'] = array(
1664 'performance_schema_max_stage_classes',
1665 'performance-schema-system-variables',
1667 $variable_doc_links['performance_schema_max_statement_classes'] = array(
1668 'performance_schema_max_statement_classes',
1669 'performance-schema-system-variables',
1671 $variable_doc_links['performance_schema_max_table_handles'] = array(
1672 'performance_schema_max_table_handles',
1673 'performance-schema-system-variables',
1675 $variable_doc_links['performance_schema_max_table_instances'] = array(
1676 'performance_schema_max_table_instances',
1677 'performance-schema-system-variables',
1679 $variable_doc_links['performance_schema_max_thread_classes'] = array(
1680 'performance_schema_max_thread_classes',
1681 'performance-schema-system-variables',
1683 $variable_doc_links['performance_schema_max_thread_instances'] = array(
1684 'performance_schema_max_thread_instances',
1685 'performance-schema-system-variables',
1687 $variable_doc_links['performance_schema_session_connect_attrs_size'] = array(
1688 'performance_schema_session_connect_attrs_size',
1689 'performance-schema-system-variables',
1691 $variable_doc_links['performance_schema_setup_actors_size'] = array(
1692 'performance_schema_setup_actors_size',
1693 'performance-schema-system-variables',
1695 $variable_doc_links['performance_schema_setup_objects_size'] = array(
1696 'performance_schema_setup_objects_size',
1697 'performance-schema-system-variables',
1699 $variable_doc_links['performance_schema_users_size'] = array(
1700 'performance_schema_users_size',
1701 'performance-schema-system-variables',
1703 $variable_doc_links['pid_file'] = array(
1707 $variable_doc_links['plugin_dir'] = array(
1709 'server-system-variables',
1711 $variable_doc_links['port'] = array(
1715 $variable_doc_links['preload_buffer_size'] = array(
1716 'preload_buffer_size',
1717 'server-system-variables',
1720 $variable_doc_links['profiling'] = array(
1722 'server-system-variables',
1724 $variable_doc_links['profiling_history_size'] = array(
1725 'profiling_history_size',
1726 'server-system-variables',
1728 $variable_doc_links['protocol_version'] = array(
1730 'server-system-variables',
1732 $variable_doc_links['proxy_user'] = array(
1734 'server-system-variables',
1736 $variable_doc_links['pseudo_thread_id'] = array(
1738 'server-system-variables',
1740 $variable_doc_links['query_alloc_block_size'] = array(
1741 'query_alloc_block_size',
1742 'server-system-variables',
1745 $variable_doc_links['query_cache_limit'] = array(
1746 'query_cache_limit',
1747 'server-system-variables',
1750 $variable_doc_links['query_cache_min_res_unit'] = array(
1751 'query_cache_min_res_unit',
1752 'server-system-variables',
1754 $variable_doc_links['query_cache_size'] = array(
1756 'server-system-variables',
1759 $variable_doc_links['query_cache_type'] = array(
1761 'server-system-variables',
1763 $variable_doc_links['query_cache_wlock_invalidate'] = array(
1764 'query_cache_wlock_invalidate',
1765 'server-system-variables',
1767 $variable_doc_links['query_prealloc_size'] = array(
1768 'query_prealloc_size',
1769 'server-system-variables',
1772 $variable_doc_links['rand_seed1'] = array(
1774 'server-system-variables',
1776 $variable_doc_links['rand_seed2'] = array(
1778 'server-system-variables',
1780 $variable_doc_links['range_alloc_block_size'] = array(
1781 'range_alloc_block_size',
1782 'server-system-variables',
1785 $variable_doc_links['read_buffer_size'] = array(
1787 'server-system-variables',
1790 $variable_doc_links['read_only'] = array(
1792 'server-system-variables',
1794 $variable_doc_links['read_rnd_buffer_size'] = array(
1795 'read_rnd_buffer_size',
1796 'server-system-variables',
1799 $variable_doc_links['relay_log'] = array(
1801 'replication-options-slave',
1803 $variable_doc_links['relay_log_basename'] = array(
1804 'relay_log_basename',
1805 'replication-options-slave',
1807 $variable_doc_links['relay-log-index'] = array(
1809 'replication-options-slave',
1811 $variable_doc_links['relay_log_index'] = array(
1813 'replication-options-slave',
1815 $variable_doc_links['relay_log_info_file'] = array(
1816 'relay_log_info_file',
1817 'replication-options-slave',
1819 $variable_doc_links['relay_log_info_repository'] = array(
1820 'relay_log_info_repository',
1821 'replication-options-slave',
1823 $variable_doc_links['relay_log_purge'] = array(
1825 'server-system-variables',
1827 $variable_doc_links['relay_log_recovery'] = array(
1828 'relay_log_recovery',
1829 'replication-options-slave',
1831 $variable_doc_links['relay_log_space_limit'] = array(
1832 'relay_log_space_limit',
1833 'server-system-variables',
1835 $variable_doc_links['report_host'] = array(
1837 'replication-options-slave',
1839 $variable_doc_links['report_password'] = array(
1841 'replication-options-slave',
1843 $variable_doc_links['report_port'] = array(
1845 'replication-options-slave',
1847 $variable_doc_links['report_user'] = array(
1849 'replication-options-slave',
1851 $variable_doc_links['rpl_stop_slave_timeout'] = array(
1852 'rpl_stop_slave_timeout',
1853 'replication-options-slave',
1855 $variable_doc_links['rpl_recovery_rank'] = array(
1856 'rpl_recovery_rank',
1857 'replication-options-slave',
1859 $variable_doc_links['rpl_semi_sync_master_enabled'] = array(
1860 'rpl_semi_sync_master_enabled',
1861 'server-system-variables',
1863 $variable_doc_links['rpl_semi_sync_master_timeout'] = array(
1864 'rpl_semi_sync_master_timeout',
1865 'server-system-variables',
1867 $variable_doc_links['rpl_semi_sync_master_trace_level'] = array(
1868 'rpl_semi_sync_master_trace_level',
1869 'server-system-variables',
1871 $variable_doc_links['rpl_semi_sync_master_wait_no_slave'] = array(
1872 'rpl_semi_sync_master_wait_no_slave',
1873 'server-system-variables',
1875 $variable_doc_links['rpl_semi_sync_slave_enabled'] = array(
1876 'rpl_semi_sync_slave_enabled',
1877 'server-system-variables',
1879 $variable_doc_links['rpl_semi_sync_slave_trace_level'] = array(
1880 'rpl_semi_sync_slave_trace_level',
1881 'server-system-variables',
1883 $variable_doc_links['safe_show_database'] = array(
1884 'safe-show-database',
1887 $variable_doc_links['secure_auth'] = array(
1891 $variable_doc_links['secure_file_priv'] = array(
1895 $variable_doc_links['server_id'] = array(
1897 'replication-options',
1899 $variable_doc_links['server_id_bits'] = array(
1901 'mysql-cluster-system-variables',
1903 $variable_doc_links['server_uuid'] = array(
1905 'replication-options',
1907 $variable_doc_links['shared_memory'] = array(
1909 'server-system-variables',
1911 $variable_doc_links['shared_memory_base_name'] = array(
1912 'shared_memory_base_name',
1913 'server-system-variables',
1915 $variable_doc_links['skip_external_locking'] = array(
1916 'skip-external-locking',
1919 $variable_doc_links['skip_name_resolve'] = array(
1920 'skip-name-resolve',
1923 $variable_doc_links['skip_networking'] = array(
1927 $variable_doc_links['skip_show_database'] = array(
1928 'skip-show-database',
1931 $variable_doc_links['slave_allow_batching'] = array(
1932 'slave_allow_batching',
1933 'mysql-cluster-system-variables',
1935 $variable_doc_links['slave_checkpoint_group'] = array(
1936 'slave_checkpoint_group',
1937 'replication-options-slave',
1939 $variable_doc_links['slave_checkpoint_period'] = array(
1940 'slave_checkpoint_period',
1941 'replication-options-slave',
1943 $variable_doc_links['slave_compressed_protocol'] = array(
1944 'slave_compressed_protocol',
1945 'replication-options-slave',
1947 $variable_doc_links['slave_exec_mode'] = array(
1949 'replication-options-slave',
1951 $variable_doc_links['slave_load_tmpdir'] = array(
1952 'slave-load-tmpdir',
1953 'replication-options-slave',
1955 $variable_doc_links['slave_max_allowed_packet'] = array(
1956 'slave_max_allowed_packet',
1957 'replication-options-slave',
1959 $variable_doc_links['slave_net_timeout'] = array(
1960 'slave-net-timeout',
1961 'replication-options-slave',
1963 $variable_doc_links['slave_parallel_workers'] = array(
1964 'slave_parallel_workers',
1965 'replication-options-slave',
1967 $variable_doc_links['slave_pending_jobs_size_max'] = array(
1968 'slave_pending_jobs_size_max',
1969 'replication-options-slave',
1971 $variable_doc_links['slave_rows_search_algorithms'] = array(
1972 'slave_rows_search_algorithms',
1973 'replication-options-slave',
1975 $variable_doc_links['slave_skip_errors'] = array(
1976 'slave-skip-errors',
1977 'replication-options-slave',
1979 $variable_doc_links['slave_sql_verify_checksum'] = array(
1980 'slave_sql_verify_checksum',
1981 'replication-options-slave',
1983 $variable_doc_links['slave_transaction_retries'] = array(
1984 'slave_transaction_retries',
1985 'replication-options-slave',
1987 $variable_doc_links['slave_type_conversions'] = array(
1988 'slave_type_conversions',
1989 'replication-options-slave',
1991 $variable_doc_links['slow_launch_time'] = array(
1993 'server-system-variables',
1995 $variable_doc_links['slow_query_log'] = array(
1998 'server-system-variables');
1999 $variable_doc_links['slow_query_log_file'] = array(
2000 'slow_query_log_file',
2001 'server-system-variables',
2003 $variable_doc_links['socket'] = array(
2007 $variable_doc_links['sort_buffer_size'] = array(
2009 'server-system-variables',
2012 $variable_doc_links['sql_auto_is_null'] = array(
2014 'server-system-variables',
2016 $variable_doc_links['sql_big_selects'] = array(
2018 'server-system-variables',
2020 $variable_doc_links['sql_big_tables'] = array(
2023 'server-system-variables');
2024 $variable_doc_links['sql_buffer_result'] = array(
2025 'sql_buffer_result',
2026 'server-system-variables',
2028 $variable_doc_links['sql_log_bin'] = array(
2030 'server-system-variables',
2032 $variable_doc_links['sql_log_off'] = array(
2034 'server-system-variables',
2036 $variable_doc_links['sql_log_update'] = array(
2038 'server-system-variables',
2040 $variable_doc_links['sql_low_priority_updates'] = array(
2041 'sql_low_priority_updates',
2042 'server-system-variables',
2044 $variable_doc_links['sql_max_join_size'] = array(
2045 'sql_max_join_size',
2046 'server-system-variables',
2048 $variable_doc_links['sql_mode'] = array(
2052 $variable_doc_links['sql_notes'] = array(
2054 'server-system-variables',
2056 $variable_doc_links['sql_quote_show_create'] = array(
2057 'sql_quote_show_create',
2058 'server-system-variables',
2060 $variable_doc_links['sql_safe_updates'] = array(
2062 'server-system-variables',
2064 $variable_doc_links['sql_select_limit'] = array(
2066 'server-system-variables',
2068 $variable_doc_links['sql_slave_skip_counter'] = array(
2069 'sql_slave_skip_counter',
2070 'replication-options-slave',
2072 $variable_doc_links['sql_warnings'] = array(
2074 'server-system-variables',
2076 $variable_doc_links['ssl_ca'] = array(
2080 $variable_doc_links['ssl_capath'] = array(
2084 $variable_doc_links['ssl_cert'] = array(
2088 $variable_doc_links['ssl_cipher'] = array(
2092 $variable_doc_links['ssl_crl'] = array(
2094 'server-system-variables',
2096 $variable_doc_links['ssl_crlpath'] = array(
2098 'server-system-variables',
2100 $variable_doc_links['ssl_key'] = array(
2104 $variable_doc_links['storage_engine'] = array(
2106 'server-system-variables',
2108 $variable_doc_links['stored_program_cache'] = array(
2109 'stored_program_cache',
2110 'server-system-variables',
2112 $variable_doc_links['sync_binlog'] = array(
2114 'replication-options-binary-log',
2116 $variable_doc_links['sync_frm'] = array(
2118 'server-system-variables',
2120 $variable_doc_links['sync_master_info'] = array(
2122 'replication-options-slave',
2124 $variable_doc_links['sync_relay_log'] = array(
2126 'replication-options-slave',
2128 $variable_doc_links['sync_relay_log_info'] = array(
2129 'sync_relay_log_info',
2130 'replication-options-slave',
2132 $variable_doc_links['system_time_zone'] = array(
2134 'server-system-variables',
2136 $variable_doc_links['table_definition_cache'] = array(
2137 'table_definition_cache',
2138 'server-system-variables',
2140 $variable_doc_links['table_lock_wait_timeout'] = array(
2141 'table_lock_wait_timeout',
2142 'server-system-variables',
2144 $variable_doc_links['table_open_cache'] = array(
2146 'server-system-variables',
2148 $variable_doc_links['table_open_cache_instances'] = array(
2149 'table_open_cache_instances',
2150 'server-system-variables',
2152 $variable_doc_links['table_type'] = array(
2154 'server-system-variables',
2156 $variable_doc_links['thread_cache_size'] = array(
2157 'thread_cache_size',
2158 'server-system-variables',
2160 $variable_doc_links['thread_concurrency'] = array(
2161 'thread_concurrency',
2162 'server-system-variables',
2164 $variable_doc_links['thread_handling'] = array(
2166 'server-system-variables',
2168 $variable_doc_links['thread_stack'] = array(
2170 'server-system-variables',
2172 $variable_doc_links['time_format'] = array(
2174 'server-system-variables',
2176 $variable_doc_links['time_zone'] = array(
2178 'server-system-variables',
2180 $variable_doc_links['timed_mutexes'] = array(
2182 'server-system-variables',
2184 $variable_doc_links['timestamp'] = array(
2186 'server-system-variables',
2188 $variable_doc_links['tmp_table_size'] = array(
2190 'server-system-variables',
2193 $variable_doc_links['tmpdir'] = array(
2197 $variable_doc_links['transaction_alloc_block_size'] = array(
2198 'transaction_alloc_block_size',
2199 'server-system-variables',
2202 $variable_doc_links['transaction_prealloc_size'] = array(
2203 'transaction_prealloc_size',
2204 'server-system-variables',
2207 $variable_doc_links['tx_isolation'] = array(
2209 'server-system-variables',
2211 $variable_doc_links['tx_read_only'] = array(
2213 'server-system-variables',
2215 $variable_doc_links['unique_checks'] = array(
2217 'server-system-variables',
2219 $variable_doc_links['updatable_views_with_limit'] = array(
2220 'updatable_views_with_limit',
2221 'server-system-variables',
2223 $variable_doc_links['version'] = array(
2225 'server-system-variables',
2227 $variable_doc_links['version_comment'] = array(
2229 'server-system-variables',
2231 $variable_doc_links['version_compile_machine'] = array(
2232 'version_compile_machine',
2233 'server-system-variables',
2235 $variable_doc_links['version_compile_os'] = array(
2236 'version_compile_os',
2237 'server-system-variables',
2239 $variable_doc_links['wait_timeout'] = array(
2241 'server-system-variables',
2243 $variable_doc_links['warning_count'] = array(
2245 'server-system-variables',
2247 return $variable_doc_links;
2251 * Returns array of static system variables (i.e. read-only)
2255 function PMA_getStaticSystemVariables()
2257 $static_variables = array(
2262 'character_set_system',
2263 'character_sets_dir',
2268 'disconnect_on_expired_password',
2269 'engine_condition_pushdown',
2271 'explicit_defaults_for_timestamp',
2275 'ft_query_expansion_limit',
2282 'have_dynamic_loading',
2287 'have_partitioning',
2294 'ignore_builtin_innodb',
2297 'innodb_additional_mem_pool_size',
2298 'innodb_api_disable_rowlock',
2299 'innodb_api_enable_binlog',
2300 'innodb_api_enable_mdl',
2301 'innodb_autoinc_lock_mode',
2302 'innodb_buffer_pool_instances',
2303 'innodb_buffer_pool_load_at_startup',
2305 'innodb_data_file_path',
2306 'innodb_data_home_dir',
2307 'innodb_doublewrite',
2308 'innodb_file_format_check',
2309 'innodb_flush_method',
2310 'innodb_force_load_corrupted',
2311 'innodb_force_recovery',
2312 'innodb_ft_cache_size',
2313 'innodb_ft_max_token_size',
2314 'innodb_ft_min_token_size',
2315 'innodb_ft_sort_pll_degree',
2316 'innodb_ft_total_cache_size',
2317 'innodb_locks_unsafe_for_binlog',
2318 'innodb_log_buffer_size',
2319 'innodb_log_file_size',
2320 'innodb_log_files_in_group',
2321 'innodb_log_group_home_dir',
2322 'innodb_mirrored_log_groups',
2323 'innodb_open_files',
2325 'innodb_purge_threads',
2326 'innodb_read_io_threads',
2328 'innodb_rollback_on_timeout',
2329 'innodb_sort_buffer_size',
2330 'innodb_sync_array_size',
2331 'innodb_undo_directory',
2332 'innodb_undo_tablespaces',
2333 'innodb_use_native_aio',
2334 'innodb_use_sys_malloc',
2336 'innodb_write_io_threads',
2338 'large_files_support',
2349 'log_bin_use_v1_row_events',
2351 'log_slave_updates',
2353 'lower_case_file_system',
2354 'lower_case_table_names',
2356 'max_long_data_size',
2358 'metadata_locks_cache_size',
2359 'metadata_locks_hash_instances',
2361 'multi_range_count',
2363 'myisam_recover_options',
2368 'performance_schema',
2369 'performance_schema_accounts_size',
2370 'performance_schema_digests_size',
2371 'performance_schema_events_stages_history_long_size',
2372 'performance_schema_events_stages_history_size',
2373 'performance_schema_events_statements_history_long_size',
2374 'performance_schema_events_statements_history_size',
2375 'performance_schema_events_waits_history_long_size',
2376 'performance_schema_events_waits_history_size',
2377 'performance_schema_hosts_size',
2378 'performance_schema_max_cond_classes',
2379 'performance_schema_max_cond_instances',
2380 'performance_schema_max_file_classes',
2381 'performance_schema_max_file_handles',
2382 'performance_schema_max_file_instances',
2383 'performance_schema_max_mutex_classes',
2384 'performance_schema_max_mutex_instances',
2385 'performance_schema_max_rwlock_classes',
2386 'performance_schema_max_rwlock_instances',
2387 'performance_schema_max_socket_classes',
2388 'performance_schema_max_socket_instances',
2389 'performance_schema_max_stage_classes',
2390 'performance_schema_max_statement_classes',
2391 'performance_schema_max_table_handles',
2392 'performance_schema_max_table_instances',
2393 'performance_schema_max_thread_classes',
2394 'performance_schema_max_thread_instances',
2395 'performance_schema_session_connect_attrs_size',
2396 'performance_schema_setup_actors_size',
2397 'performance_schema_setup_objects_size',
2398 'performance_schema_users_size',
2405 'relay_log_basename',
2408 'relay_log_info_file',
2409 'relay_log_recovery',
2410 'relay_log_space_limit',
2415 'rpl_recovery_rank',
2416 'safe_show_database',
2421 'shared_memory_base_name',
2422 'skip_external_locking',
2423 'skip_name_resolve',
2425 'skip_show_database',
2426 'slave_checkpoint_group',
2427 'slave_checkpoint_period',
2428 'slave_load_tmpdir',
2429 'slave_rows_search_algorithms',
2430 'slave_skip_errors',
2431 'slave_type_conversions',
2435 'sql_low_priority_updates',
2436 'sql_max_join_size',
2445 'table_lock_wait_timeout',
2446 'table_open_cache_instances',
2448 'thread_concurrency',
2455 'version_compile_machine',
2456 'version_compile_os',
2460 return $static_variables;