Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
116
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysqltuner.pl --outputfile result_mysqltuner.txt
  2. >> MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
  3. >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
  4. >> Run with '--help' for additional options and output filtering
  5.  
  6. [--] Skipped version check for MySQLTuner script
  7. Please enter your MySQL administrative login: admin
  8. Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.6.26-log
  9. [OK] Operating on 64-bit architecture
  10.  
  11. -------- Log file Recommendations ------------------------------------------------------------------
  12. [OK] Log file /var/log/mysql/error.log exists
  13. [--] Log file: /var/log/mysql/error.log(0B)
  14. [OK] Log file /var/log/mysql/error.log is readable.
  15. [!!] Log file /var/log/mysql/error.log is empty
  16. [OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
  17. [OK] /var/log/mysql/error.log doesn't contain any warning.
  18. [OK] /var/log/mysql/error.log doesn't contain any error.
  19. [--] 0 start(s) detected in /var/log/mysql/error.log
  20. [--] 0 shutdown(s) detected in /var/log/mysql/error.log
  21.  
  22. -------- Storage Engine Statistics -----------------------------------------------------------------
  23. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  24. [--] Data in MyISAM tables: 38.2M (Tables: 2552)
  25. [--] Data in InnoDB tables: 210.4G (Tables: 469134)
  26. [--] Data in MEMORY tables: 0B (Tables: 58)
  27. [!!] Total fragmented tables: 1
  28.  
  29. -------- Analysis Performance Metrics --------------------------------------------------------------
  30. [--] innodb_stats_on_metadata: OFF
  31. [OK] No stat updates during querying INFORMATION_SCHEMA.
  32.  
  33. -------- Security Recommendations ------------------------------------------------------------------
  34. [OK] There are no anonymous accounts for any database users
  35. [OK] All database users have passwords assigned
  36. -------- CVE Security Recommendations --------------------------------------------------------------
  37. [--] Skipped due to --cvefile option undefined
  38.  
  39. -------- Performance Metrics -----------------------------------------------------------------------
  40. [--] Up for: 26d 7h 22m 42s (1B q [491.101 qps], 50M conn, TX: 6469G, RX: 349G)
  41. [--] Reads / Writes: 90% / 10%
  42. [--] Binary logging is enabled (GTID MODE: OFF)
  43. [--] Physical Memory : 56.1G
  44. [--] Max MySQL memory : 159.2G
  45. [--] Other process memory: 0B
  46. [--] Total buffers: 25.5G global + 44.2M per thread (3072 max threads)
  47. [--] P_S Max memory usage: 914M
  48. [--] Galera GCache Max memory usage: 0B
  49. [!!] Maximum reached memory usage: 48.3G (86.04% of installed RAM)
  50. [!!] Maximum possible memory usage: 159.2G (283.44% of installed RAM)
  51. [!!] Overall possible memory usage with other process exceeded memory
  52. [!!] Slow queries: 19% (214M/1B)
  53. [OK] Highest usage of available connections: 16% (507/3072)
  54. [OK] Aborted connections: 0.74% (370958/50206131)
  55. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  56. [!!] Query cache may be disabled by default due to mutex contention.
  57. [!!] Query cache efficiency: 0.0% (0 cached / 991M selects)
  58. [OK] Query cache prunes per day: 0
  59. [OK] Sorts requiring temporary tables: 0% (10K temp sorts / 291M sorts)
  60. [!!] Joins performed without indexes: 9385371
  61. [!!] Temporary tables created on disk: 35% (58M on disk / 165M total)
  62. [OK] Thread cache hit rate: 99% (12K created / 50M connections)
  63. [!!] Table cache hit rate: 0% (2K open / 279M opened)
  64. [!!] table_definition_cache(1400) is lower than number of tables(471905)
  65. [OK] Open file limit used: 0% (6/1M)
  66. [OK] Table locks acquired immediately: 99% (1B immediate / 1B locks)
  67. [OK] Binlog cache memory access: 0% (0 Memory / 0 Total)
  68.  
  69. -------- Performance schema ------------------------------------------------------------------------
  70. [--] Memory used by P_S: 915.0M
  71. [--] Sys schema isn't installed.
  72.  
  73. -------- ThreadPool Metrics ------------------------------------------------------------------------
  74. [--] ThreadPool stat is disabled.
  75.  
  76. -------- MyISAM Metrics ----------------------------------------------------------------------------
  77. [!!] Key buffer used: 18.2% (195M used / 1B cache)
  78. [OK] Key buffer size / total MyISAM indexes: 1.0G/21.1M
  79. [OK] Read Key buffer hit rate: 100.0% (20B cached / 6M reads)
  80. [!!] Write Key buffer hit rate: 0.0% (4B cached / 48K writes)
  81.  
  82. -------- InnoDB Metrics ----------------------------------------------------------------------------
  83. [--] InnoDB is enabled.
  84. [--] InnoDB Thread Concurrency: 0
  85. [OK] InnoDB File per table is activated
  86. [!!] InnoDB buffer pool / data size: 24.0G/210.4G
  87. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (2.08333333333333 %): 256.0M * 2/24.0G should be equal to 25%
  88. [!!] InnoDB buffer pool instances: 8
  89. [--] InnoDB Buffer Pool Chunk Size not used or defined in your version
  90. [OK] InnoDB Read buffer efficiency: 99.98% (1361756316227 hits/ 1361975928793 total)
  91. [OK] InnoDB Write log efficiency: 94.21% (1127657366 hits/ 1196930296 total)
  92. [OK] InnoDB log waits: 0.00% (0 waits / 69272930 writes)
  93.  
  94. -------- AriaDB Metrics ----------------------------------------------------------------------------
  95. [--] AriaDB is disabled.
  96.  
  97. -------- TokuDB Metrics ----------------------------------------------------------------------------
  98. [--] TokuDB is disabled.
  99.  
  100. -------- XtraDB Metrics ----------------------------------------------------------------------------
  101. [--] XtraDB is disabled.
  102.  
  103. -------- Galera Metrics ----------------------------------------------------------------------------
  104. [--] Galera is disabled.
  105.  
  106. -------- Replication Metrics -----------------------------------------------------------------------
  107. [--] Galera Synchronous replication: NO
  108. [--] No replication slave(s) for this server.
  109. [--] Binlog format: MIXED
  110. [--] XA support enabled: ON
  111. [--] Semi synchronous replication Master: Not Activated
  112. [--] Semi synchronous replication Slave: Not Activated
  113. [OK] This replication slave is running with the read_only option enabled.
  114. [OK] This replication slave is up to date with master.
  115.  
  116. -------- Recommendations ---------------------------------------------------------------------------
  117. General recommendations:
  118. Reduce your overall MySQL memory footprint for system stability
  119. Dedicate this server to your database for highest performance.
  120. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  121. We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
  122. See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
  123. (specially the conclusions at the bottom of the page).
  124. When making adjustments, make tmp_table_size/max_heap_table_size equal
  125. Reduce your SELECT DISTINCT queries which have no LIMIT clause
  126. Increase table_open_cache gradually to avoid file descriptor limits
  127. Read this before increasing table_open_cache over 64: https://bit.ly/2Fulv7r
  128. Read this before increasing for MariaDB https://mariadb.com/kb/en/library/optimizing-table_open_cache/
  129. This is MyISAM only table_cache scalability problem, InnoDB not affected.
  130. See more details here: https://bugs.mysql.com/bug.php?id=49177
  131. This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
  132. Beware that open_files_limit (1024000) variable
  133. should be greater than table_open_cache (2000)
  134. Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
  135. Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB
  136. Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
  137. Variables to adjust:
  138. *** MySQL's maximum memory usage is dangerously high ***
  139. *** Add RAM before increasing MySQL buffer variables ***
  140. query_cache_size (=0)
  141. query_cache_type (=0)
  142. query_cache_limit (> 2M, or use smaller result sets)
  143. join_buffer_size (> 32.0M, or always use indexes with JOINs)
  144. tmp_table_size (> 192M)
  145. max_heap_table_size (> 192M)
  146. table_open_cache (> 2000)
  147. table_definition_cache(1400) > 471905 or -1 (autosizing if supported)
  148. innodb_buffer_pool_size (>= 210.4G) if possible.
  149. innodb_log_file_size should be (=3G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
  150. innodb_buffer_pool_instances(=24)
  151.  
  152.  
  153. mysql> SHOW GLOBAL STATUS\G;
  154. *************************** 1. row ***************************
  155. Variable_name: Aborted_clients
  156. Value: 9679
  157. *************************** 2. row ***************************
  158. Variable_name: Aborted_connects
  159. Value: 371132
  160. *************************** 3. row ***************************
  161. Variable_name: Binlog_cache_disk_use
  162. Value: 0
  163. *************************** 4. row ***************************
  164. Variable_name: Binlog_cache_use
  165. Value: 0
  166. *************************** 5. row ***************************
  167. Variable_name: Binlog_stmt_cache_disk_use
  168. Value: 0
  169. *************************** 6. row ***************************
  170. Variable_name: Binlog_stmt_cache_use
  171. Value: 0
  172. *************************** 7. row ***************************
  173. Variable_name: Bytes_received
  174. Value: 375611005675
  175. *************************** 8. row ***************************
  176. Variable_name: Bytes_sent
  177. Value: 6948696360269
  178. *************************** 9. row ***************************
  179. Variable_name: Com_admin_commands
  180. Value: 8749143
  181. *************************** 10. row ***************************
  182. Variable_name: Com_assign_to_keycache
  183. Value: 0
  184. *************************** 11. row ***************************
  185. Variable_name: Com_alter_db
  186. Value: 0
  187. *************************** 12. row ***************************
  188. Variable_name: Com_alter_db_upgrade
  189. Value: 0
  190. *************************** 13. row ***************************
  191. Variable_name: Com_alter_event
  192. Value: 0
  193. *************************** 14. row ***************************
  194. Variable_name: Com_alter_function
  195. Value: 0
  196. *************************** 15. row ***************************
  197. Variable_name: Com_alter_procedure
  198. Value: 0
  199. *************************** 16. row ***************************
  200. Variable_name: Com_alter_server
  201. Value: 0
  202. *************************** 17. row ***************************
  203. Variable_name: Com_alter_table
  204. Value: 14514
  205. *************************** 18. row ***************************
  206. Variable_name: Com_alter_tablespace
  207. Value: 0
  208. *************************** 19. row ***************************
  209. Variable_name: Com_alter_user
  210. Value: 0
  211. *************************** 20. row ***************************
  212. Variable_name: Com_analyze
  213. Value: 0
  214. *************************** 21. row ***************************
  215. Variable_name: Com_begin
  216. Value: 94675964
  217. *************************** 22. row ***************************
  218. Variable_name: Com_binlog
  219. Value: 0
  220. *************************** 23. row ***************************
  221. Variable_name: Com_call_procedure
  222. Value: 0
  223. *************************** 24. row ***************************
  224. Variable_name: Com_change_db
  225. Value: 41923101
  226. *************************** 25. row ***************************
  227. Variable_name: Com_change_master
  228. Value: 0
  229. *************************** 26. row ***************************
  230. Variable_name: Com_check
  231. Value: 0
  232. *************************** 27. row ***************************
  233. Variable_name: Com_checksum
  234. Value: 0
  235. *************************** 28. row ***************************
  236. Variable_name: Com_commit
  237. Value: 94675959
  238. *************************** 29. row ***************************
  239. Variable_name: Com_create_db
  240. Value: 23
  241. *************************** 30. row ***************************
  242. Variable_name: Com_create_event
  243. Value: 0
  244. *************************** 31. row ***************************
  245. Variable_name: Com_create_function
  246. Value: 0
  247. *************************** 32. row ***************************
  248. Variable_name: Com_create_index
  249. Value: 0
  250. *************************** 33. row ***************************
  251. Variable_name: Com_create_procedure
  252. Value: 0
  253. *************************** 34. row ***************************
  254. Variable_name: Com_create_server
  255. Value: 0
  256. *************************** 35. row ***************************
  257. Variable_name: Com_create_table
  258. Value: 8801
  259. *************************** 36. row ***************************
  260. Variable_name: Com_create_trigger
  261. Value: 0
  262. *************************** 37. row ***************************
  263. Variable_name: Com_create_udf
  264. Value: 0
  265. *************************** 38. row ***************************
  266. Variable_name: Com_create_user
  267. Value: 0
  268. *************************** 39. row ***************************
  269. Variable_name: Com_create_view
  270. Value: 9
  271. *************************** 40. row ***************************
  272. Variable_name: Com_dealloc_sql
  273. Value: 0
  274. *************************** 41. row ***************************
  275. Variable_name: Com_delete
  276. Value: 27289251
  277. *************************** 42. row ***************************
  278. Variable_name: Com_delete_multi
  279. Value: 5303
  280. *************************** 43. row ***************************
  281. Variable_name: Com_do
  282. Value: 0
  283. *************************** 44. row ***************************
  284. Variable_name: Com_drop_db
  285. Value: 2
  286. *************************** 45. row ***************************
  287. Variable_name: Com_drop_event
  288. Value: 0
  289. *************************** 46. row ***************************
  290. Variable_name: Com_drop_function
  291. Value: 0
  292. *************************** 47. row ***************************
  293. Variable_name: Com_drop_index
  294. Value: 0
  295. *************************** 48. row ***************************
  296. Variable_name: Com_drop_procedure
  297. Value: 0
  298. *************************** 49. row ***************************
  299. Variable_name: Com_drop_server
  300. Value: 0
  301. *************************** 50. row ***************************
  302. Variable_name: Com_drop_table
  303. Value: 89
  304. *************************** 51. row ***************************
  305. Variable_name: Com_drop_trigger
  306. Value: 0
  307. *************************** 52. row ***************************
  308. Variable_name: Com_drop_user
  309. Value: 0
  310. *************************** 53. row ***************************
  311. Variable_name: Com_drop_view
  312. Value: 0
  313. *************************** 54. row ***************************
  314. Variable_name: Com_empty_query
  315. Value: 5
  316. *************************** 55. row ***************************
  317. Variable_name: Com_execute_sql
  318. Value: 0
  319. *************************** 56. row ***************************
  320. Variable_name: Com_flush
  321. Value: 2
  322. *************************** 57. row ***************************
  323. Variable_name: Com_get_diagnostics
  324. Value: 0
  325. *************************** 58. row ***************************
  326. Variable_name: Com_grant
  327. Value: 0
  328. *************************** 59. row ***************************
  329. Variable_name: Com_ha_close
  330. Value: 0
  331. *************************** 60. row ***************************
  332. Variable_name: Com_ha_open
  333. Value: 0
  334. *************************** 61. row ***************************
  335. Variable_name: Com_ha_read
  336. Value: 0
  337. *************************** 62. row ***************************
  338. Variable_name: Com_help
  339. Value: 0
  340. *************************** 63. row ***************************
  341. Variable_name: Com_insert
  342. Value: 32572833
  343. *************************** 64. row ***************************
  344. Variable_name: Com_insert_select
  345. Value: 87096
  346. *************************** 65. row ***************************
  347. Variable_name: Com_install_plugin
  348. Value: 0
  349. *************************** 66. row ***************************
  350. Variable_name: Com_kill
  351. Value: 1
  352. *************************** 67. row ***************************
  353. Variable_name: Com_load
  354. Value: 0
  355. *************************** 68. row ***************************
  356. Variable_name: Com_lock_tables
  357. Value: 1421
  358. *************************** 69. row ***************************
  359. Variable_name: Com_optimize
  360. Value: 0
  361. *************************** 70. row ***************************
  362. Variable_name: Com_preload_keys
  363. Value: 0
  364. *************************** 71. row ***************************
  365. Variable_name: Com_prepare_sql
  366. Value: 0
  367. *************************** 72. row ***************************
  368. Variable_name: Com_purge
  369. Value: 0
  370. *************************** 73. row ***************************
  371. Variable_name: Com_purge_before_date
  372. Value: 0
  373. *************************** 74. row ***************************
  374. Variable_name: Com_release_savepoint
  375. Value: 2
  376. *************************** 75. row ***************************
  377. Variable_name: Com_rename_table
  378. Value: 68
  379. *************************** 76. row ***************************
  380. Variable_name: Com_rename_user
  381. Value: 0
  382. *************************** 77. row ***************************
  383. Variable_name: Com_repair
  384. Value: 0
  385. *************************** 78. row ***************************
  386. Variable_name: Com_replace
  387. Value: 6549371
  388. *************************** 79. row ***************************
  389. Variable_name: Com_replace_select
  390. Value: 0
  391. *************************** 80. row ***************************
  392. Variable_name: Com_reset
  393. Value: 0
  394. *************************** 81. row ***************************
  395. Variable_name: Com_resignal
  396. Value: 0
  397. *************************** 82. row ***************************
  398. Variable_name: Com_revoke
  399. Value: 0
  400. *************************** 83. row ***************************
  401. Variable_name: Com_revoke_all
  402. Value: 0
  403. *************************** 84. row ***************************
  404. Variable_name: Com_rollback
  405. Value: 0
  406. *************************** 85. row ***************************
  407. Variable_name: Com_rollback_to_savepoint
  408. Value: 1325
  409. *************************** 86. row ***************************
  410. Variable_name: Com_savepoint
  411. Value: 5
  412. *************************** 87. row ***************************
  413. Variable_name: Com_select
  414. Value: 991823843
  415. *************************** 88. row ***************************
  416. Variable_name: Com_set_option
  417. Value: 13689686
  418. *************************** 89. row ***************************
  419. Variable_name: Com_signal
  420. Value: 0
  421. *************************** 90. row ***************************
  422. Variable_name: Com_show_binlog_events
  423. Value: 0
  424. *************************** 91. row ***************************
  425. Variable_name: Com_show_binlogs
  426. Value: 6959
  427. *************************** 92. row ***************************
  428. Variable_name: Com_show_charsets
  429. Value: 0
  430. *************************** 93. row ***************************
  431. Variable_name: Com_show_collations
  432. Value: 0
  433. *************************** 94. row ***************************
  434. Variable_name: Com_show_create_db
  435. Value: 1419
  436. *************************** 95. row ***************************
  437. Variable_name: Com_show_create_event
  438. Value: 0
  439. *************************** 96. row ***************************
  440. Variable_name: Com_show_create_func
  441. Value: 0
  442. *************************** 97. row ***************************
  443. Variable_name: Com_show_create_proc
  444. Value: 0
  445. *************************** 98. row ***************************
  446. Variable_name: Com_show_create_table
  447. Value: 469784
  448. *************************** 99. row ***************************
  449. Variable_name: Com_show_create_trigger
  450. Value: 0
  451. *************************** 100. row ***************************
  452. Variable_name: Com_show_databases
  453. Value: 5
  454. *************************** 101. row ***************************
  455. Variable_name: Com_show_engine_logs
  456. Value: 0
  457. *************************** 102. row ***************************
  458. Variable_name: Com_show_engine_mutex
  459. Value: 0
  460. *************************** 103. row ***************************
  461. Variable_name: Com_show_engine_status
  462. Value: 6942
  463. *************************** 104. row ***************************
  464. Variable_name: Com_show_events
  465. Value: 0
  466. *************************** 105. row ***************************
  467. Variable_name: Com_show_errors
  468. Value: 0
  469. *************************** 106. row ***************************
  470. Variable_name: Com_show_fields
  471. Value: 472092
  472. *************************** 107. row ***************************
  473. Variable_name: Com_show_function_code
  474. Value: 0
  475. *************************** 108. row ***************************
  476. Variable_name: Com_show_function_status
  477. Value: 0
  478. *************************** 109. row ***************************
  479. Variable_name: Com_show_grants
  480. Value: 7
  481. *************************** 110. row ***************************
  482. Variable_name: Com_show_keys
  483. Value: 1
  484. *************************** 111. row ***************************
  485. Variable_name: Com_show_master_status
  486. Value: 162
  487. *************************** 112. row ***************************
  488. Variable_name: Com_show_open_tables
  489. Value: 0
  490. *************************** 113. row ***************************
  491. Variable_name: Com_show_plugins
  492. Value: 1
  493. *************************** 114. row ***************************
  494. Variable_name: Com_show_privileges
  495. Value: 0
  496. *************************** 115. row ***************************
  497. Variable_name: Com_show_procedure_code
  498. Value: 0
  499. *************************** 116. row ***************************
  500. Variable_name: Com_show_procedure_status
  501. Value: 0
  502. *************************** 117. row ***************************
  503. Variable_name: Com_show_processlist
  504. Value: 7092
  505. *************************** 118. row ***************************
  506. Variable_name: Com_show_profile
  507. Value: 0
  508. *************************** 119. row ***************************
  509. Variable_name: Com_show_profiles
  510. Value: 0
  511. *************************** 120. row ***************************
  512. Variable_name: Com_show_relaylog_events
  513. Value: 0
  514. *************************** 121. row ***************************
  515. Variable_name: Com_show_slave_hosts
  516. Value: 1
  517. *************************** 122. row ***************************
  518. Variable_name: Com_show_slave_status
  519. Value: 8761067
  520. *************************** 123. row ***************************
  521. Variable_name: Com_show_status
  522. Value: 7107
  523. *************************** 124. row ***************************
  524. Variable_name: Com_show_storage_engines
  525. Value: 1
  526. *************************** 125. row ***************************
  527. Variable_name: Com_show_table_status
  528. Value: 466781
  529. *************************** 126. row ***************************
  530. Variable_name: Com_show_tables
  531. Value: 1461
  532. *************************** 127. row ***************************
  533. Variable_name: Com_show_triggers
  534. Value: 465489
  535. *************************** 128. row ***************************
  536. Variable_name: Com_show_variables
  537. Value: 7119
  538. *************************** 129. row ***************************
  539. Variable_name: Com_show_warnings
  540. Value: 0
  541. *************************** 130. row ***************************
  542. Variable_name: Com_slave_start
  543. Value: 0
  544. *************************** 131. row ***************************
  545. Variable_name: Com_slave_stop
  546. Value: 0
  547. *************************** 132. row ***************************
  548. Variable_name: Com_stmt_close
  549. Value: 0
  550. *************************** 133. row ***************************
  551. Variable_name: Com_stmt_execute
  552. Value: 0
  553. *************************** 134. row ***************************
  554. Variable_name: Com_stmt_fetch
  555. Value: 0
  556. *************************** 135. row ***************************
  557. Variable_name: Com_stmt_prepare
  558. Value: 0
  559. *************************** 136. row ***************************
  560. Variable_name: Com_stmt_reprepare
  561. Value: 0
  562. *************************** 137. row ***************************
  563. Variable_name: Com_stmt_reset
  564. Value: 0
  565. *************************** 138. row ***************************
  566. Variable_name: Com_stmt_send_long_data
  567. Value: 0
  568. *************************** 139. row ***************************
  569. Variable_name: Com_truncate
  570. Value: 507
  571. *************************** 140. row ***************************
  572. Variable_name: Com_uninstall_plugin
  573. Value: 0
  574. *************************** 141. row ***************************
  575. Variable_name: Com_unlock_tables
  576. Value: 1427
  577. *************************** 142. row ***************************
  578. Variable_name: Com_update
  579. Value: 43830477
  580. *************************** 143. row ***************************
  581. Variable_name: Com_update_multi
  582. Value: 2061
  583. *************************** 144. row ***************************
  584. Variable_name: Com_xa_commit
  585. Value: 0
  586. *************************** 145. row ***************************
  587. Variable_name: Com_xa_end
  588. Value: 0
  589. *************************** 146. row ***************************
  590. Variable_name: Com_xa_prepare
  591. Value: 0
  592. *************************** 147. row ***************************
  593. Variable_name: Com_xa_recover
  594. Value: 0
  595. *************************** 148. row ***************************
  596. Variable_name: Com_xa_rollback
  597. Value: 0
  598. *************************** 149. row ***************************
  599. Variable_name: Com_xa_start
  600. Value: 0
  601. *************************** 150. row ***************************
  602. Variable_name: Compression
  603. Value: OFF
  604. *************************** 151. row ***************************
  605. Variable_name: Connection_errors_accept
  606. Value: 0
  607. *************************** 152. row ***************************
  608. Variable_name: Connection_errors_internal
  609. Value: 0
  610. *************************** 153. row ***************************
  611. Variable_name: Connection_errors_max_connections
  612. Value: 0
  613. *************************** 154. row ***************************
  614. Variable_name: Connection_errors_peer_address
  615. Value: 0
  616. *************************** 155. row ***************************
  617. Variable_name: Connection_errors_select
  618. Value: 0
  619. *************************** 156. row ***************************
  620. Variable_name: Connection_errors_tcpwrap
  621. Value: 0
  622. *************************** 157. row ***************************
  623. Variable_name: Connections
  624. Value: 50255694
  625. *************************** 158. row ***************************
  626. Variable_name: Created_tmp_disk_tables
  627. Value: 58100771
  628. *************************** 159. row ***************************
  629. Variable_name: Created_tmp_files
  630. Value: 87768
  631. *************************** 160. row ***************************
  632. Variable_name: Created_tmp_tables
  633. Value: 165917864
  634. *************************** 161. row ***************************
  635. Variable_name: Delayed_errors
  636. Value: 0
  637. *************************** 162. row ***************************
  638. Variable_name: Delayed_insert_threads
  639. Value: 0
  640. *************************** 163. row ***************************
  641. Variable_name: Delayed_writes
  642. Value: 0
  643. *************************** 164. row ***************************
  644. Variable_name: Flush_commands
  645. Value: 1
  646. *************************** 165. row ***************************
  647. Variable_name: Handler_commit
  648. Value: 1187083598
  649. *************************** 166. row ***************************
  650. Variable_name: Handler_delete
  651. Value: 496106687
  652. *************************** 167. row ***************************
  653. Variable_name: Handler_discover
  654. Value: 0
  655. *************************** 168. row ***************************
  656. Variable_name: Handler_external_lock
  657. Value: 3769307500
  658. *************************** 169. row ***************************
  659. Variable_name: Handler_mrr_init
  660. Value: 0
  661. *************************** 170. row ***************************
  662. Variable_name: Handler_prepare
  663. Value: 0
  664. *************************** 171. row ***************************
  665. Variable_name: Handler_read_first
  666. Value: 224449498
  667. *************************** 172. row ***************************
  668. Variable_name: Handler_read_key
  669. Value: 137279808270
  670. *************************** 173. row ***************************
  671. Variable_name: Handler_read_last
  672. Value: 2288715
  673. *************************** 174. row ***************************
  674. Variable_name: Handler_read_next
  675. Value: 1052470718194
  676. *************************** 175. row ***************************
  677. Variable_name: Handler_read_prev
  678. Value: 8284386963
  679. *************************** 176. row ***************************
  680. Variable_name: Handler_read_rnd
  681. Value: 25432088710
  682. *************************** 177. row ***************************
  683. Variable_name: Handler_read_rnd_next
  684. Value: 300963194594
  685. *************************** 178. row ***************************
  686. Variable_name: Handler_rollback
  687. Value: 84
  688. *************************** 179. row ***************************
  689. Variable_name: Handler_savepoint
  690. Value: 5
  691. *************************** 180. row ***************************
  692. Variable_name: Handler_savepoint_rollback
  693. Value: 1325
  694. *************************** 181. row ***************************
  695. Variable_name: Handler_update
  696. Value: 6763880761
  697. *************************** 182. row ***************************
  698. Variable_name: Handler_write
  699. Value: 29909252802
  700. *************************** 183. row ***************************
  701. Variable_name: Innodb_buffer_pool_dump_status
  702. Value: not started
  703. *************************** 184. row ***************************
  704. Variable_name: Innodb_buffer_pool_load_status
  705. Value: not started
  706. *************************** 185. row ***************************
  707. Variable_name: Innodb_buffer_pool_pages_data
  708. Value: 1468682
  709. *************************** 186. row ***************************
  710. Variable_name: Innodb_buffer_pool_bytes_data
  711. Value: 24062885888
  712. *************************** 187. row ***************************
  713. Variable_name: Innodb_buffer_pool_pages_dirty
  714. Value: 6740
  715. *************************** 188. row ***************************
  716. Variable_name: Innodb_buffer_pool_bytes_dirty
  717. Value: 110428160
  718. *************************** 189. row ***************************
  719. Variable_name: Innodb_buffer_pool_pages_flushed
  720. Value: 150193054
  721. *************************** 190. row ***************************
  722. Variable_name: Innodb_buffer_pool_pages_free
  723. Value: 7853
  724. *************************** 191. row ***************************
  725. Variable_name: Innodb_buffer_pool_pages_misc
  726. Value: 96325
  727. *************************** 192. row ***************************
  728. Variable_name: Innodb_buffer_pool_pages_total
  729. Value: 1572860
  730. *************************** 193. row ***************************
  731. Variable_name: Innodb_buffer_pool_read_ahead_rnd
  732. Value: 0
  733. *************************** 194. row ***************************
  734. Variable_name: Innodb_buffer_pool_read_ahead
  735. Value: 17291749
  736. *************************** 195. row ***************************
  737. Variable_name: Innodb_buffer_pool_read_ahead_evicted
  738. Value: 5476
  739. *************************** 196. row ***************************
  740. Variable_name: Innodb_buffer_pool_read_requests
  741. Value: 1362527306367
  742. *************************** 197. row ***************************
  743. Variable_name: Innodb_buffer_pool_reads
  744. Value: 223908924
  745. *************************** 198. row ***************************
  746. Variable_name: Innodb_buffer_pool_wait_free
  747. Value: 0
  748. *************************** 199. row ***************************
  749. Variable_name: Innodb_buffer_pool_write_requests
  750. Value: 18574211377
  751. *************************** 200. row ***************************
  752. Variable_name: Innodb_data_fsyncs
  753. Value: 114987861
  754. *************************** 201. row ***************************
  755. Variable_name: Innodb_data_pending_fsyncs
  756. Value: 0
  757. *************************** 202. row ***************************
  758. Variable_name: Innodb_data_pending_reads
  759. Value: 0
  760. *************************** 203. row ***************************
  761. Variable_name: Innodb_data_pending_writes
  762. Value: 0
  763. *************************** 204. row ***************************
  764. Variable_name: Innodb_data_read
  765. Value: 4122428100608
  766. *************************** 205. row ***************************
  767. Variable_name: Innodb_data_reads
  768. Value: 252125047
  769. *************************** 206. row ***************************
  770. Variable_name: Innodb_data_writes
  771. Value: 232092316
  772. *************************** 207. row ***************************
  773. Variable_name: Innodb_data_written
  774. Value: 5477843815424
  775. *************************** 208. row ***************************
  776. Variable_name: Innodb_dblwr_pages_written
  777. Value: 150193054
  778. *************************** 209. row ***************************
  779. Variable_name: Innodb_dblwr_writes
  780. Value: 11959746
  781. *************************** 210. row ***************************
  782. Variable_name: Innodb_have_atomic_builtins
  783. Value: ON
  784. *************************** 211. row ***************************
  785. Variable_name: Innodb_log_waits
  786. Value: 0
  787. *************************** 212. row ***************************
  788. Variable_name: Innodb_log_write_requests
  789. Value: 1197205996
  790. *************************** 213. row ***************************
  791. Variable_name: Innodb_log_writes
  792. Value: 69362297
  793. *************************** 214. row ***************************
  794. Variable_name: Innodb_os_log_fsyncs
  795. Value: 69612464
  796. *************************** 215. row ***************************
  797. Variable_name: Innodb_os_log_pending_fsyncs
  798. Value: 0
  799. *************************** 216. row ***************************
  800. Variable_name: Innodb_os_log_pending_writes
  801. Value: 0
  802. *************************** 217. row ***************************
  803. Variable_name: Innodb_os_log_written
  804. Value: 556204107264
  805. *************************** 218. row ***************************
  806. Variable_name: Innodb_page_size
  807. Value: 16384
  808. *************************** 219. row ***************************
  809. Variable_name: Innodb_pages_created
  810. Value: 8949645
  811. *************************** 220. row ***************************
  812. Variable_name: Innodb_pages_read
  813. Value: 251614384
  814. *************************** 221. row ***************************
  815. Variable_name: Innodb_pages_written
  816. Value: 150193054
  817. *************************** 222. row ***************************
  818. Variable_name: Innodb_row_lock_current_waits
  819. Value: 0
  820. *************************** 223. row ***************************
  821. Variable_name: Innodb_row_lock_time
  822. Value: 0
  823. *************************** 224. row ***************************
  824. Variable_name: Innodb_row_lock_time_avg
  825. Value: 0
  826. *************************** 225. row ***************************
  827. Variable_name: Innodb_row_lock_time_max
  828. Value: 0
  829. *************************** 226. row ***************************
  830. Variable_name: Innodb_row_lock_waits
  831. Value: 0
  832. *************************** 227. row ***************************
  833. Variable_name: Innodb_rows_deleted
  834. Value: 496172364
  835. *************************** 228. row ***************************
  836. Variable_name: Innodb_rows_inserted
  837. Value: 539630268
  838. *************************** 229. row ***************************
  839. Variable_name: Innodb_rows_read
  840. Value: 1419279067224
  841. *************************** 230. row ***************************
  842. Variable_name: Innodb_rows_updated
  843. Value: 471373449
  844. *************************** 231. row ***************************
  845. Variable_name: Innodb_num_open_files
  846. Value: 2000
  847. *************************** 232. row ***************************
  848. Variable_name: Innodb_truncated_status_writes
  849. Value: 0
  850. *************************** 233. row ***************************
  851. Variable_name: Innodb_available_undo_logs
  852. Value: 128
  853. *************************** 234. row ***************************
  854. Variable_name: Key_blocks_not_flushed
  855. Value: 0
  856. *************************** 235. row ***************************
  857. Variable_name: Key_blocks_unused
  858. Value: 857368
  859. *************************** 236. row ***************************
  860. Variable_name: Key_blocks_used
  861. Value: 6797
  862. *************************** 237. row ***************************
  863. Variable_name: Key_read_requests
  864. Value: 20817794454
  865. *************************** 238. row ***************************
  866. Variable_name: Key_reads
  867. Value: 6841275
  868. *************************** 239. row ***************************
  869. Variable_name: Key_write_requests
  870. Value: 4140103768
  871. *************************** 240. row ***************************
  872. Variable_name: Key_writes
  873. Value: 48618
  874. *************************** 241. row ***************************
  875. Variable_name: Last_query_cost
  876. Value: 0.000000
  877. *************************** 242. row ***************************
  878. Variable_name: Last_query_partial_plans
  879. Value: 0
  880. *************************** 243. row ***************************
  881. Variable_name: Max_used_connections
  882. Value: 507
  883. *************************** 244. row ***************************
  884. Variable_name: Not_flushed_delayed_rows
  885. Value: 0
  886. *************************** 245. row ***************************
  887. Variable_name: Open_files
  888. Value: 23
  889. *************************** 246. row ***************************
  890. Variable_name: Open_streams
  891. Value: 0
  892. *************************** 247. row ***************************
  893. Variable_name: Open_table_definitions
  894. Value: 1965
  895. *************************** 248. row ***************************
  896. Variable_name: Open_tables
  897. Value: 2000
  898. *************************** 249. row ***************************
  899. Variable_name: Opened_files
  900. Value: 466154876
  901. *************************** 250. row ***************************
  902. Variable_name: Opened_table_definitions
  903. Value: 232734466
  904. *************************** 251. row ***************************
  905. Variable_name: Opened_tables
  906. Value: 280606491
  907. *************************** 252. row ***************************
  908. Variable_name: Performance_schema_accounts_lost
  909. Value: 0
  910. *************************** 253. row ***************************
  911. Variable_name: Performance_schema_cond_classes_lost
  912. Value: 0
  913. *************************** 254. row ***************************
  914. Variable_name: Performance_schema_cond_instances_lost
  915. Value: 0
  916. *************************** 255. row ***************************
  917. Variable_name: Performance_schema_digest_lost
  918. Value: 544989142
  919. *************************** 256. row ***************************
  920. Variable_name: Performance_schema_file_classes_lost
  921. Value: 0
  922. *************************** 257. row ***************************
  923. Variable_name: Performance_schema_file_handles_lost
  924. Value: 0
  925. *************************** 258. row ***************************
  926. Variable_name: Performance_schema_file_instances_lost
  927. Value: 479785988
  928. *************************** 259. row ***************************
  929. Variable_name: Performance_schema_hosts_lost
  930. Value: 0
  931. *************************** 260. row ***************************
  932. Variable_name: Performance_schema_locker_lost
  933. Value: 0
  934. *************************** 261. row ***************************
  935. Variable_name: Performance_schema_mutex_classes_lost
  936. Value: 0
  937. *************************** 262. row ***************************
  938. Variable_name: Performance_schema_mutex_instances_lost
  939. Value: 0
  940. *************************** 263. row ***************************
  941. Variable_name: Performance_schema_rwlock_classes_lost
  942. Value: 0
  943. *************************** 264. row ***************************
  944. Variable_name: Performance_schema_rwlock_instances_lost
  945. Value: 0
  946. *************************** 265. row ***************************
  947. Variable_name: Performance_schema_session_connect_attrs_lost
  948. Value: 0
  949. *************************** 266. row ***************************
  950. Variable_name: Performance_schema_socket_classes_lost
  951. Value: 0
  952. *************************** 267. row ***************************
  953. Variable_name: Performance_schema_socket_instances_lost
  954. Value: 0
  955. *************************** 268. row ***************************
  956. Variable_name: Performance_schema_stage_classes_lost
  957. Value: 0
  958. *************************** 269. row ***************************
  959. Variable_name: Performance_schema_statement_classes_lost
  960. Value: 0
  961. *************************** 270. row ***************************
  962. Variable_name: Performance_schema_table_handles_lost
  963. Value: 0
  964. *************************** 271. row ***************************
  965. Variable_name: Performance_schema_table_instances_lost
  966. Value: 82646217
  967. *************************** 272. row ***************************
  968. Variable_name: Performance_schema_thread_classes_lost
  969. Value: 0
  970. *************************** 273. row ***************************
  971. Variable_name: Performance_schema_thread_instances_lost
  972. Value: 0
  973. *************************** 274. row ***************************
  974. Variable_name: Performance_schema_users_lost
  975. Value: 0
  976. *************************** 275. row ***************************
  977. Variable_name: Prepared_stmt_count
  978. Value: 0
  979. *************************** 276. row ***************************
  980. Variable_name: Qcache_free_blocks
  981. Value: 1
  982. *************************** 277. row ***************************
  983. Variable_name: Qcache_free_memory
  984. Value: 201308616
  985. *************************** 278. row ***************************
  986. Variable_name: Qcache_hits
  987. Value: 0
  988. *************************** 279. row ***************************
  989. Variable_name: Qcache_inserts
  990. Value: 0
  991. *************************** 280. row ***************************
  992. Variable_name: Qcache_lowmem_prunes
  993. Value: 0
  994. *************************** 281. row ***************************
  995. Variable_name: Qcache_not_cached
  996. Value: 991333108
  997. *************************** 282. row ***************************
  998. Variable_name: Qcache_queries_in_cache
  999. Value: 0
  1000. *************************** 283. row ***************************
  1001. Variable_name: Qcache_total_blocks
  1002. Value: 1
  1003. *************************** 284. row ***************************
  1004. Variable_name: Queries
  1005. Value: 1356675214
  1006. *************************** 285. row ***************************
  1007. Variable_name: Questions
  1008. Value: 1116739310
  1009. *************************** 286. row ***************************
  1010. Variable_name: Select_full_join
  1011. Value: 9374444
  1012. *************************** 287. row ***************************
  1013. Variable_name: Select_full_range_join
  1014. Value: 1403795
  1015. *************************** 288. row ***************************
  1016. Variable_name: Select_range
  1017. Value: 80555255
  1018. *************************** 289. row ***************************
  1019. Variable_name: Select_range_check
  1020. Value: 12471
  1021. *************************** 290. row ***************************
  1022. Variable_name: Select_scan
  1023. Value: 240278122
  1024. *************************** 291. row ***************************
  1025. Variable_name: Slave_heartbeat_period
  1026. Value: 1800.000
  1027. *************************** 292. row ***************************
  1028. Variable_name: Slave_last_heartbeat
  1029. Value:
  1030. *************************** 293. row ***************************
  1031. Variable_name: Slave_open_temp_tables
  1032. Value: 0
  1033. *************************** 294. row ***************************
  1034. Variable_name: Slave_received_heartbeats
  1035. Value: 0
  1036. *************************** 295. row ***************************
  1037. Variable_name: Slave_retried_transactions
  1038. Value: 0
  1039. *************************** 296. row ***************************
  1040. Variable_name: Slave_running
  1041. Value: ON
  1042. *************************** 297. row ***************************
  1043. Variable_name: Slow_launch_threads
  1044. Value: 0
  1045. *************************** 298. row ***************************
  1046. Variable_name: Slow_queries
  1047. Value: 214492490
  1048. *************************** 299. row ***************************
  1049. Variable_name: Sort_merge_passes
  1050. Value: 10722
  1051. *************************** 300. row ***************************
  1052. Variable_name: Sort_range
  1053. Value: 137109489
  1054. *************************** 301. row ***************************
  1055. Variable_name: Sort_rows
  1056. Value: 20677341490
  1057. *************************** 302. row ***************************
  1058. Variable_name: Sort_scan
  1059. Value: 154602967
  1060. *************************** 303. row ***************************
  1061. Variable_name: Ssl_accept_renegotiates
  1062. Value: 0
  1063. *************************** 304. row ***************************
  1064. Variable_name: Ssl_accepts
  1065. Value: 0
  1066. *************************** 305. row ***************************
  1067. Variable_name: Ssl_callback_cache_hits
  1068. Value: 0
  1069. *************************** 306. row ***************************
  1070. Variable_name: Ssl_cipher
  1071. Value:
  1072. *************************** 307. row ***************************
  1073. Variable_name: Ssl_cipher_list
  1074. Value:
  1075. *************************** 308. row ***************************
  1076. Variable_name: Ssl_client_connects
  1077. Value: 0
  1078. *************************** 309. row ***************************
  1079. Variable_name: Ssl_connect_renegotiates
  1080. Value: 0
  1081. *************************** 310. row ***************************
  1082. Variable_name: Ssl_ctx_verify_depth
  1083. Value: 0
  1084. *************************** 311. row ***************************
  1085. Variable_name: Ssl_ctx_verify_mode
  1086. Value: 0
  1087. *************************** 312. row ***************************
  1088. Variable_name: Ssl_default_timeout
  1089. Value: 0
  1090. *************************** 313. row ***************************
  1091. Variable_name: Ssl_finished_accepts
  1092. Value: 0
  1093. *************************** 314. row ***************************
  1094. Variable_name: Ssl_finished_connects
  1095. Value: 0
  1096. *************************** 315. row ***************************
  1097. Variable_name: Ssl_server_not_after
  1098. Value:
  1099. *************************** 316. row ***************************
  1100. Variable_name: Ssl_server_not_before
  1101. Value:
  1102. *************************** 317. row ***************************
  1103. Variable_name: Ssl_session_cache_hits
  1104. Value: 0
  1105. *************************** 318. row ***************************
  1106. Variable_name: Ssl_session_cache_misses
  1107. Value: 0
  1108. *************************** 319. row ***************************
  1109. Variable_name: Ssl_session_cache_mode
  1110. Value: NONE
  1111. *************************** 320. row ***************************
  1112. Variable_name: Ssl_session_cache_overflows
  1113. Value: 0
  1114. *************************** 321. row ***************************
  1115. Variable_name: Ssl_session_cache_size
  1116. Value: 0
  1117. *************************** 322. row ***************************
  1118. Variable_name: Ssl_session_cache_timeouts
  1119. Value: 0
  1120. *************************** 323. row ***************************
  1121. Variable_name: Ssl_sessions_reused
  1122. Value: 0
  1123. *************************** 324. row ***************************
  1124. Variable_name: Ssl_used_session_cache_entries
  1125. Value: 0
  1126. *************************** 325. row ***************************
  1127. Variable_name: Ssl_verify_depth
  1128. Value: 0
  1129. *************************** 326. row ***************************
  1130. Variable_name: Ssl_verify_mode
  1131. Value: 0
  1132. *************************** 327. row ***************************
  1133. Variable_name: Ssl_version
  1134. Value:
  1135. *************************** 328. row ***************************
  1136. Variable_name: Table_locks_immediate
  1137. Value: 1763086518
  1138. *************************** 329. row ***************************
  1139. Variable_name: Table_locks_waited
  1140. Value: 9595
  1141. *************************** 330. row ***************************
  1142. Variable_name: Table_open_cache_hits
  1143. Value: 1484933399
  1144. *************************** 331. row ***************************
  1145. Variable_name: Table_open_cache_misses
  1146. Value: 280604315
  1147. *************************** 332. row ***************************
  1148. Variable_name: Table_open_cache_overflows
  1149. Value: 280587711
  1150. *************************** 333. row ***************************
  1151. Variable_name: Tc_log_max_pages_used
  1152. Value: 0
  1153. *************************** 334. row ***************************
  1154. Variable_name: Tc_log_page_size
  1155. Value: 0
  1156. *************************** 335. row ***************************
  1157. Variable_name: Tc_log_page_waits
  1158. Value: 0
  1159. *************************** 336. row ***************************
  1160. Variable_name: Threads_cached
  1161. Value: 93
  1162. *************************** 337. row ***************************
  1163. Variable_name: Threads_connected
  1164. Value: 5
  1165. *************************** 338. row ***************************
  1166. Variable_name: Threads_created
  1167. Value: 12463
  1168. *************************** 339. row ***************************
  1169. Variable_name: Threads_running
  1170. Value: 2
  1171. *************************** 340. row ***************************
  1172. Variable_name: Uptime
  1173. Value: 2280932
  1174. *************************** 341. row ***************************
  1175. Variable_name: Uptime_since_flush_status
  1176. Value: 2280932
  1177. 341 rows in set (0.01 sec)
  1178.  
  1179. mysql> SHOW GLOBAL VARIABLES\G;
  1180. *************************** 1. row ***************************
  1181. Variable_name: auto_increment_increment
  1182. Value: 1
  1183. *************************** 2. row ***************************
  1184. Variable_name: auto_increment_offset
  1185. Value: 1
  1186. *************************** 3. row ***************************
  1187. Variable_name: autocommit
  1188. Value: ON
  1189. *************************** 4. row ***************************
  1190. Variable_name: automatic_sp_privileges
  1191. Value: ON
  1192. *************************** 5. row ***************************
  1193. Variable_name: avoid_temporal_upgrade
  1194. Value: OFF
  1195. *************************** 6. row ***************************
  1196. Variable_name: back_log
  1197. Value: 664
  1198. *************************** 7. row ***************************
  1199. Variable_name: basedir
  1200. Value: /usr
  1201. *************************** 8. row ***************************
  1202. Variable_name: big_tables
  1203. Value: OFF
  1204. *************************** 9. row ***************************
  1205. Variable_name: bind_address
  1206. Value: *
  1207. *************************** 10. row ***************************
  1208. Variable_name: binlog_cache_size
  1209. Value: 32768
  1210. *************************** 11. row ***************************
  1211. Variable_name: binlog_checksum
  1212. Value: CRC32
  1213. *************************** 12. row ***************************
  1214. Variable_name: binlog_direct_non_transactional_updates
  1215. Value: OFF
  1216. *************************** 13. row ***************************
  1217. Variable_name: binlog_error_action
  1218. Value: IGNORE_ERROR
  1219. *************************** 14. row ***************************
  1220. Variable_name: binlog_format
  1221. Value: MIXED
  1222. *************************** 15. row ***************************
  1223. Variable_name: binlog_gtid_simple_recovery
  1224. Value: OFF
  1225. *************************** 16. row ***************************
  1226. Variable_name: binlog_max_flush_queue_time
  1227. Value: 0
  1228. *************************** 17. row ***************************
  1229. Variable_name: binlog_order_commits
  1230. Value: ON
  1231. *************************** 18. row ***************************
  1232. Variable_name: binlog_row_image
  1233. Value: FULL
  1234. *************************** 19. row ***************************
  1235. Variable_name: binlog_rows_query_log_events
  1236. Value: OFF
  1237. *************************** 20. row ***************************
  1238. Variable_name: binlog_stmt_cache_size
  1239. Value: 32768
  1240. *************************** 21. row ***************************
  1241. Variable_name: binlogging_impossible_mode
  1242. Value: IGNORE_ERROR
  1243. *************************** 22. row ***************************
  1244. Variable_name: block_encryption_mode
  1245. Value: aes-128-ecb
  1246. *************************** 23. row ***************************
  1247. Variable_name: bulk_insert_buffer_size
  1248. Value: 8388608
  1249. *************************** 24. row ***************************
  1250. Variable_name: character_set_client
  1251. Value: latin1
  1252. *************************** 25. row ***************************
  1253. Variable_name: character_set_connection
  1254. Value: latin1
  1255. *************************** 26. row ***************************
  1256. Variable_name: character_set_database
  1257. Value: latin1
  1258. *************************** 27. row ***************************
  1259. Variable_name: character_set_filesystem
  1260. Value: binary
  1261. *************************** 28. row ***************************
  1262. Variable_name: character_set_results
  1263. Value: latin1
  1264. *************************** 29. row ***************************
  1265. Variable_name: character_set_server
  1266. Value: latin1
  1267. *************************** 30. row ***************************
  1268. Variable_name: character_set_system
  1269. Value: utf8
  1270. *************************** 31. row ***************************
  1271. Variable_name: character_sets_dir
  1272. Value: /usr/share/mysql/charsets/
  1273. *************************** 32. row ***************************
  1274. Variable_name: collation_connection
  1275. Value: latin1_swedish_ci
  1276. *************************** 33. row ***************************
  1277. Variable_name: collation_database
  1278. Value: latin1_swedish_ci
  1279. *************************** 34. row ***************************
  1280. Variable_name: collation_server
  1281. Value: latin1_swedish_ci
  1282. *************************** 35. row ***************************
  1283. Variable_name: completion_type
  1284. Value: NO_CHAIN
  1285. *************************** 36. row ***************************
  1286. Variable_name: concurrent_insert
  1287. Value: AUTO
  1288. *************************** 37. row ***************************
  1289. Variable_name: connect_timeout
  1290. Value: 8
  1291. *************************** 38. row ***************************
  1292. Variable_name: core_file
  1293. Value: OFF
  1294. *************************** 39. row ***************************
  1295. Variable_name: datadir
  1296. Value: /var/lib/mysql/
  1297. *************************** 40. row ***************************
  1298. Variable_name: date_format
  1299. Value: %Y-%m-%d
  1300. *************************** 41. row ***************************
  1301. Variable_name: datetime_format
  1302. Value: %Y-%m-%d %H:%i:%s
  1303. *************************** 42. row ***************************
  1304. Variable_name: default_storage_engine
  1305. Value: InnoDB
  1306. *************************** 43. row ***************************
  1307. Variable_name: default_tmp_storage_engine
  1308. Value: InnoDB
  1309. *************************** 44. row ***************************
  1310. Variable_name: default_week_format
  1311. Value: 0
  1312. *************************** 45. row ***************************
  1313. Variable_name: delay_key_write
  1314. Value: ON
  1315. *************************** 46. row ***************************
  1316. Variable_name: delayed_insert_limit
  1317. Value: 100
  1318. *************************** 47. row ***************************
  1319. Variable_name: delayed_insert_timeout
  1320. Value: 8
  1321. *************************** 48. row ***************************
  1322. Variable_name: delayed_queue_size
  1323. Value: 1000
  1324. *************************** 49. row ***************************
  1325. Variable_name: disconnect_on_expired_password
  1326. Value: ON
  1327. *************************** 50. row ***************************
  1328. Variable_name: div_precision_increment
  1329. Value: 4
  1330. *************************** 51. row ***************************
  1331. Variable_name: end_markers_in_json
  1332. Value: OFF
  1333. *************************** 52. row ***************************
  1334. Variable_name: enforce_gtid_consistency
  1335. Value: OFF
  1336. *************************** 53. row ***************************
  1337. Variable_name: eq_range_index_dive_limit
  1338. Value: 10
  1339. *************************** 54. row ***************************
  1340. Variable_name: event_scheduler
  1341. Value: OFF
  1342. *************************** 55. row ***************************
  1343. Variable_name: expire_logs_days
  1344. Value: 5
  1345. *************************** 56. row ***************************
  1346. Variable_name: explicit_defaults_for_timestamp
  1347. Value: ON
  1348. *************************** 57. row ***************************
  1349. Variable_name: flush
  1350. Value: OFF
  1351. *************************** 58. row ***************************
  1352. Variable_name: flush_time
  1353. Value: 0
  1354. *************************** 59. row ***************************
  1355. Variable_name: foreign_key_checks
  1356. Value: ON
  1357. *************************** 60. row ***************************
  1358. Variable_name: ft_boolean_syntax
  1359. Value: + -><()~*:""&|
  1360. *************************** 61. row ***************************
  1361. Variable_name: ft_max_word_len
  1362. Value: 84
  1363. *************************** 62. row ***************************
  1364. Variable_name: ft_min_word_len
  1365. Value: 4
  1366. *************************** 63. row ***************************
  1367. Variable_name: ft_query_expansion_limit
  1368. Value: 20
  1369. *************************** 64. row ***************************
  1370. Variable_name: ft_stopword_file
  1371. Value: (built-in)
  1372. *************************** 65. row ***************************
  1373. Variable_name: general_log
  1374. Value: OFF
  1375. *************************** 66. row ***************************
  1376. Variable_name: general_log_file
  1377. Value: /var/lib/mysql/vm4521.log
  1378. *************************** 67. row ***************************
  1379. Variable_name: group_concat_max_len
  1380. Value: 1024
  1381. *************************** 68. row ***************************
  1382. Variable_name: gtid_executed
  1383. Value:
  1384. *************************** 69. row ***************************
  1385. Variable_name: gtid_mode
  1386. Value: OFF
  1387. *************************** 70. row ***************************
  1388. Variable_name: gtid_owned
  1389. Value:
  1390. *************************** 71. row ***************************
  1391. Variable_name: gtid_purged
  1392. Value:
  1393. *************************** 72. row ***************************
  1394. Variable_name: have_compress
  1395. Value: YES
  1396. *************************** 73. row ***************************
  1397. Variable_name: have_crypt
  1398. Value: YES
  1399. *************************** 74. row ***************************
  1400. Variable_name: have_dynamic_loading
  1401. Value: YES
  1402. *************************** 75. row ***************************
  1403. Variable_name: have_geometry
  1404. Value: YES
  1405. *************************** 76. row ***************************
  1406. Variable_name: have_openssl
  1407. Value: DISABLED
  1408. *************************** 77. row ***************************
  1409. Variable_name: have_profiling
  1410. Value: YES
  1411. *************************** 78. row ***************************
  1412. Variable_name: have_query_cache
  1413. Value: YES
  1414. *************************** 79. row ***************************
  1415. Variable_name: have_rtree_keys
  1416. Value: YES
  1417. *************************** 80. row ***************************
  1418. Variable_name: have_ssl
  1419. Value: DISABLED
  1420. *************************** 81. row ***************************
  1421. Variable_name: have_symlink
  1422. Value: DISABLED
  1423. *************************** 82. row ***************************
  1424. Variable_name: host_cache_size
  1425. Value: 756
  1426. *************************** 83. row ***************************
  1427. Variable_name: hostname
  1428. Value: vm4521.cloud.seeweb.it
  1429. *************************** 84. row ***************************
  1430. Variable_name: ignore_builtin_innodb
  1431. Value: OFF
  1432. *************************** 85. row ***************************
  1433. Variable_name: ignore_db_dirs
  1434. Value: lost+found
  1435. *************************** 86. row ***************************
  1436. Variable_name: init_connect
  1437. Value:
  1438. *************************** 87. row ***************************
  1439. Variable_name: init_file
  1440. Value:
  1441. *************************** 88. row ***************************
  1442. Variable_name: init_slave
  1443. Value:
  1444. *************************** 89. row ***************************
  1445. Variable_name: innodb_adaptive_flushing
  1446. Value: ON
  1447. *************************** 90. row ***************************
  1448. Variable_name: innodb_adaptive_flushing_lwm
  1449. Value: 10
  1450. *************************** 91. row ***************************
  1451. Variable_name: innodb_adaptive_hash_index
  1452. Value: ON
  1453. *************************** 92. row ***************************
  1454. Variable_name: innodb_adaptive_max_sleep_delay
  1455. Value: 150000
  1456. *************************** 93. row ***************************
  1457. Variable_name: innodb_additional_mem_pool_size
  1458. Value: 8388608
  1459. *************************** 94. row ***************************
  1460. Variable_name: innodb_api_bk_commit_interval
  1461. Value: 5
  1462. *************************** 95. row ***************************
  1463. Variable_name: innodb_api_disable_rowlock
  1464. Value: OFF
  1465. *************************** 96. row ***************************
  1466. Variable_name: innodb_api_enable_binlog
  1467. Value: OFF
  1468. *************************** 97. row ***************************
  1469. Variable_name: innodb_api_enable_mdl
  1470. Value: OFF
  1471. *************************** 98. row ***************************
  1472. Variable_name: innodb_api_trx_level
  1473. Value: 0
  1474. *************************** 99. row ***************************
  1475. Variable_name: innodb_autoextend_increment
  1476. Value: 64
  1477. *************************** 100. row ***************************
  1478. Variable_name: innodb_autoinc_lock_mode
  1479. Value: 1
  1480. *************************** 101. row ***************************
  1481. Variable_name: innodb_buffer_pool_dump_at_shutdown
  1482. Value: OFF
  1483. *************************** 102. row ***************************
  1484. Variable_name: innodb_buffer_pool_dump_now
  1485. Value: OFF
  1486. *************************** 103. row ***************************
  1487. Variable_name: innodb_buffer_pool_filename
  1488. Value: ib_buffer_pool
  1489. *************************** 104. row ***************************
  1490. Variable_name: innodb_buffer_pool_instances
  1491. Value: 8
  1492. *************************** 105. row ***************************
  1493. Variable_name: innodb_buffer_pool_load_abort
  1494. Value: OFF
  1495. *************************** 106. row ***************************
  1496. Variable_name: innodb_buffer_pool_load_at_startup
  1497. Value: OFF
  1498. *************************** 107. row ***************************
  1499. Variable_name: innodb_buffer_pool_load_now
  1500. Value: OFF
  1501. *************************** 108. row ***************************
  1502. Variable_name: innodb_buffer_pool_size
  1503. Value: 25769803776
  1504. *************************** 109. row ***************************
  1505. Variable_name: innodb_change_buffer_max_size
  1506. Value: 25
  1507. *************************** 110. row ***************************
  1508. Variable_name: innodb_change_buffering
  1509. Value: all
  1510. *************************** 111. row ***************************
  1511. Variable_name: innodb_checksum_algorithm
  1512. Value: innodb
  1513. *************************** 112. row ***************************
  1514. Variable_name: innodb_checksums
  1515. Value: ON
  1516. *************************** 113. row ***************************
  1517. Variable_name: innodb_cmp_per_index_enabled
  1518. Value: OFF
  1519. *************************** 114. row ***************************
  1520. Variable_name: innodb_commit_concurrency
  1521. Value: 0
  1522. *************************** 115. row ***************************
  1523. Variable_name: innodb_compression_failure_threshold_pct
  1524. Value: 5
  1525. *************************** 116. row ***************************
  1526. Variable_name: innodb_compression_level
  1527. Value: 6
  1528. *************************** 117. row ***************************
  1529. Variable_name: innodb_compression_pad_pct_max
  1530. Value: 50
  1531. *************************** 118. row ***************************
  1532. Variable_name: innodb_concurrency_tickets
  1533. Value: 5000
  1534. *************************** 119. row ***************************
  1535. Variable_name: innodb_data_file_path
  1536. Value: ibdata1:12M:autoextend
  1537. *************************** 120. row ***************************
  1538. Variable_name: innodb_data_home_dir
  1539. Value:
  1540. *************************** 121. row ***************************
  1541. Variable_name: innodb_disable_sort_file_cache
  1542. Value: OFF
  1543. *************************** 122. row ***************************
  1544. Variable_name: innodb_doublewrite
  1545. Value: ON
  1546. *************************** 123. row ***************************
  1547. Variable_name: innodb_fast_shutdown
  1548. Value: 1
  1549. *************************** 124. row ***************************
  1550. Variable_name: innodb_file_format
  1551. Value: Antelope
  1552. *************************** 125. row ***************************
  1553. Variable_name: innodb_file_format_check
  1554. Value: ON
  1555. *************************** 126. row ***************************
  1556. Variable_name: innodb_file_format_max
  1557. Value: Antelope
  1558. *************************** 127. row ***************************
  1559. Variable_name: innodb_file_per_table
  1560. Value: ON
  1561. *************************** 128. row ***************************
  1562. Variable_name: innodb_flush_log_at_timeout
  1563. Value: 1
  1564. *************************** 129. row ***************************
  1565. Variable_name: innodb_flush_log_at_trx_commit
  1566. Value: 1
  1567. *************************** 130. row ***************************
  1568. Variable_name: innodb_flush_method
  1569. Value: O_DIRECT
  1570. *************************** 131. row ***************************
  1571. Variable_name: innodb_flush_neighbors
  1572. Value: 1
  1573. *************************** 132. row ***************************
  1574. Variable_name: innodb_flushing_avg_loops
  1575. Value: 30
  1576. *************************** 133. row ***************************
  1577. Variable_name: innodb_force_load_corrupted
  1578. Value: OFF
  1579. *************************** 134. row ***************************
  1580. Variable_name: innodb_force_recovery
  1581. Value: 0
  1582. *************************** 135. row ***************************
  1583. Variable_name: innodb_ft_aux_table
  1584. Value:
  1585. *************************** 136. row ***************************
  1586. Variable_name: innodb_ft_cache_size
  1587. Value: 8000000
  1588. *************************** 137. row ***************************
  1589. Variable_name: innodb_ft_enable_diag_print
  1590. Value: OFF
  1591. *************************** 138. row ***************************
  1592. Variable_name: innodb_ft_enable_stopword
  1593. Value: ON
  1594. *************************** 139. row ***************************
  1595. Variable_name: innodb_ft_max_token_size
  1596. Value: 84
  1597. *************************** 140. row ***************************
  1598. Variable_name: innodb_ft_min_token_size
  1599. Value: 3
  1600. *************************** 141. row ***************************
  1601. Variable_name: innodb_ft_num_word_optimize
  1602. Value: 2000
  1603. *************************** 142. row ***************************
  1604. Variable_name: innodb_ft_result_cache_limit
  1605. Value: 2000000000
  1606. *************************** 143. row ***************************
  1607. Variable_name: innodb_ft_server_stopword_table
  1608. Value:
  1609. *************************** 144. row ***************************
  1610. Variable_name: innodb_ft_sort_pll_degree
  1611. Value: 2
  1612. *************************** 145. row ***************************
  1613. Variable_name: innodb_ft_total_cache_size
  1614. Value: 640000000
  1615. *************************** 146. row ***************************
  1616. Variable_name: innodb_ft_user_stopword_table
  1617. Value:
  1618. *************************** 147. row ***************************
  1619. Variable_name: innodb_io_capacity
  1620. Value: 200
  1621. *************************** 148. row ***************************
  1622. Variable_name: innodb_io_capacity_max
  1623. Value: 2000
  1624. *************************** 149. row ***************************
  1625. Variable_name: innodb_large_prefix
  1626. Value: OFF
  1627. *************************** 150. row ***************************
  1628. Variable_name: innodb_lock_wait_timeout
  1629. Value: 120
  1630. *************************** 151. row ***************************
  1631. Variable_name: innodb_locks_unsafe_for_binlog
  1632. Value: OFF
  1633. *************************** 152. row ***************************
  1634. Variable_name: innodb_log_buffer_size
  1635. Value: 134217728
  1636. *************************** 153. row ***************************
  1637. Variable_name: innodb_log_compressed_pages
  1638. Value: ON
  1639. *************************** 154. row ***************************
  1640. Variable_name: innodb_log_file_size
  1641. Value: 268435456
  1642. *************************** 155. row ***************************
  1643. Variable_name: innodb_log_files_in_group
  1644. Value: 2
  1645. *************************** 156. row ***************************
  1646. Variable_name: innodb_log_group_home_dir
  1647. Value: ./
  1648. *************************** 157. row ***************************
  1649. Variable_name: innodb_lru_scan_depth
  1650. Value: 1024
  1651. *************************** 158. row ***************************
  1652. Variable_name: innodb_max_dirty_pages_pct
  1653. Value: 75
  1654. *************************** 159. row ***************************
  1655. Variable_name: innodb_max_dirty_pages_pct_lwm
  1656. Value: 0
  1657. *************************** 160. row ***************************
  1658. Variable_name: innodb_max_purge_lag
  1659. Value: 0
  1660. *************************** 161. row ***************************
  1661. Variable_name: innodb_max_purge_lag_delay
  1662. Value: 0
  1663. *************************** 162. row ***************************
  1664. Variable_name: innodb_mirrored_log_groups
  1665. Value: 1
  1666. *************************** 163. row ***************************
  1667. Variable_name: innodb_monitor_disable
  1668. Value:
  1669. *************************** 164. row ***************************
  1670. Variable_name: innodb_monitor_enable
  1671. Value:
  1672. *************************** 165. row ***************************
  1673. Variable_name: innodb_monitor_reset
  1674. Value:
  1675. *************************** 166. row ***************************
  1676. Variable_name: innodb_monitor_reset_all
  1677. Value:
  1678. *************************** 167. row ***************************
  1679. Variable_name: innodb_old_blocks_pct
  1680. Value: 37
  1681. *************************** 168. row ***************************
  1682. Variable_name: innodb_old_blocks_time
  1683. Value: 1000
  1684. *************************** 169. row ***************************
  1685. Variable_name: innodb_online_alter_log_max_size
  1686. Value: 134217728
  1687. *************************** 170. row ***************************
  1688. Variable_name: innodb_open_files
  1689. Value: 2000
  1690. *************************** 171. row ***************************
  1691. Variable_name: innodb_optimize_fulltext_only
  1692. Value: OFF
  1693. *************************** 172. row ***************************
  1694. Variable_name: innodb_page_size
  1695. Value: 16384
  1696. *************************** 173. row ***************************
  1697. Variable_name: innodb_print_all_deadlocks
  1698. Value: OFF
  1699. *************************** 174. row ***************************
  1700. Variable_name: innodb_purge_batch_size
  1701. Value: 300
  1702. *************************** 175. row ***************************
  1703. Variable_name: innodb_purge_threads
  1704. Value: 1
  1705. *************************** 176. row ***************************
  1706. Variable_name: innodb_random_read_ahead
  1707. Value: OFF
  1708. *************************** 177. row ***************************
  1709. Variable_name: innodb_read_ahead_threshold
  1710. Value: 56
  1711. *************************** 178. row ***************************
  1712. Variable_name: innodb_read_io_threads
  1713. Value: 4
  1714. *************************** 179. row ***************************
  1715. Variable_name: innodb_read_only
  1716. Value: OFF
  1717. *************************** 180. row ***************************
  1718. Variable_name: innodb_replication_delay
  1719. Value: 0
  1720. *************************** 181. row ***************************
  1721. Variable_name: innodb_rollback_on_timeout
  1722. Value: OFF
  1723. *************************** 182. row ***************************
  1724. Variable_name: innodb_rollback_segments
  1725. Value: 128
  1726. *************************** 183. row ***************************
  1727. Variable_name: innodb_sort_buffer_size
  1728. Value: 1048576
  1729. *************************** 184. row ***************************
  1730. Variable_name: innodb_spin_wait_delay
  1731. Value: 6
  1732. *************************** 185. row ***************************
  1733. Variable_name: innodb_stats_auto_recalc
  1734. Value: ON
  1735. *************************** 186. row ***************************
  1736. Variable_name: innodb_stats_method
  1737. Value: nulls_equal
  1738. *************************** 187. row ***************************
  1739. Variable_name: innodb_stats_on_metadata
  1740. Value: OFF
  1741. *************************** 188. row ***************************
  1742. Variable_name: innodb_stats_persistent
  1743. Value: ON
  1744. *************************** 189. row ***************************
  1745. Variable_name: innodb_stats_persistent_sample_pages
  1746. Value: 20
  1747. *************************** 190. row ***************************
  1748. Variable_name: innodb_stats_sample_pages
  1749. Value: 8
  1750. *************************** 191. row ***************************
  1751. Variable_name: innodb_stats_transient_sample_pages
  1752. Value: 8
  1753. *************************** 192. row ***************************
  1754. Variable_name: innodb_status_output
  1755. Value: OFF
  1756. *************************** 193. row ***************************
  1757. Variable_name: innodb_status_output_locks
  1758. Value: OFF
  1759. *************************** 194. row ***************************
  1760. Variable_name: innodb_strict_mode
  1761. Value: OFF
  1762. *************************** 195. row ***************************
  1763. Variable_name: innodb_support_xa
  1764. Value: ON
  1765. *************************** 196. row ***************************
  1766. Variable_name: innodb_sync_array_size
  1767. Value: 1
  1768. *************************** 197. row ***************************
  1769. Variable_name: innodb_sync_spin_loops
  1770. Value: 30
  1771. *************************** 198. row ***************************
  1772. Variable_name: innodb_table_locks
  1773. Value: ON
  1774. *************************** 199. row ***************************
  1775. Variable_name: innodb_thread_concurrency
  1776. Value: 0
  1777. *************************** 200. row ***************************
  1778. Variable_name: innodb_thread_sleep_delay
  1779. Value: 10000
  1780. *************************** 201. row ***************************
  1781. Variable_name: innodb_undo_directory
  1782. Value: .
  1783. *************************** 202. row ***************************
  1784. Variable_name: innodb_undo_logs
  1785. Value: 128
  1786. *************************** 203. row ***************************
  1787. Variable_name: innodb_undo_tablespaces
  1788. Value: 0
  1789. *************************** 204. row ***************************
  1790. Variable_name: innodb_use_native_aio
  1791. Value: ON
  1792. *************************** 205. row ***************************
  1793. Variable_name: innodb_use_sys_malloc
  1794. Value: ON
  1795. *************************** 206. row ***************************
  1796. Variable_name: innodb_version
  1797. Value: 5.6.26
  1798. *************************** 207. row ***************************
  1799. Variable_name: innodb_write_io_threads
  1800. Value: 4
  1801. *************************** 208. row ***************************
  1802. Variable_name: interactive_timeout
  1803. Value: 720
  1804. *************************** 209. row ***************************
  1805. Variable_name: join_buffer_size
  1806. Value: 33554432
  1807. *************************** 210. row ***************************
  1808. Variable_name: keep_files_on_create
  1809. Value: OFF
  1810. *************************** 211. row ***************************
  1811. Variable_name: key_buffer_size
  1812. Value: 1073741824
  1813. *************************** 212. row ***************************
  1814. Variable_name: key_cache_age_threshold
  1815. Value: 300
  1816. *************************** 213. row ***************************
  1817. Variable_name: key_cache_block_size
  1818. Value: 1024
  1819. *************************** 214. row ***************************
  1820. Variable_name: key_cache_division_limit
  1821. Value: 100
  1822. *************************** 215. row ***************************
  1823. Variable_name: large_files_support
  1824. Value: ON
  1825. *************************** 216. row ***************************
  1826. Variable_name: large_page_size
  1827. Value: 0
  1828. *************************** 217. row ***************************
  1829. Variable_name: large_pages
  1830. Value: OFF
  1831. *************************** 218. row ***************************
  1832. Variable_name: lc_messages
  1833. Value: en_US
  1834. *************************** 219. row ***************************
  1835. Variable_name: lc_messages_dir
  1836. Value: /usr/share/mysql/
  1837. *************************** 220. row ***************************
  1838. Variable_name: lc_time_names
  1839. Value: en_US
  1840. *************************** 221. row ***************************
  1841. Variable_name: license
  1842. Value: GPL
  1843. *************************** 222. row ***************************
  1844. Variable_name: local_infile
  1845. Value: ON
  1846. *************************** 223. row ***************************
  1847. Variable_name: lock_wait_timeout
  1848. Value: 31536000
  1849. *************************** 224. row ***************************
  1850. Variable_name: locked_in_memory
  1851. Value: OFF
  1852. *************************** 225. row ***************************
  1853. Variable_name: log_bin
  1854. Value: ON
  1855. *************************** 226. row ***************************
  1856. Variable_name: log_bin_basename
  1857. Value: /var/lib/mysql/mysql-bin
  1858. *************************** 227. row ***************************
  1859. Variable_name: log_bin_index
  1860. Value: /var/lib/mysql/mysql-bin.index
  1861. *************************** 228. row ***************************
  1862. Variable_name: log_bin_trust_function_creators
  1863. Value: OFF
  1864. *************************** 229. row ***************************
  1865. Variable_name: log_bin_use_v1_row_events
  1866. Value: OFF
  1867. *************************** 230. row ***************************
  1868. Variable_name: log_error
  1869. Value: /var/log/mysql/error.log
  1870. *************************** 231. row ***************************
  1871. Variable_name: log_output
  1872. Value: FILE
  1873. *************************** 232. row ***************************
  1874. Variable_name: log_queries_not_using_indexes
  1875. Value: ON
  1876. *************************** 233. row ***************************
  1877. Variable_name: log_slave_updates
  1878. Value: OFF
  1879. *************************** 234. row ***************************
  1880. Variable_name: log_slow_admin_statements
  1881. Value: OFF
  1882. *************************** 235. row ***************************
  1883. Variable_name: log_slow_slave_statements
  1884. Value: OFF
  1885. *************************** 236. row ***************************
  1886. Variable_name: log_throttle_queries_not_using_indexes
  1887. Value: 0
  1888. *************************** 237. row ***************************
  1889. Variable_name: log_warnings
  1890. Value: 1
  1891. *************************** 238. row ***************************
  1892. Variable_name: long_query_time
  1893. Value: 10.000000
  1894. *************************** 239. row ***************************
  1895. Variable_name: low_priority_updates
  1896. Value: OFF
  1897. *************************** 240. row ***************************
  1898. Variable_name: lower_case_file_system
  1899. Value: OFF
  1900. *************************** 241. row ***************************
  1901. Variable_name: lower_case_table_names
  1902. Value: 0
  1903. *************************** 242. row ***************************
  1904. Variable_name: master_info_repository
  1905. Value: FILE
  1906. *************************** 243. row ***************************
  1907. Variable_name: master_verify_checksum
  1908. Value: OFF
  1909. *************************** 244. row ***************************
  1910. Variable_name: max_allowed_packet
  1911. Value: 4194304
  1912. *************************** 245. row ***************************
  1913. Variable_name: max_binlog_cache_size
  1914. Value: 18446744073709547520
  1915. *************************** 246. row ***************************
  1916. Variable_name: max_binlog_size
  1917. Value: 1073741824
  1918. *************************** 247. row ***************************
  1919. Variable_name: max_binlog_stmt_cache_size
  1920. Value: 18446744073709547520
  1921. *************************** 248. row ***************************
  1922. Variable_name: max_connect_errors
  1923. Value: 100
  1924. *************************** 249. row ***************************
  1925. Variable_name: max_connections
  1926. Value: 3072
  1927. *************************** 250. row ***************************
  1928. Variable_name: max_delayed_threads
  1929. Value: 20
  1930. *************************** 251. row ***************************
  1931. Variable_name: max_digest_length
  1932. Value: 1024
  1933. *************************** 252. row ***************************
  1934. Variable_name: max_error_count
  1935. Value: 64
  1936. *************************** 253. row ***************************
  1937. Variable_name: max_heap_table_size
  1938. Value: 201326592
  1939. *************************** 254. row ***************************
  1940. Variable_name: max_insert_delayed_threads
  1941. Value: 20
  1942. *************************** 255. row ***************************
  1943. Variable_name: max_join_size
  1944. Value: 18446744073709551615
  1945. *************************** 256. row ***************************
  1946. Variable_name: max_length_for_sort_data
  1947. Value: 1024
  1948. *************************** 257. row ***************************
  1949. Variable_name: max_prepared_stmt_count
  1950. Value: 16382
  1951. *************************** 258. row ***************************
  1952. Variable_name: max_relay_log_size
  1953. Value: 0
  1954. *************************** 259. row ***************************
  1955. Variable_name: max_seeks_for_key
  1956. Value: 18446744073709551615
  1957. *************************** 260. row ***************************
  1958. Variable_name: max_sort_length
  1959. Value: 1024
  1960. *************************** 261. row ***************************
  1961. Variable_name: max_sp_recursion_depth
  1962. Value: 0
  1963. *************************** 262. row ***************************
  1964. Variable_name: max_tmp_tables
  1965. Value: 32
  1966. *************************** 263. row ***************************
  1967. Variable_name: max_user_connections
  1968. Value: 3072
  1969. *************************** 264. row ***************************
  1970. Variable_name: max_write_lock_count
  1971. Value: 18446744073709551615
  1972. *************************** 265. row ***************************
  1973. Variable_name: metadata_locks_cache_size
  1974. Value: 1024
  1975. *************************** 266. row ***************************
  1976. Variable_name: metadata_locks_hash_instances
  1977. Value: 8
  1978. *************************** 267. row ***************************
  1979. Variable_name: min_examined_row_limit
  1980. Value: 0
  1981. *************************** 268. row ***************************
  1982. Variable_name: multi_range_count
  1983. Value: 256
  1984. *************************** 269. row ***************************
  1985. Variable_name: myisam_data_pointer_size
  1986. Value: 6
  1987. *************************** 270. row ***************************
  1988. Variable_name: myisam_max_sort_file_size
  1989. Value: 9223372036853727232
  1990. *************************** 271. row ***************************
  1991. Variable_name: myisam_mmap_size
  1992. Value: 18446744073709551615
  1993. *************************** 272. row ***************************
  1994. Variable_name: myisam_recover_options
  1995. Value: OFF
  1996. *************************** 273. row ***************************
  1997. Variable_name: myisam_repair_threads
  1998. Value: 1
  1999. *************************** 274. row ***************************
  2000. Variable_name: myisam_sort_buffer_size
  2001. Value: 8388608
  2002. *************************** 275. row ***************************
  2003. Variable_name: myisam_stats_method
  2004. Value: nulls_unequal
  2005. *************************** 276. row ***************************
  2006. Variable_name: myisam_use_mmap
  2007. Value: OFF
  2008. *************************** 277. row ***************************
  2009. Variable_name: net_buffer_length
  2010. Value: 262144
  2011. *************************** 278. row ***************************
  2012. Variable_name: net_read_timeout
  2013. Value: 30
  2014. *************************** 279. row ***************************
  2015. Variable_name: net_retry_count
  2016. Value: 10
  2017. *************************** 280. row ***************************
  2018. Variable_name: net_write_timeout
  2019. Value: 60
  2020. *************************** 281. row ***************************
  2021. Variable_name: new
  2022. Value: OFF
  2023. *************************** 282. row ***************************
  2024. Variable_name: old
  2025. Value: OFF
  2026. *************************** 283. row ***************************
  2027. Variable_name: old_alter_table
  2028. Value: OFF
  2029. *************************** 284. row ***************************
  2030. Variable_name: old_passwords
  2031. Value: 0
  2032. *************************** 285. row ***************************
  2033. Variable_name: open_files_limit
  2034. Value: 1024000
  2035. *************************** 286. row ***************************
  2036. Variable_name: optimizer_prune_level
  2037. Value: 1
  2038. *************************** 287. row ***************************
  2039. Variable_name: optimizer_search_depth
  2040. Value: 62
  2041. *************************** 288. row ***************************
  2042. Variable_name: optimizer_switch
  2043. Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
  2044. *************************** 289. row ***************************
  2045. Variable_name: optimizer_trace
  2046. Value: enabled=off,one_line=off
  2047. *************************** 290. row ***************************
  2048. Variable_name: optimizer_trace_features
  2049. Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  2050. *************************** 291. row ***************************
  2051. Variable_name: optimizer_trace_limit
  2052. Value: 1
  2053. *************************** 292. row ***************************
  2054. Variable_name: optimizer_trace_max_mem_size
  2055. Value: 16384
  2056. *************************** 293. row ***************************
  2057. Variable_name: optimizer_trace_offset
  2058. Value: -1
  2059. *************************** 294. row ***************************
  2060. Variable_name: performance_schema
  2061. Value: ON
  2062. *************************** 295. row ***************************
  2063. Variable_name: performance_schema_accounts_size
  2064. Value: 100
  2065. *************************** 296. row ***************************
  2066. Variable_name: performance_schema_digests_size
  2067. Value: 10000
  2068. *************************** 297. row ***************************
  2069. Variable_name: performance_schema_events_stages_history_long_size
  2070. Value: 10000
  2071. *************************** 298. row ***************************
  2072. Variable_name: performance_schema_events_stages_history_size
  2073. Value: 10
  2074. *************************** 299. row ***************************
  2075. Variable_name: performance_schema_events_statements_history_long_size
  2076. Value: 10000
  2077. *************************** 300. row ***************************
  2078. Variable_name: performance_schema_events_statements_history_size
  2079. Value: 10
  2080. *************************** 301. row ***************************
  2081. Variable_name: performance_schema_events_waits_history_long_size
  2082. Value: 10000
  2083. *************************** 302. row ***************************
  2084. Variable_name: performance_schema_events_waits_history_size
  2085. Value: 10
  2086. *************************** 303. row ***************************
  2087. Variable_name: performance_schema_hosts_size
  2088. Value: 100
  2089. *************************** 304. row ***************************
  2090. Variable_name: performance_schema_max_cond_classes
  2091. Value: 80
  2092. *************************** 305. row ***************************
  2093. Variable_name: performance_schema_max_cond_instances
  2094. Value: 15188
  2095. *************************** 306. row ***************************
  2096. Variable_name: performance_schema_max_digest_length
  2097. Value: 1024
  2098. *************************** 307. row ***************************
  2099. Variable_name: performance_schema_max_file_classes
  2100. Value: 50
  2101. *************************** 308. row ***************************
  2102. Variable_name: performance_schema_max_file_handles
  2103. Value: 32768
  2104. *************************** 309. row ***************************
  2105. Variable_name: performance_schema_max_file_instances
  2106. Value: 31508
  2107. *************************** 310. row ***************************
  2108. Variable_name: performance_schema_max_mutex_classes
  2109. Value: 200
  2110. *************************** 311. row ***************************
  2111. Variable_name: performance_schema_max_mutex_instances
  2112. Value: 33432
  2113. *************************** 312. row ***************************
  2114. Variable_name: performance_schema_max_rwlock_classes
  2115. Value: 40
  2116. *************************** 313. row ***************************
  2117. Variable_name: performance_schema_max_rwlock_instances
  2118. Value: 14944
  2119. *************************** 314. row ***************************
  2120. Variable_name: performance_schema_max_socket_classes
  2121. Value: 10
  2122. *************************** 315. row ***************************
  2123. Variable_name: performance_schema_max_socket_instances
  2124. Value: 6164
  2125. *************************** 316. row ***************************
  2126. Variable_name: performance_schema_max_stage_classes
  2127. Value: 150
  2128. *************************** 317. row ***************************
  2129. Variable_name: performance_schema_max_statement_classes
  2130. Value: 168
  2131. *************************** 318. row ***************************
  2132. Variable_name: performance_schema_max_table_handles
  2133. Value: 4000
  2134. *************************** 319. row ***************************
  2135. Variable_name: performance_schema_max_table_instances
  2136. Value: 12500
  2137. *************************** 320. row ***************************
  2138. Variable_name: performance_schema_max_thread_classes
  2139. Value: 50
  2140. *************************** 321. row ***************************
  2141. Variable_name: performance_schema_max_thread_instances
  2142. Value: 6244
  2143. *************************** 322. row ***************************
  2144. Variable_name: performance_schema_session_connect_attrs_size
  2145. Value: 512
  2146. *************************** 323. row ***************************
  2147. Variable_name: performance_schema_setup_actors_size
  2148. Value: 100
  2149. *************************** 324. row ***************************
  2150. Variable_name: performance_schema_setup_objects_size
  2151. Value: 100
  2152. *************************** 325. row ***************************
  2153. Variable_name: performance_schema_users_size
  2154. Value: 100
  2155. *************************** 326. row ***************************
  2156. Variable_name: pid_file
  2157. Value: /var/run/mysqld/mysqld.pid
  2158. *************************** 327. row ***************************
  2159. Variable_name: plugin_dir
  2160. Value: /usr/lib/mysql/plugin/
  2161. *************************** 328. row ***************************
  2162. Variable_name: port
  2163. Value: 3306
  2164. *************************** 329. row ***************************
  2165. Variable_name: preload_buffer_size
  2166. Value: 32768
  2167. *************************** 330. row ***************************
  2168. Variable_name: profiling
  2169. Value: OFF
  2170. *************************** 331. row ***************************
  2171. Variable_name: profiling_history_size
  2172. Value: 15
  2173. *************************** 332. row ***************************
  2174. Variable_name: protocol_version
  2175. Value: 10
  2176. *************************** 333. row ***************************
  2177. Variable_name: query_alloc_block_size
  2178. Value: 8192
  2179. *************************** 334. row ***************************
  2180. Variable_name: query_cache_limit
  2181. Value: 2097152
  2182. *************************** 335. row ***************************
  2183. Variable_name: query_cache_min_res_unit
  2184. Value: 4096
  2185. *************************** 336. row ***************************
  2186. Variable_name: query_cache_size
  2187. Value: 201326592
  2188. *************************** 337. row ***************************
  2189. Variable_name: query_cache_type
  2190. Value: OFF
  2191. *************************** 338. row ***************************
  2192. Variable_name: query_cache_wlock_invalidate
  2193. Value: OFF
  2194. *************************** 339. row ***************************
  2195. Variable_name: query_prealloc_size
  2196. Value: 8192
  2197. *************************** 340. row ***************************
  2198. Variable_name: range_alloc_block_size
  2199. Value: 4096
  2200. *************************** 341. row ***************************
  2201. Variable_name: read_buffer_size
  2202. Value: 2097152
  2203. *************************** 342. row ***************************
  2204. Variable_name: read_only
  2205. Value: ON
  2206. *************************** 343. row ***************************
  2207. Variable_name: read_rnd_buffer_size
  2208. Value: 2097152
  2209. *************************** 344. row ***************************
  2210. Variable_name: relay_log
  2211. Value:
  2212. *************************** 345. row ***************************
  2213. Variable_name: relay_log_basename
  2214. Value:
  2215. *************************** 346. row ***************************
  2216. Variable_name: relay_log_index
  2217. Value:
  2218. *************************** 347. row ***************************
  2219. Variable_name: relay_log_info_file
  2220. Value: relay-log.info
  2221. *************************** 348. row ***************************
  2222. Variable_name: relay_log_info_repository
  2223. Value: FILE
  2224. *************************** 349. row ***************************
  2225. Variable_name: relay_log_purge
  2226. Value: ON
  2227. *************************** 350. row ***************************
  2228. Variable_name: relay_log_recovery
  2229. Value: OFF
  2230. *************************** 351. row ***************************
  2231. Variable_name: relay_log_space_limit
  2232. Value: 0
  2233. *************************** 352. row ***************************
  2234. Variable_name: report_host
  2235. Value:
  2236. *************************** 353. row ***************************
  2237. Variable_name: report_password
  2238. Value:
  2239. *************************** 354. row ***************************
  2240. Variable_name: report_port
  2241. Value: 3306
  2242. *************************** 355. row ***************************
  2243. Variable_name: report_user
  2244. Value:
  2245. *************************** 356. row ***************************
  2246. Variable_name: rpl_stop_slave_timeout
  2247. Value: 31536000
  2248. *************************** 357. row ***************************
  2249. Variable_name: secure_auth
  2250. Value: ON
  2251. *************************** 358. row ***************************
  2252. Variable_name: secure_file_priv
  2253. Value:
  2254. *************************** 359. row ***************************
  2255. Variable_name: server_id
  2256. Value: 1
  2257. *************************** 360. row ***************************
  2258. Variable_name: server_id_bits
  2259. Value: 32
  2260. *************************** 361. row ***************************
  2261. Variable_name: server_uuid
  2262. Value: 29954b68-ac1e-11e8-bfd7-525400dffdd7
  2263. *************************** 362. row ***************************
  2264. Variable_name: show_old_temporals
  2265. Value: OFF
  2266. *************************** 363. row ***************************
  2267. Variable_name: simplified_binlog_gtid_recovery
  2268. Value: OFF
  2269. *************************** 364. row ***************************
  2270. Variable_name: skip_external_locking
  2271. Value: ON
  2272. *************************** 365. row ***************************
  2273. Variable_name: skip_name_resolve
  2274. Value: OFF
  2275. *************************** 366. row ***************************
  2276. Variable_name: skip_networking
  2277. Value: OFF
  2278. *************************** 367. row ***************************
  2279. Variable_name: skip_show_database
  2280. Value: OFF
  2281. *************************** 368. row ***************************
  2282. Variable_name: slave_allow_batching
  2283. Value: OFF
  2284. *************************** 369. row ***************************
  2285. Variable_name: slave_checkpoint_group
  2286. Value: 512
  2287. *************************** 370. row ***************************
  2288. Variable_name: slave_checkpoint_period
  2289. Value: 300
  2290. *************************** 371. row ***************************
  2291. Variable_name: slave_compressed_protocol
  2292. Value: OFF
  2293. *************************** 372. row ***************************
  2294. Variable_name: slave_exec_mode
  2295. Value: STRICT
  2296. *************************** 373. row ***************************
  2297. Variable_name: slave_load_tmpdir
  2298. Value: /run/shm
  2299. *************************** 374. row ***************************
  2300. Variable_name: slave_max_allowed_packet
  2301. Value: 1073741824
  2302. *************************** 375. row ***************************
  2303. Variable_name: slave_net_timeout
  2304. Value: 3600
  2305. *************************** 376. row ***************************
  2306. Variable_name: slave_parallel_workers
  2307. Value: 0
  2308. *************************** 377. row ***************************
  2309. Variable_name: slave_pending_jobs_size_max
  2310. Value: 16777216
  2311. *************************** 378. row ***************************
  2312. Variable_name: slave_rows_search_algorithms
  2313. Value: TABLE_SCAN,INDEX_SCAN
  2314. *************************** 379. row ***************************
  2315. Variable_name: slave_skip_errors
  2316. Value: OFF
  2317. *************************** 380. row ***************************
  2318. Variable_name: slave_sql_verify_checksum
  2319. Value: ON
  2320. *************************** 381. row ***************************
  2321. Variable_name: slave_transaction_retries
  2322. Value: 10
  2323. *************************** 382. row ***************************
  2324. Variable_name: slave_type_conversions
  2325. Value:
  2326. *************************** 383. row ***************************
  2327. Variable_name: slow_launch_time
  2328. Value: 2
  2329. *************************** 384. row ***************************
  2330. Variable_name: slow_query_log
  2331. Value: OFF
  2332. *************************** 385. row ***************************
  2333. Variable_name: slow_query_log_file
  2334. Value: /var/log/mysql/slow.log
  2335. *************************** 386. row ***************************
  2336. Variable_name: socket
  2337. Value: /var/run/mysqld/mysqld.sock
  2338. *************************** 387. row ***************************
  2339. Variable_name: sort_buffer_size
  2340. Value: 4194304
  2341. *************************** 388. row ***************************
  2342. Variable_name: sql_auto_is_null
  2343. Value: OFF
  2344. *************************** 389. row ***************************
  2345. Variable_name: sql_big_selects
  2346. Value: ON
  2347. *************************** 390. row ***************************
  2348. Variable_name: sql_buffer_result
  2349. Value: OFF
  2350. *************************** 391. row ***************************
  2351. Variable_name: sql_log_bin
  2352. Value: ON
  2353. *************************** 392. row ***************************
  2354. Variable_name: sql_log_off
  2355. Value: OFF
  2356. *************************** 393. row ***************************
  2357. Variable_name: sql_mode
  2358. Value: NO_ENGINE_SUBSTITUTION
  2359. *************************** 394. row ***************************
  2360. Variable_name: sql_notes
  2361. Value: ON
  2362. *************************** 395. row ***************************
  2363. Variable_name: sql_quote_show_create
  2364. Value: ON
  2365. *************************** 396. row ***************************
  2366. Variable_name: sql_safe_updates
  2367. Value: OFF
  2368. *************************** 397. row ***************************
  2369. Variable_name: sql_select_limit
  2370. Value: 18446744073709551615
  2371. *************************** 398. row ***************************
  2372. Variable_name: sql_slave_skip_counter
  2373. Value: 0
  2374. *************************** 399. row ***************************
  2375. Variable_name: sql_warnings
  2376. Value: OFF
  2377. *************************** 400. row ***************************
  2378. Variable_name: ssl_ca
  2379. Value:
  2380. *************************** 401. row ***************************
  2381. Variable_name: ssl_capath
  2382. Value:
  2383. *************************** 402. row ***************************
  2384. Variable_name: ssl_cert
  2385. Value:
  2386. *************************** 403. row ***************************
  2387. Variable_name: ssl_cipher
  2388. Value:
  2389. *************************** 404. row ***************************
  2390. Variable_name: ssl_crl
  2391. Value:
  2392. *************************** 405. row ***************************
  2393. Variable_name: ssl_crlpath
  2394. Value:
  2395. *************************** 406. row ***************************
  2396. Variable_name: ssl_key
  2397. Value:
  2398. *************************** 407. row ***************************
  2399. Variable_name: storage_engine
  2400. Value: InnoDB
  2401. *************************** 408. row ***************************
  2402. Variable_name: stored_program_cache
  2403. Value: 256
  2404. *************************** 409. row ***************************
  2405. Variable_name: sync_binlog
  2406. Value: 1
  2407. *************************** 410. row ***************************
  2408. Variable_name: sync_frm
  2409. Value: ON
  2410. *************************** 411. row ***************************
  2411. Variable_name: sync_master_info
  2412. Value: 10000
  2413. *************************** 412. row ***************************
  2414. Variable_name: sync_relay_log
  2415. Value: 10000
  2416. *************************** 413. row ***************************
  2417. Variable_name: sync_relay_log_info
  2418. Value: 10000
  2419. *************************** 414. row ***************************
  2420. Variable_name: system_time_zone
  2421. Value: CET
  2422. *************************** 415. row ***************************
  2423. Variable_name: table_definition_cache
  2424. Value: 1400
  2425. *************************** 416. row ***************************
  2426. Variable_name: table_open_cache
  2427. Value: 2000
  2428. *************************** 417. row ***************************
  2429. Variable_name: table_open_cache_instances
  2430. Value: 1
  2431. *************************** 418. row ***************************
  2432. Variable_name: thread_cache_size
  2433. Value: 96
  2434. *************************** 419. row ***************************
  2435. Variable_name: thread_concurrency
  2436. Value: 12
  2437. *************************** 420. row ***************************
  2438. Variable_name: thread_handling
  2439. Value: one-thread-per-connection
  2440. *************************** 421. row ***************************
  2441. Variable_name: thread_stack
  2442. Value: 262144
  2443. *************************** 422. row ***************************
  2444. Variable_name: time_format
  2445. Value: %H:%i:%s
  2446. *************************** 423. row ***************************
  2447. Variable_name: time_zone
  2448. Value: SYSTEM
  2449. *************************** 424. row ***************************
  2450. Variable_name: timed_mutexes
  2451. Value: OFF
  2452. *************************** 425. row ***************************
  2453. Variable_name: tmp_table_size
  2454. Value: 201326592
  2455. *************************** 426. row ***************************
  2456. Variable_name: tmpdir
  2457. Value: /run/shm
  2458. *************************** 427. row ***************************
  2459. Variable_name: transaction_alloc_block_size
  2460. Value: 8192
  2461. *************************** 428. row ***************************
  2462. Variable_name: transaction_prealloc_size
  2463. Value: 4096
  2464. *************************** 429. row ***************************
  2465. Variable_name: tx_isolation
  2466. Value: REPEATABLE-READ
  2467. *************************** 430. row ***************************
  2468. Variable_name: tx_read_only
  2469. Value: OFF
  2470. *************************** 431. row ***************************
  2471. Variable_name: unique_checks
  2472. Value: ON
  2473. *************************** 432. row ***************************
  2474. Variable_name: updatable_views_with_limit
  2475. Value: YES
  2476. *************************** 433. row ***************************
  2477. Variable_name: version
  2478. Value: 5.6.26-log
  2479. *************************** 434. row ***************************
  2480. Variable_name: version_comment
  2481. Value: MySQL Community Server (GPL)
  2482. *************************** 435. row ***************************
  2483. Variable_name: version_compile_machine
  2484. Value: x86_64
  2485. *************************** 436. row ***************************
  2486. Variable_name: version_compile_os
  2487. Value: Linux
  2488. *************************** 437. row ***************************
  2489. Variable_name: wait_timeout
  2490. Value: 720
  2491. 437 rows in set (0.01 sec)
Advertisement
RAW Paste Data Copied
Advertisement