phpmyadmin/libraries/server_variables.lib.php

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