Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
224
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> SHOW GLOBAL VARIABLES \G;
  2. *************************** 1. row ***************************
  3. Variable_name: activate_all_roles_on_login
  4. Value: OFF
  5. *************************** 2. row ***************************
  6. Variable_name: admin_address
  7. Value:
  8. *************************** 3. row ***************************
  9. Variable_name: admin_port
  10. Value: 33062
  11. *************************** 4. row ***************************
  12. Variable_name: auto_generate_certs
  13. Value: ON
  14. *************************** 5. row ***************************
  15. Variable_name: auto_increment_increment
  16. Value: 7
  17. *************************** 6. row ***************************
  18. Variable_name: auto_increment_offset
  19. Value: 1
  20. *************************** 7. row ***************************
  21. Variable_name: autocommit
  22. Value: ON
  23. *************************** 8. row ***************************
  24. Variable_name: automatic_sp_privileges
  25. Value: ON
  26. *************************** 9. row ***************************
  27. Variable_name: avoid_temporal_upgrade
  28. Value: OFF
  29. *************************** 10. row ***************************
  30. Variable_name: back_log
  31. Value: 3072
  32. *************************** 11. row ***************************
  33. Variable_name: basedir
  34. Value: /usr/
  35. *************************** 12. row ***************************
  36. Variable_name: big_tables
  37. Value: OFF
  38. *************************** 13. row ***************************
  39. Variable_name: bind_address
  40. Value: 1
  41. *************************** 14. row ***************************
  42. Variable_name: binlog_cache_size
  43. Value: 32768
  44. *************************** 15. row ***************************
  45. Variable_name: binlog_checksum
  46. Value: NONE
  47. *************************** 16. row ***************************
  48. Variable_name: binlog_direct_non_transactional_updates
  49. Value: OFF
  50. *************************** 17. row ***************************
  51. Variable_name: binlog_encryption
  52. Value: OFF
  53. *************************** 18. row ***************************
  54. Variable_name: binlog_error_action
  55. Value: ABORT_SERVER
  56. *************************** 19. row ***************************
  57. Variable_name: binlog_expire_logs_seconds
  58. Value: 604800
  59. *************************** 20. row ***************************
  60. Variable_name: binlog_format
  61. Value: ROW
  62. *************************** 21. row ***************************
  63. Variable_name: binlog_group_commit_sync_delay
  64. Value: 0
  65. *************************** 22. row ***************************
  66. Variable_name: binlog_group_commit_sync_no_delay_count
  67. Value: 0
  68. *************************** 23. row ***************************
  69. Variable_name: binlog_gtid_simple_recovery
  70. Value: ON
  71. *************************** 24. row ***************************
  72. Variable_name: binlog_max_flush_queue_time
  73. Value: 0
  74. *************************** 25. row ***************************
  75. Variable_name: binlog_order_commits
  76. Value: ON
  77. *************************** 26. row ***************************
  78. Variable_name: binlog_rotate_encryption_master_key_at_startup
  79. Value: OFF
  80. *************************** 27. row ***************************
  81. Variable_name: binlog_row_event_max_size
  82. Value: 8192
  83. *************************** 28. row ***************************
  84. Variable_name: binlog_row_image
  85. Value: FULL
  86. *************************** 29. row ***************************
  87. Variable_name: binlog_row_metadata
  88. Value: MINIMAL
  89. *************************** 30. row ***************************
  90. Variable_name: binlog_row_value_options
  91. Value:
  92. *************************** 31. row ***************************
  93. Variable_name: binlog_rows_query_log_events
  94. Value: OFF
  95. *************************** 32. row ***************************
  96. Variable_name: binlog_stmt_cache_size
  97. Value: 32768
  98. *************************** 33. row ***************************
  99. Variable_name: binlog_transaction_dependency_history_size
  100. Value: 25000
  101. *************************** 34. row ***************************
  102. Variable_name: binlog_transaction_dependency_tracking
  103. Value: COMMIT_ORDER
  104. *************************** 35. row ***************************
  105. Variable_name: block_encryption_mode
  106. Value: aes-128-ecb
  107. *************************** 36. row ***************************
  108. Variable_name: bulk_insert_buffer_size
  109. Value: 8388608
  110. *************************** 37. row ***************************
  111. Variable_name: caching_sha2_password_auto_generate_rsa_keys
  112. Value: ON
  113. *************************** 38. row ***************************
  114. Variable_name: caching_sha2_password_private_key_path
  115. Value: private_key.pem
  116. *************************** 39. row ***************************
  117. Variable_name: caching_sha2_password_public_key_path
  118. Value: public_key.pem
  119. *************************** 40. row ***************************
  120. Variable_name: character_set_client
  121. Value: latin1
  122. *************************** 41. row ***************************
  123. Variable_name: character_set_connection
  124. Value: latin1
  125. *************************** 42. row ***************************
  126. Variable_name: character_set_database
  127. Value: latin1
  128. *************************** 43. row ***************************
  129. Variable_name: character_set_filesystem
  130. Value: binary
  131. *************************** 44. row ***************************
  132. Variable_name: character_set_results
  133. Value: latin1
  134. *************************** 45. row ***************************
  135. Variable_name: character_set_server
  136. Value: latin1
  137. *************************** 46. row ***************************
  138. Variable_name: character_set_system
  139. Value: utf8
  140. *************************** 47. row ***************************
  141. Variable_name: character_sets_dir
  142. Value: /usr/share/mysql-8.0/charsets/
  143. *************************** 48. row ***************************
  144. Variable_name: check_proxy_users
  145. Value: OFF
  146. *************************** 49. row ***************************
  147. Variable_name: clone_autotune_concurrency
  148. Value: ON
  149. *************************** 50. row ***************************
  150. Variable_name: clone_buffer_size
  151. Value: 4194304
  152. *************************** 51. row ***************************
  153. Variable_name: clone_ddl_timeout
  154. Value: 300
  155. *************************** 52. row ***************************
  156. Variable_name: clone_enable_compression
  157. Value: OFF
  158. *************************** 53. row ***************************
  159. Variable_name: clone_max_concurrency
  160. Value: 16
  161. *************************** 54. row ***************************
  162. Variable_name: clone_max_data_bandwidth
  163. Value: 0
  164. *************************** 55. row ***************************
  165. Variable_name: clone_max_network_bandwidth
  166. Value: 0
  167. *************************** 56. row ***************************
  168. Variable_name: clone_ssl_ca
  169. Value:
  170. *************************** 57. row ***************************
  171. Variable_name: clone_ssl_cert
  172. Value:
  173. *************************** 58. row ***************************
  174. Variable_name: clone_ssl_key
  175. Value:
  176. *************************** 59. row ***************************
  177. Variable_name: clone_valid_donor_list
  178. Value:
  179. *************************** 60. row ***************************
  180. Variable_name: collation_connection
  181. Value: latin1_swedish_ci
  182. *************************** 61. row ***************************
  183. Variable_name: collation_database
  184. Value: latin1_swedish_ci
  185. *************************** 62. row ***************************
  186. Variable_name: collation_server
  187. Value: latin1_swedish_ci
  188. *************************** 63. row ***************************
  189. Variable_name: completion_type
  190. Value: NO_CHAIN
  191. *************************** 64. row ***************************
  192. Variable_name: concurrent_insert
  193. Value: AUTO
  194. *************************** 65. row ***************************
  195. Variable_name: connect_timeout
  196. Value: 8
  197. *************************** 66. row ***************************
  198. Variable_name: core_file
  199. Value: OFF
  200. *************************** 67. row ***************************
  201. Variable_name: create_admin_listener_thread
  202. Value: OFF
  203. *************************** 68. row ***************************
  204. Variable_name: cte_max_recursion_depth
  205. Value: 1000
  206. *************************** 69. row ***************************
  207. Variable_name: datadir
  208. Value: /var/lib/mysql/
  209. *************************** 70. row ***************************
  210. Variable_name: default_authentication_plugin
  211. Value: mysql_native_password
  212. *************************** 71. row ***************************
  213. Variable_name: default_collation_for_utf8mb4
  214. Value: utf8mb4_0900_ai_ci
  215. *************************** 72. row ***************************
  216. Variable_name: default_password_lifetime
  217. Value: 0
  218. *************************** 73. row ***************************
  219. Variable_name: default_storage_engine
  220. Value: InnoDB
  221. *************************** 74. row ***************************
  222. Variable_name: default_table_encryption
  223. Value: OFF
  224. *************************** 75. row ***************************
  225. Variable_name: default_tmp_storage_engine
  226. Value: InnoDB
  227. *************************** 76. row ***************************
  228. Variable_name: default_week_format
  229. Value: 0
  230. *************************** 77. row ***************************
  231. Variable_name: delay_key_write
  232. Value: ON
  233. *************************** 78. row ***************************
  234. Variable_name: delayed_insert_limit
  235. Value: 100
  236. *************************** 79. row ***************************
  237. Variable_name: delayed_insert_timeout
  238. Value: 8
  239. *************************** 80. row ***************************
  240. Variable_name: delayed_queue_size
  241. Value: 1000
  242. *************************** 81. row ***************************
  243. Variable_name: disabled_storage_engines
  244. Value:
  245. *************************** 82. row ***************************
  246. Variable_name: disconnect_on_expired_password
  247. Value: ON
  248. *************************** 83. row ***************************
  249. Variable_name: div_precision_increment
  250. Value: 4
  251. *************************** 84. row ***************************
  252. Variable_name: end_markers_in_json
  253. Value: OFF
  254. *************************** 85. row ***************************
  255. Variable_name: enforce_gtid_consistency
  256. Value: ON
  257. *************************** 86. row ***************************
  258. Variable_name: eq_range_index_dive_limit
  259. Value: 200
  260. *************************** 87. row ***************************
  261. Variable_name: event_scheduler
  262. Value: ON
  263. *************************** 88. row ***************************
  264. Variable_name: expire_logs_days
  265. Value: 0
  266. *************************** 89. row ***************************
  267. Variable_name: explicit_defaults_for_timestamp
  268. Value: ON
  269. *************************** 90. row ***************************
  270. Variable_name: flush
  271. Value: OFF
  272. *************************** 91. row ***************************
  273. Variable_name: flush_time
  274. Value: 0
  275. *************************** 92. row ***************************
  276. Variable_name: foreign_key_checks
  277. Value: ON
  278. *************************** 93. row ***************************
  279. Variable_name: ft_boolean_syntax
  280. Value: + -><()~*:""&|
  281. *************************** 94. row ***************************
  282. Variable_name: ft_max_word_len
  283. Value: 84
  284. *************************** 95. row ***************************
  285. Variable_name: ft_min_word_len
  286. Value: 4
  287. *************************** 96. row ***************************
  288. Variable_name: ft_query_expansion_limit
  289. Value: 20
  290. *************************** 97. row ***************************
  291. Variable_name: ft_stopword_file
  292. Value: (built-in)
  293. *************************** 98. row ***************************
  294. Variable_name: general_log
  295. Value: OFF
  296. *************************** 99. row ***************************
  297. Variable_name: general_log_file
  298. Value: /var/lib/mysql/1.log
  299. *************************** 100. row ***************************
  300. Variable_name: group_concat_max_len
  301. Value: 1024
  302. *************************** 101. row ***************************
  303. Variable_name: group_replication_allow_local_lower_version_join
  304. Value: OFF
  305. *************************** 102. row ***************************
  306. Variable_name: group_replication_auto_increment_increment
  307. Value: 7
  308. *************************** 103. row ***************************
  309. Variable_name: group_replication_autorejoin_tries
  310. Value: 0
  311. *************************** 104. row ***************************
  312. Variable_name: group_replication_bootstrap_group
  313. Value: OFF
  314. *************************** 105. row ***************************
  315. Variable_name: group_replication_clone_threshold
  316. Value: 9223372036854775807
  317. *************************** 106. row ***************************
  318. Variable_name: group_replication_communication_debug_options
  319. Value: GCS_DEBUG_NONE
  320. *************************** 107. row ***************************
  321. Variable_name: group_replication_communication_max_message_size
  322. Value: 10485760
  323. *************************** 108. row ***************************
  324. Variable_name: group_replication_components_stop_timeout
  325. Value: 31536000
  326. *************************** 109. row ***************************
  327. Variable_name: group_replication_compression_threshold
  328. Value: 1000000
  329. *************************** 110. row ***************************
  330. Variable_name: group_replication_consistency
  331. Value: EVENTUAL
  332. *************************** 111. row ***************************
  333. Variable_name: group_replication_enforce_update_everywhere_checks
  334. Value: ON
  335. *************************** 112. row ***************************
  336. Variable_name: group_replication_exit_state_action
  337. Value: READ_ONLY
  338. *************************** 113. row ***************************
  339. Variable_name: group_replication_flow_control_applier_threshold
  340. Value: 25000
  341. *************************** 114. row ***************************
  342. Variable_name: group_replication_flow_control_certifier_threshold
  343. Value: 25000
  344. *************************** 115. row ***************************
  345. Variable_name: group_replication_flow_control_hold_percent
  346. Value: 10
  347. *************************** 116. row ***************************
  348. Variable_name: group_replication_flow_control_max_quota
  349. Value: 0
  350. *************************** 117. row ***************************
  351. Variable_name: group_replication_flow_control_member_quota_percent
  352. Value: 0
  353. *************************** 118. row ***************************
  354. Variable_name: group_replication_flow_control_min_quota
  355. Value: 0
  356. *************************** 119. row ***************************
  357. Variable_name: group_replication_flow_control_min_recovery_quota
  358. Value: 0
  359. *************************** 120. row ***************************
  360. Variable_name: group_replication_flow_control_mode
  361. Value: QUOTA
  362. *************************** 121. row ***************************
  363. Variable_name: group_replication_flow_control_period
  364. Value: 1
  365. *************************** 122. row ***************************
  366. Variable_name: group_replication_flow_control_release_percent
  367. Value: 50
  368. *************************** 123. row ***************************
  369. Variable_name: group_replication_force_members
  370. Value:
  371. *************************** 124. row ***************************
  372. Variable_name: group_replication_group_name
  373. Value: c7bdb6a5-746f-4eab-a21d-9d9c08578322
  374. *************************** 125. row ***************************
  375. Variable_name: group_replication_group_seeds
  376. Value: 1:33061,vm2:33061,vm3:33061
  377. *************************** 126. row ***************************
  378. Variable_name: group_replication_gtid_assignment_block_size
  379. Value: 1000000
  380. *************************** 127. row ***************************
  381. Variable_name: group_replication_ip_whitelist
  382. Value: 1,vm2,vm3
  383. *************************** 128. row ***************************
  384. Variable_name: group_replication_local_address
  385. Value: 1:33061
  386. *************************** 129. row ***************************
  387. Variable_name: group_replication_member_expel_timeout
  388. Value: 0
  389. *************************** 130. row ***************************
  390. Variable_name: group_replication_member_weight
  391. Value: 50
  392. *************************** 131. row ***************************
  393. Variable_name: group_replication_message_cache_size
  394. Value: 1073741824
  395. *************************** 132. row ***************************
  396. Variable_name: group_replication_poll_spin_loops
  397. Value: 0
  398. *************************** 133. row ***************************
  399. Variable_name: group_replication_recovery_complete_at
  400. Value: TRANSACTIONS_APPLIED
  401. *************************** 134. row ***************************
  402. Variable_name: group_replication_recovery_get_public_key
  403. Value: OFF
  404. *************************** 135. row ***************************
  405. Variable_name: group_replication_recovery_public_key_path
  406. Value:
  407. *************************** 136. row ***************************
  408. Variable_name: group_replication_recovery_reconnect_interval
  409. Value: 60
  410. *************************** 137. row ***************************
  411. Variable_name: group_replication_recovery_retry_count
  412. Value: 10
  413. *************************** 138. row ***************************
  414. Variable_name: group_replication_recovery_ssl_ca
  415. Value:
  416. *************************** 139. row ***************************
  417. Variable_name: group_replication_recovery_ssl_capath
  418. Value:
  419. *************************** 140. row ***************************
  420. Variable_name: group_replication_recovery_ssl_cert
  421. Value:
  422. *************************** 141. row ***************************
  423. Variable_name: group_replication_recovery_ssl_cipher
  424. Value:
  425. *************************** 142. row ***************************
  426. Variable_name: group_replication_recovery_ssl_crl
  427. Value:
  428. *************************** 143. row ***************************
  429. Variable_name: group_replication_recovery_ssl_crlpath
  430. Value:
  431. *************************** 144. row ***************************
  432. Variable_name: group_replication_recovery_ssl_key
  433. Value:
  434. *************************** 145. row ***************************
  435. Variable_name: group_replication_recovery_ssl_verify_server_cert
  436. Value: OFF
  437. *************************** 146. row ***************************
  438. Variable_name: group_replication_recovery_use_ssl
  439. Value: ON
  440. *************************** 147. row ***************************
  441. Variable_name: group_replication_single_primary_mode
  442. Value: OFF
  443. *************************** 148. row ***************************
  444. Variable_name: group_replication_ssl_mode
  445. Value: REQUIRED
  446. *************************** 149. row ***************************
  447. Variable_name: group_replication_start_on_boot
  448. Value: ON
  449. *************************** 150. row ***************************
  450. Variable_name: group_replication_transaction_size_limit
  451. Value: 150000000
  452. *************************** 151. row ***************************
  453. Variable_name: group_replication_unreachable_majority_timeout
  454. Value: 0
  455. *************************** 152. row ***************************
  456. Variable_name: gtid_executed
  457. Value: 04c1bc0c-b91c-11e9-bb6a-5254002ed13a:1-27,
  458. c7bdb6a5-746f-4eab-a21d-9d9c08578322:1-7212863:8212807-8212837:9212807-9212838
  459. *************************** 153. row ***************************
  460. Variable_name: gtid_executed_compression_period
  461. Value: 1000
  462. *************************** 154. row ***************************
  463. Variable_name: gtid_mode
  464. Value: ON
  465. *************************** 155. row ***************************
  466. Variable_name: gtid_owned
  467. Value:
  468. *************************** 156. row ***************************
  469. Variable_name: gtid_purged
  470. Value: 04c1bc0c-b91c-11e9-bb6a-5254002ed13a:1-27,
  471. c7bdb6a5-746f-4eab-a21d-9d9c08578322:1-7212429
  472. *************************** 157. row ***************************
  473. Variable_name: have_compress
  474. Value: YES
  475. *************************** 158. row ***************************
  476. Variable_name: have_dynamic_loading
  477. Value: YES
  478. *************************** 159. row ***************************
  479. Variable_name: have_geometry
  480. Value: YES
  481. *************************** 160. row ***************************
  482. Variable_name: have_openssl
  483. Value: YES
  484. *************************** 161. row ***************************
  485. Variable_name: have_profiling
  486. Value: YES
  487. *************************** 162. row ***************************
  488. Variable_name: have_query_cache
  489. Value: NO
  490. *************************** 163. row ***************************
  491. Variable_name: have_rtree_keys
  492. Value: YES
  493. *************************** 164. row ***************************
  494. Variable_name: have_ssl
  495. Value: YES
  496. *************************** 165. row ***************************
  497. Variable_name: have_statement_timeout
  498. Value: YES
  499. *************************** 166. row ***************************
  500. Variable_name: have_symlink
  501. Value: DISABLED
  502. *************************** 167. row ***************************
  503. Variable_name: histogram_generation_max_mem_size
  504. Value: 20000000
  505. *************************** 168. row ***************************
  506. Variable_name: host_cache_size
  507. Value: 756
  508. *************************** 169. row ***************************
  509. Variable_name: hostname
  510. Value: 1.seewebcloud.it
  511. *************************** 170. row ***************************
  512. Variable_name: information_schema_stats_expiry
  513. Value: 86400
  514. *************************** 171. row ***************************
  515. Variable_name: init_connect
  516. Value:
  517. *************************** 172. row ***************************
  518. Variable_name: init_file
  519. Value:
  520. *************************** 173. row ***************************
  521. Variable_name: init_slave
  522. Value:
  523. *************************** 174. row ***************************
  524. Variable_name: innodb_adaptive_flushing
  525. Value: ON
  526. *************************** 175. row ***************************
  527. Variable_name: innodb_adaptive_flushing_lwm
  528. Value: 10
  529. *************************** 176. row ***************************
  530. Variable_name: innodb_adaptive_hash_index
  531. Value: ON
  532. *************************** 177. row ***************************
  533. Variable_name: innodb_adaptive_hash_index_parts
  534. Value: 8
  535. *************************** 178. row ***************************
  536. Variable_name: innodb_adaptive_max_sleep_delay
  537. Value: 150000
  538. *************************** 179. row ***************************
  539. Variable_name: innodb_api_bk_commit_interval
  540. Value: 5
  541. *************************** 180. row ***************************
  542. Variable_name: innodb_api_disable_rowlock
  543. Value: OFF
  544. *************************** 181. row ***************************
  545. Variable_name: innodb_api_enable_binlog
  546. Value: OFF
  547. *************************** 182. row ***************************
  548. Variable_name: innodb_api_enable_mdl
  549. Value: OFF
  550. *************************** 183. row ***************************
  551. Variable_name: innodb_api_trx_level
  552. Value: 0
  553. *************************** 184. row ***************************
  554. Variable_name: innodb_autoextend_increment
  555. Value: 64
  556. *************************** 185. row ***************************
  557. Variable_name: innodb_autoinc_lock_mode
  558. Value: 2
  559. *************************** 186. row ***************************
  560. Variable_name: innodb_buffer_pool_chunk_size
  561. Value: 134217728
  562. *************************** 187. row ***************************
  563. Variable_name: innodb_buffer_pool_dump_at_shutdown
  564. Value: ON
  565. *************************** 188. row ***************************
  566. Variable_name: innodb_buffer_pool_dump_now
  567. Value: OFF
  568. *************************** 189. row ***************************
  569. Variable_name: innodb_buffer_pool_dump_pct
  570. Value: 25
  571. *************************** 190. row ***************************
  572. Variable_name: innodb_buffer_pool_filename
  573. Value: ib_buffer_pool
  574. *************************** 191. row ***************************
  575. Variable_name: innodb_buffer_pool_in_core_file
  576. Value: ON
  577. *************************** 192. row ***************************
  578. Variable_name: innodb_buffer_pool_instances
  579. Value: 8
  580. *************************** 193. row ***************************
  581. Variable_name: innodb_buffer_pool_load_abort
  582. Value: OFF
  583. *************************** 194. row ***************************
  584. Variable_name: innodb_buffer_pool_load_at_startup
  585. Value: ON
  586. *************************** 195. row ***************************
  587. Variable_name: innodb_buffer_pool_load_now
  588. Value: OFF
  589. *************************** 196. row ***************************
  590. Variable_name: innodb_buffer_pool_size
  591. Value: 34359738368
  592. *************************** 197. row ***************************
  593. Variable_name: innodb_change_buffer_max_size
  594. Value: 25
  595. *************************** 198. row ***************************
  596. Variable_name: innodb_change_buffering
  597. Value: all
  598. *************************** 199. row ***************************
  599. Variable_name: innodb_checksum_algorithm
  600. Value: crc32
  601. *************************** 200. row ***************************
  602. Variable_name: innodb_cmp_per_index_enabled
  603. Value: OFF
  604. *************************** 201. row ***************************
  605. Variable_name: innodb_commit_concurrency
  606. Value: 0
  607. *************************** 202. row ***************************
  608. Variable_name: innodb_compression_failure_threshold_pct
  609. Value: 5
  610. *************************** 203. row ***************************
  611. Variable_name: innodb_compression_level
  612. Value: 6
  613. *************************** 204. row ***************************
  614. Variable_name: innodb_compression_pad_pct_max
  615. Value: 50
  616. *************************** 205. row ***************************
  617. Variable_name: innodb_concurrency_tickets
  618. Value: 5000
  619. *************************** 206. row ***************************
  620. Variable_name: innodb_data_file_path
  621. Value: ibdata1:12M:autoextend
  622. *************************** 207. row ***************************
  623. Variable_name: innodb_data_home_dir
  624. Value:
  625. *************************** 208. row ***************************
  626. Variable_name: innodb_deadlock_detect
  627. Value: ON
  628. *************************** 209. row ***************************
  629. Variable_name: innodb_dedicated_server
  630. Value: OFF
  631. *************************** 210. row ***************************
  632. Variable_name: innodb_default_row_format
  633. Value: dynamic
  634. *************************** 211. row ***************************
  635. Variable_name: innodb_directories
  636. Value:
  637. *************************** 212. row ***************************
  638. Variable_name: innodb_disable_sort_file_cache
  639. Value: OFF
  640. *************************** 213. row ***************************
  641. Variable_name: innodb_doublewrite
  642. Value: ON
  643. *************************** 214. row ***************************
  644. Variable_name: innodb_fast_shutdown
  645. Value: 1
  646. *************************** 215. row ***************************
  647. Variable_name: innodb_file_per_table
  648. Value: ON
  649. *************************** 216. row ***************************
  650. Variable_name: innodb_fill_factor
  651. Value: 100
  652. *************************** 217. row ***************************
  653. Variable_name: innodb_flush_log_at_timeout
  654. Value: 1
  655. *************************** 218. row ***************************
  656. Variable_name: innodb_flush_log_at_trx_commit
  657. Value: 1
  658. *************************** 219. row ***************************
  659. Variable_name: innodb_flush_method
  660. Value: O_DIRECT
  661. *************************** 220. row ***************************
  662. Variable_name: innodb_flush_neighbors
  663. Value: 0
  664. *************************** 221. row ***************************
  665. Variable_name: innodb_flush_sync
  666. Value: ON
  667. *************************** 222. row ***************************
  668. Variable_name: innodb_flushing_avg_loops
  669. Value: 30
  670. *************************** 223. row ***************************
  671. Variable_name: innodb_force_load_corrupted
  672. Value: OFF
  673. *************************** 224. row ***************************
  674. Variable_name: innodb_force_recovery
  675. Value: 0
  676. *************************** 225. row ***************************
  677. Variable_name: innodb_fsync_threshold
  678. Value: 0
  679. *************************** 226. row ***************************
  680. Variable_name: innodb_ft_aux_table
  681. Value:
  682. *************************** 227. row ***************************
  683. Variable_name: innodb_ft_cache_size
  684. Value: 8000000
  685. *************************** 228. row ***************************
  686. Variable_name: innodb_ft_enable_diag_print
  687. Value: OFF
  688. *************************** 229. row ***************************
  689. Variable_name: innodb_ft_enable_stopword
  690. Value: ON
  691. *************************** 230. row ***************************
  692. Variable_name: innodb_ft_max_token_size
  693. Value: 84
  694. *************************** 231. row ***************************
  695. Variable_name: innodb_ft_min_token_size
  696. Value: 3
  697. *************************** 232. row ***************************
  698. Variable_name: innodb_ft_num_word_optimize
  699. Value: 2000
  700. *************************** 233. row ***************************
  701. Variable_name: innodb_ft_result_cache_limit
  702. Value: 2000000000
  703. *************************** 234. row ***************************
  704. Variable_name: innodb_ft_server_stopword_table
  705. Value:
  706. *************************** 235. row ***************************
  707. Variable_name: innodb_ft_sort_pll_degree
  708. Value: 2
  709. *************************** 236. row ***************************
  710. Variable_name: innodb_ft_total_cache_size
  711. Value: 640000000
  712. *************************** 237. row ***************************
  713. Variable_name: innodb_ft_user_stopword_table
  714. Value:
  715. *************************** 238. row ***************************
  716. Variable_name: innodb_io_capacity
  717. Value: 200
  718. *************************** 239. row ***************************
  719. Variable_name: innodb_io_capacity_max
  720. Value: 2000
  721. *************************** 240. row ***************************
  722. Variable_name: innodb_lock_wait_timeout
  723. Value: 120
  724. *************************** 241. row ***************************
  725. Variable_name: innodb_log_buffer_size
  726. Value: 134217728
  727. *************************** 242. row ***************************
  728. Variable_name: innodb_log_checksums
  729. Value: ON
  730. *************************** 243. row ***************************
  731. Variable_name: innodb_log_compressed_pages
  732. Value: ON
  733. *************************** 244. row ***************************
  734. Variable_name: innodb_log_file_size
  735. Value: 268435456
  736. *************************** 245. row ***************************
  737. Variable_name: innodb_log_files_in_group
  738. Value: 2
  739. *************************** 246. row ***************************
  740. Variable_name: innodb_log_group_home_dir
  741. Value: ./
  742. *************************** 247. row ***************************
  743. Variable_name: innodb_log_spin_cpu_abs_lwm
  744. Value: 80
  745. *************************** 248. row ***************************
  746. Variable_name: innodb_log_spin_cpu_pct_hwm
  747. Value: 50
  748. *************************** 249. row ***************************
  749. Variable_name: innodb_log_wait_for_flush_spin_hwm
  750. Value: 400
  751. *************************** 250. row ***************************
  752. Variable_name: innodb_log_write_ahead_size
  753. Value: 8192
  754. *************************** 251. row ***************************
  755. Variable_name: innodb_lru_scan_depth
  756. Value: 1024
  757. *************************** 252. row ***************************
  758. Variable_name: innodb_max_dirty_pages_pct
  759. Value: 90.000000
  760. *************************** 253. row ***************************
  761. Variable_name: innodb_max_dirty_pages_pct_lwm
  762. Value: 10.000000
  763. *************************** 254. row ***************************
  764. Variable_name: innodb_max_purge_lag
  765. Value: 0
  766. *************************** 255. row ***************************
  767. Variable_name: innodb_max_purge_lag_delay
  768. Value: 0
  769. *************************** 256. row ***************************
  770. Variable_name: innodb_max_undo_log_size
  771. Value: 1073741824
  772. *************************** 257. row ***************************
  773. Variable_name: innodb_monitor_disable
  774. Value:
  775. *************************** 258. row ***************************
  776. Variable_name: innodb_monitor_enable
  777. Value:
  778. *************************** 259. row ***************************
  779. Variable_name: innodb_monitor_reset
  780. Value:
  781. *************************** 260. row ***************************
  782. Variable_name: innodb_monitor_reset_all
  783. Value:
  784. *************************** 261. row ***************************
  785. Variable_name: innodb_numa_interleave
  786. Value: OFF
  787. *************************** 262. row ***************************
  788. Variable_name: innodb_old_blocks_pct
  789. Value: 37
  790. *************************** 263. row ***************************
  791. Variable_name: innodb_old_blocks_time
  792. Value: 1000
  793. *************************** 264. row ***************************
  794. Variable_name: innodb_online_alter_log_max_size
  795. Value: 134217728
  796. *************************** 265. row ***************************
  797. Variable_name: innodb_open_files
  798. Value: 3459
  799. *************************** 266. row ***************************
  800. Variable_name: innodb_optimize_fulltext_only
  801. Value: OFF
  802. *************************** 267. row ***************************
  803. Variable_name: innodb_page_cleaners
  804. Value: 4
  805. *************************** 268. row ***************************
  806. Variable_name: innodb_page_size
  807. Value: 16384
  808. *************************** 269. row ***************************
  809. Variable_name: innodb_parallel_read_threads
  810. Value: 4
  811. *************************** 270. row ***************************
  812. Variable_name: innodb_print_all_deadlocks
  813. Value: OFF
  814. *************************** 271. row ***************************
  815. Variable_name: innodb_print_ddl_logs
  816. Value: OFF
  817. *************************** 272. row ***************************
  818. Variable_name: innodb_purge_batch_size
  819. Value: 300
  820. *************************** 273. row ***************************
  821. Variable_name: innodb_purge_rseg_truncate_frequency
  822. Value: 128
  823. *************************** 274. row ***************************
  824. Variable_name: innodb_purge_threads
  825. Value: 4
  826. *************************** 275. row ***************************
  827. Variable_name: innodb_random_read_ahead
  828. Value: OFF
  829. *************************** 276. row ***************************
  830. Variable_name: innodb_read_ahead_threshold
  831. Value: 56
  832. *************************** 277. row ***************************
  833. Variable_name: innodb_read_io_threads
  834. Value: 4
  835. *************************** 278. row ***************************
  836. Variable_name: innodb_read_only
  837. Value: OFF
  838. *************************** 279. row ***************************
  839. Variable_name: innodb_redo_log_archive_dirs
  840. Value:
  841. *************************** 280. row ***************************
  842. Variable_name: innodb_redo_log_encrypt
  843. Value: OFF
  844. *************************** 281. row ***************************
  845. Variable_name: innodb_replication_delay
  846. Value: 0
  847. *************************** 282. row ***************************
  848. Variable_name: innodb_rollback_on_timeout
  849. Value: OFF
  850. *************************** 283. row ***************************
  851. Variable_name: innodb_rollback_segments
  852. Value: 128
  853. *************************** 284. row ***************************
  854. Variable_name: innodb_sort_buffer_size
  855. Value: 1048576
  856. *************************** 285. row ***************************
  857. Variable_name: innodb_spin_wait_delay
  858. Value: 6
  859. *************************** 286. row ***************************
  860. Variable_name: innodb_spin_wait_pause_multiplier
  861. Value: 50
  862. *************************** 287. row ***************************
  863. Variable_name: innodb_stats_auto_recalc
  864. Value: ON
  865. *************************** 288. row ***************************
  866. Variable_name: innodb_stats_include_delete_marked
  867. Value: OFF
  868. *************************** 289. row ***************************
  869. Variable_name: innodb_stats_method
  870. Value: nulls_equal
  871. *************************** 290. row ***************************
  872. Variable_name: innodb_stats_on_metadata
  873. Value: OFF
  874. *************************** 291. row ***************************
  875. Variable_name: innodb_stats_persistent
  876. Value: ON
  877. *************************** 292. row ***************************
  878. Variable_name: innodb_stats_persistent_sample_pages
  879. Value: 20
  880. *************************** 293. row ***************************
  881. Variable_name: innodb_stats_transient_sample_pages
  882. Value: 8
  883. *************************** 294. row ***************************
  884. Variable_name: innodb_status_output
  885. Value: OFF
  886. *************************** 295. row ***************************
  887. Variable_name: innodb_status_output_locks
  888. Value: OFF
  889. *************************** 296. row ***************************
  890. Variable_name: innodb_strict_mode
  891. Value: ON
  892. *************************** 297. row ***************************
  893. Variable_name: innodb_sync_array_size
  894. Value: 1
  895. *************************** 298. row ***************************
  896. Variable_name: innodb_sync_spin_loops
  897. Value: 30
  898. *************************** 299. row ***************************
  899. Variable_name: innodb_table_locks
  900. Value: ON
  901. *************************** 300. row ***************************
  902. Variable_name: innodb_temp_data_file_path
  903. Value: ibtmp1:12M:autoextend
  904. *************************** 301. row ***************************
  905. Variable_name: innodb_temp_tablespaces_dir
  906. Value: ./#innodb_temp/
  907. *************************** 302. row ***************************
  908. Variable_name: innodb_thread_concurrency
  909. Value: 12
  910. *************************** 303. row ***************************
  911. Variable_name: innodb_thread_sleep_delay
  912. Value: 0
  913. *************************** 304. row ***************************
  914. Variable_name: innodb_tmpdir
  915. Value:
  916. *************************** 305. row ***************************
  917. Variable_name: innodb_undo_directory
  918. Value: ./
  919. *************************** 306. row ***************************
  920. Variable_name: innodb_undo_log_encrypt
  921. Value: OFF
  922. *************************** 307. row ***************************
  923. Variable_name: innodb_undo_log_truncate
  924. Value: ON
  925. *************************** 308. row ***************************
  926. Variable_name: innodb_undo_tablespaces
  927. Value: 2
  928. *************************** 309. row ***************************
  929. Variable_name: innodb_use_native_aio
  930. Value: ON
  931. *************************** 310. row ***************************
  932. Variable_name: innodb_version
  933. Value: 8.0.17
  934. *************************** 311. row ***************************
  935. Variable_name: innodb_write_io_threads
  936. Value: 4
  937. *************************** 312. row ***************************
  938. Variable_name: interactive_timeout
  939. Value: 720
  940. *************************** 313. row ***************************
  941. Variable_name: internal_tmp_mem_storage_engine
  942. Value: TempTable
  943. *************************** 314. row ***************************
  944. Variable_name: join_buffer_size
  945. Value: 33554432
  946. *************************** 315. row ***************************
  947. Variable_name: keep_files_on_create
  948. Value: OFF
  949. *************************** 316. row ***************************
  950. Variable_name: key_buffer_size
  951. Value: 134217728
  952. *************************** 317. row ***************************
  953. Variable_name: key_cache_age_threshold
  954. Value: 300
  955. *************************** 318. row ***************************
  956. Variable_name: key_cache_block_size
  957. Value: 1024
  958. *************************** 319. row ***************************
  959. Variable_name: key_cache_division_limit
  960. Value: 100
  961. *************************** 320. row ***************************
  962. Variable_name: keyring_operations
  963. Value: ON
  964. *************************** 321. row ***************************
  965. Variable_name: large_files_support
  966. Value: ON
  967. *************************** 322. row ***************************
  968. Variable_name: large_page_size
  969. Value: 0
  970. *************************** 323. row ***************************
  971. Variable_name: large_pages
  972. Value: OFF
  973. *************************** 324. row ***************************
  974. Variable_name: lc_messages
  975. Value: en_US
  976. *************************** 325. row ***************************
  977. Variable_name: lc_messages_dir
  978. Value: /usr/share/mysql-8.0/
  979. *************************** 326. row ***************************
  980. Variable_name: lc_time_names
  981. Value: en_US
  982. *************************** 327. row ***************************
  983. Variable_name: license
  984. Value: GPL
  985. *************************** 328. row ***************************
  986. Variable_name: local_infile
  987. Value: OFF
  988. *************************** 329. row ***************************
  989. Variable_name: lock_wait_timeout
  990. Value: 31536000
  991. *************************** 330. row ***************************
  992. Variable_name: locked_in_memory
  993. Value: OFF
  994. *************************** 331. row ***************************
  995. Variable_name: log_bin
  996. Value: ON
  997. *************************** 332. row ***************************
  998. Variable_name: log_bin_basename
  999. Value: /var/lib/mysql/binlog
  1000. *************************** 333. row ***************************
  1001. Variable_name: log_bin_index
  1002. Value: /var/lib/mysql/binlog.index
  1003. *************************** 334. row ***************************
  1004. Variable_name: log_bin_trust_function_creators
  1005. Value: OFF
  1006. *************************** 335. row ***************************
  1007. Variable_name: log_bin_use_v1_row_events
  1008. Value: OFF
  1009. *************************** 336. row ***************************
  1010. Variable_name: log_error
  1011. Value: /var/log/mysql/error.log
  1012. *************************** 337. row ***************************
  1013. Variable_name: log_error_services
  1014. Value: log_filter_internal; log_sink_internal
  1015. *************************** 338. row ***************************
  1016. Variable_name: log_error_suppression_list
  1017. Value:
  1018. *************************** 339. row ***************************
  1019. Variable_name: log_error_verbosity
  1020. Value: 2
  1021. *************************** 340. row ***************************
  1022. Variable_name: log_output
  1023. Value: FILE
  1024. *************************** 341. row ***************************
  1025. Variable_name: log_queries_not_using_indexes
  1026. Value: OFF
  1027. *************************** 342. row ***************************
  1028. Variable_name: log_slave_updates
  1029. Value: ON
  1030. *************************** 343. row ***************************
  1031. Variable_name: log_slow_admin_statements
  1032. Value: OFF
  1033. *************************** 344. row ***************************
  1034. Variable_name: log_slow_extra
  1035. Value: OFF
  1036. *************************** 345. row ***************************
  1037. Variable_name: log_slow_slave_statements
  1038. Value: OFF
  1039. *************************** 346. row ***************************
  1040. Variable_name: log_statements_unsafe_for_binlog
  1041. Value: ON
  1042. *************************** 347. row ***************************
  1043. Variable_name: log_throttle_queries_not_using_indexes
  1044. Value: 0
  1045. *************************** 348. row ***************************
  1046. Variable_name: log_timestamps
  1047. Value: UTC
  1048. *************************** 349. row ***************************
  1049. Variable_name: long_query_time
  1050. Value: 10.000000
  1051. *************************** 350. row ***************************
  1052. Variable_name: low_priority_updates
  1053. Value: OFF
  1054. *************************** 351. row ***************************
  1055. Variable_name: lower_case_file_system
  1056. Value: OFF
  1057. *************************** 352. row ***************************
  1058. Variable_name: lower_case_table_names
  1059. Value: 0
  1060. *************************** 353. row ***************************
  1061. Variable_name: mandatory_roles
  1062. Value:
  1063. *************************** 354. row ***************************
  1064. Variable_name: master_info_repository
  1065. Value: TABLE
  1066. *************************** 355. row ***************************
  1067. Variable_name: master_verify_checksum
  1068. Value: OFF
  1069. *************************** 356. row ***************************
  1070. Variable_name: max_allowed_packet
  1071. Value: 67108864
  1072. *************************** 357. row ***************************
  1073. Variable_name: max_binlog_cache_size
  1074. Value: 18446744073709547520
  1075. *************************** 358. row ***************************
  1076. Variable_name: max_binlog_size
  1077. Value: 1073741824
  1078. *************************** 359. row ***************************
  1079. Variable_name: max_binlog_stmt_cache_size
  1080. Value: 18446744073709547520
  1081. *************************** 360. row ***************************
  1082. Variable_name: max_connect_errors
  1083. Value: 100
  1084. *************************** 361. row ***************************
  1085. Variable_name: max_connections
  1086. Value: 3072
  1087. *************************** 362. row ***************************
  1088. Variable_name: max_delayed_threads
  1089. Value: 20
  1090. *************************** 363. row ***************************
  1091. Variable_name: max_digest_length
  1092. Value: 1024
  1093. *************************** 364. row ***************************
  1094. Variable_name: max_error_count
  1095. Value: 1024
  1096. *************************** 365. row ***************************
  1097. Variable_name: max_execution_time
  1098. Value: 0
  1099. *************************** 366. row ***************************
  1100. Variable_name: max_heap_table_size
  1101. Value: 201326592
  1102. *************************** 367. row ***************************
  1103. Variable_name: max_insert_delayed_threads
  1104. Value: 20
  1105. *************************** 368. row ***************************
  1106. Variable_name: max_join_size
  1107. Value: 18446744073709551615
  1108. *************************** 369. row ***************************
  1109. Variable_name: max_length_for_sort_data
  1110. Value: 4096
  1111. *************************** 370. row ***************************
  1112. Variable_name: max_points_in_geometry
  1113. Value: 65536
  1114. *************************** 371. row ***************************
  1115. Variable_name: max_prepared_stmt_count
  1116. Value: 16382
  1117. *************************** 372. row ***************************
  1118. Variable_name: max_relay_log_size
  1119. Value: 0
  1120. *************************** 373. row ***************************
  1121. Variable_name: max_seeks_for_key
  1122. Value: 18446744073709551615
  1123. *************************** 374. row ***************************
  1124. Variable_name: max_sort_length
  1125. Value: 1024
  1126. *************************** 375. row ***************************
  1127. Variable_name: max_sp_recursion_depth
  1128. Value: 0
  1129. *************************** 376. row ***************************
  1130. Variable_name: max_user_connections
  1131. Value: 3072
  1132. *************************** 377. row ***************************
  1133. Variable_name: max_write_lock_count
  1134. Value: 18446744073709551615
  1135. *************************** 378. row ***************************
  1136. Variable_name: min_examined_row_limit
  1137. Value: 0
  1138. *************************** 379. row ***************************
  1139. Variable_name: myisam_data_pointer_size
  1140. Value: 6
  1141. *************************** 380. row ***************************
  1142. Variable_name: myisam_max_sort_file_size
  1143. Value: 9223372036853727232
  1144. *************************** 381. row ***************************
  1145. Variable_name: myisam_mmap_size
  1146. Value: 18446744073709551615
  1147. *************************** 382. row ***************************
  1148. Variable_name: myisam_recover_options
  1149. Value: OFF
  1150. *************************** 383. row ***************************
  1151. Variable_name: myisam_repair_threads
  1152. Value: 1
  1153. *************************** 384. row ***************************
  1154. Variable_name: myisam_sort_buffer_size
  1155. Value: 8388608
  1156. *************************** 385. row ***************************
  1157. Variable_name: myisam_stats_method
  1158. Value: nulls_unequal
  1159. *************************** 386. row ***************************
  1160. Variable_name: myisam_use_mmap
  1161. Value: OFF
  1162. *************************** 387. row ***************************
  1163. Variable_name: mysql_native_password_proxy_users
  1164. Value: OFF
  1165. *************************** 388. row ***************************
  1166. Variable_name: mysqlx_bind_address
  1167. Value: *
  1168. *************************** 389. row ***************************
  1169. Variable_name: mysqlx_connect_timeout
  1170. Value: 30
  1171. *************************** 390. row ***************************
  1172. Variable_name: mysqlx_document_id_unique_prefix
  1173. Value: 0
  1174. *************************** 391. row ***************************
  1175. Variable_name: mysqlx_enable_hello_notice
  1176. Value: ON
  1177. *************************** 392. row ***************************
  1178. Variable_name: mysqlx_idle_worker_thread_timeout
  1179. Value: 60
  1180. *************************** 393. row ***************************
  1181. Variable_name: mysqlx_interactive_timeout
  1182. Value: 28800
  1183. *************************** 394. row ***************************
  1184. Variable_name: mysqlx_max_allowed_packet
  1185. Value: 67108864
  1186. *************************** 395. row ***************************
  1187. Variable_name: mysqlx_max_connections
  1188. Value: 100
  1189. *************************** 396. row ***************************
  1190. Variable_name: mysqlx_min_worker_threads
  1191. Value: 2
  1192. *************************** 397. row ***************************
  1193. Variable_name: mysqlx_port
  1194. Value: 33060
  1195. *************************** 398. row ***************************
  1196. Variable_name: mysqlx_port_open_timeout
  1197. Value: 0
  1198. *************************** 399. row ***************************
  1199. Variable_name: mysqlx_read_timeout
  1200. Value: 30
  1201. *************************** 400. row ***************************
  1202. Variable_name: mysqlx_socket
  1203. Value: /var/run/mysqld/mysqlx.sock
  1204. *************************** 401. row ***************************
  1205. Variable_name: mysqlx_ssl_ca
  1206. Value:
  1207. *************************** 402. row ***************************
  1208. Variable_name: mysqlx_ssl_capath
  1209. Value:
  1210. *************************** 403. row ***************************
  1211. Variable_name: mysqlx_ssl_cert
  1212. Value:
  1213. *************************** 404. row ***************************
  1214. Variable_name: mysqlx_ssl_cipher
  1215. Value:
  1216. *************************** 405. row ***************************
  1217. Variable_name: mysqlx_ssl_crl
  1218. Value:
  1219. *************************** 406. row ***************************
  1220. Variable_name: mysqlx_ssl_crlpath
  1221. Value:
  1222. *************************** 407. row ***************************
  1223. Variable_name: mysqlx_ssl_key
  1224. Value:
  1225. *************************** 408. row ***************************
  1226. Variable_name: mysqlx_wait_timeout
  1227. Value: 28800
  1228. *************************** 409. row ***************************
  1229. Variable_name: mysqlx_write_timeout
  1230. Value: 60
  1231. *************************** 410. row ***************************
  1232. Variable_name: net_buffer_length
  1233. Value: 262144
  1234. *************************** 411. row ***************************
  1235. Variable_name: net_read_timeout
  1236. Value: 30
  1237. *************************** 412. row ***************************
  1238. Variable_name: net_retry_count
  1239. Value: 10
  1240. *************************** 413. row ***************************
  1241. Variable_name: net_write_timeout
  1242. Value: 60
  1243. *************************** 414. row ***************************
  1244. Variable_name: new
  1245. Value: OFF
  1246. *************************** 415. row ***************************
  1247. Variable_name: ngram_token_size
  1248. Value: 2
  1249. *************************** 416. row ***************************
  1250. Variable_name: offline_mode
  1251. Value: OFF
  1252. *************************** 417. row ***************************
  1253. Variable_name: old
  1254. Value: OFF
  1255. *************************** 418. row ***************************
  1256. Variable_name: old_alter_table
  1257. Value: OFF
  1258. *************************** 419. row ***************************
  1259. Variable_name: open_files_limit
  1260. Value: 10000
  1261. *************************** 420. row ***************************
  1262. Variable_name: optimizer_prune_level
  1263. Value: 1
  1264. *************************** 421. row ***************************
  1265. Variable_name: optimizer_search_depth
  1266. Value: 62
  1267. *************************** 422. row ***************************
  1268. Variable_name: optimizer_switch
  1269. 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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on
  1270. *************************** 423. row ***************************
  1271. Variable_name: optimizer_trace
  1272. Value: enabled=off,one_line=off
  1273. *************************** 424. row ***************************
  1274. Variable_name: optimizer_trace_features
  1275. Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  1276. *************************** 425. row ***************************
  1277. Variable_name: optimizer_trace_limit
  1278. Value: 1
  1279. *************************** 426. row ***************************
  1280. Variable_name: optimizer_trace_max_mem_size
  1281. Value: 1048576
  1282. *************************** 427. row ***************************
  1283. Variable_name: optimizer_trace_offset
  1284. Value: -1
  1285. *************************** 428. row ***************************
  1286. Variable_name: parser_max_mem_size
  1287. Value: 18446744073709551615
  1288. *************************** 429. row ***************************
  1289. Variable_name: partial_revokes
  1290. Value: OFF
  1291. *************************** 430. row ***************************
  1292. Variable_name: password_history
  1293. Value: 0
  1294. *************************** 431. row ***************************
  1295. Variable_name: password_require_current
  1296. Value: OFF
  1297. *************************** 432. row ***************************
  1298. Variable_name: password_reuse_interval
  1299. Value: 0
  1300. *************************** 433. row ***************************
  1301. Variable_name: performance_schema
  1302. Value: ON
  1303. *************************** 434. row ***************************
  1304. Variable_name: performance_schema_accounts_size
  1305. Value: -1
  1306. *************************** 435. row ***************************
  1307. Variable_name: performance_schema_digests_size
  1308. Value: 10000
  1309. *************************** 436. row ***************************
  1310. Variable_name: performance_schema_error_size
  1311. Value: 4564
  1312. *************************** 437. row ***************************
  1313. Variable_name: performance_schema_events_stages_history_long_size
  1314. Value: 10000
  1315. *************************** 438. row ***************************
  1316. Variable_name: performance_schema_events_stages_history_size
  1317. Value: 10
  1318. *************************** 439. row ***************************
  1319. Variable_name: performance_schema_events_statements_history_long_size
  1320. Value: 10000
  1321. *************************** 440. row ***************************
  1322. Variable_name: performance_schema_events_statements_history_size
  1323. Value: 10
  1324. *************************** 441. row ***************************
  1325. Variable_name: performance_schema_events_transactions_history_long_size
  1326. Value: 10000
  1327. *************************** 442. row ***************************
  1328. Variable_name: performance_schema_events_transactions_history_size
  1329. Value: 10
  1330. *************************** 443. row ***************************
  1331. Variable_name: performance_schema_events_waits_history_long_size
  1332. Value: 10000
  1333. *************************** 444. row ***************************
  1334. Variable_name: performance_schema_events_waits_history_size
  1335. Value: 10
  1336. *************************** 445. row ***************************
  1337. Variable_name: performance_schema_hosts_size
  1338. Value: -1
  1339. *************************** 446. row ***************************
  1340. Variable_name: performance_schema_max_cond_classes
  1341. Value: 100
  1342. *************************** 447. row ***************************
  1343. Variable_name: performance_schema_max_cond_instances
  1344. Value: -1
  1345. *************************** 448. row ***************************
  1346. Variable_name: performance_schema_max_digest_length
  1347. Value: 1024
  1348. *************************** 449. row ***************************
  1349. Variable_name: performance_schema_max_digest_sample_age
  1350. Value: 60
  1351. *************************** 450. row ***************************
  1352. Variable_name: performance_schema_max_file_classes
  1353. Value: 80
  1354. *************************** 451. row ***************************
  1355. Variable_name: performance_schema_max_file_handles
  1356. Value: 32768
  1357. *************************** 452. row ***************************
  1358. Variable_name: performance_schema_max_file_instances
  1359. Value: -1
  1360. *************************** 453. row ***************************
  1361. Variable_name: performance_schema_max_index_stat
  1362. Value: -1
  1363. *************************** 454. row ***************************
  1364. Variable_name: performance_schema_max_memory_classes
  1365. Value: 450
  1366. *************************** 455. row ***************************
  1367. Variable_name: performance_schema_max_metadata_locks
  1368. Value: -1
  1369. *************************** 456. row ***************************
  1370. Variable_name: performance_schema_max_mutex_classes
  1371. Value: 300
  1372. *************************** 457. row ***************************
  1373. Variable_name: performance_schema_max_mutex_instances
  1374. Value: -1
  1375. *************************** 458. row ***************************
  1376. Variable_name: performance_schema_max_prepared_statements_instances
  1377. Value: -1
  1378. *************************** 459. row ***************************
  1379. Variable_name: performance_schema_max_program_instances
  1380. Value: -1
  1381. *************************** 460. row ***************************
  1382. Variable_name: performance_schema_max_rwlock_classes
  1383. Value: 60
  1384. *************************** 461. row ***************************
  1385. Variable_name: performance_schema_max_rwlock_instances
  1386. Value: -1
  1387. *************************** 462. row ***************************
  1388. Variable_name: performance_schema_max_socket_classes
  1389. Value: 10
  1390. *************************** 463. row ***************************
  1391. Variable_name: performance_schema_max_socket_instances
  1392. Value: -1
  1393. *************************** 464. row ***************************
  1394. Variable_name: performance_schema_max_sql_text_length
  1395. Value: 1024
  1396. *************************** 465. row ***************************
  1397. Variable_name: performance_schema_max_stage_classes
  1398. Value: 175
  1399. *************************** 466. row ***************************
  1400. Variable_name: performance_schema_max_statement_classes
  1401. Value: 218
  1402. *************************** 467. row ***************************
  1403. Variable_name: performance_schema_max_statement_stack
  1404. Value: 10
  1405. *************************** 468. row ***************************
  1406. Variable_name: performance_schema_max_table_handles
  1407. Value: -1
  1408. *************************** 469. row ***************************
  1409. Variable_name: performance_schema_max_table_instances
  1410. Value: -1
  1411. *************************** 470. row ***************************
  1412. Variable_name: performance_schema_max_table_lock_stat
  1413. Value: -1
  1414. *************************** 471. row ***************************
  1415. Variable_name: performance_schema_max_thread_classes
  1416. Value: 100
  1417. *************************** 472. row ***************************
  1418. Variable_name: performance_schema_max_thread_instances
  1419. Value: -1
  1420. *************************** 473. row ***************************
  1421. Variable_name: performance_schema_session_connect_attrs_size
  1422. Value: 512
  1423. *************************** 474. row ***************************
  1424. Variable_name: performance_schema_setup_actors_size
  1425. Value: -1
  1426. *************************** 475. row ***************************
  1427. Variable_name: performance_schema_setup_objects_size
  1428. Value: -1
  1429. *************************** 476. row ***************************
  1430. Variable_name: performance_schema_users_size
  1431. Value: -1
  1432. *************************** 477. row ***************************
  1433. Variable_name: persist_only_admin_x509_subject
  1434. Value:
  1435. *************************** 478. row ***************************
  1436. Variable_name: persisted_globals_load
  1437. Value: ON
  1438. *************************** 479. row ***************************
  1439. Variable_name: pid_file
  1440. Value: /var/run/mysqld/mysqld.pid
  1441. *************************** 480. row ***************************
  1442. Variable_name: plugin_dir
  1443. Value: /usr/lib/mysql/plugin/
  1444. *************************** 481. row ***************************
  1445. Variable_name: port
  1446. Value: 3306
  1447. *************************** 482. row ***************************
  1448. Variable_name: preload_buffer_size
  1449. Value: 32768
  1450. *************************** 483. row ***************************
  1451. Variable_name: print_identified_with_as_hex
  1452. Value: OFF
  1453. *************************** 484. row ***************************
  1454. Variable_name: profiling
  1455. Value: OFF
  1456. *************************** 485. row ***************************
  1457. Variable_name: profiling_history_size
  1458. Value: 15
  1459. *************************** 486. row ***************************
  1460. Variable_name: protocol_version
  1461. Value: 10
  1462. *************************** 487. row ***************************
  1463. Variable_name: query_alloc_block_size
  1464. Value: 8192
  1465. *************************** 488. row ***************************
  1466. Variable_name: query_prealloc_size
  1467. Value: 8192
  1468. *************************** 489. row ***************************
  1469. Variable_name: range_alloc_block_size
  1470. Value: 4096
  1471. *************************** 490. row ***************************
  1472. Variable_name: range_optimizer_max_mem_size
  1473. Value: 8388608
  1474. *************************** 491. row ***************************
  1475. Variable_name: rbr_exec_mode
  1476. Value: STRICT
  1477. *************************** 492. row ***************************
  1478. Variable_name: read_buffer_size
  1479. Value: 2097152
  1480. *************************** 493. row ***************************
  1481. Variable_name: read_only
  1482. Value: OFF
  1483. *************************** 494. row ***************************
  1484. Variable_name: read_rnd_buffer_size
  1485. Value: 2097152
  1486. *************************** 495. row ***************************
  1487. Variable_name: regexp_stack_limit
  1488. Value: 8000000
  1489. *************************** 496. row ***************************
  1490. Variable_name: regexp_time_limit
  1491. Value: 32
  1492. *************************** 497. row ***************************
  1493. Variable_name: relay_log
  1494. Value: vm7990-relay-bin
  1495. *************************** 498. row ***************************
  1496. Variable_name: relay_log_basename
  1497. Value: /var/lib/mysql/vm7990-relay-bin
  1498. *************************** 499. row ***************************
  1499. Variable_name: relay_log_index
  1500. Value: /var/lib/mysql/vm7990-relay-bin.index
  1501. *************************** 500. row ***************************
  1502. Variable_name: relay_log_info_file
  1503. Value: relay-log.info
  1504. *************************** 501. row ***************************
  1505. Variable_name: relay_log_info_repository
  1506. Value: TABLE
  1507. *************************** 502. row ***************************
  1508. Variable_name: relay_log_purge
  1509. Value: ON
  1510. *************************** 503. row ***************************
  1511. Variable_name: relay_log_recovery
  1512. Value: OFF
  1513. *************************** 504. row ***************************
  1514. Variable_name: relay_log_space_limit
  1515. Value: 0
  1516. *************************** 505. row ***************************
  1517. Variable_name: report_host
  1518. Value: 1
  1519. *************************** 506. row ***************************
  1520. Variable_name: report_password
  1521. Value:
  1522. *************************** 507. row ***************************
  1523. Variable_name: report_port
  1524. Value: 3306
  1525. *************************** 508. row ***************************
  1526. Variable_name: report_user
  1527. Value:
  1528. *************************** 509. row ***************************
  1529. Variable_name: require_secure_transport
  1530. Value: OFF
  1531. *************************** 510. row ***************************
  1532. Variable_name: rpl_read_size
  1533. Value: 8192
  1534. *************************** 511. row ***************************
  1535. Variable_name: rpl_stop_slave_timeout
  1536. Value: 31536000
  1537. *************************** 512. row ***************************
  1538. Variable_name: schema_definition_cache
  1539. Value: 256
  1540. *************************** 513. row ***************************
  1541. Variable_name: secondary_engine_cost_threshold
  1542. Value: 100000.000000
  1543. *************************** 514. row ***************************
  1544. Variable_name: secure_file_priv
  1545. Value: /var/lib/mysql-files/
  1546. *************************** 515. row ***************************
  1547. Variable_name: server_id
  1548. Value: 1
  1549. *************************** 516. row ***************************
  1550. Variable_name: server_id_bits
  1551. Value: 32
  1552. *************************** 517. row ***************************
  1553. Variable_name: server_uuid
  1554. Value: 04c1bc0c-b91c-11e9-bb6a-5254002ed13a
  1555. *************************** 518. row ***************************
  1556. Variable_name: session_track_gtids
  1557. Value: OFF
  1558. *************************** 519. row ***************************
  1559. Variable_name: session_track_schema
  1560. Value: ON
  1561. *************************** 520. row ***************************
  1562. Variable_name: session_track_state_change
  1563. Value: OFF
  1564. *************************** 521. row ***************************
  1565. Variable_name: session_track_system_variables
  1566. Value: time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  1567. *************************** 522. row ***************************
  1568. Variable_name: session_track_transaction_info
  1569. Value: OFF
  1570. *************************** 523. row ***************************
  1571. Variable_name: sha256_password_auto_generate_rsa_keys
  1572. Value: ON
  1573. *************************** 524. row ***************************
  1574. Variable_name: sha256_password_private_key_path
  1575. Value: private_key.pem
  1576. *************************** 525. row ***************************
  1577. Variable_name: sha256_password_proxy_users
  1578. Value: OFF
  1579. *************************** 526. row ***************************
  1580. Variable_name: sha256_password_public_key_path
  1581. Value: public_key.pem
  1582. *************************** 527. row ***************************
  1583. Variable_name: show_create_table_verbosity
  1584. Value: OFF
  1585. *************************** 528. row ***************************
  1586. Variable_name: show_old_temporals
  1587. Value: OFF
  1588. *************************** 529. row ***************************
  1589. Variable_name: skip_external_locking
  1590. Value: ON
  1591. *************************** 530. row ***************************
  1592. Variable_name: skip_name_resolve
  1593. Value: OFF
  1594. *************************** 531. row ***************************
  1595. Variable_name: skip_networking
  1596. Value: OFF
  1597. *************************** 532. row ***************************
  1598. Variable_name: skip_show_database
  1599. Value: OFF
  1600. *************************** 533. row ***************************
  1601. Variable_name: slave_allow_batching
  1602. Value: OFF
  1603. *************************** 534. row ***************************
  1604. Variable_name: slave_checkpoint_group
  1605. Value: 512
  1606. *************************** 535. row ***************************
  1607. Variable_name: slave_checkpoint_period
  1608. Value: 300
  1609. *************************** 536. row ***************************
  1610. Variable_name: slave_compressed_protocol
  1611. Value: OFF
  1612. *************************** 537. row ***************************
  1613. Variable_name: slave_exec_mode
  1614. Value: STRICT
  1615. *************************** 538. row ***************************
  1616. Variable_name: slave_load_tmpdir
  1617. Value: /tmp
  1618. *************************** 539. row ***************************
  1619. Variable_name: slave_max_allowed_packet
  1620. Value: 1073741824
  1621. *************************** 540. row ***************************
  1622. Variable_name: slave_net_timeout
  1623. Value: 60
  1624. *************************** 541. row ***************************
  1625. Variable_name: slave_parallel_type
  1626. Value: DATABASE
  1627. *************************** 542. row ***************************
  1628. Variable_name: slave_parallel_workers
  1629. Value: 0
  1630. *************************** 543. row ***************************
  1631. Variable_name: slave_pending_jobs_size_max
  1632. Value: 134217728
  1633. *************************** 544. row ***************************
  1634. Variable_name: slave_preserve_commit_order
  1635. Value: OFF
  1636. *************************** 545. row ***************************
  1637. Variable_name: slave_rows_search_algorithms
  1638. Value: INDEX_SCAN,HASH_SCAN
  1639. *************************** 546. row ***************************
  1640. Variable_name: slave_skip_errors
  1641. Value: OFF
  1642. *************************** 547. row ***************************
  1643. Variable_name: slave_sql_verify_checksum
  1644. Value: ON
  1645. *************************** 548. row ***************************
  1646. Variable_name: slave_transaction_retries
  1647. Value: 10
  1648. *************************** 549. row ***************************
  1649. Variable_name: slave_type_conversions
  1650. Value:
  1651. *************************** 550. row ***************************
  1652. Variable_name: slow_launch_time
  1653. Value: 2
  1654. *************************** 551. row ***************************
  1655. Variable_name: slow_query_log
  1656. Value: OFF
  1657. *************************** 552. row ***************************
  1658. Variable_name: slow_query_log_file
  1659. Value: /var/lib/mysql/1-slow.log
  1660. *************************** 553. row ***************************
  1661. Variable_name: socket
  1662. Value: /var/run/mysqld/mysqld.sock
  1663. *************************** 554. row ***************************
  1664. Variable_name: sort_buffer_size
  1665. Value: 4194304
  1666. *************************** 555. row ***************************
  1667. Variable_name: sql_auto_is_null
  1668. Value: OFF
  1669. *************************** 556. row ***************************
  1670. Variable_name: sql_big_selects
  1671. Value: ON
  1672. *************************** 557. row ***************************
  1673. Variable_name: sql_buffer_result
  1674. Value: OFF
  1675. *************************** 558. row ***************************
  1676. Variable_name: sql_log_off
  1677. Value: OFF
  1678. *************************** 559. row ***************************
  1679. Variable_name: sql_mode
  1680. Value: NO_ENGINE_SUBSTITUTION
  1681. *************************** 560. row ***************************
  1682. Variable_name: sql_notes
  1683. Value: ON
  1684. *************************** 561. row ***************************
  1685. Variable_name: sql_quote_show_create
  1686. Value: ON
  1687. *************************** 562. row ***************************
  1688. Variable_name: sql_require_primary_key
  1689. Value: OFF
  1690. *************************** 563. row ***************************
  1691. Variable_name: sql_safe_updates
  1692. Value: OFF
  1693. *************************** 564. row ***************************
  1694. Variable_name: sql_select_limit
  1695. Value: 18446744073709551615
  1696. *************************** 565. row ***************************
  1697. Variable_name: sql_slave_skip_counter
  1698. Value: 0
  1699. *************************** 566. row ***************************
  1700. Variable_name: sql_warnings
  1701. Value: OFF
  1702. *************************** 567. row ***************************
  1703. Variable_name: ssl_ca
  1704. Value: ca.pem
  1705. *************************** 568. row ***************************
  1706. Variable_name: ssl_capath
  1707. Value:
  1708. *************************** 569. row ***************************
  1709. Variable_name: ssl_cert
  1710. Value: server-cert.pem
  1711. *************************** 570. row ***************************
  1712. Variable_name: ssl_cipher
  1713. Value:
  1714. *************************** 571. row ***************************
  1715. Variable_name: ssl_crl
  1716. Value:
  1717. *************************** 572. row ***************************
  1718. Variable_name: ssl_crlpath
  1719. Value:
  1720. *************************** 573. row ***************************
  1721. Variable_name: ssl_fips_mode
  1722. Value: OFF
  1723. *************************** 574. row ***************************
  1724. Variable_name: ssl_key
  1725. Value: server-key.pem
  1726. *************************** 575. row ***************************
  1727. Variable_name: stored_program_cache
  1728. Value: 256
  1729. *************************** 576. row ***************************
  1730. Variable_name: stored_program_definition_cache
  1731. Value: 256
  1732. *************************** 577. row ***************************
  1733. Variable_name: super_read_only
  1734. Value: OFF
  1735. *************************** 578. row ***************************
  1736. Variable_name: sync_binlog
  1737. Value: 1
  1738. *************************** 579. row ***************************
  1739. Variable_name: sync_master_info
  1740. Value: 10000
  1741. *************************** 580. row ***************************
  1742. Variable_name: sync_relay_log
  1743. Value: 10000
  1744. *************************** 581. row ***************************
  1745. Variable_name: sync_relay_log_info
  1746. Value: 10000
  1747. *************************** 582. row ***************************
  1748. Variable_name: system_time_zone
  1749. Value: CET
  1750. *************************** 583. row ***************************
  1751. Variable_name: table_definition_cache
  1752. Value: 2000
  1753. *************************** 584. row ***************************
  1754. Variable_name: table_encryption_privilege_check
  1755. Value: OFF
  1756. *************************** 585. row ***************************
  1757. Variable_name: table_open_cache
  1758. Value: 3459
  1759. *************************** 586. row ***************************
  1760. Variable_name: table_open_cache_instances
  1761. Value: 16
  1762. *************************** 587. row ***************************
  1763. Variable_name: tablespace_definition_cache
  1764. Value: 256
  1765. *************************** 588. row ***************************
  1766. Variable_name: temptable_max_ram
  1767. Value: 1073741824
  1768. *************************** 589. row ***************************
  1769. Variable_name: temptable_use_mmap
  1770. Value: ON
  1771. *************************** 590. row ***************************
  1772. Variable_name: thread_cache_size
  1773. Value: 96
  1774. *************************** 591. row ***************************
  1775. Variable_name: thread_handling
  1776. Value: one-thread-per-connection
  1777. *************************** 592. row ***************************
  1778. Variable_name: thread_stack
  1779. Value: 262144
  1780. *************************** 593. row ***************************
  1781. Variable_name: time_zone
  1782. Value: SYSTEM
  1783. *************************** 594. row ***************************
  1784. Variable_name: tls_ciphersuites
  1785. Value:
  1786. *************************** 595. row ***************************
  1787. Variable_name: tls_version
  1788. Value: TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
  1789. *************************** 596. row ***************************
  1790. Variable_name: tmp_table_size
  1791. Value: 201326592
  1792. *************************** 597. row ***************************
  1793. Variable_name: tmpdir
  1794. Value: /tmp
  1795. *************************** 598. row ***************************
  1796. Variable_name: transaction_alloc_block_size
  1797. Value: 8192
  1798. *************************** 599. row ***************************
  1799. Variable_name: transaction_isolation
  1800. Value: READ-COMMITTED
  1801. *************************** 600. row ***************************
  1802. Variable_name: transaction_prealloc_size
  1803. Value: 4096
  1804. *************************** 601. row ***************************
  1805. Variable_name: transaction_read_only
  1806. Value: OFF
  1807. *************************** 602. row ***************************
  1808. Variable_name: transaction_write_set_extraction
  1809. Value: XXHASH64
  1810. *************************** 603. row ***************************
  1811. Variable_name: unique_checks
  1812. Value: ON
  1813. *************************** 604. row ***************************
  1814. Variable_name: updatable_views_with_limit
  1815. Value: YES
  1816. *************************** 605. row ***************************
  1817. Variable_name: version
  1818. Value: 8.0.17
  1819. *************************** 606. row ***************************
  1820. Variable_name: version_comment
  1821. Value: MySQL Community Server - GPL
  1822. *************************** 607. row ***************************
  1823. Variable_name: version_compile_machine
  1824. Value: x86_64
  1825. *************************** 608. row ***************************
  1826. Variable_name: version_compile_os
  1827. Value: Linux
  1828. *************************** 609. row ***************************
  1829. Variable_name: version_compile_zlib
  1830. Value: 1.2.11
  1831. *************************** 610. row ***************************
  1832. Variable_name: wait_timeout
  1833. Value: 720
  1834. *************************** 611. row ***************************
  1835. Variable_name: windowing_use_high_precision
  1836. Value: ON
  1837. 611 rows in set (0.01 sec)
Advertisement
RAW Paste Data Copied
Advertisement