server_variables.lib.php 55 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * functions for displaying server variables
  5. *
  6. * @usedby server_variables.php
  7. *
  8. * @package PhpMyAdmin
  9. */
  10. if (! defined('PHPMYADMIN')) {
  11. exit;
  12. }
  13. /**
  14. * Get Ajax return when $_REQUEST['type'] === 'getval'
  15. *
  16. * @param Array $variable_doc_links documentation links
  17. *
  18. * @return null
  19. */
  20. function PMA_getAjaxReturnForGetVal($variable_doc_links)
  21. {
  22. $response = PMA_Response::getInstance();
  23. // Send with correct charset
  24. header('Content-Type: text/html; charset=UTF-8');
  25. $varValue = $GLOBALS['dbi']->fetchSingleRow(
  26. 'SHOW GLOBAL VARIABLES WHERE Variable_name="'
  27. . PMA_Util::sqlAddSlashes($_REQUEST['varName']) . '";',
  28. 'NUM'
  29. );
  30. if (isset($variable_doc_links[$_REQUEST['varName']][3])
  31. && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
  32. ) {
  33. $response->addJSON(
  34. 'message',
  35. implode(
  36. ' ', PMA_Util::formatByteDown($varValue[1], 3, 3)
  37. )
  38. );
  39. } else {
  40. $response->addJSON(
  41. 'message',
  42. $varValue[1]
  43. );
  44. }
  45. }
  46. /**
  47. * Get Ajax return when $_REQUEST['type'] === 'setval'
  48. *
  49. * @param Array $variable_doc_links documentation links
  50. *
  51. * @return null
  52. */
  53. function PMA_getAjaxReturnForSetVal($variable_doc_links)
  54. {
  55. $response = PMA_Response::getInstance();
  56. $value = $_REQUEST['varValue'];
  57. $matches = array();
  58. if (isset($variable_doc_links[$_REQUEST['varName']][3])
  59. && $variable_doc_links[$_REQUEST['varName']][3] == 'byte'
  60. && preg_match(
  61. '/^\s*(\d+(\.\d+)?)\s*(mb|kb|mib|kib|gb|gib)\s*$/i',
  62. $value,
  63. $matches
  64. )
  65. ) {
  66. $exp = array(
  67. 'kb' => 1,
  68. 'kib' => 1,
  69. 'mb' => 2,
  70. 'mib' => 2,
  71. 'gb' => 3,
  72. 'gib' => 3
  73. );
  74. $value = floatval($matches[1]) * PMA_Util::pow(
  75. 1024,
  76. $exp[strtolower($matches[3])]
  77. );
  78. } else {
  79. $value = PMA_Util::sqlAddSlashes($value);
  80. }
  81. if (! is_numeric($value)) {
  82. $value="'" . $value . "'";
  83. }
  84. if (! preg_match("/[^a-zA-Z0-9_]+/", $_REQUEST['varName'])
  85. && $GLOBALS['dbi']->query(
  86. 'SET GLOBAL ' . $_REQUEST['varName'] . ' = ' . $value
  87. )
  88. ) {
  89. // Some values are rounded down etc.
  90. $varValue = $GLOBALS['dbi']->fetchSingleRow(
  91. 'SHOW GLOBAL VARIABLES WHERE Variable_name="'
  92. . PMA_Util::sqlAddSlashes($_REQUEST['varName'])
  93. . '";', 'NUM'
  94. );
  95. $response->addJSON(
  96. 'variable',
  97. PMA_formatVariable(
  98. $_REQUEST['varName'],
  99. $varValue[1],
  100. $variable_doc_links
  101. )
  102. );
  103. } else {
  104. $response->isSuccess(false);
  105. $response->addJSON(
  106. 'error',
  107. __('Setting variable failed')
  108. );
  109. }
  110. }
  111. /**
  112. * Format Variable
  113. *
  114. * @param string $name variable name
  115. * @param number $value variable value
  116. * @param array $variable_doc_links documentation links
  117. *
  118. * @return string formatted string
  119. */
  120. function PMA_formatVariable($name, $value, $variable_doc_links)
  121. {
  122. if (is_numeric($value)) {
  123. if (isset($variable_doc_links[$name][3])
  124. && $variable_doc_links[$name][3]=='byte'
  125. ) {
  126. return '<abbr title="'
  127. . PMA_Util::formatNumber($value, 0) . '">'
  128. . implode(' ', PMA_Util::formatByteDown($value, 3, 3))
  129. . '</abbr>';
  130. } else {
  131. return PMA_Util::formatNumber($value, 0);
  132. }
  133. }
  134. return htmlspecialchars($value);
  135. }
  136. /**
  137. * Prints link templates
  138. *
  139. * @return string
  140. */
  141. function PMA_getHtmlForLinkTemplates()
  142. {
  143. $url = 'server_variables.php' . PMA_URL_getCommon(array());
  144. $output = '<a style="display: none;" href="#" class="editLink">';
  145. $output .= PMA_Util::getIcon('b_edit.png', __('Edit')) . '</a>';
  146. $output .= '<a style="display: none;" href="'
  147. . $url . '" class="ajax saveLink">';
  148. $output .= PMA_Util::getIcon('b_save.png', __('Save')) . '</a> ';
  149. $output .= '<a style="display: none;" href="#" class="cancelLink">';
  150. $output .= PMA_Util::getIcon('b_close.png', __('Cancel')) . '</a> ';
  151. $output .= PMA_Util::getImage(
  152. 'b_help.png',
  153. __('Documentation'),
  154. array(
  155. 'style' => 'display:none',
  156. 'id' => 'docImage'
  157. )
  158. );
  159. return $output;
  160. }
  161. /**
  162. * Prints Html for Server Variables
  163. *
  164. * @param Array $variable_doc_links documentation links
  165. *
  166. * @return string
  167. */
  168. function PMA_getHtmlForServerVariables($variable_doc_links)
  169. {
  170. $value = ! empty($_REQUEST['filter'])
  171. ? htmlspecialchars($_REQUEST['filter'])
  172. : '';
  173. $output = '<fieldset id="tableFilter">'
  174. . '<legend>' . __('Filters') . '</legend>'
  175. . '<div class="formelement">'
  176. . '<label for="filterText">' . __('Containing the word:') . '</label>'
  177. . '<input name="filterText" type="text" id="filterText"'
  178. . ' style="vertical-align: baseline;" value="' . $value . '" />'
  179. . '</div>'
  180. . '</fieldset>';
  181. $output .= '<div id="serverVariables" class="data filteredData noclick">'
  182. . '<div class="var-header var-row">'
  183. . '<div class="var-name">' . __('Variable') . '</div>'
  184. . '<div class="var-value valueHeader">'
  185. . __('Session value') . ' / ' . __('Global value')
  186. . '</div>'
  187. . '<div style="clear:both"></div>'
  188. . '</div>';
  189. $output .= PMA_getHtmlForServerVariablesItems($variable_doc_links);
  190. $output .= '</div>';
  191. return $output;
  192. }
  193. /**
  194. * Prints Html for Server Variables Items
  195. *
  196. * @param Array $variable_doc_links documentation links
  197. *
  198. * @return string
  199. */
  200. function PMA_getHtmlForServerVariablesItems($variable_doc_links)
  201. {
  202. /**
  203. * Sends the queries and buffers the results
  204. */
  205. $serverVarsSession
  206. = $GLOBALS['dbi']->fetchResult('SHOW SESSION VARIABLES;', 0, 1);
  207. $serverVars = $GLOBALS['dbi']->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1);
  208. $output = '';
  209. $odd_row = true;
  210. foreach ($serverVars as $name => $value) {
  211. $has_session_value = isset($serverVarsSession[$name])
  212. && $serverVarsSession[$name] != $value;
  213. $row_class = ($odd_row ? ' odd' : ' even')
  214. . ($has_session_value ? ' diffSession' : '');
  215. $output .= '<div class="var-row' . $row_class . '">'
  216. . '<div class="var-name">';
  217. // To display variable documentation link
  218. if (isset($variable_doc_links[$name])) {
  219. $output .= '<span title="'
  220. . htmlspecialchars(str_replace('_', ' ', $name)) . '">';
  221. $output .= PMA_Util::showMySQLDocu(
  222. $variable_doc_links[$name][1],
  223. false,
  224. $variable_doc_links[$name][2] . '_' . $variable_doc_links[$name][0],
  225. true
  226. );
  227. $output .= htmlspecialchars(str_replace('_', ' ', $name));
  228. $output .= '</a>';
  229. $output .= '</span>';
  230. } else {
  231. $output .= htmlspecialchars(str_replace('_', ' ', $name));
  232. }
  233. $output .= '</div>'
  234. . '<div class="var-value value'
  235. . ($GLOBALS['dbi']->isSuperuser() ? ' editable' : '') . '">&nbsp;'
  236. . PMA_formatVariable($name, $value, $variable_doc_links)
  237. . '</div>'
  238. . '<div style="clear:both"></div>'
  239. . '</div>';
  240. if ($has_session_value) {
  241. $output .= '<div class="var-row' . ($odd_row ? ' odd' : ' even') . '">'
  242. . '<div class="var-name session">(' . __('Session value') . ')</div>'
  243. . '<div class="var-value value">&nbsp;'
  244. . PMA_formatVariable(
  245. $name,
  246. $serverVarsSession[$name],
  247. $variable_doc_links
  248. ) . '</div>'
  249. . '<div style="clear:both"></div>'
  250. . '</div>';
  251. }
  252. $odd_row = ! $odd_row;
  253. }
  254. return $output;
  255. }
  256. /**
  257. * Returns Array of documentation links
  258. *
  259. * $variable_doc_links[string $name] = array(
  260. * string $anchor,
  261. * string $chapter,
  262. * string $type);
  263. * string $name: name of the system variable
  264. * string $anchor: anchor to the documentation page
  265. * string $chapter: chapter of "HTML, one page per chapter" documentation
  266. * string $type: type of system variable
  267. * string $format: if set to 'byte' it will format the variable
  268. * with PMA_Util::formatByteDown()
  269. *
  270. * @return array
  271. */
  272. function PMA_getArrayForDocumentLinks()
  273. {
  274. $variable_doc_links = array();
  275. $variable_doc_links['auto_increment_increment'] = array(
  276. 'auto_increment_increment',
  277. 'replication-options-master',
  278. 'sysvar');
  279. $variable_doc_links['auto_increment_offset'] = array(
  280. 'auto_increment_offset',
  281. 'replication-options-master',
  282. 'sysvar');
  283. $variable_doc_links['autocommit'] = array(
  284. 'autocommit',
  285. 'server-system-variables',
  286. 'sysvar');
  287. $variable_doc_links['automatic_sp_privileges'] = array(
  288. 'automatic_sp_privileges',
  289. 'server-system-variables',
  290. 'sysvar');
  291. $variable_doc_links['back_log'] = array(
  292. 'back_log',
  293. 'server-system-variables',
  294. 'sysvar');
  295. $variable_doc_links['basedir'] = array(
  296. 'basedir',
  297. 'server-options',
  298. 'option_mysqld');
  299. $variable_doc_links['big_tables'] = array(
  300. 'big-tables',
  301. 'server-options',
  302. 'option_mysqld');
  303. $variable_doc_links['bind_address'] = array(
  304. 'bind-address',
  305. 'server-options',
  306. 'option_mysqld');
  307. $variable_doc_links['binlog_cache_size'] = array(
  308. 'binlog_cache_size',
  309. 'replication-options-binary-log',
  310. 'sysvar',
  311. 'byte');
  312. $variable_doc_links['binlog_direct_non_transactional_updates'] = array(
  313. 'binlog_direct_non_transactional_updates',
  314. 'replication-options-binary-log',
  315. 'sysvar');
  316. $variable_doc_links['binlog_format'] = array(
  317. 'binlog-format',
  318. 'server-options',
  319. 'sysvar');
  320. $variable_doc_links['binlog_stmt_cache_size'] = array(
  321. 'binlog_stmt_cache_size',
  322. 'replication-options-binary-log',
  323. 'sysvar',
  324. 'byte');
  325. $variable_doc_links['bulk_insert_buffer_size'] = array(
  326. 'bulk_insert_buffer_size',
  327. 'server-system-variables',
  328. 'sysvar',
  329. 'byte');
  330. $variable_doc_links['character_set_client'] = array(
  331. 'character_set_client',
  332. 'server-system-variables',
  333. 'sysvar');
  334. $variable_doc_links['character_set_connection'] = array(
  335. 'character_set_connection',
  336. 'server-system-variables',
  337. 'sysvar');
  338. $variable_doc_links['character_set_database'] = array(
  339. 'character_set_database',
  340. 'server-system-variables',
  341. 'sysvar');
  342. $variable_doc_links['character_set_filesystem'] = array(
  343. 'character-set-filesystem',
  344. 'server-options',
  345. 'option_mysqld');
  346. $variable_doc_links['character_set_results'] = array(
  347. 'character_set_results',
  348. 'server-system-variables',
  349. 'sysvar');
  350. $variable_doc_links['character_set_server'] = array(
  351. 'character-set-server',
  352. 'server-options',
  353. 'option_mysqld');
  354. $variable_doc_links['character_set_system'] = array(
  355. 'character_set_system',
  356. 'server-system-variables',
  357. 'sysvar');
  358. $variable_doc_links['character_sets_dir'] = array(
  359. 'character-sets-dir',
  360. 'server-options',
  361. 'option_mysqld');
  362. $variable_doc_links['collation_connection'] = array(
  363. 'collation_connection',
  364. 'server-system-variables',
  365. 'sysvar');
  366. $variable_doc_links['collation_database'] = array(
  367. 'collation_database',
  368. 'server-system-variables',
  369. 'sysvar');
  370. $variable_doc_links['collation_server'] = array(
  371. 'collation-server',
  372. 'server-options',
  373. 'option_mysqld');
  374. $variable_doc_links['completion_type'] = array(
  375. 'completion_type',
  376. 'server-system-variables',
  377. 'sysvar');
  378. $variable_doc_links['concurrent_insert'] = array(
  379. 'concurrent_insert',
  380. 'server-system-variables',
  381. 'sysvar');
  382. $variable_doc_links['connect_timeout'] = array(
  383. 'connect_timeout',
  384. 'server-system-variables',
  385. 'sysvar');
  386. $variable_doc_links['datadir'] = array(
  387. 'datadir',
  388. 'server-options',
  389. 'option_mysqld');
  390. $variable_doc_links['date_format'] = array(
  391. 'date_format',
  392. 'server-system-variables',
  393. 'sysvar');
  394. $variable_doc_links['datetime_format'] = array(
  395. 'datetime_format',
  396. 'server-system-variables',
  397. 'sysvar');
  398. $variable_doc_links['debug'] = array(
  399. 'debug',
  400. 'server-options',
  401. 'option_mysqld');
  402. $variable_doc_links['debug_sync'] = array(
  403. 'debug_sync',
  404. 'server-system-variables',
  405. 'sysvar');
  406. $variable_doc_links['default_storage_engine'] = array(
  407. 'default-storage-engine',
  408. 'server-options',
  409. 'option_mysqld');
  410. $variable_doc_links['default_week_format'] = array(
  411. 'default_week_format',
  412. 'server-system-variables',
  413. 'sysvar');
  414. $variable_doc_links['delay_key_write'] = array(
  415. 'delay-key-write',
  416. 'server-options',
  417. 'option_mysqld');
  418. $variable_doc_links['delayed_insert_limit'] = array(
  419. 'delayed_insert_limit',
  420. 'server-system-variables',
  421. 'sysvar');
  422. $variable_doc_links['delayed_insert_timeout'] = array(
  423. 'delayed_insert_timeout',
  424. 'server-system-variables',
  425. 'sysvar');
  426. $variable_doc_links['delayed_queue_size'] = array(
  427. 'delayed_queue_size',
  428. 'server-system-variables',
  429. 'sysvar');
  430. $variable_doc_links['div_precision_increment'] = array(
  431. 'div_precision_increment',
  432. 'server-system-variables',
  433. 'sysvar');
  434. $variable_doc_links['engine_condition_pushdown'] = array(
  435. 'engine-condition-pushdown',
  436. 'server-options',
  437. 'option_mysqld');
  438. $variable_doc_links['error_count'] = array(
  439. 'error_count',
  440. 'server-system-variables',
  441. 'sysvar');
  442. $variable_doc_links['event_scheduler'] = array(
  443. 'event-scheduler',
  444. 'server-options',
  445. 'option_mysqld');
  446. $variable_doc_links['expire_logs_days'] = array(
  447. 'expire_logs_days',
  448. 'server-system-variables',
  449. 'sysvar');
  450. $variable_doc_links['external_user'] = array(
  451. 'external_user',
  452. 'server-system-variables',
  453. 'sysvar');
  454. $variable_doc_links['flush'] = array(
  455. 'flush',
  456. 'server-system-variables',
  457. 'sysvar');
  458. $variable_doc_links['flush_time'] = array(
  459. 'flush_time',
  460. 'server-system-variables',
  461. 'sysvar');
  462. $variable_doc_links['foreign_key_checks'] = array(
  463. 'foreign_key_checks',
  464. 'server-system-variables',
  465. 'sysvar');
  466. $variable_doc_links['ft_boolean_syntax'] = array(
  467. 'ft_boolean_syntax',
  468. 'server-system-variables',
  469. 'sysvar');
  470. $variable_doc_links['ft_max_word_len'] = array(
  471. 'ft_max_word_len',
  472. 'server-system-variables',
  473. 'sysvar');
  474. $variable_doc_links['ft_min_word_len'] = array(
  475. 'ft_min_word_len',
  476. 'server-system-variables',
  477. 'sysvar');
  478. $variable_doc_links['ft_query_expansion_limit'] = array(
  479. 'ft_query_expansion_limit',
  480. 'server-system-variables',
  481. 'sysvar');
  482. $variable_doc_links['ft_stopword_file'] = array(
  483. 'ft_stopword_file',
  484. 'server-system-variables',
  485. 'sysvar');
  486. $variable_doc_links['general_log'] = array(
  487. 'general-log',
  488. 'server-options',
  489. 'option_mysqld');
  490. $variable_doc_links['general_log_file'] = array(
  491. 'general_log_file',
  492. 'server-system-variables',
  493. 'sysvar');
  494. $variable_doc_links['group_concat_max_len'] = array(
  495. 'group_concat_max_len',
  496. 'server-system-variables',
  497. 'sysvar');
  498. $variable_doc_links['have_compress'] = array(
  499. 'have_compress',
  500. 'server-system-variables',
  501. 'sysvar');
  502. $variable_doc_links['have_crypt'] = array(
  503. 'have_crypt',
  504. 'server-system-variables',
  505. 'sysvar');
  506. $variable_doc_links['have_csv'] = array(
  507. 'have_csv',
  508. 'server-system-variables',
  509. 'sysvar');
  510. $variable_doc_links['have_dynamic_loading'] = array(
  511. 'have_dynamic_loading',
  512. 'server-system-variables',
  513. 'sysvar');
  514. $variable_doc_links['have_geometry'] = array(
  515. 'have_geometry',
  516. 'server-system-variables',
  517. 'sysvar');
  518. $variable_doc_links['have_innodb'] = array(
  519. 'have_innodb',
  520. 'server-system-variables',
  521. 'sysvar');
  522. $variable_doc_links['have_openssl'] = array(
  523. 'have_openssl',
  524. 'server-system-variables',
  525. 'sysvar');
  526. $variable_doc_links['have_partitioning'] = array(
  527. 'have_partitioning',
  528. 'server-system-variables',
  529. 'sysvar');
  530. $variable_doc_links['have_profiling'] = array(
  531. 'have_profiling',
  532. 'server-system-variables',
  533. 'sysvar');
  534. $variable_doc_links['have_query_cache'] = array(
  535. 'have_query_cache',
  536. 'server-system-variables',
  537. 'sysvar');
  538. $variable_doc_links['have_rtree_keys'] = array(
  539. 'have_rtree_keys',
  540. 'server-system-variables',
  541. 'sysvar');
  542. $variable_doc_links['have_ssl'] = array(
  543. 'have_ssl',
  544. 'server-system-variables',
  545. 'sysvar');
  546. $variable_doc_links['have_symlink'] = array(
  547. 'have_symlink',
  548. 'server-system-variables',
  549. 'sysvar');
  550. $variable_doc_links['hostname'] = array(
  551. 'hostname',
  552. 'server-system-variables',
  553. 'sysvar');
  554. $variable_doc_links['identity'] = array(
  555. 'identity',
  556. 'server-system-variables',
  557. 'sysvar');
  558. $variable_doc_links['ignore_builtin_innodb'] = array(
  559. 'ignore-builtin-innodb',
  560. 'innodb-parameters',
  561. 'option_mysqld');
  562. $variable_doc_links['init_connect'] = array(
  563. 'init_connect',
  564. 'server-system-variables',
  565. 'sysvar');
  566. $variable_doc_links['init_file'] = array(
  567. 'init-file',
  568. 'server-options',
  569. 'option_mysqld');
  570. $variable_doc_links['init_slave'] = array(
  571. 'init_slave',
  572. 'replication-options-slave',
  573. 'sysvar');
  574. $variable_doc_links['innodb_adaptive_flushing'] = array(
  575. 'innodb_adaptive_flushing',
  576. 'innodb-parameters',
  577. 'sysvar');
  578. $variable_doc_links['innodb_adaptive_hash_index'] = array(
  579. 'innodb_adaptive_hash_index',
  580. 'innodb-parameters',
  581. 'sysvar');
  582. $variable_doc_links['innodb_additional_mem_pool_size'] = array(
  583. 'innodb_additional_mem_pool_size',
  584. 'innodb-parameters',
  585. 'sysvar',
  586. 'byte');
  587. $variable_doc_links['innodb_autoextend_increment'] = array(
  588. 'innodb_autoextend_increment',
  589. 'innodb-parameters',
  590. 'sysvar');
  591. $variable_doc_links['innodb_autoinc_lock_mode'] = array(
  592. 'innodb_autoinc_lock_mode',
  593. 'innodb-parameters',
  594. 'sysvar');
  595. $variable_doc_links['innodb_buffer_pool_instances'] = array(
  596. 'innodb_buffer_pool_instances',
  597. 'innodb-parameters',
  598. 'sysvar');
  599. $variable_doc_links['innodb_buffer_pool_size'] = array(
  600. 'innodb_buffer_pool_size',
  601. 'innodb-parameters',
  602. 'sysvar',
  603. 'byte');
  604. $variable_doc_links['innodb_change_buffering'] = array(
  605. 'innodb_change_buffering',
  606. 'innodb-parameters',
  607. 'sysvar');
  608. $variable_doc_links['innodb_checksums'] = array(
  609. 'innodb_checksums',
  610. 'innodb-parameters',
  611. 'sysvar');
  612. $variable_doc_links['innodb_commit_concurrency'] = array(
  613. 'innodb_commit_concurrency',
  614. 'innodb-parameters',
  615. 'sysvar');
  616. $variable_doc_links['innodb_concurrency_tickets'] = array(
  617. 'innodb_concurrency_tickets',
  618. 'innodb-parameters',
  619. 'sysvar');
  620. $variable_doc_links['innodb_data_file_path'] = array(
  621. 'innodb_data_file_path',
  622. 'innodb-parameters',
  623. 'sysvar');
  624. $variable_doc_links['innodb_data_home_dir'] = array(
  625. 'innodb_data_home_dir',
  626. 'innodb-parameters',
  627. 'sysvar');
  628. $variable_doc_links['innodb_doublewrite'] = array(
  629. 'innodb_doublewrite',
  630. 'innodb-parameters',
  631. 'sysvar');
  632. $variable_doc_links['innodb_fast_shutdown'] = array(
  633. 'innodb_fast_shutdown',
  634. 'innodb-parameters',
  635. 'sysvar');
  636. $variable_doc_links['innodb_file_format'] = array(
  637. 'innodb_file_format',
  638. 'innodb-parameters',
  639. 'sysvar');
  640. $variable_doc_links['innodb_file_format_check'] = array(
  641. 'innodb_file_format_check',
  642. 'innodb-parameters',
  643. 'sysvar');
  644. $variable_doc_links['innodb_file_format_max'] = array(
  645. 'innodb_file_format_max',
  646. 'innodb-parameters',
  647. 'sysvar');
  648. $variable_doc_links['innodb_file_per_table'] = array(
  649. 'innodb_file_per_table',
  650. 'innodb-parameters',
  651. 'sysvar');
  652. $variable_doc_links['innodb_flush_log_at_trx_commit'] = array(
  653. 'innodb_flush_log_at_trx_commit',
  654. 'innodb-parameters',
  655. 'sysvar');
  656. $variable_doc_links['innodb_flush_method'] = array(
  657. 'innodb_flush_method',
  658. 'innodb-parameters',
  659. 'sysvar');
  660. $variable_doc_links['innodb_force_recovery'] = array(
  661. 'innodb_force_recovery',
  662. 'innodb-parameters',
  663. 'sysvar');
  664. $variable_doc_links['innodb_io_capacity'] = array(
  665. 'innodb_io_capacity',
  666. 'innodb-parameters',
  667. 'sysvar');
  668. $variable_doc_links['innodb_lock_wait_timeout'] = array(
  669. 'innodb_lock_wait_timeout',
  670. 'innodb-parameters',
  671. 'sysvar');
  672. $variable_doc_links['innodb_locks_unsafe_for_binlog'] = array(
  673. 'innodb_locks_unsafe_for_binlog',
  674. 'innodb-parameters',
  675. 'sysvar');
  676. $variable_doc_links['innodb_log_buffer_size'] = array(
  677. 'innodb_log_buffer_size',
  678. 'innodb-parameters',
  679. 'sysvar',
  680. 'byte');
  681. $variable_doc_links['innodb_log_file_size'] = array(
  682. 'innodb_log_file_size',
  683. 'innodb-parameters',
  684. 'sysvar',
  685. 'byte');
  686. $variable_doc_links['innodb_log_files_in_group'] = array(
  687. 'innodb_log_files_in_group',
  688. 'innodb-parameters',
  689. 'sysvar');
  690. $variable_doc_links['innodb_log_group_home_dir'] = array(
  691. 'innodb_log_group_home_dir',
  692. 'innodb-parameters',
  693. 'sysvar');
  694. $variable_doc_links['innodb_max_dirty_pages_pct'] = array(
  695. 'innodb_max_dirty_pages_pct',
  696. 'innodb-parameters',
  697. 'sysvar');
  698. $variable_doc_links['innodb_max_purge_lag'] = array(
  699. 'innodb_max_purge_lag',
  700. 'innodb-parameters',
  701. 'sysvar');
  702. $variable_doc_links['innodb_mirrored_log_groups'] = array(
  703. 'innodb_mirrored_log_groups',
  704. 'innodb-parameters',
  705. 'sysvar');
  706. $variable_doc_links['innodb_old_blocks_pct'] = array(
  707. 'innodb_old_blocks_pct',
  708. 'innodb-parameters',
  709. 'sysvar');
  710. $variable_doc_links['innodb_old_blocks_time'] = array(
  711. 'innodb_old_blocks_time',
  712. 'innodb-parameters',
  713. 'sysvar');
  714. $variable_doc_links['innodb_open_files'] = array(
  715. 'innodb_open_files',
  716. 'innodb-parameters',
  717. 'sysvar');
  718. $variable_doc_links['innodb_purge_batch_size'] = array(
  719. 'innodb_purge_batch_size',
  720. 'innodb-parameters',
  721. 'sysvar');
  722. $variable_doc_links['innodb_purge_threads'] = array(
  723. 'innodb_purge_threads',
  724. 'innodb-parameters',
  725. 'sysvar');
  726. $variable_doc_links['innodb_read_ahead_threshold'] = array(
  727. 'innodb_read_ahead_threshold',
  728. 'innodb-parameters',
  729. 'sysvar');
  730. $variable_doc_links['innodb_read_io_threads'] = array(
  731. 'innodb_read_io_threads',
  732. 'innodb-parameters',
  733. 'sysvar');
  734. $variable_doc_links['innodb_replication_delay'] = array(
  735. 'innodb_replication_delay',
  736. 'innodb-parameters',
  737. 'sysvar');
  738. $variable_doc_links['innodb_rollback_on_timeout'] = array(
  739. 'innodb_rollback_on_timeout',
  740. 'innodb-parameters',
  741. 'sysvar');
  742. $variable_doc_links['innodb_spin_wait_delay'] = array(
  743. 'innodb_spin_wait_delay',
  744. 'innodb-parameters',
  745. 'sysvar');
  746. $variable_doc_links['innodb_stats_on_metadata'] = array(
  747. 'innodb_stats_on_metadata',
  748. 'innodb-parameters',
  749. 'sysvar');
  750. $variable_doc_links['innodb_stats_sample_pages'] = array(
  751. 'innodb_stats_sample_pages',
  752. 'innodb-parameters',
  753. 'sysvar');
  754. $variable_doc_links['innodb_strict_mode'] = array(
  755. 'innodb_strict_mode',
  756. 'innodb-parameters',
  757. 'sysvar');
  758. $variable_doc_links['innodb_support_xa'] = array(
  759. 'innodb_support_xa',
  760. 'innodb-parameters',
  761. 'sysvar');
  762. $variable_doc_links['innodb_sync_spin_loops'] = array(
  763. 'innodb_sync_spin_loops',
  764. 'innodb-parameters',
  765. 'sysvar');
  766. $variable_doc_links['innodb_table_locks'] = array(
  767. 'innodb_table_locks',
  768. 'innodb-parameters',
  769. 'sysvar');
  770. $variable_doc_links['innodb_thread_concurrency'] = array(
  771. 'innodb_thread_concurrency',
  772. 'innodb-parameters',
  773. 'sysvar');
  774. $variable_doc_links['innodb_thread_sleep_delay'] = array(
  775. 'innodb_thread_sleep_delay',
  776. 'innodb-parameters',
  777. 'sysvar');
  778. $variable_doc_links['innodb_use_native_aio'] = array(
  779. 'innodb_use_native_aio',
  780. 'innodb-parameters',
  781. 'sysvar');
  782. $variable_doc_links['innodb_use_sys_malloc'] = array(
  783. 'innodb_use_sys_malloc',
  784. 'innodb-parameters',
  785. 'sysvar');
  786. $variable_doc_links['innodb_version'] = array(
  787. 'innodb_version',
  788. 'innodb-parameters',
  789. 'sysvar');
  790. $variable_doc_links['innodb_write_io_threads'] = array(
  791. 'innodb_write_io_threads',
  792. 'innodb-parameters',
  793. 'sysvar');
  794. $variable_doc_links['insert_id'] = array(
  795. 'insert_id',
  796. 'server-system-variables',
  797. 'sysvar');
  798. $variable_doc_links['interactive_timeout'] = array(
  799. 'interactive_timeout',
  800. 'server-system-variables',
  801. 'sysvar');
  802. $variable_doc_links['join_buffer_size'] = array(
  803. 'join_buffer_size',
  804. 'server-system-variables',
  805. 'sysvar',
  806. 'byte');
  807. $variable_doc_links['keep_files_on_create'] = array(
  808. 'keep_files_on_create',
  809. 'server-system-variables',
  810. 'sysvar');
  811. $variable_doc_links['key_buffer_size'] = array(
  812. 'key_buffer_size',
  813. 'server-system-variables',
  814. 'sysvar',
  815. 'byte');
  816. $variable_doc_links['key_cache_age_threshold'] = array(
  817. 'key_cache_age_threshold',
  818. 'server-system-variables',
  819. 'sysvar');
  820. $variable_doc_links['key_cache_block_size'] = array(
  821. 'key_cache_block_size',
  822. 'server-system-variables',
  823. 'sysvar',
  824. 'byte');
  825. $variable_doc_links['key_cache_division_limit'] = array(
  826. 'key_cache_division_limit',
  827. 'server-system-variables',
  828. 'sysvar');
  829. $variable_doc_links['language'] = array(
  830. 'language',
  831. 'server-options',
  832. 'option_mysqld');
  833. $variable_doc_links['large_files_support'] = array(
  834. 'large_files_support',
  835. 'server-system-variables',
  836. 'sysvar');
  837. $variable_doc_links['large_page_size'] = array(
  838. 'large_page_size',
  839. 'server-system-variables',
  840. 'sysvar',
  841. 'byte');
  842. $variable_doc_links['large_pages'] = array(
  843. 'large-pages',
  844. 'server-options',
  845. 'option_mysqld');
  846. $variable_doc_links['last_insert_id'] = array(
  847. 'last_insert_id',
  848. 'server-system-variables',
  849. 'sysvar');
  850. $variable_doc_links['lc_messages'] = array(
  851. 'lc-messages',
  852. 'server-options',
  853. 'option_mysqld');
  854. $variable_doc_links['lc_messages_dir'] = array(
  855. 'lc-messages-dir',
  856. 'server-options',
  857. 'option_mysqld');
  858. $variable_doc_links['lc_time_names'] = array(
  859. 'lc_time_names',
  860. 'server-system-variables',
  861. 'sysvar');
  862. $variable_doc_links['license'] = array(
  863. 'license',
  864. 'server-system-variables',
  865. 'sysvar');
  866. $variable_doc_links['local_infile'] = array(
  867. 'local_infile',
  868. 'server-system-variables',
  869. 'sysvar');
  870. $variable_doc_links['lock_wait_timeout'] = array(
  871. 'lock_wait_timeout',
  872. 'server-system-variables',
  873. 'sysvar');
  874. $variable_doc_links['locked_in_memory'] = array(
  875. 'locked_in_memory',
  876. 'server-system-variables',
  877. 'sysvar');
  878. $variable_doc_links['log'] = array(
  879. 'log',
  880. 'server-options',
  881. 'option_mysqld');
  882. $variable_doc_links['log_bin'] = array(
  883. 'log_bin',
  884. 'server-system-variables',
  885. 'sysvar');
  886. $variable_doc_links['log-bin'] = array(
  887. 'log-bin',
  888. 'replication-options-binary-log',
  889. 'option_mysqld');
  890. $variable_doc_links['log_bin_trust_function_creators'] = array(
  891. 'log-bin-trust-function-creators',
  892. 'replication-options-binary-log',
  893. 'option_mysqld');
  894. $variable_doc_links['log_error'] = array(
  895. 'log-error',
  896. 'server-options',
  897. 'option_mysqld');
  898. $variable_doc_links['log_output'] = array(
  899. 'log-output',
  900. 'server-options',
  901. 'option_mysqld');
  902. $variable_doc_links['log_queries_not_using_indexes'] = array(
  903. 'log-queries-not-using-indexes',
  904. 'server-options',
  905. 'option_mysqld');
  906. $variable_doc_links['log_slave_updates'] = array(
  907. 'log-slave-updates',
  908. 'replication-options-slave',
  909. 'option_mysqld');
  910. $variable_doc_links['log_slow_queries'] = array(
  911. 'log-slow-queries',
  912. 'server-options',
  913. 'option_mysqld');
  914. $variable_doc_links['log_warnings'] = array(
  915. 'log-warnings',
  916. 'server-options',
  917. 'option_mysqld');
  918. $variable_doc_links['long_query_time'] = array(
  919. 'long_query_time',
  920. 'server-system-variables',
  921. 'sysvar');
  922. $variable_doc_links['low_priority_updates'] = array(
  923. 'low-priority-updates',
  924. 'server-options',
  925. 'option_mysqld');
  926. $variable_doc_links['lower_case_file_system'] = array(
  927. 'lower_case_file_system',
  928. 'server-system-variables',
  929. 'sysvar');
  930. $variable_doc_links['lower_case_table_names'] = array(
  931. 'lower_case_table_names',
  932. 'server-system-variables',
  933. 'sysvar');
  934. $variable_doc_links['master-bind'] = array(
  935. '',
  936. 'replication-options',
  937. 0);
  938. $variable_doc_links['max_allowed_packet'] = array(
  939. 'max_allowed_packet',
  940. 'server-system-variables',
  941. 'sysvar');
  942. $variable_doc_links['max_binlog_cache_size'] = array(
  943. 'max_binlog_cache_size',
  944. 'replication-options-binary-log',
  945. 'sysvar',
  946. 'byte');
  947. $variable_doc_links['max_binlog_size'] = array(
  948. 'max_binlog_size',
  949. 'replication-options-binary-log',
  950. 'sysvar',
  951. 'byte');
  952. $variable_doc_links['max_binlog_stmt_cache_size'] = array(
  953. 'max_binlog_stmt_cache_size',
  954. 'replication-options-binary-log',
  955. 'sysvar',
  956. 'byte');
  957. $variable_doc_links['max_connect_errors'] = array(
  958. 'max_connect_errors',
  959. 'server-system-variables',
  960. 'sysvar');
  961. $variable_doc_links['max_connections'] = array(
  962. 'max_connections',
  963. 'server-system-variables',
  964. 'sysvar');
  965. $variable_doc_links['max_delayed_threads'] = array(
  966. 'max_delayed_threads',
  967. 'server-system-variables',
  968. 'sysvar');
  969. $variable_doc_links['max_error_count'] = array(
  970. 'max_error_count',
  971. 'server-system-variables',
  972. 'sysvar');
  973. $variable_doc_links['max_heap_table_size'] = array(
  974. 'max_heap_table_size',
  975. 'server-system-variables',
  976. 'sysvar',
  977. 'byte');
  978. $variable_doc_links['max_insert_delayed_threads'] = array(
  979. 'max_insert_delayed_threads',
  980. 'server-system-variables',
  981. 'sysvar');
  982. $variable_doc_links['max_join_size'] = array(
  983. 'max_join_size',
  984. 'server-system-variables',
  985. 'sysvar');
  986. $variable_doc_links['max_length_for_sort_data'] = array(
  987. 'max_length_for_sort_data',
  988. 'server-system-variables',
  989. 'sysvar');
  990. $variable_doc_links['max_prepared_stmt_count'] = array(
  991. 'max_prepared_stmt_count',
  992. 'server-system-variables',
  993. 'sysvar');
  994. $variable_doc_links['max_relay_log_size'] = array(
  995. 'max_relay_log_size',
  996. 'server-system-variables',
  997. 'sysvar',
  998. 'byte');
  999. $variable_doc_links['max_seeks_for_key'] = array(
  1000. 'max_seeks_for_key',
  1001. 'server-system-variables',
  1002. 'sysvar');
  1003. $variable_doc_links['max_sort_length'] = array(
  1004. 'max_sort_length',
  1005. 'server-system-variables',
  1006. 'sysvar');
  1007. $variable_doc_links['max_sp_recursion_depth'] = array(
  1008. 'max_sp_recursion_depth',
  1009. 'server-system-variables',
  1010. 'sysvar');
  1011. $variable_doc_links['max_tmp_tables'] = array(
  1012. 'max_tmp_tables',
  1013. 'server-system-variables',
  1014. 'sysvar');
  1015. $variable_doc_links['max_user_connections'] = array(
  1016. 'max_user_connections',
  1017. 'server-system-variables',
  1018. 'sysvar');
  1019. $variable_doc_links['max_write_lock_count'] = array(
  1020. 'max_write_lock_count',
  1021. 'server-system-variables',
  1022. 'sysvar');
  1023. $variable_doc_links['memlock'] = array(
  1024. 'memlock',
  1025. 'server-options',
  1026. 'option_mysqld');
  1027. $variable_doc_links['min_examined_row_limit'] = array(
  1028. 'min-examined-row-limit',
  1029. 'server-options',
  1030. 'option_mysqld');
  1031. $variable_doc_links['myisam_data_pointer_size'] = array(
  1032. 'myisam_data_pointer_size',
  1033. 'server-system-variables',
  1034. 'sysvar',
  1035. 'byte');
  1036. $variable_doc_links['myisam_max_sort_file_size'] = array(
  1037. 'myisam_max_sort_file_size',
  1038. 'server-system-variables',
  1039. 'sysvar',
  1040. 'byte');
  1041. $variable_doc_links['myisam_mmap_size'] = array(
  1042. 'myisam_mmap_size',
  1043. 'server-system-variables',
  1044. 'sysvar',
  1045. 'byte');
  1046. $variable_doc_links['myisam_recover_options'] = array(
  1047. 'myisam_recover_options',
  1048. 'server-system-variables',
  1049. 'sysvar');
  1050. $variable_doc_links['myisam_repair_threads'] = array(
  1051. 'myisam_repair_threads',
  1052. 'server-system-variables',
  1053. 'sysvar');
  1054. $variable_doc_links['myisam_sort_buffer_size'] = array(
  1055. 'myisam_sort_buffer_size',
  1056. 'server-system-variables',
  1057. 'sysvar',
  1058. 'byte');
  1059. $variable_doc_links['myisam_stats_method'] = array(
  1060. 'myisam_stats_method',
  1061. 'server-system-variables',
  1062. 'sysvar');
  1063. $variable_doc_links['myisam_use_mmap'] = array(
  1064. 'myisam_use_mmap',
  1065. 'server-system-variables',
  1066. 'sysvar');
  1067. $variable_doc_links['named_pipe'] = array(
  1068. 'named_pipe',
  1069. 'server-system-variables',
  1070. 'sysvar');
  1071. $variable_doc_links['net_buffer_length'] = array(
  1072. 'net_buffer_length',
  1073. 'server-system-variables',
  1074. 'sysvar');
  1075. $variable_doc_links['net_read_timeout'] = array(
  1076. 'net_read_timeout',
  1077. 'server-system-variables',
  1078. 'sysvar');
  1079. $variable_doc_links['net_retry_count'] = array(
  1080. 'net_retry_count',
  1081. 'server-system-variables',
  1082. 'sysvar');
  1083. $variable_doc_links['net_write_timeout'] = array(
  1084. 'net_write_timeout',
  1085. 'server-system-variables',
  1086. 'sysvar');
  1087. $variable_doc_links['new'] = array(
  1088. 'new',
  1089. 'server-system-variables',
  1090. 'sysvar');
  1091. $variable_doc_links['old'] = array(
  1092. 'old',
  1093. 'server-system-variables',
  1094. 'sysvar');
  1095. $variable_doc_links['old_alter_table'] = array(
  1096. 'old-alter-table',
  1097. 'server-options',
  1098. 'option_mysqld');
  1099. $variable_doc_links['old_passwords'] = array(
  1100. 'old-passwords',
  1101. 'server-options',
  1102. 'option_mysqld');
  1103. $variable_doc_links['open_files_limit'] = array(
  1104. 'open-files-limit',
  1105. 'server-options',
  1106. 'option_mysqld');
  1107. $variable_doc_links['optimizer_prune_level'] = array(
  1108. 'optimizer_prune_level',
  1109. 'server-system-variables',
  1110. 'sysvar');
  1111. $variable_doc_links['optimizer_search_depth'] = array(
  1112. 'optimizer_search_depth',
  1113. 'server-system-variables',
  1114. 'sysvar');
  1115. $variable_doc_links['optimizer_switch'] = array(
  1116. 'optimizer_switch',
  1117. 'server-system-variables',
  1118. 'sysvar');
  1119. $variable_doc_links['partition'] = array(
  1120. 'partition',
  1121. 'server-options',
  1122. 'option_mysqld');
  1123. $variable_doc_links['performance_schema'] = array(
  1124. 'performance_schema',
  1125. 'performance-schema-system-variables',
  1126. 'sysvar');
  1127. $variable_doc_links['performance_schema_events_waits_history_long_size'] = array(
  1128. 'performance_schema_events_waits_history_long_size',
  1129. 'performance-schema-system-variables',
  1130. 'sysvar');
  1131. $variable_doc_links['performance_schema_events_waits_history_size'] = array(
  1132. 'performance_schema_events_waits_history_size',
  1133. 'performance-schema-system-variables',
  1134. 'sysvar');
  1135. $variable_doc_links['performance_schema_max_cond_classes'] = array(
  1136. 'performance_schema_max_cond_classes',
  1137. 'performance-schema-system-variables',
  1138. 'sysvar');
  1139. $variable_doc_links['performance_schema_max_cond_instances'] = array(
  1140. 'performance_schema_max_cond_instances',
  1141. 'performance-schema-system-variables',
  1142. 'sysvar');
  1143. $variable_doc_links['performance_schema_max_file_classes'] = array(
  1144. 'performance_schema_max_file_classes',
  1145. 'performance-schema-system-variables',
  1146. 'sysvar');
  1147. $variable_doc_links['performance_schema_max_file_handles'] = array(
  1148. 'performance_schema_max_file_handles',
  1149. 'performance-schema-system-variables',
  1150. 'sysvar');
  1151. $variable_doc_links['performance_schema_max_file_instances'] = array(
  1152. 'performance_schema_max_file_instances',
  1153. 'performance-schema-system-variables',
  1154. 'sysvar');
  1155. $variable_doc_links['performance_schema_max_mutex_classes'] = array(
  1156. 'performance_schema_max_mutex_classes',
  1157. 'performance-schema-system-variables',
  1158. 'sysvar');
  1159. $variable_doc_links['performance_schema_max_mutex_instances'] = array(
  1160. 'performance_schema_max_mutex_instances',
  1161. 'performance-schema-system-variables',
  1162. 'sysvar');
  1163. $variable_doc_links['performance_schema_max_rwlock_classes'] = array(
  1164. 'performance_schema_max_rwlock_classes',
  1165. 'performance-schema-system-variables',
  1166. 'sysvar');
  1167. $variable_doc_links['performance_schema_max_rwlock_instances'] = array(
  1168. 'performance_schema_max_rwlock_instances',
  1169. 'performance-schema-system-variables',
  1170. 'sysvar');
  1171. $variable_doc_links['performance_schema_max_table_handles'] = array(
  1172. 'performance_schema_max_table_handles',
  1173. 'performance-schema-system-variables',
  1174. 'sysvar');
  1175. $variable_doc_links['performance_schema_max_table_instances'] = array(
  1176. 'performance_schema_max_table_instances',
  1177. 'performance-schema-system-variables',
  1178. 'sysvar');
  1179. $variable_doc_links['performance_schema_max_thread_classes'] = array(
  1180. 'performance_schema_max_thread_classes',
  1181. 'performance-schema-system-variables',
  1182. 'sysvar');
  1183. $variable_doc_links['performance_schema_max_thread_instances'] = array(
  1184. 'performance_schema_max_thread_instances',
  1185. 'performance-schema-system-variables',
  1186. 'sysvar');
  1187. $variable_doc_links['pid_file'] = array(
  1188. 'pid-file',
  1189. 'server-options',
  1190. 'option_mysqld');
  1191. $variable_doc_links['plugin_dir'] = array(
  1192. 'plugin_dir',
  1193. 'server-system-variables',
  1194. 'sysvar');
  1195. $variable_doc_links['port'] = array(
  1196. 'port',
  1197. 'server-options',
  1198. 'option_mysqld');
  1199. $variable_doc_links['preload_buffer_size'] = array(
  1200. 'preload_buffer_size',
  1201. 'server-system-variables',
  1202. 'sysvar',
  1203. 'byte');
  1204. $variable_doc_links['profiling'] = array(
  1205. 'profiling',
  1206. 'server-system-variables',
  1207. 'sysvar');
  1208. $variable_doc_links['profiling_history_size'] = array(
  1209. 'profiling_history_size',
  1210. 'server-system-variables',
  1211. 'sysvar');
  1212. $variable_doc_links['protocol_version'] = array(
  1213. 'protocol_version',
  1214. 'server-system-variables',
  1215. 'sysvar');
  1216. $variable_doc_links['proxy_user'] = array(
  1217. 'proxy_user',
  1218. 'server-system-variables',
  1219. 'sysvar');
  1220. $variable_doc_links['pseudo_thread_id'] = array(
  1221. 'pseudo_thread_id',
  1222. 'server-system-variables',
  1223. 'sysvar');
  1224. $variable_doc_links['query_alloc_block_size'] = array(
  1225. 'query_alloc_block_size',
  1226. 'server-system-variables',
  1227. 'sysvar',
  1228. 'byte');
  1229. $variable_doc_links['query_cache_limit'] = array(
  1230. 'query_cache_limit',
  1231. 'server-system-variables',
  1232. 'sysvar',
  1233. 'byte');
  1234. $variable_doc_links['query_cache_min_res_unit'] = array(
  1235. 'query_cache_min_res_unit',
  1236. 'server-system-variables',
  1237. 'sysvar');
  1238. $variable_doc_links['query_cache_size'] = array(
  1239. 'query_cache_size',
  1240. 'server-system-variables',
  1241. 'sysvar',
  1242. 'byte');
  1243. $variable_doc_links['query_cache_type'] = array(
  1244. 'query_cache_type',
  1245. 'server-system-variables',
  1246. 'sysvar');
  1247. $variable_doc_links['query_cache_wlock_invalidate'] = array(
  1248. 'query_cache_wlock_invalidate',
  1249. 'server-system-variables',
  1250. 'sysvar');
  1251. $variable_doc_links['query_prealloc_size'] = array(
  1252. 'query_prealloc_size',
  1253. 'server-system-variables',
  1254. 'sysvar',
  1255. 'byte');
  1256. $variable_doc_links['rand_seed1'] = array(
  1257. 'rand_seed1',
  1258. 'server-system-variables',
  1259. 'sysvar');
  1260. $variable_doc_links['rand_seed2'] = array(
  1261. 'rand_seed2',
  1262. 'server-system-variables',
  1263. 'sysvar');
  1264. $variable_doc_links['range_alloc_block_size'] = array(
  1265. 'range_alloc_block_size',
  1266. 'server-system-variables',
  1267. 'sysvar',
  1268. 'byte');
  1269. $variable_doc_links['read_buffer_size'] = array(
  1270. 'read_buffer_size',
  1271. 'server-system-variables',
  1272. 'sysvar',
  1273. 'byte');
  1274. $variable_doc_links['read_only'] = array(
  1275. 'read_only',
  1276. 'server-system-variables',
  1277. 'sysvar');
  1278. $variable_doc_links['read_rnd_buffer_size'] = array(
  1279. 'read_rnd_buffer_size',
  1280. 'server-system-variables',
  1281. 'sysvar',
  1282. 'byte');
  1283. $variable_doc_links['relay-log-index'] = array(
  1284. 'relay-log-index',
  1285. 'replication-options-slave',
  1286. 'option_mysqld');
  1287. $variable_doc_links['relay_log_index'] = array(
  1288. 'relay_log_index',
  1289. 'replication-options-slave',
  1290. 'sysvar');
  1291. $variable_doc_links['relay_log_info_file'] = array(
  1292. 'relay_log_info_file',
  1293. 'replication-options-slave',
  1294. 'sysvar');
  1295. $variable_doc_links['relay_log_purge'] = array(
  1296. 'relay_log_purge',
  1297. 'server-system-variables',
  1298. 'sysvar');
  1299. $variable_doc_links['relay_log_recovery'] = array(
  1300. 'relay_log_recovery',
  1301. 'replication-options-slave',
  1302. 'sysvar');
  1303. $variable_doc_links['relay_log_space_limit'] = array(
  1304. 'relay_log_space_limit',
  1305. 'server-system-variables',
  1306. 'sysvar');
  1307. $variable_doc_links['report_host'] = array(
  1308. 'report-host',
  1309. 'replication-options-slave',
  1310. 'option_mysqld');
  1311. $variable_doc_links['report_password'] = array(
  1312. 'report-password',
  1313. 'replication-options-slave',
  1314. 'option_mysqld');
  1315. $variable_doc_links['report_port'] = array(
  1316. 'report-port',
  1317. 'replication-options-slave',
  1318. 'option_mysqld');
  1319. $variable_doc_links['report_user'] = array(
  1320. 'report-user',
  1321. 'replication-options-slave',
  1322. 'option_mysqld');
  1323. $variable_doc_links['rpl_recovery_rank'] = array(
  1324. 'rpl_recovery_rank',
  1325. 'replication-options-slave',
  1326. 'option_mysqld');
  1327. $variable_doc_links['rpl_semi_sync_master_enabled'] = array(
  1328. 'rpl_semi_sync_master_enabled',
  1329. 'server-system-variables',
  1330. 'sysvar');
  1331. $variable_doc_links['rpl_semi_sync_master_timeout'] = array(
  1332. 'rpl_semi_sync_master_timeout',
  1333. 'server-system-variables',
  1334. 'sysvar');
  1335. $variable_doc_links['rpl_semi_sync_master_trace_level'] = array(
  1336. 'rpl_semi_sync_master_trace_level',
  1337. 'server-system-variables',
  1338. 'sysvar');
  1339. $variable_doc_links['rpl_semi_sync_master_wait_no_slave'] = array(
  1340. 'rpl_semi_sync_master_wait_no_slave',
  1341. 'server-system-variables',
  1342. 'sysvar');
  1343. $variable_doc_links['rpl_semi_sync_slave_enabled'] = array(
  1344. 'rpl_semi_sync_slave_enabled',
  1345. 'server-system-variables',
  1346. 'sysvar');
  1347. $variable_doc_links['rpl_semi_sync_slave_trace_level'] = array(
  1348. 'rpl_semi_sync_slave_trace_level',
  1349. 'server-system-variables',
  1350. 'sysvar');
  1351. $variable_doc_links['safe_show_database'] = array(
  1352. 'safe-show-database',
  1353. 'server-options',
  1354. 'option_mysqld');
  1355. $variable_doc_links['secure_auth'] = array(
  1356. 'secure-auth',
  1357. 'server-options',
  1358. 'option_mysqld');
  1359. $variable_doc_links['secure_file_priv'] = array(
  1360. 'secure-file-priv',
  1361. 'server-options',
  1362. 'option_mysqld');
  1363. $variable_doc_links['server_id'] = array(
  1364. 'server-id',
  1365. 'replication-options',
  1366. 'option_mysqld');
  1367. $variable_doc_links['shared_memory'] = array(
  1368. 'shared_memory',
  1369. 'server-system-variables',
  1370. 'sysvar');
  1371. $variable_doc_links['shared_memory_base_name'] = array(
  1372. 'shared_memory_base_name',
  1373. 'server-system-variables',
  1374. 'sysvar');
  1375. $variable_doc_links['skip_external_locking'] = array(
  1376. 'skip-external-locking',
  1377. 'server-options',
  1378. 'option_mysqld');
  1379. $variable_doc_links['skip_name_resolve'] = array(
  1380. 'skip-name-resolve',
  1381. 'server-options',
  1382. 'option_mysqld');
  1383. $variable_doc_links['skip_networking'] = array(
  1384. 'skip-networking',
  1385. 'server-options',
  1386. 'option_mysqld');
  1387. $variable_doc_links['skip_show_database'] = array(
  1388. 'skip-show-database',
  1389. 'server-options',
  1390. 'option_mysqld');
  1391. $variable_doc_links['slave_compressed_protocol'] = array(
  1392. 'slave_compressed_protocol',
  1393. 'replication-options-slave',
  1394. 'sysvar');
  1395. $variable_doc_links['slave_exec_mode'] = array(
  1396. 'slave_exec_mode',
  1397. 'replication-options-slave',
  1398. 'sysvar');
  1399. $variable_doc_links['slave_load_tmpdir'] = array(
  1400. 'slave-load-tmpdir',
  1401. 'replication-options-slave',
  1402. 'option_mysqld');
  1403. $variable_doc_links['slave_net_timeout'] = array(
  1404. 'slave-net-timeout',
  1405. 'replication-options-slave',
  1406. 'option_mysqld');
  1407. $variable_doc_links['slave_skip_errors'] = array(
  1408. 'slave-skip-errors',
  1409. 'replication-options-slave',
  1410. 'option_mysqld');
  1411. $variable_doc_links['slave_transaction_retries'] = array(
  1412. 'slave_transaction_retries',
  1413. 'replication-options-slave',
  1414. 'sysvar');
  1415. $variable_doc_links['slave_type_conversions'] = array(
  1416. 'slave_type_conversions',
  1417. 'replication-options-slave',
  1418. 'sysvar');
  1419. $variable_doc_links['slow_launch_time'] = array(
  1420. 'slow_launch_time',
  1421. 'server-system-variables',
  1422. 'sysvar');
  1423. $variable_doc_links['slow_query_log'] = array(
  1424. 'slow-query-log',
  1425. 'server-options',
  1426. 'server-system-variables');
  1427. $variable_doc_links['slow_query_log_file'] = array(
  1428. 'slow_query_log_file',
  1429. 'server-system-variables',
  1430. 'sysvar');
  1431. $variable_doc_links['socket'] = array(
  1432. 'socket',
  1433. 'server-options',
  1434. 'option_mysqld');
  1435. $variable_doc_links['sort_buffer_size'] = array(
  1436. 'sort_buffer_size',
  1437. 'server-system-variables',
  1438. 'sysvar',
  1439. 'byte');
  1440. $variable_doc_links['sql_auto_is_null'] = array(
  1441. 'sql_auto_is_null',
  1442. 'server-system-variables',
  1443. 'sysvar');
  1444. $variable_doc_links['sql_big_selects'] = array(
  1445. 'sql_big_selects',
  1446. 'server-system-variables',
  1447. 'sysvar');
  1448. $variable_doc_links['sql_big_tables'] = array(
  1449. 'big-tables',
  1450. 'server-options',
  1451. 'server-system-variables');
  1452. $variable_doc_links['sql_buffer_result'] = array(
  1453. 'sql_buffer_result',
  1454. 'server-system-variables',
  1455. 'sysvar');
  1456. $variable_doc_links['sql_log_bin'] = array(
  1457. 'sql_log_bin',
  1458. 'server-system-variables',
  1459. 'sysvar');
  1460. $variable_doc_links['sql_log_off'] = array(
  1461. 'sql_log_off',
  1462. 'server-system-variables',
  1463. 'sysvar');
  1464. $variable_doc_links['sql_log_update'] = array(
  1465. 'sql_log_update',
  1466. 'server-system-variables',
  1467. 'sysvar');
  1468. $variable_doc_links['sql_low_priority_updates'] = array(
  1469. 'sql_low_priority_updates',
  1470. 'server-system-variables',
  1471. 'sysvar');
  1472. $variable_doc_links['sql_max_join_size'] = array(
  1473. 'sql_max_join_size',
  1474. 'server-system-variables',
  1475. 'sysvar');
  1476. $variable_doc_links['sql_mode'] = array(
  1477. 'sql-mode',
  1478. 'server-options',
  1479. 'option_mysqld');
  1480. $variable_doc_links['sql_notes'] = array(
  1481. 'sql_notes',
  1482. 'server-system-variables',
  1483. 'sysvar');
  1484. $variable_doc_links['sql_quote_show_create'] = array(
  1485. 'sql_quote_show_create',
  1486. 'server-system-variables',
  1487. 'sysvar');
  1488. $variable_doc_links['sql_safe_updates'] = array(
  1489. 'sql_safe_updates',
  1490. 'server-system-variables',
  1491. 'sysvar');
  1492. $variable_doc_links['sql_select_limit'] = array(
  1493. 'sql_select_limit',
  1494. 'server-system-variables',
  1495. 'sysvar');
  1496. $variable_doc_links['sql_slave_skip_counter'] = array(
  1497. 'sql_slave_skip_counter',
  1498. 'replication-options-slave',
  1499. 'sysvar');
  1500. $variable_doc_links['sql_warnings'] = array(
  1501. 'sql_warnings',
  1502. 'server-system-variables',
  1503. 'sysvar');
  1504. $variable_doc_links['ssl_ca'] = array(
  1505. 'ssl-ca',
  1506. 'ssl-options',
  1507. 'option_general');
  1508. $variable_doc_links['ssl_capath'] = array(
  1509. 'ssl-capath',
  1510. 'ssl-options',
  1511. 'option_general');
  1512. $variable_doc_links['ssl_cert'] = array(
  1513. 'ssl-cert',
  1514. 'ssl-options',
  1515. 'option_general');
  1516. $variable_doc_links['ssl_cipher'] = array(
  1517. 'ssl-cipher',
  1518. 'ssl-options',
  1519. 'option_general');
  1520. $variable_doc_links['ssl_key'] = array(
  1521. 'ssl-key',
  1522. 'ssl-options',
  1523. 'option_general');
  1524. $variable_doc_links['storage_engine'] = array(
  1525. 'storage_engine',
  1526. 'server-system-variables',
  1527. 'sysvar');
  1528. $variable_doc_links['sync_binlog'] = array(
  1529. 'sync_binlog',
  1530. 'replication-options-binary-log',
  1531. 'sysvar');
  1532. $variable_doc_links['sync_frm'] = array(
  1533. 'sync_frm',
  1534. 'server-system-variables',
  1535. 'sysvar');
  1536. $variable_doc_links['sync_master_info'] = array(
  1537. 'sync_master_info',
  1538. 'replication-options-slave',
  1539. 'sysvar');
  1540. $variable_doc_links['sync_relay_log'] = array(
  1541. 'sync_relay_log',
  1542. 'replication-options-slave',
  1543. 'sysvar');
  1544. $variable_doc_links['sync_relay_log_info'] = array(
  1545. 'sync_relay_log_info',
  1546. 'replication-options-slave',
  1547. 'sysvar');
  1548. $variable_doc_links['system_time_zone'] = array(
  1549. 'system_time_zone',
  1550. 'server-system-variables',
  1551. 'sysvar');
  1552. $variable_doc_links['table_definition_cache'] = array(
  1553. 'table_definition_cache',
  1554. 'server-system-variables',
  1555. 'sysvar');
  1556. $variable_doc_links['table_lock_wait_timeout'] = array(
  1557. 'table_lock_wait_timeout',
  1558. 'server-system-variables',
  1559. 'sysvar');
  1560. $variable_doc_links['table_open_cache'] = array(
  1561. 'table_open_cache',
  1562. 'server-system-variables',
  1563. 'sysvar');
  1564. $variable_doc_links['table_type'] = array(
  1565. 'table_type',
  1566. 'server-system-variables',
  1567. 'sysvar');
  1568. $variable_doc_links['thread_cache_size'] = array(
  1569. 'thread_cache_size',
  1570. 'server-system-variables',
  1571. 'sysvar');
  1572. $variable_doc_links['thread_concurrency'] = array(
  1573. 'thread_concurrency',
  1574. 'server-system-variables',
  1575. 'sysvar');
  1576. $variable_doc_links['thread_handling'] = array(
  1577. 'thread_handling',
  1578. 'server-system-variables',
  1579. 'sysvar');
  1580. $variable_doc_links['thread_stack'] = array(
  1581. 'thread_stack',
  1582. 'server-system-variables',
  1583. 'sysvar');
  1584. $variable_doc_links['time_format'] = array(
  1585. 'time_format',
  1586. 'server-system-variables',
  1587. 'sysvar');
  1588. $variable_doc_links['time_zone'] = array(
  1589. 'time_zone',
  1590. 'server-system-variables',
  1591. 'sysvar');
  1592. $variable_doc_links['timed_mutexes'] = array(
  1593. 'timed_mutexes',
  1594. 'server-system-variables',
  1595. 'sysvar');
  1596. $variable_doc_links['timestamp'] = array(
  1597. 'timestamp',
  1598. 'server-system-variables',
  1599. 'sysvar');
  1600. $variable_doc_links['tmp_table_size'] = array(
  1601. 'tmp_table_size',
  1602. 'server-system-variables',
  1603. 'sysvar',
  1604. 'byte');
  1605. $variable_doc_links['tmpdir'] = array(
  1606. 'tmpdir',
  1607. 'server-options',
  1608. 'option_mysqld');
  1609. $variable_doc_links['transaction_alloc_block_size'] = array(
  1610. 'transaction_alloc_block_size',
  1611. 'server-system-variables',
  1612. 'sysvar',
  1613. 'byte');
  1614. $variable_doc_links['transaction_prealloc_size'] = array(
  1615. 'transaction_prealloc_size',
  1616. 'server-system-variables',
  1617. 'sysvar',
  1618. 'byte');
  1619. $variable_doc_links['tx_isolation'] = array(
  1620. 'tx_isolation',
  1621. 'server-system-variables',
  1622. 'sysvar');
  1623. $variable_doc_links['unique_checks'] = array(
  1624. 'unique_checks',
  1625. 'server-system-variables',
  1626. 'sysvar');
  1627. $variable_doc_links['updatable_views_with_limit'] = array(
  1628. 'updatable_views_with_limit',
  1629. 'server-system-variables',
  1630. 'sysvar');
  1631. $variable_doc_links['version'] = array(
  1632. 'version',
  1633. 'server-system-variables',
  1634. 'sysvar');
  1635. $variable_doc_links['version_comment'] = array(
  1636. 'version_comment',
  1637. 'server-system-variables',
  1638. 'sysvar');
  1639. $variable_doc_links['version_compile_machine'] = array(
  1640. 'version_compile_machine',
  1641. 'server-system-variables',
  1642. 'sysvar');
  1643. $variable_doc_links['version_compile_os'] = array(
  1644. 'version_compile_os',
  1645. 'server-system-variables',
  1646. 'sysvar');
  1647. $variable_doc_links['wait_timeout'] = array(
  1648. 'wait_timeout',
  1649. 'server-system-variables',
  1650. 'sysvar');
  1651. $variable_doc_links['warning_count'] = array(
  1652. 'warning_count',
  1653. 'server-system-variables',
  1654. 'sysvar');
  1655. return $variable_doc_links;
  1656. }
  1657. ?>