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 $varValue = $GLOBALS['dbi']->fetchSingleRow(
29 'SHOW GLOBAL VARIABLES WHERE Variable_name="'
30 . PMA_Util
::sqlAddSlashes($_REQUEST['varName']) . '";',
33 if (isset($variable_doc_links[$_REQUEST['varName']][3])
34 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
39 ' ', PMA_Util
::formatByteDown($varValue[1], 3, 3)
50 * Get Ajax return when $_REQUEST['type'] === 'setval'
52 * @param Array $variable_doc_links documentation links
56 function PMA_getAjaxReturnForSetVal($variable_doc_links)
58 $response = PMA_Response
::getInstance();
60 $value = $_REQUEST['varValue'];
63 if (isset($variable_doc_links[$_REQUEST['varName']][3])
64 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
66 '/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i',
79 $value = floatval($matches[1]) * PMA_Util
::pow(
81 $exp[strtolower($matches[3])]
84 $value = PMA_Util
::sqlAddSlashes($value);
87 if (! is_numeric($value)) {
88 $value="'" . $value . "'";
91 if (! preg_match("/[^a-zA-Z0-9_]+/", $_REQUEST['varName'])
92 && $GLOBALS['dbi']->query(
93 'SET GLOBAL ' . $_REQUEST['varName'] . ' = ' . $value
96 // Some values are rounded down etc.
97 $varValue = $GLOBALS['dbi']->fetchSingleRow(
98 'SHOW GLOBAL VARIABLES WHERE Variable_name="'
99 . PMA_Util
::sqlAddSlashes($_REQUEST['varName'])
105 $_REQUEST['varName'],
111 $response->isSuccess(false);
114 __('Setting variable failed')
122 * @param string $name variable name
123 * @param numeric $value variable value
124 * @param Array $variable_doc_links documentation links
126 * @return formatted string
128 function PMA_formatVariable($name, $value, $variable_doc_links)
130 if (is_numeric($value)) {
131 if (isset($variable_doc_links[$name][3])
132 && $variable_doc_links[$name][3]=='byte'
134 return '<abbr title="'
135 . PMA_Util
::formatNumber($value, 0) . '">'
136 . implode(' ', PMA_Util
::formatByteDown($value, 3, 3))
139 return PMA_Util
::formatNumber($value, 0);
142 return htmlspecialchars($value);
146 * Prints link templates
150 function PMA_getHtmlForLinkTemplates()
152 $url = 'server_variables.php' . PMA_URL_getCommon(array());
153 $output = '<a style="display: none;" href="#" class="editLink">';
154 $output .= PMA_Util
::getIcon('b_edit.png', __('Edit')) . '</a>';
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(
164 'style' => 'display:none',
173 * Prints Html for Server Variables
175 * @param Array $variable_doc_links documentation links
179 function PMA_getHtmlForServerVariables($variable_doc_links)
181 $value = ! empty($_REQUEST['filter'])
182 ?
htmlspecialchars($_REQUEST['filter'])
184 $output = '<fieldset id="tableFilter">'
185 . '<legend>' . __('Filters') . '</legend>'
186 . '<div class="formelement">'
187 . '<label for="filterText">' . __('Containing the word:') . '</label>'
188 . '<input name="filterText" type="text" id="filterText"'
189 . ' style="vertical-align: baseline;" value="' . $value . '" />'
193 $output .= '<div id="serverVariables" class="data filteredData noclick">'
194 . '<div class="var-header var-row">'
195 . '<div class="var-name">' . __('Variable') . '</div>'
196 . '<div class="var-value valueHeader">'
197 . __('Session value') . ' / ' . __('Global value')
199 . '<div style="clear:both"></div>'
202 $output .= PMA_getHtmlForServerVariablesItems($variable_doc_links);
211 * Prints Html for Server Variables Items
213 * @param Array $variable_doc_links documentation links
217 function PMA_getHtmlForServerVariablesItems($variable_doc_links)
220 * Sends the queries and buffers the results
223 = $GLOBALS['dbi']->fetchResult('SHOW SESSION VARIABLES;', 0, 1);
224 $serverVars = $GLOBALS['dbi']->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1);
228 foreach ($serverVars as $name => $value) {
229 $has_session_value = isset($serverVarsSession[$name])
230 && $serverVarsSession[$name] != $value;
231 $row_class = ($odd_row ?
' odd' : ' even')
232 . ($has_session_value ?
' diffSession' : '');
234 $output .= '<div class="var-row' . $row_class . '">'
235 . '<div class="var-name">';
237 // To display variable documentation link
238 if (isset($variable_doc_links[$name])) {
239 $output .= '<span title="'
240 . htmlspecialchars(str_replace('_', ' ', $name)) . '">';
241 $output .= PMA_Util
::showMySQLDocu(
242 $variable_doc_links[$name][1],
244 $variable_doc_links[$name][2] . '_' . $variable_doc_links[$name][0],
247 $output .= htmlspecialchars(str_replace('_', ' ', $name));
249 $output .= '</span>';
251 $output .= htmlspecialchars(str_replace('_', ' ', $name));
254 . '<div class="var-value value'
255 . ($GLOBALS['dbi']->isSuperuser() ?
' editable' : '') . '"> '
256 . PMA_formatVariable($name, $value, $variable_doc_links)
258 . '<div style="clear:both"></div>'
261 if ($has_session_value) {
262 $output .= '<div class="var-row' . ($odd_row ?
' odd' : ' even') . '">'
263 . '<div class="var-name session">(' . __('Session value') . ')</div>'
264 . '<div class="var-value value"> '
265 . PMA_formatVariable(
267 $serverVarsSession[$name],
270 . '<div style="clear:both"></div>'
274 $odd_row = ! $odd_row;
281 * Returns Array of documentation links
283 * $variable_doc_links[string $name] = array(
287 * string $name: name of the system variable
288 * string $anchor: anchor to the documentation page
289 * string $chapter: chapter of "HTML, one page per chapter" documentation
290 * string $type: type of system variable
291 * string $format: if set to 'byte' it will format the variable
292 * with PMA_Util::formatByteDown()
296 function PMA_getArrayForDocumentLinks()
298 $variable_doc_links = array();
299 $variable_doc_links['auto_increment_increment'] = array(
300 'auto_increment_increment',
301 'replication-options-master',
303 $variable_doc_links['auto_increment_offset'] = array(
304 'auto_increment_offset',
305 'replication-options-master',
307 $variable_doc_links['autocommit'] = array(
309 'server-system-variables',
311 $variable_doc_links['automatic_sp_privileges'] = array(
312 'automatic_sp_privileges',
313 'server-system-variables',
315 $variable_doc_links['back_log'] = array(
317 'server-system-variables',
319 $variable_doc_links['basedir'] = array(
323 $variable_doc_links['big_tables'] = array(
327 $variable_doc_links['bind_address'] = array(
331 $variable_doc_links['binlog_cache_size'] = array(
333 'replication-options-binary-log',
336 $variable_doc_links['binlog_direct_non_transactional_updates'] = array(
337 'binlog_direct_non_transactional_updates',
338 'replication-options-binary-log',
340 $variable_doc_links['binlog_format'] = array(
344 $variable_doc_links['binlog_stmt_cache_size'] = array(
345 'binlog_stmt_cache_size',
346 'replication-options-binary-log',
349 $variable_doc_links['bulk_insert_buffer_size'] = array(
350 'bulk_insert_buffer_size',
351 'server-system-variables',
354 $variable_doc_links['character_set_client'] = array(
355 'character_set_client',
356 'server-system-variables',
358 $variable_doc_links['character_set_connection'] = array(
359 'character_set_connection',
360 'server-system-variables',
362 $variable_doc_links['character_set_database'] = array(
363 'character_set_database',
364 'server-system-variables',
366 $variable_doc_links['character_set_filesystem'] = array(
367 'character-set-filesystem',
370 $variable_doc_links['character_set_results'] = array(
371 'character_set_results',
372 'server-system-variables',
374 $variable_doc_links['character_set_server'] = array(
375 'character-set-server',
378 $variable_doc_links['character_set_system'] = array(
379 'character_set_system',
380 'server-system-variables',
382 $variable_doc_links['character_sets_dir'] = array(
383 'character-sets-dir',
386 $variable_doc_links['collation_connection'] = array(
387 'collation_connection',
388 'server-system-variables',
390 $variable_doc_links['collation_database'] = array(
391 'collation_database',
392 'server-system-variables',
394 $variable_doc_links['collation_server'] = array(
398 $variable_doc_links['completion_type'] = array(
400 'server-system-variables',
402 $variable_doc_links['concurrent_insert'] = array(
404 'server-system-variables',
406 $variable_doc_links['connect_timeout'] = array(
408 'server-system-variables',
410 $variable_doc_links['datadir'] = array(
414 $variable_doc_links['date_format'] = array(
416 'server-system-variables',
418 $variable_doc_links['datetime_format'] = array(
420 'server-system-variables',
422 $variable_doc_links['debug'] = array(
426 $variable_doc_links['debug_sync'] = array(
428 'server-system-variables',
430 $variable_doc_links['default_storage_engine'] = array(
431 'default-storage-engine',
434 $variable_doc_links['default_week_format'] = array(
435 'default_week_format',
436 'server-system-variables',
438 $variable_doc_links['delay_key_write'] = array(
442 $variable_doc_links['delayed_insert_limit'] = array(
443 'delayed_insert_limit',
444 'server-system-variables',
446 $variable_doc_links['delayed_insert_timeout'] = array(
447 'delayed_insert_timeout',
448 'server-system-variables',
450 $variable_doc_links['delayed_queue_size'] = array(
451 'delayed_queue_size',
452 'server-system-variables',
454 $variable_doc_links['div_precision_increment'] = array(
455 'div_precision_increment',
456 'server-system-variables',
458 $variable_doc_links['engine_condition_pushdown'] = array(
459 'engine-condition-pushdown',
462 $variable_doc_links['error_count'] = array(
464 'server-system-variables',
466 $variable_doc_links['event_scheduler'] = array(
470 $variable_doc_links['expire_logs_days'] = array(
472 'server-system-variables',
474 $variable_doc_links['external_user'] = array(
476 'server-system-variables',
478 $variable_doc_links['flush'] = array(
480 'server-system-variables',
482 $variable_doc_links['flush_time'] = array(
484 'server-system-variables',
486 $variable_doc_links['foreign_key_checks'] = array(
487 'foreign_key_checks',
488 'server-system-variables',
490 $variable_doc_links['ft_boolean_syntax'] = array(
492 'server-system-variables',
494 $variable_doc_links['ft_max_word_len'] = array(
496 'server-system-variables',
498 $variable_doc_links['ft_min_word_len'] = array(
500 'server-system-variables',
502 $variable_doc_links['ft_query_expansion_limit'] = array(
503 'ft_query_expansion_limit',
504 'server-system-variables',
506 $variable_doc_links['ft_stopword_file'] = array(
508 'server-system-variables',
510 $variable_doc_links['general_log'] = array(
514 $variable_doc_links['general_log_file'] = array(
516 'server-system-variables',
518 $variable_doc_links['group_concat_max_len'] = array(
519 'group_concat_max_len',
520 'server-system-variables',
522 $variable_doc_links['have_compress'] = array(
524 'server-system-variables',
526 $variable_doc_links['have_crypt'] = array(
528 'server-system-variables',
530 $variable_doc_links['have_csv'] = array(
532 'server-system-variables',
534 $variable_doc_links['have_dynamic_loading'] = array(
535 'have_dynamic_loading',
536 'server-system-variables',
538 $variable_doc_links['have_geometry'] = array(
540 'server-system-variables',
542 $variable_doc_links['have_innodb'] = array(
544 'server-system-variables',
546 $variable_doc_links['have_openssl'] = array(
548 'server-system-variables',
550 $variable_doc_links['have_partitioning'] = array(
552 'server-system-variables',
554 $variable_doc_links['have_profiling'] = array(
556 'server-system-variables',
558 $variable_doc_links['have_query_cache'] = array(
560 'server-system-variables',
562 $variable_doc_links['have_rtree_keys'] = array(
564 'server-system-variables',
566 $variable_doc_links['have_ssl'] = array(
568 'server-system-variables',
570 $variable_doc_links['have_symlink'] = array(
572 'server-system-variables',
574 $variable_doc_links['hostname'] = array(
576 'server-system-variables',
578 $variable_doc_links['identity'] = array(
580 'server-system-variables',
582 $variable_doc_links['ignore_builtin_innodb'] = array(
583 'ignore-builtin-innodb',
586 $variable_doc_links['init_connect'] = array(
588 'server-system-variables',
590 $variable_doc_links['init_file'] = array(
594 $variable_doc_links['init_slave'] = array(
596 'replication-options-slave',
598 $variable_doc_links['innodb_adaptive_flushing'] = array(
599 'innodb_adaptive_flushing',
602 $variable_doc_links['innodb_adaptive_hash_index'] = array(
603 'innodb_adaptive_hash_index',
606 $variable_doc_links['innodb_additional_mem_pool_size'] = array(
607 'innodb_additional_mem_pool_size',
611 $variable_doc_links['innodb_autoextend_increment'] = array(
612 'innodb_autoextend_increment',
615 $variable_doc_links['innodb_autoinc_lock_mode'] = array(
616 'innodb_autoinc_lock_mode',
619 $variable_doc_links['innodb_buffer_pool_instances'] = array(
620 'innodb_buffer_pool_instances',
623 $variable_doc_links['innodb_buffer_pool_size'] = array(
624 'innodb_buffer_pool_size',
628 $variable_doc_links['innodb_change_buffering'] = array(
629 'innodb_change_buffering',
632 $variable_doc_links['innodb_checksums'] = array(
636 $variable_doc_links['innodb_commit_concurrency'] = array(
637 'innodb_commit_concurrency',
640 $variable_doc_links['innodb_concurrency_tickets'] = array(
641 'innodb_concurrency_tickets',
644 $variable_doc_links['innodb_data_file_path'] = array(
645 'innodb_data_file_path',
648 $variable_doc_links['innodb_data_home_dir'] = array(
649 'innodb_data_home_dir',
652 $variable_doc_links['innodb_doublewrite'] = array(
653 'innodb_doublewrite',
656 $variable_doc_links['innodb_fast_shutdown'] = array(
657 'innodb_fast_shutdown',
660 $variable_doc_links['innodb_file_format'] = array(
661 'innodb_file_format',
664 $variable_doc_links['innodb_file_format_check'] = array(
665 'innodb_file_format_check',
668 $variable_doc_links['innodb_file_format_max'] = array(
669 'innodb_file_format_max',
672 $variable_doc_links['innodb_file_per_table'] = array(
673 'innodb_file_per_table',
676 $variable_doc_links['innodb_flush_log_at_trx_commit'] = array(
677 'innodb_flush_log_at_trx_commit',
680 $variable_doc_links['innodb_flush_method'] = array(
681 'innodb_flush_method',
684 $variable_doc_links['innodb_force_recovery'] = array(
685 'innodb_force_recovery',
688 $variable_doc_links['innodb_io_capacity'] = array(
689 'innodb_io_capacity',
692 $variable_doc_links['innodb_lock_wait_timeout'] = array(
693 'innodb_lock_wait_timeout',
696 $variable_doc_links['innodb_locks_unsafe_for_binlog'] = array(
697 'innodb_locks_unsafe_for_binlog',
700 $variable_doc_links['innodb_log_buffer_size'] = array(
701 'innodb_log_buffer_size',
705 $variable_doc_links['innodb_log_file_size'] = array(
706 'innodb_log_file_size',
710 $variable_doc_links['innodb_log_files_in_group'] = array(
711 'innodb_log_files_in_group',
714 $variable_doc_links['innodb_log_group_home_dir'] = array(
715 'innodb_log_group_home_dir',
718 $variable_doc_links['innodb_max_dirty_pages_pct'] = array(
719 'innodb_max_dirty_pages_pct',
722 $variable_doc_links['innodb_max_purge_lag'] = array(
723 'innodb_max_purge_lag',
726 $variable_doc_links['innodb_mirrored_log_groups'] = array(
727 'innodb_mirrored_log_groups',
730 $variable_doc_links['innodb_old_blocks_pct'] = array(
731 'innodb_old_blocks_pct',
734 $variable_doc_links['innodb_old_blocks_time'] = array(
735 'innodb_old_blocks_time',
738 $variable_doc_links['innodb_open_files'] = array(
742 $variable_doc_links['innodb_purge_batch_size'] = array(
743 'innodb_purge_batch_size',
746 $variable_doc_links['innodb_purge_threads'] = array(
747 'innodb_purge_threads',
750 $variable_doc_links['innodb_read_ahead_threshold'] = array(
751 'innodb_read_ahead_threshold',
754 $variable_doc_links['innodb_read_io_threads'] = array(
755 'innodb_read_io_threads',
758 $variable_doc_links['innodb_replication_delay'] = array(
759 'innodb_replication_delay',
762 $variable_doc_links['innodb_rollback_on_timeout'] = array(
763 'innodb_rollback_on_timeout',
766 $variable_doc_links['innodb_spin_wait_delay'] = array(
767 'innodb_spin_wait_delay',
770 $variable_doc_links['innodb_stats_on_metadata'] = array(
771 'innodb_stats_on_metadata',
774 $variable_doc_links['innodb_stats_sample_pages'] = array(
775 'innodb_stats_sample_pages',
778 $variable_doc_links['innodb_strict_mode'] = array(
779 'innodb_strict_mode',
782 $variable_doc_links['innodb_support_xa'] = array(
786 $variable_doc_links['innodb_sync_spin_loops'] = array(
787 'innodb_sync_spin_loops',
790 $variable_doc_links['innodb_table_locks'] = array(
791 'innodb_table_locks',
794 $variable_doc_links['innodb_thread_concurrency'] = array(
795 'innodb_thread_concurrency',
798 $variable_doc_links['innodb_thread_sleep_delay'] = array(
799 'innodb_thread_sleep_delay',
802 $variable_doc_links['innodb_use_native_aio'] = array(
803 'innodb_use_native_aio',
806 $variable_doc_links['innodb_use_sys_malloc'] = array(
807 'innodb_use_sys_malloc',
810 $variable_doc_links['innodb_version'] = array(
814 $variable_doc_links['innodb_write_io_threads'] = array(
815 'innodb_write_io_threads',
818 $variable_doc_links['insert_id'] = array(
820 'server-system-variables',
822 $variable_doc_links['interactive_timeout'] = array(
823 'interactive_timeout',
824 'server-system-variables',
826 $variable_doc_links['join_buffer_size'] = array(
828 'server-system-variables',
831 $variable_doc_links['keep_files_on_create'] = array(
832 'keep_files_on_create',
833 'server-system-variables',
835 $variable_doc_links['key_buffer_size'] = array(
837 'server-system-variables',
840 $variable_doc_links['key_cache_age_threshold'] = array(
841 'key_cache_age_threshold',
842 'server-system-variables',
844 $variable_doc_links['key_cache_block_size'] = array(
845 'key_cache_block_size',
846 'server-system-variables',
849 $variable_doc_links['key_cache_division_limit'] = array(
850 'key_cache_division_limit',
851 'server-system-variables',
853 $variable_doc_links['language'] = array(
857 $variable_doc_links['large_files_support'] = array(
858 'large_files_support',
859 'server-system-variables',
861 $variable_doc_links['large_page_size'] = array(
863 'server-system-variables',
866 $variable_doc_links['large_pages'] = array(
870 $variable_doc_links['last_insert_id'] = array(
872 'server-system-variables',
874 $variable_doc_links['lc_messages'] = array(
878 $variable_doc_links['lc_messages_dir'] = array(
882 $variable_doc_links['lc_time_names'] = array(
884 'server-system-variables',
886 $variable_doc_links['license'] = array(
888 'server-system-variables',
890 $variable_doc_links['local_infile'] = array(
892 'server-system-variables',
894 $variable_doc_links['lock_wait_timeout'] = array(
896 'server-system-variables',
898 $variable_doc_links['locked_in_memory'] = array(
900 'server-system-variables',
902 $variable_doc_links['log'] = array(
906 $variable_doc_links['log_bin'] = array(
908 'server-system-variables',
910 $variable_doc_links['log-bin'] = array(
912 'replication-options-binary-log',
914 $variable_doc_links['log_bin_trust_function_creators'] = array(
915 'log-bin-trust-function-creators',
916 'replication-options-binary-log',
918 $variable_doc_links['log_error'] = array(
922 $variable_doc_links['log_output'] = array(
926 $variable_doc_links['log_queries_not_using_indexes'] = array(
927 'log-queries-not-using-indexes',
930 $variable_doc_links['log_slave_updates'] = array(
932 'replication-options-slave',
934 $variable_doc_links['log_slow_queries'] = array(
938 $variable_doc_links['log_warnings'] = array(
942 $variable_doc_links['long_query_time'] = array(
944 'server-system-variables',
946 $variable_doc_links['low_priority_updates'] = array(
947 'low-priority-updates',
950 $variable_doc_links['lower_case_file_system'] = array(
951 'lower_case_file_system',
952 'server-system-variables',
954 $variable_doc_links['lower_case_table_names'] = array(
955 'lower_case_table_names',
956 'server-system-variables',
958 $variable_doc_links['master-bind'] = array(
960 'replication-options',
962 $variable_doc_links['max_allowed_packet'] = array(
963 'max_allowed_packet',
964 'server-system-variables',
966 $variable_doc_links['max_binlog_cache_size'] = array(
967 'max_binlog_cache_size',
968 'replication-options-binary-log',
971 $variable_doc_links['max_binlog_size'] = array(
973 'replication-options-binary-log',
976 $variable_doc_links['max_binlog_stmt_cache_size'] = array(
977 'max_binlog_stmt_cache_size',
978 'replication-options-binary-log',
981 $variable_doc_links['max_connect_errors'] = array(
982 'max_connect_errors',
983 'server-system-variables',
985 $variable_doc_links['max_connections'] = array(
987 'server-system-variables',
989 $variable_doc_links['max_delayed_threads'] = array(
990 'max_delayed_threads',
991 'server-system-variables',
993 $variable_doc_links['max_error_count'] = array(
995 'server-system-variables',
997 $variable_doc_links['max_heap_table_size'] = array(
998 'max_heap_table_size',
999 'server-system-variables',
1002 $variable_doc_links['max_insert_delayed_threads'] = array(
1003 'max_insert_delayed_threads',
1004 'server-system-variables',
1006 $variable_doc_links['max_join_size'] = array(
1008 'server-system-variables',
1010 $variable_doc_links['max_length_for_sort_data'] = array(
1011 'max_length_for_sort_data',
1012 'server-system-variables',
1014 $variable_doc_links['max_prepared_stmt_count'] = array(
1015 'max_prepared_stmt_count',
1016 'server-system-variables',
1018 $variable_doc_links['max_relay_log_size'] = array(
1019 'max_relay_log_size',
1020 'server-system-variables',
1023 $variable_doc_links['max_seeks_for_key'] = array(
1024 'max_seeks_for_key',
1025 'server-system-variables',
1027 $variable_doc_links['max_sort_length'] = array(
1029 'server-system-variables',
1031 $variable_doc_links['max_sp_recursion_depth'] = array(
1032 'max_sp_recursion_depth',
1033 'server-system-variables',
1035 $variable_doc_links['max_tmp_tables'] = array(
1037 'server-system-variables',
1039 $variable_doc_links['max_user_connections'] = array(
1040 'max_user_connections',
1041 'server-system-variables',
1043 $variable_doc_links['max_write_lock_count'] = array(
1044 'max_write_lock_count',
1045 'server-system-variables',
1047 $variable_doc_links['memlock'] = array(
1051 $variable_doc_links['min_examined_row_limit'] = array(
1052 'min-examined-row-limit',
1055 $variable_doc_links['myisam_data_pointer_size'] = array(
1056 'myisam_data_pointer_size',
1057 'server-system-variables',
1060 $variable_doc_links['myisam_max_sort_file_size'] = array(
1061 'myisam_max_sort_file_size',
1062 'server-system-variables',
1065 $variable_doc_links['myisam_mmap_size'] = array(
1067 'server-system-variables',
1070 $variable_doc_links['myisam_recover_options'] = array(
1071 'myisam_recover_options',
1072 'server-system-variables',
1074 $variable_doc_links['myisam_repair_threads'] = array(
1075 'myisam_repair_threads',
1076 'server-system-variables',
1078 $variable_doc_links['myisam_sort_buffer_size'] = array(
1079 'myisam_sort_buffer_size',
1080 'server-system-variables',
1083 $variable_doc_links['myisam_stats_method'] = array(
1084 'myisam_stats_method',
1085 'server-system-variables',
1087 $variable_doc_links['myisam_use_mmap'] = array(
1089 'server-system-variables',
1091 $variable_doc_links['named_pipe'] = array(
1093 'server-system-variables',
1095 $variable_doc_links['net_buffer_length'] = array(
1096 'net_buffer_length',
1097 'server-system-variables',
1099 $variable_doc_links['net_read_timeout'] = array(
1101 'server-system-variables',
1103 $variable_doc_links['net_retry_count'] = array(
1105 'server-system-variables',
1107 $variable_doc_links['net_write_timeout'] = array(
1108 'net_write_timeout',
1109 'server-system-variables',
1111 $variable_doc_links['new'] = array(
1113 'server-system-variables',
1115 $variable_doc_links['old'] = array(
1117 'server-system-variables',
1119 $variable_doc_links['old_alter_table'] = array(
1123 $variable_doc_links['old_passwords'] = array(
1127 $variable_doc_links['open_files_limit'] = array(
1131 $variable_doc_links['optimizer_prune_level'] = array(
1132 'optimizer_prune_level',
1133 'server-system-variables',
1135 $variable_doc_links['optimizer_search_depth'] = array(
1136 'optimizer_search_depth',
1137 'server-system-variables',
1139 $variable_doc_links['optimizer_switch'] = array(
1141 'server-system-variables',
1143 $variable_doc_links['partition'] = array(
1147 $variable_doc_links['performance_schema'] = array(
1148 'performance_schema',
1149 'performance-schema-system-variables',
1151 $variable_doc_links['performance_schema_events_waits_history_long_size'] = array(
1152 'performance_schema_events_waits_history_long_size',
1153 'performance-schema-system-variables',
1155 $variable_doc_links['performance_schema_events_waits_history_size'] = array(
1156 'performance_schema_events_waits_history_size',
1157 'performance-schema-system-variables',
1159 $variable_doc_links['performance_schema_max_cond_classes'] = array(
1160 'performance_schema_max_cond_classes',
1161 'performance-schema-system-variables',
1163 $variable_doc_links['performance_schema_max_cond_instances'] = array(
1164 'performance_schema_max_cond_instances',
1165 'performance-schema-system-variables',
1167 $variable_doc_links['performance_schema_max_file_classes'] = array(
1168 'performance_schema_max_file_classes',
1169 'performance-schema-system-variables',
1171 $variable_doc_links['performance_schema_max_file_handles'] = array(
1172 'performance_schema_max_file_handles',
1173 'performance-schema-system-variables',
1175 $variable_doc_links['performance_schema_max_file_instances'] = array(
1176 'performance_schema_max_file_instances',
1177 'performance-schema-system-variables',
1179 $variable_doc_links['performance_schema_max_mutex_classes'] = array(
1180 'performance_schema_max_mutex_classes',
1181 'performance-schema-system-variables',
1183 $variable_doc_links['performance_schema_max_mutex_instances'] = array(
1184 'performance_schema_max_mutex_instances',
1185 'performance-schema-system-variables',
1187 $variable_doc_links['performance_schema_max_rwlock_classes'] = array(
1188 'performance_schema_max_rwlock_classes',
1189 'performance-schema-system-variables',
1191 $variable_doc_links['performance_schema_max_rwlock_instances'] = array(
1192 'performance_schema_max_rwlock_instances',
1193 'performance-schema-system-variables',
1195 $variable_doc_links['performance_schema_max_table_handles'] = array(
1196 'performance_schema_max_table_handles',
1197 'performance-schema-system-variables',
1199 $variable_doc_links['performance_schema_max_table_instances'] = array(
1200 'performance_schema_max_table_instances',
1201 'performance-schema-system-variables',
1203 $variable_doc_links['performance_schema_max_thread_classes'] = array(
1204 'performance_schema_max_thread_classes',
1205 'performance-schema-system-variables',
1207 $variable_doc_links['performance_schema_max_thread_instances'] = array(
1208 'performance_schema_max_thread_instances',
1209 'performance-schema-system-variables',
1211 $variable_doc_links['pid_file'] = array(
1215 $variable_doc_links['plugin_dir'] = array(
1217 'server-system-variables',
1219 $variable_doc_links['port'] = array(
1223 $variable_doc_links['preload_buffer_size'] = array(
1224 'preload_buffer_size',
1225 'server-system-variables',
1228 $variable_doc_links['profiling'] = array(
1230 'server-system-variables',
1232 $variable_doc_links['profiling_history_size'] = array(
1233 'profiling_history_size',
1234 'server-system-variables',
1236 $variable_doc_links['protocol_version'] = array(
1238 'server-system-variables',
1240 $variable_doc_links['proxy_user'] = array(
1242 'server-system-variables',
1244 $variable_doc_links['pseudo_thread_id'] = array(
1246 'server-system-variables',
1248 $variable_doc_links['query_alloc_block_size'] = array(
1249 'query_alloc_block_size',
1250 'server-system-variables',
1253 $variable_doc_links['query_cache_limit'] = array(
1254 'query_cache_limit',
1255 'server-system-variables',
1258 $variable_doc_links['query_cache_min_res_unit'] = array(
1259 'query_cache_min_res_unit',
1260 'server-system-variables',
1262 $variable_doc_links['query_cache_size'] = array(
1264 'server-system-variables',
1267 $variable_doc_links['query_cache_type'] = array(
1269 'server-system-variables',
1271 $variable_doc_links['query_cache_wlock_invalidate'] = array(
1272 'query_cache_wlock_invalidate',
1273 'server-system-variables',
1275 $variable_doc_links['query_prealloc_size'] = array(
1276 'query_prealloc_size',
1277 'server-system-variables',
1280 $variable_doc_links['rand_seed1'] = array(
1282 'server-system-variables',
1284 $variable_doc_links['rand_seed2'] = array(
1286 'server-system-variables',
1288 $variable_doc_links['range_alloc_block_size'] = array(
1289 'range_alloc_block_size',
1290 'server-system-variables',
1293 $variable_doc_links['read_buffer_size'] = array(
1295 'server-system-variables',
1298 $variable_doc_links['read_only'] = array(
1300 'server-system-variables',
1302 $variable_doc_links['read_rnd_buffer_size'] = array(
1303 'read_rnd_buffer_size',
1304 'server-system-variables',
1307 $variable_doc_links['relay-log-index'] = array(
1309 'replication-options-slave',
1311 $variable_doc_links['relay_log_index'] = array(
1313 'replication-options-slave',
1315 $variable_doc_links['relay_log_info_file'] = array(
1316 'relay_log_info_file',
1317 'replication-options-slave',
1319 $variable_doc_links['relay_log_purge'] = array(
1321 'server-system-variables',
1323 $variable_doc_links['relay_log_recovery'] = array(
1324 'relay_log_recovery',
1325 'replication-options-slave',
1327 $variable_doc_links['relay_log_space_limit'] = array(
1328 'relay_log_space_limit',
1329 'server-system-variables',
1331 $variable_doc_links['report_host'] = array(
1333 'replication-options-slave',
1335 $variable_doc_links['report_password'] = array(
1337 'replication-options-slave',
1339 $variable_doc_links['report_port'] = array(
1341 'replication-options-slave',
1343 $variable_doc_links['report_user'] = array(
1345 'replication-options-slave',
1347 $variable_doc_links['rpl_recovery_rank'] = array(
1348 'rpl_recovery_rank',
1349 'replication-options-slave',
1351 $variable_doc_links['rpl_semi_sync_master_enabled'] = array(
1352 'rpl_semi_sync_master_enabled',
1353 'server-system-variables',
1355 $variable_doc_links['rpl_semi_sync_master_timeout'] = array(
1356 'rpl_semi_sync_master_timeout',
1357 'server-system-variables',
1359 $variable_doc_links['rpl_semi_sync_master_trace_level'] = array(
1360 'rpl_semi_sync_master_trace_level',
1361 'server-system-variables',
1363 $variable_doc_links['rpl_semi_sync_master_wait_no_slave'] = array(
1364 'rpl_semi_sync_master_wait_no_slave',
1365 'server-system-variables',
1367 $variable_doc_links['rpl_semi_sync_slave_enabled'] = array(
1368 'rpl_semi_sync_slave_enabled',
1369 'server-system-variables',
1371 $variable_doc_links['rpl_semi_sync_slave_trace_level'] = array(
1372 'rpl_semi_sync_slave_trace_level',
1373 'server-system-variables',
1375 $variable_doc_links['safe_show_database'] = array(
1376 'safe-show-database',
1379 $variable_doc_links['secure_auth'] = array(
1383 $variable_doc_links['secure_file_priv'] = array(
1387 $variable_doc_links['server_id'] = array(
1389 'replication-options',
1391 $variable_doc_links['shared_memory'] = array(
1393 'server-system-variables',
1395 $variable_doc_links['shared_memory_base_name'] = array(
1396 'shared_memory_base_name',
1397 'server-system-variables',
1399 $variable_doc_links['skip_external_locking'] = array(
1400 'skip-external-locking',
1403 $variable_doc_links['skip_name_resolve'] = array(
1404 'skip-name-resolve',
1407 $variable_doc_links['skip_networking'] = array(
1411 $variable_doc_links['skip_show_database'] = array(
1412 'skip-show-database',
1415 $variable_doc_links['slave_compressed_protocol'] = array(
1416 'slave_compressed_protocol',
1417 'replication-options-slave',
1419 $variable_doc_links['slave_exec_mode'] = array(
1421 'replication-options-slave',
1423 $variable_doc_links['slave_load_tmpdir'] = array(
1424 'slave-load-tmpdir',
1425 'replication-options-slave',
1427 $variable_doc_links['slave_net_timeout'] = array(
1428 'slave-net-timeout',
1429 'replication-options-slave',
1431 $variable_doc_links['slave_skip_errors'] = array(
1432 'slave-skip-errors',
1433 'replication-options-slave',
1435 $variable_doc_links['slave_transaction_retries'] = array(
1436 'slave_transaction_retries',
1437 'replication-options-slave',
1439 $variable_doc_links['slave_type_conversions'] = array(
1440 'slave_type_conversions',
1441 'replication-options-slave',
1443 $variable_doc_links['slow_launch_time'] = array(
1445 'server-system-variables',
1447 $variable_doc_links['slow_query_log'] = array(
1450 'server-system-variables');
1451 $variable_doc_links['slow_query_log_file'] = array(
1452 'slow_query_log_file',
1453 'server-system-variables',
1455 $variable_doc_links['socket'] = array(
1459 $variable_doc_links['sort_buffer_size'] = array(
1461 'server-system-variables',
1464 $variable_doc_links['sql_auto_is_null'] = array(
1466 'server-system-variables',
1468 $variable_doc_links['sql_big_selects'] = array(
1470 'server-system-variables',
1472 $variable_doc_links['sql_big_tables'] = array(
1475 'server-system-variables');
1476 $variable_doc_links['sql_buffer_result'] = array(
1477 'sql_buffer_result',
1478 'server-system-variables',
1480 $variable_doc_links['sql_log_bin'] = array(
1482 'server-system-variables',
1484 $variable_doc_links['sql_log_off'] = array(
1486 'server-system-variables',
1488 $variable_doc_links['sql_log_update'] = array(
1490 'server-system-variables',
1492 $variable_doc_links['sql_low_priority_updates'] = array(
1493 'sql_low_priority_updates',
1494 'server-system-variables',
1496 $variable_doc_links['sql_max_join_size'] = array(
1497 'sql_max_join_size',
1498 'server-system-variables',
1500 $variable_doc_links['sql_mode'] = array(
1504 $variable_doc_links['sql_notes'] = array(
1506 'server-system-variables',
1508 $variable_doc_links['sql_quote_show_create'] = array(
1509 'sql_quote_show_create',
1510 'server-system-variables',
1512 $variable_doc_links['sql_safe_updates'] = array(
1514 'server-system-variables',
1516 $variable_doc_links['sql_select_limit'] = array(
1518 'server-system-variables',
1520 $variable_doc_links['sql_slave_skip_counter'] = array(
1521 'sql_slave_skip_counter',
1522 'replication-options-slave',
1524 $variable_doc_links['sql_warnings'] = array(
1526 'server-system-variables',
1528 $variable_doc_links['ssl_ca'] = array(
1532 $variable_doc_links['ssl_capath'] = array(
1536 $variable_doc_links['ssl_cert'] = array(
1540 $variable_doc_links['ssl_cipher'] = array(
1544 $variable_doc_links['ssl_key'] = array(
1548 $variable_doc_links['storage_engine'] = array(
1550 'server-system-variables',
1552 $variable_doc_links['sync_binlog'] = array(
1554 'replication-options-binary-log',
1556 $variable_doc_links['sync_frm'] = array(
1558 'server-system-variables',
1560 $variable_doc_links['sync_master_info'] = array(
1562 'replication-options-slave',
1564 $variable_doc_links['sync_relay_log'] = array(
1566 'replication-options-slave',
1568 $variable_doc_links['sync_relay_log_info'] = array(
1569 'sync_relay_log_info',
1570 'replication-options-slave',
1572 $variable_doc_links['system_time_zone'] = array(
1574 'server-system-variables',
1576 $variable_doc_links['table_definition_cache'] = array(
1577 'table_definition_cache',
1578 'server-system-variables',
1580 $variable_doc_links['table_lock_wait_timeout'] = array(
1581 'table_lock_wait_timeout',
1582 'server-system-variables',
1584 $variable_doc_links['table_open_cache'] = array(
1586 'server-system-variables',
1588 $variable_doc_links['table_type'] = array(
1590 'server-system-variables',
1592 $variable_doc_links['thread_cache_size'] = array(
1593 'thread_cache_size',
1594 'server-system-variables',
1596 $variable_doc_links['thread_concurrency'] = array(
1597 'thread_concurrency',
1598 'server-system-variables',
1600 $variable_doc_links['thread_handling'] = array(
1602 'server-system-variables',
1604 $variable_doc_links['thread_stack'] = array(
1606 'server-system-variables',
1608 $variable_doc_links['time_format'] = array(
1610 'server-system-variables',
1612 $variable_doc_links['time_zone'] = array(
1614 'server-system-variables',
1616 $variable_doc_links['timed_mutexes'] = array(
1618 'server-system-variables',
1620 $variable_doc_links['timestamp'] = array(
1622 'server-system-variables',
1624 $variable_doc_links['tmp_table_size'] = array(
1626 'server-system-variables',
1629 $variable_doc_links['tmpdir'] = array(
1633 $variable_doc_links['transaction_alloc_block_size'] = array(
1634 'transaction_alloc_block_size',
1635 'server-system-variables',
1638 $variable_doc_links['transaction_prealloc_size'] = array(
1639 'transaction_prealloc_size',
1640 'server-system-variables',
1643 $variable_doc_links['tx_isolation'] = array(
1645 'server-system-variables',
1647 $variable_doc_links['unique_checks'] = array(
1649 'server-system-variables',
1651 $variable_doc_links['updatable_views_with_limit'] = array(
1652 'updatable_views_with_limit',
1653 'server-system-variables',
1655 $variable_doc_links['version'] = array(
1657 'server-system-variables',
1659 $variable_doc_links['version_comment'] = array(
1661 'server-system-variables',
1663 $variable_doc_links['version_compile_machine'] = array(
1664 'version_compile_machine',
1665 'server-system-variables',
1667 $variable_doc_links['version_compile_os'] = array(
1668 'version_compile_os',
1669 'server-system-variables',
1671 $variable_doc_links['wait_timeout'] = array(
1673 'server-system-variables',
1675 $variable_doc_links['warning_count'] = array(
1677 'server-system-variables',
1679 return $variable_doc_links;