?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Translated using Weblate (Slovak)
[phpmyadmin.git] / libraries / server_variables.lib.php
blob459939e3e71b3fffa9208bb7f27e27987f1c8e56
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3
4 /**
5 * functions for displaying server variables
6 *
7 * @usedby server_variables.php
8 *
9 * @package PhpMyAdmin
10 */
11 if (! defined('PHPMYADMIN')) {
12 exit;
13 }
14
15 /**
16 * Get Ajax return when $_REQUEST['type'] === 'getval'
17 *
18 * @param Array $variable_doc_links documentation links
19 *
20 * @return null
21 */
22 function PMA_getAjaxReturnForGetVal($variable_doc_links)
23 {
24 $response = PMA_Response::getInstance();
25
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']) . '";',
31 'NUM'
32 );
33 if (isset($variable_doc_links[$_REQUEST['varName']][3])
34 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
35 ) {
36 $response->addJSON(
37 'message',
38 implode(
39 ' ', PMA_Util::formatByteDown($varValue[1], 3, 3)
40 )
41 );
42 } else {
43 $response->addJSON(
44 'message',
45 $varValue[1]
46 );
47 }
48 }
49 /**
50 * Get Ajax return when $_REQUEST['type'] === 'setval'
51 *
52 * @param Array $variable_doc_links documentation links
53 *
54 * @return null
55 */
56 function PMA_getAjaxReturnForSetVal($variable_doc_links)
57 {
58 $response = PMA_Response::getInstance();
59
60 $value = $_REQUEST['varValue'];
61 $matches = array();
62
63 if (isset($variable_doc_links[$_REQUEST['varName']][3])
64 && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
65 && preg_match(
66 '/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i',
67 $value,
68 $matches
69 )
70 ) {
71 $exp = array(
72 'kb' => 1,
73 'kib' => 1,
74 'mb' => 2,
75 'mib' => 2,
76 'gb' => 3,
77 'gib' => 3
78 );
79 $value = floatval($matches[1]) * PMA_Util::pow(
80 1024,
81 $exp[/*overload*/mb_strtolower($matches[3])]
82 );
83 } else {
84 $value = PMA_Util::sqlAddSlashes($value);
85 }
86
87 if (! is_numeric($value)) {
88 $value="'" . $value . "'";
89 }
90
91 if (! preg_match("/[^a-zA-Z0-9_]+/", $_REQUEST['varName'])
92 && $GLOBALS['dbi']->query(
93 'SET GLOBAL ' . $_REQUEST['varName'] . ' = ' . $value
94 )
95 ) {
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'])
100 . '";', 'NUM'
101 );
102 $response->addJSON(
103 'variable',
104 PMA_formatVariable(
105 $_REQUEST['varName'],
106 $varValue[1],
107 $variable_doc_links
108 )
109 );
110 } else {
111 $response->isSuccess(false);
112 $response->addJSON(
113 'error',
114 __('Setting variable failed')
115 );
116 }
117 }
118
119 /**
120 * Format Variable
121 *
122 * @param string $name variable name
123 * @param number $value variable value
124 * @param array $variable_doc_links documentation links
125 *
126 * @return string formatted string
127 */
128 function PMA_formatVariable($name, $value, $variable_doc_links)
129 {
130 if (is_numeric($value)) {
131 if (isset($variable_doc_links[$name][3])
132 && $variable_doc_links[$name][3]=='byte'
133 ) {
134 return '<abbr title="'
135 . PMA_Util::formatNumber($value, 0) . '">'
136 . implode(' ', PMA_Util::formatByteDown($value, 3, 3))
137 . '</abbr>';
138 } else {
139 return PMA_Util::formatNumber($value, 0);
140 }
141 }
142 return htmlspecialchars($value);
143 }
144
145 /**
146 * Prints link templates
147 *
148 * @return string
149 */
150 function PMA_getHtmlForLinkTemplates()
151 {
152 $url = 'server_variables.php' . PMA_URL_getCommon();
153 $output = '<a style="display: none;" href="'
154 . $url . '" class="ajax saveLink">';
155 $output .= PMA_Util::getIcon('b_save.png', __('Save')) . '</a> ';
156 $output .= '<a style="display: none;" href="#" class="cancelLink">';
157 $output .= PMA_Util::getIcon('b_close.png', __('Cancel')) . '</a> ';
158 $output .= PMA_Util::getImage(
159 'b_help.png',
160 __('Documentation'),
161 array('style' => 'display:none', 'id' => 'docImage')
162 );
163 return $output;
164 }
165
166 /**
167 * Prints Html for Server Variables
168 *
169 * @param Array $variable_doc_links documentation links
170 *
171 * @return string
172 */
173 function PMA_getHtmlForServerVariables($variable_doc_links)
174 {
175 $value = ! empty($_REQUEST['filter'])
176 ? htmlspecialchars($_REQUEST['filter'])
177 : '';
178 $output = '<fieldset id="tableFilter">'
179 . '<legend>' . __('Filters') . '</legend>'
180 . '<div class="formelement">'
181 . '<label for="filterText">' . __('Containing the word:') . '</label>'
182 . '<input name="filterText" type="text" id="filterText"'
183 . ' style="vertical-align: baseline;" value="' . $value . '" />'
184 . '</div>'
185 . '</fieldset>';
186
187 $output .= '<table id="serverVariables" class="data filteredData noclick">'
188 . '<thead><tr class="var-header var-row">'
189 . '<td class="var-action">' . __('Action') . '</td>'
190 . '<td class="var-name">' . __('Variable') . '</td>'
191 . '<td class="var-value">'
192 . __('Session value') . ' / ' . __('Global value')
193 . '</td>'
194 . '</tr>'
195 . '</thead>';
196
197 $output .= PMA_getHtmlForServerVariablesItems($variable_doc_links);
198
199 $output .= '</table>';
200
201 return $output;
202 }
203
204
205 /**
206 * Prints Html for Server Variables Items
207 *
208 * @param Array $variable_doc_links documentation links
209 *
210 * @return string
211 */
212 function PMA_getHtmlForServerVariablesItems($variable_doc_links)
213 {
214 /**
215 * Sends the queries and buffers the results
216 */
217 $serverVarsSession
218 = $GLOBALS['dbi']->fetchResult('SHOW SESSION VARIABLES;', 0, 1);
219 $serverVars = $GLOBALS['dbi']->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1);
220
221 // list of Dynamic System variables
222 $dynamic_variables = PMA_getDynamicSystemVariables();
223
224 $output = '<tbody>';
225 $odd_row = true;
226 foreach ($serverVars as $name => $value) {
227 $has_session_value = isset($serverVarsSession[$name])
228 && $serverVarsSession[$name] != $value;
229 $row_class = ($odd_row ? ' odd' : ' even')
230 . ($has_session_value ? ' diffSession' : '');
231
232 $output .= '<tr class="var-row' . $row_class . '">';
233
234 $output .= '<td class="var-action">';
235
236 // Edit Link active only for Dynamic System variables
237 if (in_array(strtolower($name), $dynamic_variables)) {
238 $output .= '<a href="#" class="editLink">'
239 . PMA_Util::getIcon('b_edit.png', __('Edit')) . '</a>';
240 } else {
241 $output .= '<span title="'
242 . __('This is a read-only variable and can not be edited')
243 . '" class="read_only_var" >'
244 . PMA_Util::getIcon('bd_edit.png', __('Edit'))
245 . '</span>';
246 }
247
248 $output .= '</td>';
249
250 $output .= '<td class="var-name">';
251 // To display variable documentation link
252 if (isset($variable_doc_links[$name])) {
253 $output .= '<span title="'
254 . htmlspecialchars(str_replace('_', ' ', $name)) . '">';
255 $output .= PMA_Util::showMySQLDocu(
256 $variable_doc_links[$name][1],
257 false,
258 $variable_doc_links[$name][2] . '_' . $variable_doc_links[$name][0],
259 true
260 );
261 $output .= htmlspecialchars(str_replace('_', ' ', $name));
262 $output .= '</a>';
263 $output .= '</span>';
264 } else {
265 $output .= htmlspecialchars(str_replace('_', ' ', $name));
266 }
267 $output .= '</td>';
268
269 $output .= '<td class="var-value value'
270 . ($GLOBALS['dbi']->isSuperuser() ? ' editable' : '') . '">&nbsp;'
271 . PMA_formatVariable($name, $value, $variable_doc_links)
272 . '</td>'
273 . '</tr>';
274
275 if ($has_session_value) {
276 $output .= '<tr class="var-row' . ($odd_row ? ' odd' : ' even') . '">'
277 . '<td class="var-action"></td>'
278 . '<td class="var-name session">(' . __('Session value') . ')</td>'
279 . '<td class="var-value value">&nbsp;'
280 . PMA_formatVariable(
281 $name,
282 $serverVarsSession[$name],
283 $variable_doc_links
284 ) . '</td>'
285 . '</tr>';
286 }
287
288 $odd_row = ! $odd_row;
289 }
290 $output .= '</tbody>';
291
292 return $output;
293 }
294
295 /**
296 * Returns Array of documentation links
297 *
298 * $variable_doc_links[string $name] = array(
299 * string $name,
300 * string $anchor,
301 * string $chapter,
302 * string $type,
303 * string $format);
304 * string $name: name of the system variable
305 * string $anchor: anchor to the documentation page
306 * string $chapter: chapter of "HTML, one page per chapter" documentation
307 * string $type: type of system variable
308 * string $format: if set to 'byte' it will format the variable
309 * with PMA_Util::formatByteDown()
310 *
311 * @return array
312 */
313 function PMA_getArrayForDocumentLinks()
314 {
315 $variable_doc_links = array();
316 $variable_doc_links['auto_increment_increment'] = array(
317 'auto_increment_increment',
318 'replication-options-master',
319 'sysvar');
320 $variable_doc_links['auto_increment_offset'] = array(
321 'auto_increment_offset',
322 'replication-options-master',
323 'sysvar');
324 $variable_doc_links['autocommit'] = array(
325 'autocommit',
326 'server-system-variables',
327 'sysvar');
328 $variable_doc_links['automatic_sp_privileges'] = array(
329 'automatic_sp_privileges',
330 'server-system-variables',
331 'sysvar');
332 $variable_doc_links['back_log'] = array(
333 'back_log',
334 'server-system-variables',
335 'sysvar');
336 $variable_doc_links['basedir'] = array(
337 'basedir',
338 'server-options',
339 'option_mysqld');
340 $variable_doc_links['big_tables'] = array(
341 'big-tables',
342 'server-options',
343 'option_mysqld');
344 $variable_doc_links['bind_address'] = array(
345 'bind-address',
346 'server-options',
347 'option_mysqld');
348 $variable_doc_links['binlog_cache_size'] = array(
349 'binlog_cache_size',
350 'replication-options-binary-log',
351 'sysvar',
352 'byte');
353 $variable_doc_links['binlog_checksum'] = array(
354 'binlog_checksum',
355 'replication-options-binary-log',
356 'sysvar');
357 $variable_doc_links['binlog_direct_non_transactional_updates'] = array(
358 'binlog_direct_non_transactional_updates',
359 'replication-options-binary-log',
360 'sysvar');
361 $variable_doc_links['binlog_format'] = array(
362 'binlog-format',
363 'server-options',
364 'sysvar');
365 $variable_doc_links['binlog_max_flush_queue_time'] = array(
366 'binlog_max_flush_queue_time',
367 'replication-options-binary-log',
368 'sysvar');
369 $variable_doc_links['binlog_order_commits'] = array(
370 'binlog_order_commits',
371 'replication-options-binary-log',
372 'sysvar');
373 $variable_doc_links['binlog_row_image'] = array(
374 'binlog_row_image',
375 'replication-options-binary-log',
376 'sysvar');
377 $variable_doc_links['binlog_rows_query_log_events'] = array(
378 'binlog_rows_query_log_events',
379 'replication-options-binary-log',
380 'sysvar');
381 $variable_doc_links['binlog_stmt_cache_size'] = array(
382 'binlog_stmt_cache_size',
383 'replication-options-binary-log',
384 'sysvar',
385 'byte');
386 $variable_doc_links['block_encryption_mode'] = array(
387 'block_encryption_mode',
388 'server-system-variables',
389 'sysvar');
390 $variable_doc_links['bulk_insert_buffer_size'] = array(
391 'bulk_insert_buffer_size',
392 'server-system-variables',
393 'sysvar',
394 'byte');
395 $variable_doc_links['character_set_client'] = array(
396 'character_set_client',
397 'server-system-variables',
398 'sysvar');
399 $variable_doc_links['character_set_connection'] = array(
400 'character_set_connection',
401 'server-system-variables',
402 'sysvar');
403 $variable_doc_links['character_set_database'] = array(
404 'character_set_database',
405 'server-system-variables',
406 'sysvar');
407 $variable_doc_links['character_set_filesystem'] = array(
408 'character-set-filesystem',
409 'server-options',
410 'option_mysqld');
411 $variable_doc_links['character_set_results'] = array(
412 'character_set_results',
413 'server-system-variables',
414 'sysvar');
415 $variable_doc_links['character_set_server'] = array(
416 'character-set-server',
417 'server-options',
418 'option_mysqld');
419 $variable_doc_links['character_set_system'] = array(
420 'character_set_system',
421 'server-system-variables',
422 'sysvar');
423 $variable_doc_links['character_sets_dir'] = array(
424 'character-sets-dir',
425 'server-options',
426 'option_mysqld');
427 $variable_doc_links['collation_connection'] = array(
428 'collation_connection',
429 'server-system-variables',
430 'sysvar');
431 $variable_doc_links['collation_database'] = array(
432 'collation_database',
433 'server-system-variables',
434 'sysvar');
435 $variable_doc_links['collation_server'] = array(
436 'collation-server',
437 'server-options',
438 'option_mysqld');
439 $variable_doc_links['completion_type'] = array(
440 'completion_type',
441 'server-system-variables',
442 'sysvar');
443 $variable_doc_links['concurrent_insert'] = array(
444 'concurrent_insert',
445 'server-system-variables',
446 'sysvar');
447 $variable_doc_links['connect_timeout'] = array(
448 'connect_timeout',
449 'server-system-variables',
450 'sysvar');
451 $variable_doc_links['core_file'] = array(
452 'core_file',
453 'server-system-variables',
454 'sysvar');
455 $variable_doc_links['datadir'] = array(
456 'datadir',
457 'server-options',
458 'option_mysqld');
459 $variable_doc_links['date_format'] = array(
460 'date_format',
461 'server-system-variables',
462 'sysvar');
463 $variable_doc_links['datetime_format'] = array(
464 'datetime_format',
465 'server-system-variables',
466 'sysvar');
467 $variable_doc_links['debug'] = array(
468 'debug',
469 'server-options',
470 'option_mysqld');
471 $variable_doc_links['debug_sync'] = array(
472 'debug_sync',
473 'server-system-variables',
474 'sysvar');
475 $variable_doc_links['default_storage_engine'] = array(
476 'default-storage-engine',
477 'server-options',
478 'option_mysqld');
479 $variable_doc_links['default_tmp_storage_engine'] = array(
480 'default_tmp_storage_engine',
481 'server-system-variables',
482 'sysvar');
483 $variable_doc_links['default_week_format'] = array(
484 'default_week_format',
485 'server-system-variables',
486 'sysvar');
487 $variable_doc_links['delay_key_write'] = array(
488 'delay-key-write',
489 'server-options',
490 'option_mysqld');
491 $variable_doc_links['delayed_insert_limit'] = array(
492 'delayed_insert_limit',
493 'server-system-variables',
494 'sysvar');
495 $variable_doc_links['delayed_insert_timeout'] = array(
496 'delayed_insert_timeout',
497 'server-system-variables',
498 'sysvar');
499 $variable_doc_links['delayed_queue_size'] = array(
500 'delayed_queue_size',
501 'server-system-variables',
502 'sysvar');
503 $variable_doc_links['disconnect_on_expired_password'] = array(
504 'disconnect_on_expired_password',
505 'server-system-variables',
506 'sysvar');
507 $variable_doc_links['div_precision_increment'] = array(
508 'div_precision_increment',
509 'server-system-variables',
510 'sysvar');
511 $variable_doc_links['end_markers_in_json'] = array(
512 'end_markers_in_json',
513 'server-system-variables',
514 'sysvar');
515 $variable_doc_links['enforce_gtid_consistency'] = array(
516 'enforce_gtid_consistency',
517 'replication-options-gtids',
518 'sysvar');
519 $variable_doc_links['eq_range_index_dive_limit'] = array(
520 'eq_range_index_dive_limit',
521 'server-system-variables',
522 'sysvar');
523 $variable_doc_links['engine_condition_pushdown'] = array(
524 'engine-condition-pushdown',
525 'server-options',
526 'option_mysqld');
527 $variable_doc_links['error_count'] = array(
528 'error_count',
529 'server-system-variables',
530 'sysvar');
531 $variable_doc_links['event_scheduler'] = array(
532 'event-scheduler',
533 'server-options',
534 'option_mysqld');
535 $variable_doc_links['expire_logs_days'] = array(
536 'expire_logs_days',
537 'server-system-variables',
538 'sysvar');
539 $variable_doc_links['explicit_defaults_for_timestamp'] = array(
540 'explicit_defaults_for_timestamp',
541 'server-system-variables',
542 'sysvar');
543 $variable_doc_links['external_user'] = array(
544 'external_user',
545 'server-system-variables',
546 'sysvar');
547 $variable_doc_links['flush'] = array(
548 'flush',
549 'server-system-variables',
550 'sysvar');
551 $variable_doc_links['flush_time'] = array(
552 'flush_time',
553 'server-system-variables',
554 'sysvar');
555 $variable_doc_links['foreign_key_checks'] = array(
556 'foreign_key_checks',
557 'server-system-variables',
558 'sysvar');
559 $variable_doc_links['ft_boolean_syntax'] = array(
560 'ft_boolean_syntax',
561 'server-system-variables',
562 'sysvar');
563 $variable_doc_links['ft_max_word_len'] = array(
564 'ft_max_word_len',
565 'server-system-variables',
566 'sysvar');
567 $variable_doc_links['ft_min_word_len'] = array(
568 'ft_min_word_len',
569 'server-system-variables',
570 'sysvar');
571 $variable_doc_links['ft_query_expansion_limit'] = array(
572 'ft_query_expansion_limit',
573 'server-system-variables',
574 'sysvar');
575 $variable_doc_links['ft_stopword_file'] = array(
576 'ft_stopword_file',
577 'server-system-variables',
578 'sysvar');
579 $variable_doc_links['general_log'] = array(
580 'general-log',
581 'server-options',
582 'option_mysqld');
583 $variable_doc_links['general_log_file'] = array(
584 'general_log_file',
585 'server-system-variables',
586 'sysvar');
587 $variable_doc_links['group_concat_max_len'] = array(
588 'group_concat_max_len',
589 'server-system-variables',
590 'sysvar');
591 $variable_doc_links['gtid_executed'] = array(
592 'gtid_executed',
593 'replication-options-gtids',
594 'sysvar');
595 $variable_doc_links['gtid_mode'] = array(
596 'gtid_mode',
597 'replication-options-gtids',
598 'sysvar');
599 $variable_doc_links['gtid_owned'] = array(
600 'gtid_owned',
601 'replication-options-gtids',
602 'sysvar');
603 $variable_doc_links['gtid_purged'] = array(
604 'gtid_purged',
605 'replication-options-gtids',
606 'sysvar');
607 $variable_doc_links['have_compress'] = array(
608 'have_compress',
609 'server-system-variables',
610 'sysvar');
611 $variable_doc_links['have_crypt'] = array(
612 'have_crypt',
613 'server-system-variables',
614 'sysvar');
615 $variable_doc_links['have_csv'] = array(
616 'have_csv',
617 'server-system-variables',
618 'sysvar');
619 $variable_doc_links['have_dynamic_loading'] = array(
620 'have_dynamic_loading',
621 'server-system-variables',
622 'sysvar');
623 $variable_doc_links['have_geometry'] = array(
624 'have_geometry',
625 'server-system-variables',
626 'sysvar');
627 $variable_doc_links['have_innodb'] = array(
628 'have_innodb',
629 'server-system-variables',
630 'sysvar');
631 $variable_doc_links['have_ndbcluster'] = array(
632 'have_ndbcluster',
633 'mysql-cluster-system-variables',
634 'sysvar');
635 $variable_doc_links['have_openssl'] = array(
636 'have_openssl',
637 'server-system-variables',
638 'sysvar');
639 $variable_doc_links['have_partitioning'] = array(
640 'have_partitioning',
641 'server-system-variables',
642 'sysvar');
643 $variable_doc_links['have_profiling'] = array(
644 'have_profiling',
645 'server-system-variables',
646 'sysvar');
647 $variable_doc_links['have_query_cache'] = array(
648 'have_query_cache',
649 'server-system-variables',
650 'sysvar');
651 $variable_doc_links['have_rtree_keys'] = array(
652 'have_rtree_keys',
653 'server-system-variables',
654 'sysvar');
655 $variable_doc_links['have_ssl'] = array(
656 'have_ssl',
657 'server-system-variables',
658 'sysvar');
659 $variable_doc_links['have_symlink'] = array(
660 'have_symlink',
661 'server-system-variables',
662 'sysvar');
663 $variable_doc_links['host_cache_size'] = array(
664 'host_cache_size',
665 'server-system-variables',
666 'sysvar');
667 $variable_doc_links['hostname'] = array(
668 'hostname',
669 'server-system-variables',
670 'sysvar');
671 $variable_doc_links['identity'] = array(
672 'identity',
673 'server-system-variables',
674 'sysvar');
675 $variable_doc_links['ignore_builtin_innodb'] = array(
676 'ignore-builtin-innodb',
677 'innodb-parameters',
678 'option_mysqld');
679 $variable_doc_links['ignore_db_dirs'] = array(
680 'ignore_db_dirs',
681 'server-system-variables',
682 'sysvar');
683 $variable_doc_links['init_connect'] = array(
684 'init_connect',
685 'server-system-variables',
686 'sysvar');
687 $variable_doc_links['init_file'] = array(
688 'init-file',
689 'server-options',
690 'option_mysqld');
691 $variable_doc_links['init_slave'] = array(
692 'init_slave',
693 'replication-options-slave',
694 'sysvar');
695 $variable_doc_links['innodb_adaptive_flushing'] = array(
696 'innodb_adaptive_flushing',
697 'innodb-parameters',
698 'sysvar');
699 $variable_doc_links['innodb_adaptive_flushing_lwm'] = array(
700 'innodb_adaptive_flushing_lwm',
701 'innodb-parameters',
702 'sysvar');
703 $variable_doc_links['innodb_adaptive_hash_index'] = array(
704 'innodb_adaptive_hash_index',
705 'innodb-parameters',
706 'sysvar');
707 $variable_doc_links['innodb_adaptive_max_sleep_delay'] = array(
708 'innodb_adaptive_max_sleep_delay',
709 'innodb-parameters',
710 'sysvar');
711 $variable_doc_links['innodb_additional_mem_pool_size'] = array(
712 'innodb_additional_mem_pool_size',
713 'innodb-parameters',
714 'sysvar',
715 'byte');
716 $variable_doc_links['innodb_api_bk_commit_interval'] = array(
717 'innodb_api_bk_commit_interval',
718 'innodb-parameters',
719 'sysvar');
720 $variable_doc_links['innodb_api_disable_rowlock'] = array(
721 'innodb_api_disable_rowlock',
722 'innodb-parameters',
723 'sysvar');
724 $variable_doc_links['innodb_api_enable_binlog'] = array(
725 'innodb_api_enable_binlog',
726 'innodb-parameters',
727 'sysvar');
728 $variable_doc_links['innodb_api_enable_mdl'] = array(
729 'innodb_api_enable_mdl',
730 'innodb-parameters',
731 'sysvar');
732 $variable_doc_links['innodb_api_trx_level'] = array(
733 'innodb_api_trx_level',
734 'innodb-parameters',
735 'sysvar');
736 $variable_doc_links['innodb_autoextend_increment'] = array(
737 'innodb_autoextend_increment',
738 'innodb-parameters',
739 'sysvar');
740 $variable_doc_links['innodb_autoinc_lock_mode'] = array(
741 'innodb_autoinc_lock_mode',
742 'innodb-parameters',
743 'sysvar');
744 $variable_doc_links['innodb_buffer_pool_dump_at_shutdown'] = array(
745 'innodb_buffer_pool_dump_at_shutdown',
746 'innodb-parameters',
747 'sysvar');
748 $variable_doc_links['innodb_buffer_pool_dump_now'] = array(
749 'innodb_buffer_pool_dump_now',
750 'innodb-parameters',
751 'sysvar');
752 $variable_doc_links['innodb_buffer_pool_filename'] = array(
753 'innodb_buffer_pool_filename',
754 'innodb-parameters',
755 'sysvar');
756 $variable_doc_links['innodb_buffer_pool_instances'] = array(
757 'innodb_buffer_pool_instances',
758 'innodb-parameters',
759 'sysvar');
760 $variable_doc_links['innodb_buffer_pool_load_abort'] = array(
761 'innodb_buffer_pool_load_abort',
762 'innodb-parameters',
763 'sysvar');
764 $variable_doc_links['innodb_buffer_pool_load_at_startup'] = array(
765 'innodb_buffer_pool_load_at_startup',
766 'innodb-parameters',
767 'sysvar');
768 $variable_doc_links['innodb_buffer_pool_load_now'] = array(
769 'innodb_buffer_pool_load_now',
770 'innodb-parameters',
771 'sysvar');
772 $variable_doc_links['innodb_buffer_pool_size'] = array(
773 'innodb_buffer_pool_size',
774 'innodb-parameters',
775 'sysvar',
776 'byte');
777 $variable_doc_links['innodb_change_buffer_max_size'] = array(
778 'innodb_change_buffer_max_size',
779 'innodb-parameters',
780 'sysvar');
781 $variable_doc_links['innodb_change_buffering'] = array(
782 'innodb_change_buffering',
783 'innodb-parameters',
784 'sysvar');
785 $variable_doc_links['innodb_checksum_algorithm'] = array(
786 'innodb_checksum_algorithm',
787 'innodb-parameters',
788 'sysvar');
789 $variable_doc_links['innodb_checksums'] = array(
790 'innodb_checksums',
791 'innodb-parameters',
792 'sysvar');
793 $variable_doc_links['innodb_cmp_per_index_enabled'] = array(
794 'innodb_cmp_per_index_enabled',
795 'innodb-parameters',
796 'sysvar');
797 $variable_doc_links['innodb_commit_concurrency'] = array(
798 'innodb_commit_concurrency',
799 'innodb-parameters',
800 'sysvar');
801 $variable_doc_links['innodb_compression_failure_threshold_pct'] = array(
802 'innodb_compression_failure_threshold_pct',
803 'innodb-parameters',
804 'sysvar');
805 $variable_doc_links['innodb_compression_level'] = array(
806 'innodb_compression_level',
807 'innodb-parameters',
808 'sysvar');
809 $variable_doc_links['innodb_compression_pad_pct_max'] = array(
810 'innodb_compression_pad_pct_max',
811 'innodb-parameters',
812 'sysvar');
813 $variable_doc_links['innodb_concurrency_tickets'] = array(
814 'innodb_concurrency_tickets',
815 'innodb-parameters',
816 'sysvar');
817 $variable_doc_links['innodb_data_file_path'] = array(
818 'innodb_data_file_path',
819 'innodb-parameters',
820 'sysvar');
821 $variable_doc_links['innodb_data_home_dir'] = array(
822 'innodb_data_home_dir',
823 'innodb-parameters',
824 'sysvar');
825 $variable_doc_links['innodb_disable_sort_file_cache'] = array(
826 'innodb_disable_sort_file_cache',
827 'innodb-parameters',
828 'sysvar');
829 $variable_doc_links['innodb_doublewrite'] = array(
830 'innodb_doublewrite',
831 'innodb-parameters',
832 'sysvar');
833 $variable_doc_links['innodb_fast_shutdown'] = array(
834 'innodb_fast_shutdown',
835 'innodb-parameters',
836 'sysvar');
837 $variable_doc_links['innodb_file_format'] = array(
838 'innodb_file_format',
839 'innodb-parameters',
840 'sysvar');
841 $variable_doc_links['innodb_file_format_check'] = array(
842 'innodb_file_format_check',
843 'innodb-parameters',
844 'sysvar');
845 $variable_doc_links['innodb_file_format_max'] = array(
846 'innodb_file_format_max',
847 'innodb-parameters',
848 'sysvar');
849 $variable_doc_links['innodb_file_per_table'] = array(
850 'innodb_file_per_table',
851 'innodb-parameters',
852 'sysvar');
853 $variable_doc_links['innodb_flush_log_at_timeout'] = array(
854 'innodb_flush_log_at_timeout',
855 'innodb-parameters',
856 'sysvar');
857 $variable_doc_links['innodb_flush_log_at_trx_commit'] = array(
858 'innodb_flush_log_at_trx_commit',
859 'innodb-parameters',
860 'sysvar');
861 $variable_doc_links['innodb_flush_method'] = array(
862 'innodb_flush_method',
863 'innodb-parameters',
864 'sysvar');
865 $variable_doc_links['innodb_flush_neighbors'] = array(
866 'innodb_flush_neighbors',
867 'innodb-parameters',
868 'sysvar');
869 $variable_doc_links['innodb_flushing_avg_loops'] = array(
870 'innodb_flushing_avg_loops',
871 'innodb-parameters',
872 'sysvar');
873 $variable_doc_links['innodb_force_load_corrupted'] = array(
874 'innodb_force_load_corrupted',
875 'innodb-parameters',
876 'sysvar');
877 $variable_doc_links['innodb_force_recovery'] = array(
878 'innodb_force_recovery',
879 'innodb-parameters',
880 'sysvar');
881 $variable_doc_links['innodb_ft_aux_table'] = array(
882 'innodb_ft_aux_table',
883 'innodb-parameters',
884 'sysvar');
885 $variable_doc_links['innodb_ft_cache_size'] = array(
886 'innodb_ft_cache_size',
887 'innodb-parameters',
888 'sysvar');
889 $variable_doc_links['innodb_ft_enable_diag_print'] = array(
890 'innodb_ft_enable_diag_print',
891 'innodb-parameters',
892 'sysvar');
893 $variable_doc_links['innodb_ft_enable_stopword'] = array(
894 'innodb_ft_enable_stopword',
895 'innodb-parameters',
896 'sysvar');
897 $variable_doc_links['innodb_ft_max_token_size'] = array(
898 'innodb_ft_max_token_size',
899 'innodb-parameters',
900 'sysvar');
901 $variable_doc_links['innodb_ft_min_token_size'] = array(
902 'innodb_ft_min_token_size',
903 'innodb-parameters',
904 'sysvar');
905 $variable_doc_links['innodb_ft_num_word_optimize'] = array(
906 'innodb_ft_num_word_optimize',
907 'innodb-parameters',
908 'sysvar');
909 $variable_doc_links['innodb_ft_result_cache_limit'] = array(
910 'innodb_ft_result_cache_limit',
911 'innodb-parameters',
912 'sysvar');
913 $variable_doc_links['innodb_ft_server_stopword_table'] = array(
914 'innodb_ft_server_stopword_table',
915 'innodb-parameters',
916 'sysvar');
917 $variable_doc_links['innodb_ft_sort_pll_degree'] = array(
918 'innodb_ft_sort_pll_degree',
919 'innodb-parameters',
920 'sysvar');
921 $variable_doc_links['innodb_ft_total_cache_size'] = array(
922 'innodb_ft_total_cache_size',
923 'innodb-parameters',
924 'sysvar');
925 $variable_doc_links['innodb_ft_user_stopword_table'] = array(
926 'innodb_ft_user_stopword_table',
927 'innodb-parameters',
928 'sysvar');
929 $variable_doc_links['innodb_io_capacity'] = array(
930 'innodb_io_capacity',
931 'innodb-parameters',
932 'sysvar');
933 $variable_doc_links['innodb_io_capacity_max'] = array(
934 'innodb_io_capacity_max',
935 'innodb-parameters',
936 'sysvar');
937 $variable_doc_links['innodb_large_prefix'] = array(
938 'innodb_large_prefix',
939 'innodb-parameters',
940 'sysvar');
941 $variable_doc_links['innodb_lock_wait_timeout'] = array(
942 'innodb_lock_wait_timeout',
943 'innodb-parameters',
944 'sysvar');
945 $variable_doc_links['innodb_locks_unsafe_for_binlog'] = array(
946 'innodb_locks_unsafe_for_binlog',
947 'innodb-parameters',
948 'sysvar');
949 $variable_doc_links['innodb_log_buffer_size'] = array(
950 'innodb_log_buffer_size',
951 'innodb-parameters',
952 'sysvar',
953 'byte');
954 $variable_doc_links['innodb_log_compressed_pages'] = array(
955 'innodb_log_compressed_pages',
956 'innodb-parameters',
957 'sysvar');
958 $variable_doc_links['innodb_log_file_size'] = array(
959 'innodb_log_file_size',
960 'innodb-parameters',
961 'sysvar',
962 'byte');
963 $variable_doc_links['innodb_log_files_in_group'] = array(
964 'innodb_log_files_in_group',
965 'innodb-parameters',
966 'sysvar');
967 $variable_doc_links['innodb_log_group_home_dir'] = array(
968 'innodb_log_group_home_dir',
969 'innodb-parameters',
970 'sysvar');
971 $variable_doc_links['innodb_lru_scan_depth'] = array(
972 'innodb_lru_scan_depth',
973 'innodb-parameters',
974 'sysvar');
975 $variable_doc_links['innodb_max_dirty_pages_pct'] = array(
976 'innodb_max_dirty_pages_pct',
977 'innodb-parameters',
978 'sysvar');
979 $variable_doc_links['innodb_max_dirty_pages_pct_lwm'] = array(
980 'innodb_max_dirty_pages_pct_lwm',
981 'innodb-parameters',
982 'sysvar');
983 $variable_doc_links['innodb_max_purge_lag'] = array(
984 'innodb_max_purge_lag',
985 'innodb-parameters',
986 'sysvar');
987 $variable_doc_links['innodb_max_purge_lag_delay'] = array(
988 'innodb_max_purge_lag_delay',
989 'innodb-parameters',
990 'sysvar');
991 $variable_doc_links['innodb_mirrored_log_groups'] = array(
992 'innodb_mirrored_log_groups',
993 'innodb-parameters',
994 'sysvar');
995 $variable_doc_links['innodb_monitor_disable'] = array(
996 'innodb_monitor_disable',
997 'innodb-parameters',
998 'sysvar');
999 $variable_doc_links['innodb_monitor_enable'] = array(
1000 'innodb_monitor_enable',
1001 'innodb-parameters',
1002 'sysvar');
1003 $variable_doc_links['innodb_monitor_reset'] = array(
1004 'innodb_monitor_reset',
1005 'innodb-parameters',
1006 'sysvar');
1007 $variable_doc_links['innodb_monitor_reset_all'] = array(
1008 'innodb_monitor_reset_all',
1009 'innodb-parameters',
1010 'sysvar');
1011 $variable_doc_links['innodb_old_blocks_pct'] = array(
1012 'innodb_old_blocks_pct',
1013 'innodb-parameters',
1014 'sysvar');
1015 $variable_doc_links['innodb_old_blocks_time'] = array(
1016 'innodb_old_blocks_time',
1017 'innodb-parameters',
1018 'sysvar');
1019 $variable_doc_links['innodb_online_alter_log_max_size'] = array(
1020 'innodb_online_alter_log_max_size',
1021 'innodb-parameters',
1022 'sysvar');
1023 $variable_doc_links['innodb_open_files'] = array(
1024 'innodb_open_files',
1025 'innodb-parameters',
1026 'sysvar');
1027 $variable_doc_links['innodb_optimize_fulltext_only'] = array(
1028 'innodb_optimize_fulltext_only',
1029 'innodb-parameters',
1030 'sysvar');
1031 $variable_doc_links['innodb_page_size'] = array(
1032 'innodb_page_size',
1033 'innodb-parameters',
1034 'sysvar');
1035 $variable_doc_links['innodb_print_all_deadlocks'] = array(
1036 'innodb_print_all_deadlocks',
1037 'innodb-parameters',
1038 'sysvar');
1039 $variable_doc_links['innodb_purge_batch_size'] = array(
1040 'innodb_purge_batch_size',
1041 'innodb-parameters',
1042 'sysvar');
1043 $variable_doc_links['innodb_purge_threads'] = array(
1044 'innodb_purge_threads',
1045 'innodb-parameters',
1046 'sysvar');
1047 $variable_doc_links['innodb_random_read_ahead'] = array(
1048 'innodb_random_read_ahead',
1049 'innodb-parameters',
1050 'sysvar');
1051 $variable_doc_links['innodb_read_ahead_threshold'] = array(
1052 'innodb_read_ahead_threshold',
1053 'innodb-parameters',
1054 'sysvar');
1055 $variable_doc_links['innodb_read_io_threads'] = array(
1056 'innodb_read_io_threads',
1057 'innodb-parameters',
1058 'sysvar');
1059 $variable_doc_links['innodb_read_only'] = array(
1060 'innodb_read_only',
1061 'innodb-parameters',
1062 'sysvar');
1063 $variable_doc_links['innodb_replication_delay'] = array(
1064 'innodb_replication_delay',
1065 'innodb-parameters',
1066 'sysvar');
1067 $variable_doc_links['innodb_rollback_on_timeout'] = array(
1068 'innodb_rollback_on_timeout',
1069 'innodb-parameters',
1070 'sysvar');
1071 $variable_doc_links['innodb_rollback_segments'] = array(
1072 'innodb_rollback_segments',
1073 'innodb-parameters',
1074 'sysvar');
1075 $variable_doc_links['innodb_sort_buffer_size'] = array(
1076 'innodb_sort_buffer_size',
1077 'innodb-parameters',
1078 'sysvar');
1079 $variable_doc_links['innodb_spin_wait_delay'] = array(
1080 'innodb_spin_wait_delay',
1081 'innodb-parameters',
1082 'sysvar');
1083 $variable_doc_links['innodb_stats_auto_recalc'] = array(
1084 'innodb_stats_auto_recalc',
1085 'innodb-parameters',
1086 'sysvar');
1087 $variable_doc_links['innodb_stats_method'] = array(
1088 'innodb_stats_method',
1089 'innodb-parameters',
1090 'sysvar');
1091 $variable_doc_links['innodb_stats_on_metadata'] = array(
1092 'innodb_stats_on_metadata',
1093 'innodb-parameters',
1094 'sysvar');
1095 $variable_doc_links['innodb_stats_persistent'] = array(
1096 'innodb_stats_persistent',
1097 'innodb-parameters',
1098 'sysvar');
1099 $variable_doc_links['innodb_stats_persistent_sample_pages'] = array(
1100 'innodb_stats_persistent_sample_pages',
1101 'innodb-parameters',
1102 'sysvar');
1103 $variable_doc_links['innodb_stats_sample_pages'] = array(
1104 'innodb_stats_sample_pages',
1105 'innodb-parameters',
1106 'sysvar');
1107 $variable_doc_links['innodb_stats_transient_sample_pages'] = array(
1108 'innodb_stats_transient_sample_pages',
1109 'innodb-parameters',
1110 'sysvar');
1111 $variable_doc_links['innodb_status_output'] = array(
1112 'innodb_status_output',
1113 'innodb-parameters',
1114 'sysvar');
1115 $variable_doc_links['innodb_status_output_locks'] = array(
1116 'innodb_status_output_locks',
1117 'innodb-parameters',
1118 'sysvar');
1119 $variable_doc_links['innodb_strict_mode'] = array(
1120 'innodb_strict_mode',
1121 'innodb-parameters',
1122 'sysvar');
1123 $variable_doc_links['innodb_support_xa'] = array(
1124 'innodb_support_xa',
1125 'innodb-parameters',
1126 'sysvar');
1127 $variable_doc_links['innodb_sync_array_size'] = array(
1128 'innodb_sync_array_size',
1129 'innodb-parameters',
1130 'sysvar');
1131 $variable_doc_links['innodb_sync_spin_loops'] = array(
1132 'innodb_sync_spin_loops',
1133 'innodb-parameters',
1134 'sysvar');
1135 $variable_doc_links['innodb_table_locks'] = array(
1136 'innodb_table_locks',
1137 'innodb-parameters',
1138 'sysvar');
1139 $variable_doc_links['innodb_thread_concurrency'] = array(
1140 'innodb_thread_concurrency',
1141 'innodb-parameters',
1142 'sysvar');
1143 $variable_doc_links['innodb_thread_sleep_delay'] = array(
1144 'innodb_thread_sleep_delay',
1145 'innodb-parameters',
1146 'sysvar');
1147 $variable_doc_links['innodb_undo_directory'] = array(
1148 'innodb_undo_directory',
1149 'innodb-parameters',
1150 'sysvar');
1151 $variable_doc_links['innodb_undo_logs'] = array(
1152 'innodb_undo_logs',
1153 'innodb-parameters',
1154 'sysvar');
1155 $variable_doc_links['innodb_undo_tablespaces'] = array(
1156 'innodb_undo_tablespaces',
1157 'innodb-parameters',
1158 'sysvar');
1159 $variable_doc_links['innodb_use_native_aio'] = array(
1160 'innodb_use_native_aio',
1161 'innodb-parameters',
1162 'sysvar');
1163 $variable_doc_links['innodb_use_sys_malloc'] = array(
1164 'innodb_use_sys_malloc',
1165 'innodb-parameters',
1166 'sysvar');
1167 $variable_doc_links['innodb_version'] = array(
1168 'innodb_version',
1169 'innodb-parameters',
1170 'sysvar');
1171 $variable_doc_links['innodb_write_io_threads'] = array(
1172 'innodb_write_io_threads',
1173 'innodb-parameters',
1174 'sysvar');
1175 $variable_doc_links['insert_id'] = array(
1176 'insert_id',
1177 'server-system-variables',
1178 'sysvar');
1179 $variable_doc_links['interactive_timeout'] = array(
1180 'interactive_timeout',
1181 'server-system-variables',
1182 'sysvar');
1183 $variable_doc_links['join_buffer_size'] = array(
1184 'join_buffer_size',
1185 'server-system-variables',
1186 'sysvar',
1187 'byte');
1188 $variable_doc_links['keep_files_on_create'] = array(
1189 'keep_files_on_create',
1190 'server-system-variables',
1191 'sysvar');
1192 $variable_doc_links['key_buffer_size'] = array(
1193 'key_buffer_size',
1194 'server-system-variables',
1195 'sysvar',
1196 'byte');
1197 $variable_doc_links['key_cache_age_threshold'] = array(
1198 'key_cache_age_threshold',
1199 'server-system-variables',
1200 'sysvar');
1201 $variable_doc_links['key_cache_block_size'] = array(
1202 'key_cache_block_size',
1203 'server-system-variables',
1204 'sysvar',
1205 'byte');
1206 $variable_doc_links['key_cache_division_limit'] = array(
1207 'key_cache_division_limit',
1208 'server-system-variables',
1209 'sysvar');
1210 $variable_doc_links['language'] = array(
1211 'language',
1212 'server-options',
1213 'option_mysqld');
1214 $variable_doc_links['large_files_support'] = array(
1215 'large_files_support',
1216 'server-system-variables',
1217 'sysvar');
1218 $variable_doc_links['large_page_size'] = array(
1219 'large_page_size',
1220 'server-system-variables',
1221 'sysvar',
1222 'byte');
1223 $variable_doc_links['large_pages'] = array(
1224 'large-pages',
1225 'server-options',
1226 'option_mysqld');
1227 $variable_doc_links['last_insert_id'] = array(
1228 'last_insert_id',
1229 'server-system-variables',
1230 'sysvar');
1231 $variable_doc_links['lc_messages'] = array(
1232 'lc-messages',
1233 'server-options',
1234 'option_mysqld');
1235 $variable_doc_links['lc_messages_dir'] = array(
1236 'lc-messages-dir',
1237 'server-options',
1238 'option_mysqld');
1239 $variable_doc_links['lc_time_names'] = array(
1240 'lc_time_names',
1241 'server-system-variables',
1242 'sysvar');
1243 $variable_doc_links['license'] = array(
1244 'license',
1245 'server-system-variables',
1246 'sysvar');
1247 $variable_doc_links['local_infile'] = array(
1248 'local_infile',
1249 'server-system-variables',
1250 'sysvar');
1251 $variable_doc_links['lock_wait_timeout'] = array(
1252 'lock_wait_timeout',
1253 'server-system-variables',
1254 'sysvar');
1255 $variable_doc_links['locked_in_memory'] = array(
1256 'locked_in_memory',
1257 'server-system-variables',
1258 'sysvar');
1259 $variable_doc_links['log'] = array(
1260 'log',
1261 'server-options',
1262 'option_mysqld');
1263 $variable_doc_links['log_bin'] = array(
1264 'log_bin',
1265 'replication-options-binary-log',
1266 'sysvar');
1267 $variable_doc_links['log-bin'] = array(
1268 'log-bin',
1269 'replication-options-binary-log',
1270 'option_mysqld');
1271 $variable_doc_links['log_bin_basename'] = array(
1272 'log_bin_basename',
1273 'replication-options-binary-log',
1274 'sysvar');
1275 $variable_doc_links['log_bin_index'] = array(
1276 'log_bin_index',
1277 'replication-options-binary-log',
1278 'sysvar');
1279 $variable_doc_links['log_bin_trust_function_creators'] = array(
1280 'log-bin-trust-function-creators',
1281 'replication-options-binary-log',
1282 'option_mysqld');
1283 $variable_doc_links['log_bin_use_v1_row_events'] = array(
1284 'log_bin_use_v1_row_events',
1285 'replication-options-binary-log',
1286 'sysvar');
1287 $variable_doc_links['log_error'] = array(
1288 'log-error',
1289 'server-options',
1290 'option_mysqld');
1291 $variable_doc_links['log_output'] = array(
1292 'log-output',
1293 'server-options',
1294 'option_mysqld');
1295 $variable_doc_links['log_queries_not_using_indexes'] = array(
1296 'log-queries-not-using-indexes',
1297 'server-options',
1298 'option_mysqld');
1299 $variable_doc_links['log_slave_updates'] = array(
1300 'log-slave-updates',
1301 'replication-options-slave',
1302 'option_mysqld');
1303 $variable_doc_links['log_slow_admin_statements'] = array(
1304 'log_slow_admin_statements',
1305 'server-system-variables',
1306 'sysvar');
1307 $variable_doc_links['log_slow_slave_statements'] = array(
1308 'log_slow_slave_statements',
1309 'replication-options-slave',
1310 'sysvar');
1311 $variable_doc_links['log_throttle_queries_not_using_indexes'] = array(
1312 'log_throttle_queries_not_using_indexes',
1313 'server-system-variables',
1314 'sysvar');
1315 $variable_doc_links['log_slow_queries'] = array(
1316 'log-slow-queries',
1317 'server-options',
1318 'option_mysqld');
1319 $variable_doc_links['log_warnings'] = array(
1320 'log-warnings',
1321 'server-options',
1322 'option_mysqld');
1323 $variable_doc_links['long_query_time'] = array(
1324 'long_query_time',
1325 'server-system-variables',
1326 'sysvar');
1327 $variable_doc_links['low_priority_updates'] = array(
1328 'low-priority-updates',
1329 'server-options',
1330 'option_mysqld');
1331 $variable_doc_links['lower_case_file_system'] = array(
1332 'lower_case_file_system',
1333 'server-system-variables',
1334 'sysvar');
1335 $variable_doc_links['lower_case_table_names'] = array(
1336 'lower_case_table_names',
1337 'server-system-variables',
1338 'sysvar');
1339 $variable_doc_links['master_info_repository'] = array(
1340 'master_info_repository',
1341 'replication-options-slave',
1342 'sysvar');
1343 $variable_doc_links['master_verify_checksum'] = array(
1344 'master_verify_checksum',
1345 'replication-options-binary-log',
1346 'sysvar');
1347 $variable_doc_links['master-bind'] = array(
1348 '',
1349 'replication-options',
1350 0);
1351 $variable_doc_links['max_allowed_packet'] = array(
1352 'max_allowed_packet',
1353 'server-system-variables',
1354 'sysvar');
1355 $variable_doc_links['max_binlog_cache_size'] = array(
1356 'max_binlog_cache_size',
1357 'replication-options-binary-log',
1358 'sysvar',
1359 'byte');
1360 $variable_doc_links['max_binlog_size'] = array(
1361 'max_binlog_size',
1362 'replication-options-binary-log',
1363 'sysvar',
1364 'byte');
1365 $variable_doc_links['max_binlog_stmt_cache_size'] = array(
1366 'max_binlog_stmt_cache_size',
1367 'replication-options-binary-log',
1368 'sysvar',
1369 'byte');
1370 $variable_doc_links['max_connect_errors'] = array(
1371 'max_connect_errors',
1372 'server-system-variables',
1373 'sysvar');
1374 $variable_doc_links['max_connections'] = array(
1375 'max_connections',
1376 'server-system-variables',
1377 'sysvar');
1378 $variable_doc_links['max_delayed_threads'] = array(
1379 'max_delayed_threads',
1380 'server-system-variables',
1381 'sysvar');
1382 $variable_doc_links['max_error_count'] = array(
1383 'max_error_count',
1384 'server-system-variables',
1385 'sysvar');
1386 $variable_doc_links['max_heap_table_size'] = array(
1387 'max_heap_table_size',
1388 'server-system-variables',
1389 'sysvar',
1390 'byte');
1391 $variable_doc_links['max_insert_delayed_threads'] = array(
1392 'max_insert_delayed_threads',
1393 'server-system-variables',
1394 'sysvar');
1395 $variable_doc_links['max_join_size'] = array(
1396 'max_join_size',
1397 'server-system-variables',
1398 'sysvar');
1399 $variable_doc_links['max_length_for_sort_data'] = array(
1400 'max_length_for_sort_data',
1401 'server-system-variables',
1402 'sysvar');
1403 $variable_doc_links['max_long_data_size'] = array(
1404 'max_long_data_size',
1405 'server-system-variables',
1406 'sysvar');
1407 $variable_doc_links['max_prepared_stmt_count'] = array(
1408 'max_prepared_stmt_count',
1409 'server-system-variables',
1410 'sysvar');
1411 $variable_doc_links['max_relay_log_size'] = array(
1412 'max_relay_log_size',
1413 'server-system-variables',
1414 'sysvar',
1415 'byte');
1416 $variable_doc_links['max_seeks_for_key'] = array(
1417 'max_seeks_for_key',
1418 'server-system-variables',
1419 'sysvar');
1420 $variable_doc_links['max_sort_length'] = array(
1421 'max_sort_length',
1422 'server-system-variables',
1423 'sysvar');
1424 $variable_doc_links['max_sp_recursion_depth'] = array(
1425 'max_sp_recursion_depth',
1426 'server-system-variables',
1427 'sysvar');
1428 $variable_doc_links['max_tmp_tables'] = array(
1429 'max_tmp_tables',
1430 'server-system-variables',
1431 'sysvar');
1432 $variable_doc_links['max_user_connections'] = array(
1433 'max_user_connections',
1434 'server-system-variables',
1435 'sysvar');
1436 $variable_doc_links['max_write_lock_count'] = array(
1437 'max_write_lock_count',
1438 'server-system-variables',
1439 'sysvar');
1440 $variable_doc_links['metadata_locks_cache_size'] = array(
1441 'metadata_locks_cache_size',
1442 'server-system-variables',
1443 'sysvar');
1444 $variable_doc_links['metadata_locks_hash_instances'] = array(
1445 'metadata_locks_hash_instances',
1446 'server-system-variables',
1447 'sysvar');
1448 $variable_doc_links['memlock'] = array(
1449 'memlock',
1450 'server-options',
1451 'option_mysqld');
1452 $variable_doc_links['min_examined_row_limit'] = array(
1453 'min-examined-row-limit',
1454 'server-options',
1455 'option_mysqld');
1456 $variable_doc_links['multi_range_count'] = array(
1457 'multi_range_count',
1458 'server-system-variables',
1459 'sysvar');
1460 $variable_doc_links['myisam_data_pointer_size'] = array(
1461 'myisam_data_pointer_size',
1462 'server-system-variables',
1463 'sysvar',
1464 'byte');
1465 $variable_doc_links['myisam_max_sort_file_size'] = array(
1466 'myisam_max_sort_file_size',
1467 'server-system-variables',
1468 'sysvar',
1469 'byte');
1470 $variable_doc_links['myisam_mmap_size'] = array(
1471 'myisam_mmap_size',
1472 'server-system-variables',
1473 'sysvar',
1474 'byte');
1475 $variable_doc_links['myisam_recover_options'] = array(
1476 'myisam_recover_options',
1477 'server-system-variables',
1478 'sysvar');
1479 $variable_doc_links['myisam_repair_threads'] = array(
1480 'myisam_repair_threads',
1481 'server-system-variables',
1482 'sysvar');
1483 $variable_doc_links['myisam_sort_buffer_size'] = array(
1484 'myisam_sort_buffer_size',
1485 'server-system-variables',
1486 'sysvar',
1487 'byte');
1488 $variable_doc_links['myisam_stats_method'] = array(
1489 'myisam_stats_method',
1490 'server-system-variables',
1491 'sysvar');
1492 $variable_doc_links['myisam_use_mmap'] = array(
1493 'myisam_use_mmap',
1494 'server-system-variables',
1495 'sysvar');
1496 $variable_doc_links['named_pipe'] = array(
1497 'named_pipe',
1498 'server-system-variables',
1499 'sysvar');
1500 $variable_doc_links['net_buffer_length'] = array(
1501 'net_buffer_length',
1502 'server-system-variables',
1503 'sysvar');
1504 $variable_doc_links['net_read_timeout'] = array(
1505 'net_read_timeout',
1506 'server-system-variables',
1507 'sysvar');
1508 $variable_doc_links['net_retry_count'] = array(
1509 'net_retry_count',
1510 'server-system-variables',
1511 'sysvar');
1512 $variable_doc_links['net_write_timeout'] = array(
1513 'net_write_timeout',
1514 'server-system-variables',
1515 'sysvar');
1516 $variable_doc_links['new'] = array(
1517 'new',
1518 'server-system-variables',
1519 'sysvar');
1520 $variable_doc_links['old'] = array(
1521 'old',
1522 'server-system-variables',
1523 'sysvar');
1524 $variable_doc_links['old_alter_table'] = array(
1525 'old-alter-table',
1526 'server-options',
1527 'option_mysqld');
1528 $variable_doc_links['old_passwords'] = array(
1529 'old-passwords',
1530 'server-options',
1531 'option_mysqld');
1532 $variable_doc_links['open_files_limit'] = array(
1533 'open-files-limit',
1534 'server-options',
1535 'option_mysqld');
1536 $variable_doc_links['optimizer_prune_level'] = array(
1537 'optimizer_prune_level',
1538 'server-system-variables',
1539 'sysvar');
1540 $variable_doc_links['optimizer_search_depth'] = array(
1541 'optimizer_search_depth',
1542 'server-system-variables',
1543 'sysvar');
1544 $variable_doc_links['optimizer_switch'] = array(
1545 'optimizer_switch',
1546 'server-system-variables',
1547 'sysvar');
1548 $variable_doc_links['optimizer_trace'] = array(
1549 'optimizer_trace',
1550 'server-system-variables',
1551 'sysvar');
1552 $variable_doc_links['optimizer_trace_features'] = array(
1553 'optimizer_trace_features',
1554 'server-system-variables',
1555 'sysvar');
1556 $variable_doc_links['optimizer_trace_limit'] = array(
1557 'optimizer_trace_limit',
1558 'server-system-variables',
1559 'sysvar');
1560 $variable_doc_links['optimizer_trace_max_mem_size'] = array(
1561 'optimizer_trace_max_mem_size',
1562 'server-system-variables',
1563 'sysvar');
1564 $variable_doc_links['optimizer_trace_offset'] = array(
1565 'optimizer_trace_offset',
1566 'server-system-variables',
1567 'sysvar');
1568 $variable_doc_links['partition'] = array(
1569 'partition',
1570 'server-options',
1571 'option_mysqld');
1572 $variable_doc_links['performance_schema'] = array(
1573 'performance_schema',
1574 'performance-schema-system-variables',
1575 'sysvar');
1576 $variable_doc_links['performance_schema_accounts_size'] = array(
1577 'performance_schema_accounts_size',
1578 'performance-schema-system-variables',
1579 'sysvar');
1580 $variable_doc_links['performance_schema_digests_size'] = array(
1581 'performance_schema_digests_size',
1582 'performance-schema-system-variables',
1583 'sysvar');
1584 $variable_doc_links['performance_schema_events_stages_history_long_size']
1585 = array(
1586 'performance_schema_events_stages_history_long_size',
1587 'performance-schema-system-variables',
1588 'sysvar',
1589 );
1590 $variable_doc_links['performance_schema_events_stages_history_size'] = array(
1591 'performance_schema_events_stages_history_size',
1592 'performance-schema-system-variables',
1593 'sysvar');
1594 $variable_doc_links['performance_schema_events_statements_history_long_size']
1595 = array(
1596 'performance_schema_events_statements_history_long_size',
1597 'performance-schema-system-variables',
1598 'sysvar',
1599 );
1600 $variable_doc_links['performance_schema_events_statements_history_size'] = array(
1601 'performance_schema_events_statements_history_size',
1602 'performance-schema-system-variables',
1603 'sysvar');
1604 $variable_doc_links['performance_schema_events_waits_history_long_size'] = array(
1605 'performance_schema_events_waits_history_long_size',
1606 'performance-schema-system-variables',
1607 'sysvar');
1608 $variable_doc_links['performance_schema_events_waits_history_size'] = array(
1609 'performance_schema_events_waits_history_size',
1610 'performance-schema-system-variables',
1611 'sysvar');
1612 $variable_doc_links['performance_schema_hosts_size'] = array(
1613 'performance_schema_hosts_size',
1614 'performance-schema-system-variables',
1615 'sysvar');
1616 $variable_doc_links['performance_schema_max_cond_classes'] = array(
1617 'performance_schema_max_cond_classes',
1618 'performance-schema-system-variables',
1619 'sysvar');
1620 $variable_doc_links['performance_schema_max_cond_instances'] = array(
1621 'performance_schema_max_cond_instances',
1622 'performance-schema-system-variables',
1623 'sysvar');
1624 $variable_doc_links['performance_schema_max_file_classes'] = array(
1625 'performance_schema_max_file_classes',
1626 'performance-schema-system-variables',
1627 'sysvar');
1628 $variable_doc_links['performance_schema_max_file_handles'] = array(
1629 'performance_schema_max_file_handles',
1630 'performance-schema-system-variables',
1631 'sysvar');
1632 $variable_doc_links['performance_schema_max_file_instances'] = array(
1633 'performance_schema_max_file_instances',
1634 'performance-schema-system-variables',
1635 'sysvar');
1636 $variable_doc_links['performance_schema_max_mutex_classes'] = array(
1637 'performance_schema_max_mutex_classes',
1638 'performance-schema-system-variables',
1639 'sysvar');
1640 $variable_doc_links['performance_schema_max_mutex_instances'] = array(
1641 'performance_schema_max_mutex_instances',
1642 'performance-schema-system-variables',
1643 'sysvar');
1644 $variable_doc_links['performance_schema_max_rwlock_classes'] = array(
1645 'performance_schema_max_rwlock_classes',
1646 'performance-schema-system-variables',
1647 'sysvar');
1648 $variable_doc_links['performance_schema_max_rwlock_instances'] = array(
1649 'performance_schema_max_rwlock_instances',
1650 'performance-schema-system-variables',
1651 'sysvar');
1652 $variable_doc_links['performance_schema_max_socket_classes'] = array(
1653 'performance_schema_max_socket_classes',
1654 'performance-schema-system-variables',
1655 'sysvar');
1656 $variable_doc_links['performance_schema_max_socket_instances'] = array(
1657 'performance_schema_max_socket_instances',
1658 'performance-schema-system-variables',
1659 'sysvar');
1660 $variable_doc_links['performance_schema_max_stage_classes'] = array(
1661 'performance_schema_max_stage_classes',
1662 'performance-schema-system-variables',
1663 'sysvar');
1664 $variable_doc_links['performance_schema_max_statement_classes'] = array(
1665 'performance_schema_max_statement_classes',
1666 'performance-schema-system-variables',
1667 'sysvar');
1668 $variable_doc_links['performance_schema_max_table_handles'] = array(
1669 'performance_schema_max_table_handles',
1670 'performance-schema-system-variables',
1671 'sysvar');
1672 $variable_doc_links['performance_schema_max_table_instances'] = array(
1673 'performance_schema_max_table_instances',
1674 'performance-schema-system-variables',
1675 'sysvar');
1676 $variable_doc_links['performance_schema_max_thread_classes'] = array(
1677 'performance_schema_max_thread_classes',
1678 'performance-schema-system-variables',
1679 'sysvar');
1680 $variable_doc_links['performance_schema_max_thread_instances'] = array(
1681 'performance_schema_max_thread_instances',
1682 'performance-schema-system-variables',
1683 'sysvar');
1684 $variable_doc_links['performance_schema_session_connect_attrs_size'] = array(
1685 'performance_schema_session_connect_attrs_size',
1686 'performance-schema-system-variables',
1687 'sysvar');
1688 $variable_doc_links['performance_schema_setup_actors_size'] = array(
1689 'performance_schema_setup_actors_size',
1690 'performance-schema-system-variables',
1691 'sysvar');
1692 $variable_doc_links['performance_schema_setup_objects_size'] = array(
1693 'performance_schema_setup_objects_size',
1694 'performance-schema-system-variables',
1695 'sysvar');
1696 $variable_doc_links['performance_schema_users_size'] = array(
1697 'performance_schema_users_size',
1698 'performance-schema-system-variables',
1699 'sysvar');
1700 $variable_doc_links['pid_file'] = array(
1701 'pid-file',
1702 'server-options',
1703 'option_mysqld');
1704 $variable_doc_links['plugin_dir'] = array(
1705 'plugin_dir',
1706 'server-system-variables',
1707 'sysvar');
1708 $variable_doc_links['port'] = array(
1709 'port',
1710 'server-options',
1711 'option_mysqld');
1712 $variable_doc_links['preload_buffer_size'] = array(
1713 'preload_buffer_size',
1714 'server-system-variables',
1715 'sysvar',
1716 'byte');
1717 $variable_doc_links['profiling'] = array(
1718 'profiling',
1719 'server-system-variables',
1720 'sysvar');
1721 $variable_doc_links['profiling_history_size'] = array(
1722 'profiling_history_size',
1723 'server-system-variables',
1724 'sysvar');
1725 $variable_doc_links['protocol_version'] = array(
1726 'protocol_version',
1727 'server-system-variables',
1728 'sysvar');
1729 $variable_doc_links['proxy_user'] = array(
1730 'proxy_user',
1731 'server-system-variables',
1732 'sysvar');
1733 $variable_doc_links['pseudo_thread_id'] = array(
1734 'pseudo_thread_id',
1735 'server-system-variables',
1736 'sysvar');
1737 $variable_doc_links['query_alloc_block_size'] = array(
1738 'query_alloc_block_size',
1739 'server-system-variables',
1740 'sysvar',
1741 'byte');
1742 $variable_doc_links['query_cache_limit'] = array(
1743 'query_cache_limit',
1744 'server-system-variables',
1745 'sysvar',
1746 'byte');
1747 $variable_doc_links['query_cache_min_res_unit'] = array(
1748 'query_cache_min_res_unit',
1749 'server-system-variables',
1750 'sysvar');
1751 $variable_doc_links['query_cache_size'] = array(
1752 'query_cache_size',
1753 'server-system-variables',
1754 'sysvar',
1755 'byte');
1756 $variable_doc_links['query_cache_type'] = array(
1757 'query_cache_type',
1758 'server-system-variables',
1759 'sysvar');
1760 $variable_doc_links['query_cache_wlock_invalidate'] = array(
1761 'query_cache_wlock_invalidate',
1762 'server-system-variables',
1763 'sysvar');
1764 $variable_doc_links['query_prealloc_size'] = array(
1765 'query_prealloc_size',
1766 'server-system-variables',
1767 'sysvar',
1768 'byte');
1769 $variable_doc_links['rand_seed1'] = array(
1770 'rand_seed1',
1771 'server-system-variables',
1772 'sysvar');
1773 $variable_doc_links['rand_seed2'] = array(
1774 'rand_seed2',
1775 'server-system-variables',
1776 'sysvar');
1777 $variable_doc_links['range_alloc_block_size'] = array(
1778 'range_alloc_block_size',
1779 'server-system-variables',
1780 'sysvar',
1781 'byte');
1782 $variable_doc_links['read_buffer_size'] = array(
1783 'read_buffer_size',
1784 'server-system-variables',
1785 'sysvar',
1786 'byte');
1787 $variable_doc_links['read_only'] = array(
1788 'read_only',
1789 'server-system-variables',
1790 'sysvar');
1791 $variable_doc_links['read_rnd_buffer_size'] = array(
1792 'read_rnd_buffer_size',
1793 'server-system-variables',
1794 'sysvar',
1795 'byte');
1796 $variable_doc_links['relay_log'] = array(
1797 'relay_log',
1798 'replication-options-slave',
1799 'sysvar');
1800 $variable_doc_links['relay_log_basename'] = array(
1801 'relay_log_basename',
1802 'replication-options-slave',
1803 'sysvar');
1804 $variable_doc_links['relay-log-index'] = array(
1805 'relay-log-index',
1806 'replication-options-slave',
1807 'option_mysqld');
1808 $variable_doc_links['relay_log_index'] = array(
1809 'relay_log_index',
1810 'replication-options-slave',
1811 'sysvar');
1812 $variable_doc_links['relay_log_info_file'] = array(
1813 'relay_log_info_file',
1814 'replication-options-slave',
1815 'sysvar');
1816 $variable_doc_links['relay_log_info_repository'] = array(
1817 'relay_log_info_repository',
1818 'replication-options-slave',
1819 'sysvar');
1820 $variable_doc_links['relay_log_purge'] = array(
1821 'relay_log_purge',
1822 'server-system-variables',
1823 'sysvar');
1824 $variable_doc_links['relay_log_recovery'] = array(
1825 'relay_log_recovery',
1826 'replication-options-slave',
1827 'sysvar');
1828 $variable_doc_links['relay_log_space_limit'] = array(
1829 'relay_log_space_limit',
1830 'server-system-variables',
1831 'sysvar');
1832 $variable_doc_links['report_host'] = array(
1833 'report-host',
1834 'replication-options-slave',
1835 'option_mysqld');
1836 $variable_doc_links['report_password'] = array(
1837 'report-password',
1838 'replication-options-slave',
1839 'option_mysqld');
1840 $variable_doc_links['report_port'] = array(
1841 'report-port',
1842 'replication-options-slave',
1843 'option_mysqld');
1844 $variable_doc_links['report_user'] = array(
1845 'report-user',
1846 'replication-options-slave',
1847 'option_mysqld');
1848 $variable_doc_links['rpl_stop_slave_timeout'] = array(
1849 'rpl_stop_slave_timeout',
1850 'replication-options-slave',
1851 'sysvar');
1852 $variable_doc_links['rpl_recovery_rank'] = array(
1853 'rpl_recovery_rank',
1854 'replication-options-slave',
1855 'option_mysqld');
1856 $variable_doc_links['rpl_semi_sync_master_enabled'] = array(
1857 'rpl_semi_sync_master_enabled',
1858 'server-system-variables',
1859 'sysvar');
1860 $variable_doc_links['rpl_semi_sync_master_timeout'] = array(
1861 'rpl_semi_sync_master_timeout',
1862 'server-system-variables',
1863 'sysvar');
1864 $variable_doc_links['rpl_semi_sync_master_trace_level'] = array(
1865 'rpl_semi_sync_master_trace_level',
1866 'server-system-variables',
1867 'sysvar');
1868 $variable_doc_links['rpl_semi_sync_master_wait_no_slave'] = array(
1869 'rpl_semi_sync_master_wait_no_slave',
1870 'server-system-variables',
1871 'sysvar');
1872 $variable_doc_links['rpl_semi_sync_slave_enabled'] = array(
1873 'rpl_semi_sync_slave_enabled',
1874 'server-system-variables',
1875 'sysvar');
1876 $variable_doc_links['rpl_semi_sync_slave_trace_level'] = array(
1877 'rpl_semi_sync_slave_trace_level',
1878 'server-system-variables',
1879 'sysvar');
1880 $variable_doc_links['safe_show_database'] = array(
1881 'safe-show-database',
1882 'server-options',
1883 'option_mysqld');
1884 $variable_doc_links['secure_auth'] = array(
1885 'secure-auth',
1886 'server-options',
1887 'option_mysqld');
1888 $variable_doc_links['secure_file_priv'] = array(
1889 'secure-file-priv',
1890 'server-options',
1891 'option_mysqld');
1892 $variable_doc_links['server_id'] = array(
1893 'server-id',
1894 'replication-options',
1895 'option_mysqld');
1896 $variable_doc_links['server_id_bits'] = array(
1897 'server_id_bits',
1898 'mysql-cluster-system-variables',
1899 'sysvar');
1900 $variable_doc_links['server_uuid'] = array(
1901 'server_uuid',
1902 'replication-options',
1903 'sysvar');
1904 $variable_doc_links['shared_memory'] = array(
1905 'shared_memory',
1906 'server-system-variables',
1907 'sysvar');
1908 $variable_doc_links['shared_memory_base_name'] = array(
1909 'shared_memory_base_name',
1910 'server-system-variables',
1911 'sysvar');
1912 $variable_doc_links['skip_external_locking'] = array(
1913 'skip-external-locking',
1914 'server-options',
1915 'option_mysqld');
1916 $variable_doc_links['skip_name_resolve'] = array(
1917 'skip-name-resolve',
1918 'server-options',
1919 'option_mysqld');
1920 $variable_doc_links['skip_networking'] = array(
1921 'skip-networking',
1922 'server-options',
1923 'option_mysqld');
1924 $variable_doc_links['skip_show_database'] = array(
1925 'skip-show-database',
1926 'server-options',
1927 'option_mysqld');
1928 $variable_doc_links['slave_allow_batching'] = array(
1929 'slave_allow_batching',
1930 'mysql-cluster-system-variables',
1931 'sysvar');
1932 $variable_doc_links['slave_checkpoint_group'] = array(
1933 'slave_checkpoint_group',
1934 'replication-options-slave',
1935 'sysvar');
1936 $variable_doc_links['slave_checkpoint_period'] = array(
1937 'slave_checkpoint_period',
1938 'replication-options-slave',
1939 'sysvar');
1940 $variable_doc_links['slave_compressed_protocol'] = array(
1941 'slave_compressed_protocol',
1942 'replication-options-slave',
1943 'sysvar');
1944 $variable_doc_links['slave_exec_mode'] = array(
1945 'slave_exec_mode',
1946 'replication-options-slave',
1947 'sysvar');
1948 $variable_doc_links['slave_load_tmpdir'] = array(
1949 'slave-load-tmpdir',
1950 'replication-options-slave',
1951 'option_mysqld');
1952 $variable_doc_links['slave_max_allowed_packet'] = array(
1953 'slave_max_allowed_packet',
1954 'replication-options-slave',
1955 'sysvar');
1956 $variable_doc_links['slave_net_timeout'] = array(
1957 'slave-net-timeout',
1958 'replication-options-slave',
1959 'option_mysqld');
1960 $variable_doc_links['slave_parallel_workers'] = array(
1961 'slave_parallel_workers',
1962 'replication-options-slave',
1963 'sysvar');
1964 $variable_doc_links['slave_pending_jobs_size_max'] = array(
1965 'slave_pending_jobs_size_max',
1966 'replication-options-slave',
1967 'sysvar');
1968 $variable_doc_links['slave_rows_search_algorithms'] = array(
1969 'slave_rows_search_algorithms',
1970 'replication-options-slave',
1971 'sysvar');
1972 $variable_doc_links['slave_skip_errors'] = array(
1973 'slave-skip-errors',
1974 'replication-options-slave',
1975 'option_mysqld');
1976 $variable_doc_links['slave_sql_verify_checksum'] = array(
1977 'slave_sql_verify_checksum',
1978 'replication-options-slave',
1979 'sysvar');
1980 $variable_doc_links['slave_transaction_retries'] = array(
1981 'slave_transaction_retries',
1982 'replication-options-slave',
1983 'sysvar');
1984 $variable_doc_links['slave_type_conversions'] = array(
1985 'slave_type_conversions',
1986 'replication-options-slave',
1987 'sysvar');
1988 $variable_doc_links['slow_launch_time'] = array(
1989 'slow_launch_time',
1990 'server-system-variables',
1991 'sysvar');
1992 $variable_doc_links['slow_query_log'] = array(
1993 'slow-query-log',
1994 'server-options',
1995 'server-system-variables');
1996 $variable_doc_links['slow_query_log_file'] = array(
1997 'slow_query_log_file',
1998 'server-system-variables',
1999 'sysvar');
2000 $variable_doc_links['socket'] = array(
2001 'socket',
2002 'server-options',
2003 'option_mysqld');
2004 $variable_doc_links['sort_buffer_size'] = array(
2005 'sort_buffer_size',
2006 'server-system-variables',
2007 'sysvar',
2008 'byte');
2009 $variable_doc_links['sql_auto_is_null'] = array(
2010 'sql_auto_is_null',
2011 'server-system-variables',
2012 'sysvar');
2013 $variable_doc_links['sql_big_selects'] = array(
2014 'sql_big_selects',
2015 'server-system-variables',
2016 'sysvar');
2017 $variable_doc_links['sql_big_tables'] = array(
2018 'big-tables',
2019 'server-options',
2020 'server-system-variables');
2021 $variable_doc_links['sql_buffer_result'] = array(
2022 'sql_buffer_result',
2023 'server-system-variables',
2024 'sysvar');
2025 $variable_doc_links['sql_log_bin'] = array(
2026 'sql_log_bin',
2027 'server-system-variables',
2028 'sysvar');
2029 $variable_doc_links['sql_log_off'] = array(
2030 'sql_log_off',
2031 'server-system-variables',
2032 'sysvar');
2033 $variable_doc_links['sql_log_update'] = array(
2034 'sql_log_update',
2035 'server-system-variables',
2036 'sysvar');
2037 $variable_doc_links['sql_low_priority_updates'] = array(
2038 'sql_low_priority_updates',
2039 'server-system-variables',
2040 'sysvar');
2041 $variable_doc_links['sql_max_join_size'] = array(
2042 'sql_max_join_size',
2043 'server-system-variables',
2044 'sysvar');
2045 $variable_doc_links['sql_mode'] = array(
2046 'sql-mode',
2047 'server-options',
2048 'option_mysqld');
2049 $variable_doc_links['sql_notes'] = array(
2050 'sql_notes',
2051 'server-system-variables',
2052 'sysvar');
2053 $variable_doc_links['sql_quote_show_create'] = array(
2054 'sql_quote_show_create',
2055 'server-system-variables',
2056 'sysvar');
2057 $variable_doc_links['sql_safe_updates'] = array(
2058 'sql_safe_updates',
2059 'server-system-variables',
2060 'sysvar');
2061 $variable_doc_links['sql_select_limit'] = array(
2062 'sql_select_limit',
2063 'server-system-variables',
2064 'sysvar');
2065 $variable_doc_links['sql_slave_skip_counter'] = array(
2066 'sql_slave_skip_counter',
2067 'replication-options-slave',
2068 'sysvar');
2069 $variable_doc_links['sql_warnings'] = array(
2070 'sql_warnings',
2071 'server-system-variables',
2072 'sysvar');
2073 $variable_doc_links['ssl_ca'] = array(
2074 'ssl-ca',
2075 'ssl-options',
2076 'option_general');
2077 $variable_doc_links['ssl_capath'] = array(
2078 'ssl-capath',
2079 'ssl-options',
2080 'option_general');
2081 $variable_doc_links['ssl_cert'] = array(
2082 'ssl-cert',
2083 'ssl-options',
2084 'option_general');
2085 $variable_doc_links['ssl_cipher'] = array(
2086 'ssl-cipher',
2087 'ssl-options',
2088 'option_general');
2089 $variable_doc_links['ssl_crl'] = array(
2090 'ssl_crl',
2091 'server-system-variables',
2092 'sysvar');
2093 $variable_doc_links['ssl_crlpath'] = array(
2094 'ssl_crlpath',
2095 'server-system-variables',
2096 'sysvar');
2097 $variable_doc_links['ssl_key'] = array(
2098 'ssl-key',
2099 'ssl-options',
2100 'option_general');
2101 $variable_doc_links['storage_engine'] = array(
2102 'storage_engine',
2103 'server-system-variables',
2104 'sysvar');
2105 $variable_doc_links['stored_program_cache'] = array(
2106 'stored_program_cache',
2107 'server-system-variables',
2108 'sysvar');
2109 $variable_doc_links['sync_binlog'] = array(
2110 'sync_binlog',
2111 'replication-options-binary-log',
2112 'sysvar');
2113 $variable_doc_links['sync_frm'] = array(
2114 'sync_frm',
2115 'server-system-variables',
2116 'sysvar');
2117 $variable_doc_links['sync_master_info'] = array(
2118 'sync_master_info',
2119 'replication-options-slave',
2120 'sysvar');
2121 $variable_doc_links['sync_relay_log'] = array(
2122 'sync_relay_log',
2123 'replication-options-slave',
2124 'sysvar');
2125 $variable_doc_links['sync_relay_log_info'] = array(
2126 'sync_relay_log_info',
2127 'replication-options-slave',
2128 'sysvar');
2129 $variable_doc_links['system_time_zone'] = array(
2130 'system_time_zone',
2131 'server-system-variables',
2132 'sysvar');
2133 $variable_doc_links['table_definition_cache'] = array(
2134 'table_definition_cache',
2135 'server-system-variables',
2136 'sysvar');
2137 $variable_doc_links['table_lock_wait_timeout'] = array(
2138 'table_lock_wait_timeout',
2139 'server-system-variables',
2140 'sysvar');
2141 $variable_doc_links['table_open_cache'] = array(
2142 'table_open_cache',
2143 'server-system-variables',
2144 'sysvar');
2145 $variable_doc_links['table_open_cache_instances'] = array(
2146 'table_open_cache_instances',
2147 'server-system-variables',
2148 'sysvar');
2149 $variable_doc_links['table_type'] = array(
2150 'table_type',
2151 'server-system-variables',
2152 'sysvar');
2153 $variable_doc_links['thread_cache_size'] = array(
2154 'thread_cache_size',
2155 'server-system-variables',
2156 'sysvar');
2157 $variable_doc_links['thread_concurrency'] = array(
2158 'thread_concurrency',
2159 'server-system-variables',
2160 'sysvar');
2161 $variable_doc_links['thread_handling'] = array(
2162 'thread_handling',
2163 'server-system-variables',
2164 'sysvar');
2165 $variable_doc_links['thread_stack'] = array(
2166 'thread_stack',
2167 'server-system-variables',
2168 'sysvar');
2169 $variable_doc_links['time_format'] = array(
2170 'time_format',
2171 'server-system-variables',
2172 'sysvar');
2173 $variable_doc_links['time_zone'] = array(
2174 'time_zone',
2175 'server-system-variables',
2176 'sysvar');
2177 $variable_doc_links['timed_mutexes'] = array(
2178 'timed_mutexes',
2179 'server-system-variables',
2180 'sysvar');
2181 $variable_doc_links['timestamp'] = array(
2182 'timestamp',
2183 'server-system-variables',
2184 'sysvar');
2185 $variable_doc_links['tmp_table_size'] = array(
2186 'tmp_table_size',
2187 'server-system-variables',
2188 'sysvar',
2189 'byte');
2190 $variable_doc_links['tmpdir'] = array(
2191 'tmpdir',
2192 'server-options',
2193 'option_mysqld');
2194 $variable_doc_links['transaction_alloc_block_size'] = array(
2195 'transaction_alloc_block_size',
2196 'server-system-variables',
2197 'sysvar',
2198 'byte');
2199 $variable_doc_links['transaction_prealloc_size'] = array(
2200 'transaction_prealloc_size',
2201 'server-system-variables',
2202 'sysvar',
2203 'byte');
2204 $variable_doc_links['tx_isolation'] = array(
2205 'tx_isolation',
2206 'server-system-variables',
2207 'sysvar');
2208 $variable_doc_links['tx_read_only'] = array(
2209 'tx_read_only',
2210 'server-system-variables',
2211 'sysvar');
2212 $variable_doc_links['unique_checks'] = array(
2213 'unique_checks',
2214 'server-system-variables',
2215 'sysvar');
2216 $variable_doc_links['updatable_views_with_limit'] = array(
2217 'updatable_views_with_limit',
2218 'server-system-variables',
2219 'sysvar');
2220 $variable_doc_links['version'] = array(
2221 'version',
2222 'server-system-variables',
2223 'sysvar');
2224 $variable_doc_links['version_comment'] = array(
2225 'version_comment',
2226 'server-system-variables',
2227 'sysvar');
2228 $variable_doc_links['version_compile_machine'] = array(
2229 'version_compile_machine',
2230 'server-system-variables',
2231 'sysvar');
2232 $variable_doc_links['version_compile_os'] = array(
2233 'version_compile_os',
2234 'server-system-variables',
2235 'sysvar');
2236 $variable_doc_links['wait_timeout'] = array(
2237 'wait_timeout',
2238 'server-system-variables',
2239 'sysvar');
2240 $variable_doc_links['warning_count'] = array(
2241 'warning_count',
2242 'server-system-variables',
2243 'sysvar');
2244 return $variable_doc_links;
2245 }
2246
2247 /**
2248 * Returns Array of dynamic system variables (i.e. not read-only)
2249 *
2250 * @return array
2251 */
2252 function PMA_getDynamicSystemVariables()
2253 {
2254 $dynamic_variables = array(
2255 'auto_increment_increment',
2256 'auto_increment_offset',
2257 'autocommit',
2258 'automatic_sp_privileges',
2259 'avoid_temporal_upgrade',
2260 'big_tables',
2261 'binlog_cache_size',
2262 'binlog_checksum',
2263 'binlog_direct_non_transactional_updates',
2264 'binlog_error_action',
2265 'binlog_format',
2266 'binlog_group_commit_sync_delay',
2267 'binlog_group_commit_sync_no_delay_count',
2268 'binlog_max_flush_queue_time',
2269 'binlog_order_commits',
2270 'binlog_row_image=image_type',
2271 'binlog_rows_query_log_events',
2272 'binlog_stmt_cache_size',
2273 'binlogging_impossible_mode',
2274 'block_encryption_mode',
2275 'bulk_insert_buffer_size',
2276 'character_set_client',
2277 'character_set_connection',
2278 'character_set_database',
2279 'character_set_filesystem',
2280 'character_set_results',
2281 'character_set_server',
2282 'check_proxy_users',
2283 'collation_connection',
2284 'collation_database',
2285 'collation_server',
2286 'completion_type',
2287 'concurrent_insert',
2288 'connect_timeout',
2289 'debug',
2290 'debug_sync',
2291 'default_password_lifetime',
2292 'default_storage_engine',
2293 'default_tmp_storage_engine',
2294 'default_week_format',
2295 'delay_key_write',
2296 'delayed_insert_limit',
2297 'delayed_insert_timeout',
2298 'delayed_queue_size',
2299 'div_precision_increment',
2300 'end_markers_in_json',
2301 'enforce_gtid_consistency',
2302 'enforce_gtid_consistency',
2303 'eq_range_index_dive_limit',
2304 'event_scheduler',
2305 'executed_gtids_compression_period',
2306 'expire_logs_days',
2307 'flush',
2308 'flush_time',
2309 'foreign_key_checks',
2310 'ft_boolean_syntax',
2311 'general_log',
2312 'general_log_file',
2313 'group_concat_max_len',
2314 'gtid_executed_compression_period',
2315 'gtid_mode',
2316 'gtid_mode',
2317 'gtid_next',
2318 'gtid_purged',
2319 'host_cache_size',
2320 'identity',
2321 'init_connect',
2322 'init_slave',
2323 'innodb_adaptive_flushing',
2324 'innodb_adaptive_flushing_lwm',
2325 'innodb_adaptive_hash_index',
2326 'innodb_adaptive_max_sleep_delay',
2327 'innodb_api_bk_commit_interval',
2328 'innodb_api_trx_level',
2329 'innodb_autoextend_increment',
2330 'innodb_buffer_pool_dump_at_shutdown',
2331 'innodb_buffer_pool_dump_now',
2332 'innodb_buffer_pool_dump_pct',
2333 'innodb_buffer_pool_filename',
2334 'innodb_buffer_pool_load_abort',
2335 'innodb_buffer_pool_load_now',
2336 'innodb_buffer_pool_size',
2337 'innodb_change_buffer_max_size',
2338 'innodb_change_buffering',
2339 'innodb_checksum_algorithm',
2340 'innodb_cmp_per_index_enabled',
2341 'innodb_commit_concurrency',
2342 'innodb_compression_failure_threshold_pct',
2343 'innodb_compression_level',
2344 'innodb_compression_pad_pct_max',
2345 'innodb_concurrency_tickets',
2346 'innodb_create_intrinsic',
2347 'innodb_disable_sort_file_cache',
2348 'innodb_fast_shutdown',
2349 'innodb_file_format',
2350 'innodb_file_format_max',
2351 'innodb_file_per_table',
2352 'innodb_fill_factor',
2353 'innodb_flush_log_at_timeout',
2354 'innodb_flush_log_at_trx_commit',
2355 'innodb_flush_neighbors',
2356 'innodb_flush_sync',
2357 'innodb_flushing_avg_loops',
2358 'innodb_ft_aux_table',
2359 'innodb_ft_enable_diag_print',
2360 'innodb_ft_enable_stopword',
2361 'innodb_ft_num_word_optimize',
2362 'innodb_ft_result_cache_limit',
2363 'innodb_ft_server_stopword_table',
2364 'innodb_ft_user_stopword_table',
2365 'innodb_io_capacity',
2366 'innodb_io_capacity_max',
2367 'innodb_large_prefix',
2368 'innodb_lock_wait_timeout',
2369 'innodb_log_checksum_algorithm',
2370 'innodb_log_compressed_pages',
2371 'innodb_log_write_ahead_size',
2372 'innodb_lru_scan_depth',
2373 'innodb_max_dirty_pages_pct',
2374 'innodb_max_dirty_pages_pct_lwm',
2375 'innodb_max_purge_lag',
2376 'innodb_max_purge_lag_delay',
2377 'innodb_max_undo_log_size',
2378 'innodb_monitor_disable',
2379 'innodb_monitor_enable',
2380 'innodb_monitor_reset',
2381 'innodb_monitor_reset_all',
2382 'innodb_old_blocks_pct',
2383 'innodb_old_blocks_time',
2384 'innodb_online_alter_log_max_size',
2385 'innodb_optimize_fulltext_only',
2386 'innodb_optimize_point_storage',
2387 'innodb_print_all_deadlocks',
2388 'innodb_purge_batch_size',
2389 'innodb_purge_rseg_truncate_frequency',
2390 'innodb_random_read_ahead',
2391 'innodb_read_ahead_threshold',
2392 'innodb_replication_delay',
2393 'innodb_rollback_segments',
2394 'innodb_spin_wait_delay',
2395 'innodb_stats_auto_recalc',
2396 'innodb_stats_method',
2397 'innodb_stats_on_metadata',
2398 'innodb_stats_persistent',
2399 'innodb_stats_persistent_sample_pages',
2400 'innodb_stats_sample_pages',
2401 'innodb_stats_transient_sample_pages',
2402 'innodb_status_output',
2403 'innodb_status_output_locks',
2404 'innodb_strict_mode',
2405 'innodb_support_xa',
2406 'innodb_sync_spin_loops',
2407 'innodb_table_locks',
2408 'innodb_thread_concurrency',
2409 'innodb_thread_sleep_delay',
2410 'innodb_undo_log_truncate',
2411 'innodb_undo_logs',
2412 'insert_id',
2413 'interactive_timeout',
2414 'internal_tmp_disk_storage_engine',
2415 'join_buffer_size',
2416 'keep_files_on_create',
2417 'key_buffer_size',
2418 'key_cache_age_threshold',
2419 'key_cache_block_size',
2420 'key_cache_division_limit',
2421 'last_insert_id',
2422 'lc_messages',
2423 'lc_time_names',
2424 'local_infile',
2425 'lock_wait_timeout',
2426 'log_backward_compatible_user_definitions',
2427 'log_bin_trust_function_creators',
2428 'log_error_verbosity',
2429 'log_output',
2430 'log_queries_not_using_indexes',
2431 'log_slow_admin_statements',
2432 'log_slow_slave_statements',
2433 'log_syslog',
2434 'log_syslog_facility',
2435 'log_syslog_include_pid',
2436 'log_syslog_tag',
2437 'log_throttle_queries_not_using_indexes',
2438 'log_timestamps',
2439 'log_warnings',
2440 'long_query_time',
2441 'low_priority_updates',
2442 'master_info_repository',
2443 'master_verify_checksum',
2444 'max_allowed_packet',
2445 'max_binlog_cache_size',
2446 'max_binlog_size',
2447 'max_binlog_stmt_cache_size',
2448 'max_connect_errors',
2449 'max_connections',
2450 'max_delayed_threads',
2451 'max_error_count',
2452 'max_heap_table_size',
2453 'max_insert_delayed_threads',
2454 'max_join_size',
2455 'max_length_for_sort_data',
2456 'max_points_in_geometry',
2457 'max_prepared_stmt_count',
2458 'max_relay_log_size',
2459 'max_seeks_for_key',
2460 'max_sort_length',
2461 'max_sp_recursion_depth',
2462 'max_statement_time',
2463 'max_user_connections',
2464 'max_write_lock_count',
2465 'min_examined_row_limit',
2466 'myisam_data_pointer_size',
2467 'myisam_max_sort_file_size',
2468 'myisam_repair_threads',
2469 'myisam_sort_buffer_size',
2470 'myisam_stats_method',
2471 'myisam_use_mmap',
2472 'mysql_native_password_proxy_users',
2473 'ndb_blob_write_batch_bytes',
2474 'ndb_deferred_constraints',
2475 'ndb_deferred_constraints',
2476 'ndb_distribution={KEYHASH|LINHASH}',
2477 'ndb_distribution',
2478 'ndb_eventbuffer_free_percent',
2479 'ndb_eventbuffer_max_alloc',
2480 'ndb_force_send',
2481 'ndb_index_stat_enable',
2482 'ndb_index_stat_option',
2483 'ndb_join_pushdown',
2484 'ndb_log_binlog_index',
2485 'ndb_log_empty_epochs',
2486 'ndb_log_updated_only',
2487 'ndb_optimization_delay',
2488 'ndb_recv_thread_cpu_mask',
2489 'ndb_show_foreign_key_mock_tables',
2490 'ndb_table_no_logging',
2491 'ndb_use_transactions',
2492 'ndbinfo_max_rows',
2493 'ndbinfo_show_hidden',
2494 'net_buffer_length',
2495 'net_read_timeout',
2496 'net_retry_count',
2497 'net_write_timeout',
2498 'new',
2499 'offline_mode',
2500 'old_alter_table',
2501 'old_passwords',
2502 'optimizer_prune_level',
2503 'optimizer_search_depth',
2504 'optimizer_switch',
2505 'optimizer_trace',
2506 'optimizer_trace_features',
2507 'optimizer_trace_limit',
2508 'optimizer_trace_max_mem_size',
2509 'optimizer_trace_offset',
2510 'preload_buffer_size',
2511 'profiling',
2512 'profiling_history_size',
2513 'pseudo_slave_mode',
2514 'pseudo_thread_id',
2515 'query_alloc_block_size',
2516 'query_cache_limit',
2517 'query_cache_min_res_unit',
2518 'query_cache_size',
2519 'query_cache_type',
2520 'query_cache_wlock_invalidate',
2521 'query_prealloc_size',
2522 'rand_seed1',
2523 'rand_seed2',
2524 'range_alloc_block_size',
2525 'rbr_exec_mode',
2526 'read_buffer_size',
2527 'read_only',
2528 'read_rnd_buffer_size',
2529 'relay_log_info_repository',
2530 'relay_log_purge',
2531 'rewriter_enabled',
2532 'rewriter_verbose',
2533 'rpl_semi_sync_master_enabled',
2534 'rpl_semi_sync_master_timeout',
2535 'rpl_semi_sync_master_trace_level',
2536 'rpl_semi_sync_master_wait_for_slave_count',
2537 'rpl_semi_sync_master_wait_no_slave',
2538 'rpl_semi_sync_master_wait_point',
2539 'rpl_semi_sync_slave_enabled',
2540 'rpl_semi_sync_slave_trace_level',
2541 'rpl_stop_slave_timeout',
2542 'secure_auth',
2543 'server_id',
2544 'session_track_gtids',
2545 'session_track_schema',
2546 'session_track_state_change',
2547 'session_track_system_variables',
2548 'sha256_password_proxy_users',
2549 'show_compatibility_56',
2550 'show_old_temporals',
2551 'slave_allow_batching',
2552 'slave_checkpoint_group=#',
2553 'slave_checkpoint_period=#',
2554 'slave_compressed_protocol',
2555 'slave_exec_mode',
2556 'slave_max_allowed_packet',
2557 'slave_net_timeout',
2558 'slave_parallel_type',
2559 'slave_parallel_workers',
2560 'slave_pending_jobs_size_max',
2561 'slave_preserve_commit_order',
2562 'slave_rows_search_algorithms=list',
2563 'slave_sql_verify_checksum',
2564 'slave_transaction_retries',
2565 'slow_launch_time',
2566 'slow_query_log',
2567 'slow_query_log_file',
2568 'sort_buffer_size',
2569 'sql_auto_is_null',
2570 'sql_big_selects',
2571 'sql_buffer_result',
2572 'sql_log_bin',
2573 'sql_log_off',
2574 'sql_mode',
2575 'sql_notes',
2576 'sql_quote_show_create',
2577 'sql_safe_updates',
2578 'sql_select_limit',
2579 'sql_slave_skip_counter',
2580 'sql_warnings',
2581 'storage_engine',
2582 'stored_program_cache',
2583 'super_read_only',
2584 'sync_binlog',
2585 'sync_frm',
2586 'sync_master_info',
2587 'sync_relay_log',
2588 'sync_relay_log_info',
2589 'table_definition_cache',
2590 'table_open_cache',
2591 'thread_cache_size',
2592 'time_zone',
2593 'timed_mutexes',
2594 'timestamp',
2595 'tmp_table_size',
2596 'transaction_alloc_block_size',
2597 'transaction_allow_batching',
2598 'transaction_prealloc_size',
2599 'transaction_write_set_extraction',
2600 'tx_isolation',
2601 'tx_read_only',
2602 'unique_checks',
2603 'updatable_views_with_limit',
2604 'validate_password_dictionary_file',
2605 'validate_password_length',
2606 'validate_password_mixed_case_count',
2607 'validate_password_number_count',
2608 'validate_password_policy',
2609 'validate_password_special_char_count',
2610 'wait_timeout'
2611 );
2612
2613 return $dynamic_variables;
2614
2615 }
2616
phpMyAdmin