API tools faq
paste
Advertisement
Guest User

SHOW VARIABLES MySQL

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