Advertisement
Guest User

SHOW VARIABLES MariaDB

a guest
Feb 18th, 2022
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 84.70 KB | None | 0 0
  1. *************************** 1. row ***************************
  2. Variable_name: alter_algorithm
  3. Value: DEFAULT
  4. *************************** 2. row ***************************
  5. Variable_name: analyze_sample_percentage
  6. Value: 100.000000
  7. *************************** 3. row ***************************
  8. Variable_name: aria_block_size
  9. Value: 8192
  10. *************************** 4. row ***************************
  11. Variable_name: aria_checkpoint_interval
  12. Value: 30
  13. *************************** 5. row ***************************
  14. Variable_name: aria_checkpoint_log_activity
  15. Value: 1048576
  16. *************************** 6. row ***************************
  17. Variable_name: aria_encrypt_tables
  18. Value: OFF
  19. *************************** 7. row ***************************
  20. Variable_name: aria_force_start_after_recovery_failures
  21. Value: 0
  22. *************************** 8. row ***************************
  23. Variable_name: aria_group_commit
  24. Value: none
  25. *************************** 9. row ***************************
  26. Variable_name: aria_group_commit_interval
  27. Value: 0
  28. *************************** 10. row ***************************
  29. Variable_name: aria_log_file_size
  30. Value: 1073741824
  31. *************************** 11. row ***************************
  32. Variable_name: aria_log_purge_type
  33. Value: immediate
  34. *************************** 12. row ***************************
  35. Variable_name: aria_max_sort_file_size
  36. Value: 9223372036853727232
  37. *************************** 13. row ***************************
  38. Variable_name: aria_page_checksum
  39. Value: ON
  40. *************************** 14. row ***************************
  41. Variable_name: aria_pagecache_age_threshold
  42. Value: 300
  43. *************************** 15. row ***************************
  44. Variable_name: aria_pagecache_buffer_size
  45. Value: 134217728
  46. *************************** 16. row ***************************
  47. Variable_name: aria_pagecache_division_limit
  48. Value: 100
  49. *************************** 17. row ***************************
  50. Variable_name: aria_pagecache_file_hash_size
  51. Value: 512
  52. *************************** 18. row ***************************
  53. Variable_name: aria_recover_options
  54. Value: BACKUP,QUICK
  55. *************************** 19. row ***************************
  56. Variable_name: aria_repair_threads
  57. Value: 1
  58. *************************** 20. row ***************************
  59. Variable_name: aria_sort_buffer_size
  60. Value: 268434432
  61. *************************** 21. row ***************************
  62. Variable_name: aria_stats_method
  63. Value: nulls_unequal
  64. *************************** 22. row ***************************
  65. Variable_name: aria_sync_log_dir
  66. Value: NEWFILE
  67. *************************** 23. row ***************************
  68. Variable_name: aria_used_for_temp_tables
  69. Value: ON
  70. *************************** 24. row ***************************
  71. Variable_name: auto_increment_increment
  72. Value: 1
  73. *************************** 25. row ***************************
  74. Variable_name: auto_increment_offset
  75. Value: 1
  76. *************************** 26. row ***************************
  77. Variable_name: autocommit
  78. Value: ON
  79. *************************** 27. row ***************************
  80. Variable_name: automatic_sp_privileges
  81. Value: ON
  82. *************************** 28. row ***************************
  83. Variable_name: back_log
  84. Value: 80
  85. *************************** 29. row ***************************
  86. Variable_name: basedir
  87. Value: /usr/
  88. *************************** 30. row ***************************
  89. Variable_name: big_tables
  90. Value: OFF
  91. *************************** 31. row ***************************
  92. Variable_name: bind_address
  93. Value: 0.0.0.0
  94. *************************** 32. row ***************************
  95. Variable_name: binlog_annotate_row_events
  96. Value: ON
  97. *************************** 33. row ***************************
  98. Variable_name: binlog_cache_size
  99. Value: 32768
  100. *************************** 34. row ***************************
  101. Variable_name: binlog_checksum
  102. Value: CRC32
  103. *************************** 35. row ***************************
  104. Variable_name: binlog_commit_wait_count
  105. Value: 0
  106. *************************** 36. row ***************************
  107. Variable_name: binlog_commit_wait_usec
  108. Value: 100000
  109. *************************** 37. row ***************************
  110. Variable_name: binlog_direct_non_transactional_updates
  111. Value: OFF
  112. *************************** 38. row ***************************
  113. Variable_name: binlog_file_cache_size
  114. Value: 16384
  115. *************************** 39. row ***************************
  116. Variable_name: binlog_format
  117. Value: ROW
  118. *************************** 40. row ***************************
  119. Variable_name: binlog_optimize_thread_scheduling
  120. Value: ON
  121. *************************** 41. row ***************************
  122. Variable_name: binlog_row_image
  123. Value: FULL
  124. *************************** 42. row ***************************
  125. Variable_name: binlog_row_metadata
  126. Value: NO_LOG
  127. *************************** 43. row ***************************
  128. Variable_name: binlog_stmt_cache_size
  129. Value: 32768
  130. *************************** 44. row ***************************
  131. Variable_name: bulk_insert_buffer_size
  132. Value: 8388608
  133. *************************** 45. row ***************************
  134. Variable_name: character_set_client
  135. Value: utf8mb4
  136. *************************** 46. row ***************************
  137. Variable_name: character_set_connection
  138. Value: utf8mb4
  139. *************************** 47. row ***************************
  140. Variable_name: character_set_database
  141. Value: utf8mb4
  142. *************************** 48. row ***************************
  143. Variable_name: character_set_filesystem
  144. Value: binary
  145. *************************** 49. row ***************************
  146. Variable_name: character_set_results
  147. Value: utf8mb4
  148. *************************** 50. row ***************************
  149. Variable_name: character_set_server
  150. Value: utf8mb4
  151. *************************** 51. row ***************************
  152. Variable_name: character_set_system
  153. Value: utf8
  154. *************************** 52. row ***************************
  155. Variable_name: character_sets_dir
  156. Value: /usr/share/mysql/charsets/
  157. *************************** 53. row ***************************
  158. Variable_name: check_constraint_checks
  159. Value: ON
  160. *************************** 54. row ***************************
  161. Variable_name: collation_connection
  162. Value: utf8mb4_general_ci
  163. *************************** 55. row ***************************
  164. Variable_name: collation_database
  165. Value: utf8mb4_unicode_ci
  166. *************************** 56. row ***************************
  167. Variable_name: collation_server
  168. Value: utf8mb4_unicode_ci
  169. *************************** 57. row ***************************
  170. Variable_name: column_compression_threshold
  171. Value: 100
  172. *************************** 58. row ***************************
  173. Variable_name: column_compression_zlib_level
  174. Value: 6
  175. *************************** 59. row ***************************
  176. Variable_name: column_compression_zlib_strategy
  177. Value: DEFAULT_STRATEGY
  178. *************************** 60. row ***************************
  179. Variable_name: column_compression_zlib_wrap
  180. Value: OFF
  181. *************************** 61. row ***************************
  182. Variable_name: completion_type
  183. Value: NO_CHAIN
  184. *************************** 62. row ***************************
  185. Variable_name: concurrent_insert
  186. Value: AUTO
  187. *************************** 63. row ***************************
  188. Variable_name: connect_timeout
  189. Value: 10
  190. *************************** 64. row ***************************
  191. Variable_name: core_file
  192. Value: OFF
  193. *************************** 65. row ***************************
  194. Variable_name: datadir
  195. Value: /home/mysql/
  196. *************************** 66. row ***************************
  197. Variable_name: date_format
  198. Value: %Y-%m-%d
  199. *************************** 67. row ***************************
  200. Variable_name: datetime_format
  201. Value: %Y-%m-%d %H:%i:%s
  202. *************************** 68. row ***************************
  203. Variable_name: deadlock_search_depth_long
  204. Value: 15
  205. *************************** 69. row ***************************
  206. Variable_name: deadlock_search_depth_short
  207. Value: 4
  208. *************************** 70. row ***************************
  209. Variable_name: deadlock_timeout_long
  210. Value: 50000000
  211. *************************** 71. row ***************************
  212. Variable_name: deadlock_timeout_short
  213. Value: 10000
  214. *************************** 72. row ***************************
  215. Variable_name: debug_no_thread_alarm
  216. Value: OFF
  217. *************************** 73. row ***************************
  218. Variable_name: default_master_connection
  219. Value:
  220. *************************** 74. row ***************************
  221. Variable_name: default_password_lifetime
  222. Value: 0
  223. *************************** 75. row ***************************
  224. Variable_name: default_regex_flags
  225. Value:
  226. *************************** 76. row ***************************
  227. Variable_name: default_storage_engine
  228. Value: InnoDB
  229. *************************** 77. row ***************************
  230. Variable_name: default_tmp_storage_engine
  231. Value:
  232. *************************** 78. row ***************************
  233. Variable_name: default_week_format
  234. Value: 0
  235. *************************** 79. row ***************************
  236. Variable_name: delay_key_write
  237. Value: ON
  238. *************************** 80. row ***************************
  239. Variable_name: delayed_insert_limit
  240. Value: 100
  241. *************************** 81. row ***************************
  242. Variable_name: delayed_insert_timeout
  243. Value: 300
  244. *************************** 82. row ***************************
  245. Variable_name: delayed_queue_size
  246. Value: 1000
  247. *************************** 83. row ***************************
  248. Variable_name: disconnect_on_expired_password
  249. Value: OFF
  250. *************************** 84. row ***************************
  251. Variable_name: div_precision_increment
  252. Value: 4
  253. *************************** 85. row ***************************
  254. Variable_name: encrypt_binlog
  255. Value: OFF
  256. *************************** 86. row ***************************
  257. Variable_name: encrypt_tmp_disk_tables
  258. Value: OFF
  259. *************************** 87. row ***************************
  260. Variable_name: encrypt_tmp_files
  261. Value: OFF
  262. *************************** 88. row ***************************
  263. Variable_name: enforce_storage_engine
  264. Value:
  265. *************************** 89. row ***************************
  266. Variable_name: eq_range_index_dive_limit
  267. Value: 200
  268. *************************** 90. row ***************************
  269. Variable_name: error_count
  270. Value: 0
  271. *************************** 91. row ***************************
  272. Variable_name: event_scheduler
  273. Value: OFF
  274. *************************** 92. row ***************************
  275. Variable_name: expensive_subquery_limit
  276. Value: 100
  277. *************************** 93. row ***************************
  278. Variable_name: expire_logs_days
  279. Value: 0
  280. *************************** 94. row ***************************
  281. Variable_name: explicit_defaults_for_timestamp
  282. Value: OFF
  283. *************************** 95. row ***************************
  284. Variable_name: external_user
  285. Value:
  286. *************************** 96. row ***************************
  287. Variable_name: extra_max_connections
  288. Value: 1
  289. *************************** 97. row ***************************
  290. Variable_name: extra_port
  291. Value: 0
  292. *************************** 98. row ***************************
  293. Variable_name: flush
  294. Value: OFF
  295. *************************** 99. row ***************************
  296. Variable_name: flush_time
  297. Value: 0
  298. *************************** 100. row ***************************
  299. Variable_name: foreign_key_checks
  300. Value: ON
  301. *************************** 101. row ***************************
  302. Variable_name: ft_boolean_syntax
  303. Value: + -><()~*:""&|
  304. *************************** 102. row ***************************
  305. Variable_name: ft_max_word_len
  306. Value: 84
  307. *************************** 103. row ***************************
  308. Variable_name: ft_min_word_len
  309. Value: 4
  310. *************************** 104. row ***************************
  311. Variable_name: ft_query_expansion_limit
  312. Value: 20
  313. *************************** 105. row ***************************
  314. Variable_name: ft_stopword_file
  315. Value: (built-in)
  316. *************************** 106. row ***************************
  317. Variable_name: general_log
  318. Value: OFF
  319. *************************** 107. row ***************************
  320. Variable_name: general_log_file
  321. Value: portail-probance.log
  322. *************************** 108. row ***************************
  323. Variable_name: group_concat_max_len
  324. Value: 1048576
  325. *************************** 109. row ***************************
  326. Variable_name: gtid_binlog_pos
  327. Value:
  328. *************************** 110. row ***************************
  329. Variable_name: gtid_binlog_state
  330. Value:
  331. *************************** 111. row ***************************
  332. Variable_name: gtid_cleanup_batch_size
  333. Value: 64
  334. *************************** 112. row ***************************
  335. Variable_name: gtid_current_pos
  336. Value:
  337. *************************** 113. row ***************************
  338. Variable_name: gtid_domain_id
  339. Value: 0
  340. *************************** 114. row ***************************
  341. Variable_name: gtid_ignore_duplicates
  342. Value: OFF
  343. *************************** 115. row ***************************
  344. Variable_name: gtid_pos_auto_engines
  345. Value:
  346. *************************** 116. row ***************************
  347. Variable_name: gtid_seq_no
  348. Value: 0
  349. *************************** 117. row ***************************
  350. Variable_name: gtid_slave_pos
  351. Value:
  352. *************************** 118. row ***************************
  353. Variable_name: gtid_strict_mode
  354. Value: OFF
  355. *************************** 119. row ***************************
  356. Variable_name: have_compress
  357. Value: YES
  358. *************************** 120. row ***************************
  359. Variable_name: have_crypt
  360. Value: YES
  361. *************************** 121. row ***************************
  362. Variable_name: have_dynamic_loading
  363. Value: YES
  364. *************************** 122. row ***************************
  365. Variable_name: have_geometry
  366. Value: YES
  367. *************************** 123. row ***************************
  368. Variable_name: have_openssl
  369. Value: YES
  370. *************************** 124. row ***************************
  371. Variable_name: have_profiling
  372. Value: YES
  373. *************************** 125. row ***************************
  374. Variable_name: have_query_cache
  375. Value: YES
  376. *************************** 126. row ***************************
  377. Variable_name: have_rtree_keys
  378. Value: YES
  379. *************************** 127. row ***************************
  380. Variable_name: have_ssl
  381. Value: DISABLED
  382. *************************** 128. row ***************************
  383. Variable_name: have_symlink
  384. Value: YES
  385. *************************** 129. row ***************************
  386. Variable_name: histogram_size
  387. Value: 254
  388. *************************** 130. row ***************************
  389. Variable_name: histogram_type
  390. Value: DOUBLE_PREC_HB
  391. *************************** 131. row ***************************
  392. Variable_name: host_cache_size
  393. Value: 279
  394. *************************** 132. row ***************************
  395. Variable_name: hostname
  396. Value: portail-probance
  397. *************************** 133. row ***************************
  398. Variable_name: identity
  399. Value: 0
  400. *************************** 134. row ***************************
  401. Variable_name: idle_readonly_transaction_timeout
  402. Value: 0
  403. *************************** 135. row ***************************
  404. Variable_name: idle_transaction_timeout
  405. Value: 0
  406. *************************** 136. row ***************************
  407. Variable_name: idle_write_transaction_timeout
  408. Value: 0
  409. *************************** 137. row ***************************
  410. Variable_name: ignore_builtin_innodb
  411. Value: OFF
  412. *************************** 138. row ***************************
  413. Variable_name: ignore_db_dirs
  414. Value:
  415. *************************** 139. row ***************************
  416. Variable_name: in_predicate_conversion_threshold
  417. Value: 1000
  418. *************************** 140. row ***************************
  419. Variable_name: in_transaction
  420. Value: 0
  421. *************************** 141. row ***************************
  422. Variable_name: init_connect
  423. Value:
  424. *************************** 142. row ***************************
  425. Variable_name: init_file
  426. Value:
  427. *************************** 143. row ***************************
  428. Variable_name: init_slave
  429. Value:
  430. *************************** 144. row ***************************
  431. Variable_name: innodb_adaptive_flushing
  432. Value: ON
  433. *************************** 145. row ***************************
  434. Variable_name: innodb_adaptive_flushing_lwm
  435. Value: 10.000000
  436. *************************** 146. row ***************************
  437. Variable_name: innodb_adaptive_hash_index
  438. Value: OFF
  439. *************************** 147. row ***************************
  440. Variable_name: innodb_adaptive_hash_index_parts
  441. Value: 8
  442. *************************** 148. row ***************************
  443. Variable_name: innodb_adaptive_max_sleep_delay
  444. Value: 0
  445. *************************** 149. row ***************************
  446. Variable_name: innodb_autoextend_increment
  447. Value: 64
  448. *************************** 150. row ***************************
  449. Variable_name: innodb_autoinc_lock_mode
  450. Value: 2
  451. *************************** 151. row ***************************
  452. Variable_name: innodb_background_scrub_data_check_interval
  453. Value: 0
  454. *************************** 152. row ***************************
  455. Variable_name: innodb_background_scrub_data_compressed
  456. Value: OFF
  457. *************************** 153. row ***************************
  458. Variable_name: innodb_background_scrub_data_interval
  459. Value: 0
  460. *************************** 154. row ***************************
  461. Variable_name: innodb_background_scrub_data_uncompressed
  462. Value: OFF
  463. *************************** 155. row ***************************
  464. Variable_name: innodb_buf_dump_status_frequency
  465. Value: 0
  466. *************************** 156. row ***************************
  467. Variable_name: innodb_buffer_pool_chunk_size
  468. Value: 134217728
  469. *************************** 157. row ***************************
  470. Variable_name: innodb_buffer_pool_dump_at_shutdown
  471. Value: ON
  472. *************************** 158. row ***************************
  473. Variable_name: innodb_buffer_pool_dump_now
  474. Value: OFF
  475. *************************** 159. row ***************************
  476. Variable_name: innodb_buffer_pool_dump_pct
  477. Value: 25
  478. *************************** 160. row ***************************
  479. Variable_name: innodb_buffer_pool_filename
  480. Value: ib_buffer_pool
  481. *************************** 161. row ***************************
  482. Variable_name: innodb_buffer_pool_instances
  483. Value: 1
  484. *************************** 162. row ***************************
  485. Variable_name: innodb_buffer_pool_load_abort
  486. Value: OFF
  487. *************************** 163. row ***************************
  488. Variable_name: innodb_buffer_pool_load_at_startup
  489. Value: ON
  490. *************************** 164. row ***************************
  491. Variable_name: innodb_buffer_pool_load_now
  492. Value: OFF
  493. *************************** 165. row ***************************
  494. Variable_name: innodb_buffer_pool_size
  495. Value: 134217728
  496. *************************** 166. row ***************************
  497. Variable_name: innodb_change_buffer_max_size
  498. Value: 25
  499. *************************** 167. row ***************************
  500. Variable_name: innodb_change_buffering
  501. Value: all
  502. *************************** 168. row ***************************
  503. Variable_name: innodb_checksum_algorithm
  504. Value: full_crc32
  505. *************************** 169. row ***************************
  506. Variable_name: innodb_cmp_per_index_enabled
  507. Value: OFF
  508. *************************** 170. row ***************************
  509. Variable_name: innodb_commit_concurrency
  510. Value: 0
  511. *************************** 171. row ***************************
  512. Variable_name: innodb_compression_algorithm
  513. Value: zlib
  514. *************************** 172. row ***************************
  515. Variable_name: innodb_compression_default
  516. Value: OFF
  517. *************************** 173. row ***************************
  518. Variable_name: innodb_compression_failure_threshold_pct
  519. Value: 5
  520. *************************** 174. row ***************************
  521. Variable_name: innodb_compression_level
  522. Value: 6
  523. *************************** 175. row ***************************
  524. Variable_name: innodb_compression_pad_pct_max
  525. Value: 50
  526. *************************** 176. row ***************************
  527. Variable_name: innodb_concurrency_tickets
  528. Value: 0
  529. *************************** 177. row ***************************
  530. Variable_name: innodb_data_file_path
  531. Value: ibdata1:12M:autoextend
  532. *************************** 178. row ***************************
  533. Variable_name: innodb_data_home_dir
  534. Value:
  535. *************************** 179. row ***************************
  536. Variable_name: innodb_deadlock_detect
  537. Value: ON
  538. *************************** 180. row ***************************
  539. Variable_name: innodb_default_encryption_key_id
  540. Value: 1
  541. *************************** 181. row ***************************
  542. Variable_name: innodb_default_row_format
  543. Value: dynamic
  544. *************************** 182. row ***************************
  545. Variable_name: innodb_defragment
  546. Value: OFF
  547. *************************** 183. row ***************************
  548. Variable_name: innodb_defragment_fill_factor
  549. Value: 0.900000
  550. *************************** 184. row ***************************
  551. Variable_name: innodb_defragment_fill_factor_n_recs
  552. Value: 20
  553. *************************** 185. row ***************************
  554. Variable_name: innodb_defragment_frequency
  555. Value: 40
  556. *************************** 186. row ***************************
  557. Variable_name: innodb_defragment_n_pages
  558. Value: 7
  559. *************************** 187. row ***************************
  560. Variable_name: innodb_defragment_stats_accuracy
  561. Value: 0
  562. *************************** 188. row ***************************
  563. Variable_name: innodb_disable_sort_file_cache
  564. Value: OFF
  565. *************************** 189. row ***************************
  566. Variable_name: innodb_disallow_writes
  567. Value: OFF
  568. *************************** 190. row ***************************
  569. Variable_name: innodb_doublewrite
  570. Value: ON
  571. *************************** 191. row ***************************
  572. Variable_name: innodb_encrypt_log
  573. Value: OFF
  574. *************************** 192. row ***************************
  575. Variable_name: innodb_encrypt_tables
  576. Value: OFF
  577. *************************** 193. row ***************************
  578. Variable_name: innodb_encrypt_temporary_tables
  579. Value: OFF
  580. *************************** 194. row ***************************
  581. Variable_name: innodb_encryption_rotate_key_age
  582. Value: 1
  583. *************************** 195. row ***************************
  584. Variable_name: innodb_encryption_rotation_iops
  585. Value: 100
  586. *************************** 196. row ***************************
  587. Variable_name: innodb_encryption_threads
  588. Value: 0
  589. *************************** 197. row ***************************
  590. Variable_name: innodb_fast_shutdown
  591. Value: 1
  592. *************************** 198. row ***************************
  593. Variable_name: innodb_fatal_semaphore_wait_threshold
  594. Value: 600
  595. *************************** 199. row ***************************
  596. Variable_name: innodb_file_format
  597. Value:
  598. *************************** 200. row ***************************
  599. Variable_name: innodb_file_per_table
  600. Value: ON
  601. *************************** 201. row ***************************
  602. Variable_name: innodb_fill_factor
  603. Value: 100
  604. *************************** 202. row ***************************
  605. Variable_name: innodb_flush_log_at_timeout
  606. Value: 1
  607. *************************** 203. row ***************************
  608. Variable_name: innodb_flush_log_at_trx_commit
  609. Value: 1
  610. *************************** 204. row ***************************
  611. Variable_name: innodb_flush_method
  612. Value: fsync
  613. *************************** 205. row ***************************
  614. Variable_name: innodb_flush_neighbors
  615. Value: 1
  616. *************************** 206. row ***************************
  617. Variable_name: innodb_flush_sync
  618. Value: ON
  619. *************************** 207. row ***************************
  620. Variable_name: innodb_flushing_avg_loops
  621. Value: 30
  622. *************************** 208. row ***************************
  623. Variable_name: innodb_force_load_corrupted
  624. Value: OFF
  625. *************************** 209. row ***************************
  626. Variable_name: innodb_force_primary_key
  627. Value: OFF
  628. *************************** 210. row ***************************
  629. Variable_name: innodb_force_recovery
  630. Value: 0
  631. *************************** 211. row ***************************
  632. Variable_name: innodb_ft_aux_table
  633. Value:
  634. *************************** 212. row ***************************
  635. Variable_name: innodb_ft_cache_size
  636. Value: 8000000
  637. *************************** 213. row ***************************
  638. Variable_name: innodb_ft_enable_diag_print
  639. Value: OFF
  640. *************************** 214. row ***************************
  641. Variable_name: innodb_ft_enable_stopword
  642. Value: ON
  643. *************************** 215. row ***************************
  644. Variable_name: innodb_ft_max_token_size
  645. Value: 84
  646. *************************** 216. row ***************************
  647. Variable_name: innodb_ft_min_token_size
  648. Value: 3
  649. *************************** 217. row ***************************
  650. Variable_name: innodb_ft_num_word_optimize
  651. Value: 2000
  652. *************************** 218. row ***************************
  653. Variable_name: innodb_ft_result_cache_limit
  654. Value: 2000000000
  655. *************************** 219. row ***************************
  656. Variable_name: innodb_ft_server_stopword_table
  657. Value:
  658. *************************** 220. row ***************************
  659. Variable_name: innodb_ft_sort_pll_degree
  660. Value: 2
  661. *************************** 221. row ***************************
  662. Variable_name: innodb_ft_total_cache_size
  663. Value: 640000000
  664. *************************** 222. row ***************************
  665. Variable_name: innodb_ft_user_stopword_table
  666. Value:
  667. *************************** 223. row ***************************
  668. Variable_name: innodb_immediate_scrub_data_uncompressed
  669. Value: OFF
  670. *************************** 224. row ***************************
  671. Variable_name: innodb_instant_alter_column_allowed
  672. Value: add_drop_reorder
  673. *************************** 225. row ***************************
  674. Variable_name: innodb_io_capacity
  675. Value: 200
  676. *************************** 226. row ***************************
  677. Variable_name: innodb_io_capacity_max
  678. Value: 2000
  679. *************************** 227. row ***************************
  680. Variable_name: innodb_large_prefix
  681. Value:
  682. *************************** 228. row ***************************
  683. Variable_name: innodb_lock_schedule_algorithm
  684. Value: fcfs
  685. *************************** 229. row ***************************
  686. Variable_name: innodb_lock_wait_timeout
  687. Value: 50
  688. *************************** 230. row ***************************
  689. Variable_name: innodb_log_buffer_size
  690. Value: 16777216
  691. *************************** 231. row ***************************
  692. Variable_name: innodb_log_checksums
  693. Value: ON
  694. *************************** 232. row ***************************
  695. Variable_name: innodb_log_compressed_pages
  696. Value: ON
  697. *************************** 233. row ***************************
  698. Variable_name: innodb_log_file_size
  699. Value: 100663296
  700. *************************** 234. row ***************************
  701. Variable_name: innodb_log_files_in_group
  702. Value: 1
  703. *************************** 235. row ***************************
  704. Variable_name: innodb_log_group_home_dir
  705. Value: ./
  706. *************************** 236. row ***************************
  707. Variable_name: innodb_log_optimize_ddl
  708. Value: OFF
  709. *************************** 237. row ***************************
  710. Variable_name: innodb_log_write_ahead_size
  711. Value: 8192
  712. *************************** 238. row ***************************
  713. Variable_name: innodb_lru_flush_size
  714. Value: 32
  715. *************************** 239. row ***************************
  716. Variable_name: innodb_lru_scan_depth
  717. Value: 1536
  718. *************************** 240. row ***************************
  719. Variable_name: innodb_max_dirty_pages_pct
  720. Value: 90.000000
  721. *************************** 241. row ***************************
  722. Variable_name: innodb_max_dirty_pages_pct_lwm
  723. Value: 0.000000
  724. *************************** 242. row ***************************
  725. Variable_name: innodb_max_purge_lag
  726. Value: 0
  727. *************************** 243. row ***************************
  728. Variable_name: innodb_max_purge_lag_delay
  729. Value: 0
  730. *************************** 244. row ***************************
  731. Variable_name: innodb_max_purge_lag_wait
  732. Value: 4294967295
  733. *************************** 245. row ***************************
  734. Variable_name: innodb_max_undo_log_size
  735. Value: 10485760
  736. *************************** 246. row ***************************
  737. Variable_name: innodb_monitor_disable
  738. Value:
  739. *************************** 247. row ***************************
  740. Variable_name: innodb_monitor_enable
  741. Value:
  742. *************************** 248. row ***************************
  743. Variable_name: innodb_monitor_reset
  744. Value:
  745. *************************** 249. row ***************************
  746. Variable_name: innodb_monitor_reset_all
  747. Value:
  748. *************************** 250. row ***************************
  749. Variable_name: innodb_old_blocks_pct
  750. Value: 37
  751. *************************** 251. row ***************************
  752. Variable_name: innodb_old_blocks_time
  753. Value: 1000
  754. *************************** 252. row ***************************
  755. Variable_name: innodb_online_alter_log_max_size
  756. Value: 134217728
  757. *************************** 253. row ***************************
  758. Variable_name: innodb_open_files
  759. Value: 2000
  760. *************************** 254. row ***************************
  761. Variable_name: innodb_optimize_fulltext_only
  762. Value: OFF
  763. *************************** 255. row ***************************
  764. Variable_name: innodb_page_cleaners
  765. Value: 1
  766. *************************** 256. row ***************************
  767. Variable_name: innodb_page_size
  768. Value: 16384
  769. *************************** 257. row ***************************
  770. Variable_name: innodb_prefix_index_cluster_optimization
  771. Value: OFF
  772. *************************** 258. row ***************************
  773. Variable_name: innodb_print_all_deadlocks
  774. Value: OFF
  775. *************************** 259. row ***************************
  776. Variable_name: innodb_purge_batch_size
  777. Value: 300
  778. *************************** 260. row ***************************
  779. Variable_name: innodb_purge_rseg_truncate_frequency
  780. Value: 128
  781. *************************** 261. row ***************************
  782. Variable_name: innodb_purge_threads
  783. Value: 4
  784. *************************** 262. row ***************************
  785. Variable_name: innodb_random_read_ahead
  786. Value: OFF
  787. *************************** 263. row ***************************
  788. Variable_name: innodb_read_ahead_threshold
  789. Value: 56
  790. *************************** 264. row ***************************
  791. Variable_name: innodb_read_io_threads
  792. Value: 4
  793. *************************** 265. row ***************************
  794. Variable_name: innodb_read_only
  795. Value: OFF
  796. *************************** 266. row ***************************
  797. Variable_name: innodb_replication_delay
  798. Value: 0
  799. *************************** 267. row ***************************
  800. Variable_name: innodb_rollback_on_timeout
  801. Value: OFF
  802. *************************** 268. row ***************************
  803. Variable_name: innodb_scrub_log
  804. Value: OFF
  805. *************************** 269. row ***************************
  806. Variable_name: innodb_scrub_log_speed
  807. Value: 256
  808. *************************** 270. row ***************************
  809. Variable_name: innodb_sort_buffer_size
  810. Value: 1048576
  811. *************************** 271. row ***************************
  812. Variable_name: innodb_spin_wait_delay
  813. Value: 4
  814. *************************** 272. row ***************************
  815. Variable_name: innodb_stats_auto_recalc
  816. Value: ON
  817. *************************** 273. row ***************************
  818. Variable_name: innodb_stats_include_delete_marked
  819. Value: OFF
  820. *************************** 274. row ***************************
  821. Variable_name: innodb_stats_method
  822. Value: nulls_equal
  823. *************************** 275. row ***************************
  824. Variable_name: innodb_stats_modified_counter
  825. Value: 0
  826. *************************** 276. row ***************************
  827. Variable_name: innodb_stats_on_metadata
  828. Value: OFF
  829. *************************** 277. row ***************************
  830. Variable_name: innodb_stats_persistent
  831. Value: ON
  832. *************************** 278. row ***************************
  833. Variable_name: innodb_stats_persistent_sample_pages
  834. Value: 20
  835. *************************** 279. row ***************************
  836. Variable_name: innodb_stats_traditional
  837. Value: ON
  838. *************************** 280. row ***************************
  839. Variable_name: innodb_stats_transient_sample_pages
  840. Value: 8
  841. *************************** 281. row ***************************
  842. Variable_name: innodb_status_output
  843. Value: OFF
  844. *************************** 282. row ***************************
  845. Variable_name: innodb_status_output_locks
  846. Value: OFF
  847. *************************** 283. row ***************************
  848. Variable_name: innodb_strict_mode
  849. Value: ON
  850. *************************** 284. row ***************************
  851. Variable_name: innodb_sync_array_size
  852. Value: 1
  853. *************************** 285. row ***************************
  854. Variable_name: innodb_sync_spin_loops
  855. Value: 30
  856. *************************** 286. row ***************************
  857. Variable_name: innodb_table_locks
  858. Value: ON
  859. *************************** 287. row ***************************
  860. Variable_name: innodb_temp_data_file_path
  861. Value: ibtmp1:12M:autoextend
  862. *************************** 288. row ***************************
  863. Variable_name: innodb_thread_concurrency
  864. Value: 0
  865. *************************** 289. row ***************************
  866. Variable_name: innodb_thread_sleep_delay
  867. Value: 0
  868. *************************** 290. row ***************************
  869. Variable_name: innodb_tmpdir
  870. Value:
  871. *************************** 291. row ***************************
  872. Variable_name: innodb_undo_directory
  873. Value: ./
  874. *************************** 292. row ***************************
  875. Variable_name: innodb_undo_log_truncate
  876. Value: OFF
  877. *************************** 293. row ***************************
  878. Variable_name: innodb_undo_logs
  879. Value: 128
  880. *************************** 294. row ***************************
  881. Variable_name: innodb_undo_tablespaces
  882. Value: 0
  883. *************************** 295. row ***************************
  884. Variable_name: innodb_use_atomic_writes
  885. Value: ON
  886. *************************** 296. row ***************************
  887. Variable_name: innodb_use_native_aio
  888. Value: ON
  889. *************************** 297. row ***************************
  890. Variable_name: innodb_version
  891. Value: 10.5.12
  892. *************************** 298. row ***************************
  893. Variable_name: innodb_write_io_threads
  894. Value: 4
  895. *************************** 299. row ***************************
  896. Variable_name: insert_id
  897. Value: 0
  898. *************************** 300. row ***************************
  899. Variable_name: interactive_timeout
  900. Value: 28800
  901. *************************** 301. row ***************************
  902. Variable_name: join_buffer_size
  903. Value: 262144
  904. *************************** 302. row ***************************
  905. Variable_name: join_buffer_space_limit
  906. Value: 2097152
  907. *************************** 303. row ***************************
  908. Variable_name: join_cache_level
  909. Value: 2
  910. *************************** 304. row ***************************
  911. Variable_name: keep_files_on_create
  912. Value: OFF
  913. *************************** 305. row ***************************
  914. Variable_name: key_buffer_size
  915. Value: 134217728
  916. *************************** 306. row ***************************
  917. Variable_name: key_cache_age_threshold
  918. Value: 300
  919. *************************** 307. row ***************************
  920. Variable_name: key_cache_block_size
  921. Value: 1024
  922. *************************** 308. row ***************************
  923. Variable_name: key_cache_division_limit
  924. Value: 100
  925. *************************** 309. row ***************************
  926. Variable_name: key_cache_file_hash_size
  927. Value: 512
  928. *************************** 310. row ***************************
  929. Variable_name: key_cache_segments
  930. Value: 0
  931. *************************** 311. row ***************************
  932. Variable_name: large_files_support
  933. Value: ON
  934. *************************** 312. row ***************************
  935. Variable_name: large_page_size
  936. Value: 0
  937. *************************** 313. row ***************************
  938. Variable_name: large_pages
  939. Value: OFF
  940. *************************** 314. row ***************************
  941. Variable_name: last_gtid
  942. Value:
  943. *************************** 315. row ***************************
  944. Variable_name: last_insert_id
  945. Value: 0
  946. *************************** 316. row ***************************
  947. Variable_name: lc_messages
  948. Value: en_US
  949. *************************** 317. row ***************************
  950. Variable_name: lc_messages_dir
  951. Value:
  952. *************************** 318. row ***************************
  953. Variable_name: lc_time_names
  954. Value: en_US
  955. *************************** 319. row ***************************
  956. Variable_name: license
  957. Value: GPL
  958. *************************** 320. row ***************************
  959. Variable_name: local_infile
  960. Value: ON
  961. *************************** 321. row ***************************
  962. Variable_name: lock_wait_timeout
  963. Value: 86400
  964. *************************** 322. row ***************************
  965. Variable_name: locked_in_memory
  966. Value: OFF
  967. *************************** 323. row ***************************
  968. Variable_name: log_bin
  969. Value: OFF
  970. *************************** 324. row ***************************
  971. Variable_name: log_bin_basename
  972. Value:
  973. *************************** 325. row ***************************
  974. Variable_name: log_bin_compress
  975. Value: OFF
  976. *************************** 326. row ***************************
  977. Variable_name: log_bin_compress_min_len
  978. Value: 256
  979. *************************** 327. row ***************************
  980. Variable_name: log_bin_index
  981. Value:
  982. *************************** 328. row ***************************
  983. Variable_name: log_bin_trust_function_creators
  984. Value: OFF
  985. *************************** 329. row ***************************
  986. Variable_name: log_disabled_statements
  987. Value: sp
  988. *************************** 330. row ***************************
  989. Variable_name: log_error
  990. Value: /home/mysql/log/mariadb.err
  991. *************************** 331. row ***************************
  992. Variable_name: log_output
  993. Value: FILE
  994. *************************** 332. row ***************************
  995. Variable_name: log_queries_not_using_indexes
  996. Value: OFF
  997. *************************** 333. row ***************************
  998. Variable_name: log_slave_updates
  999. Value: OFF
  1000. *************************** 334. row ***************************
  1001. Variable_name: log_slow_admin_statements
  1002. Value: ON
  1003. *************************** 335. row ***************************
  1004. Variable_name: log_slow_disabled_statements
  1005. Value: sp
  1006. *************************** 336. row ***************************
  1007. Variable_name: log_slow_filter
  1008. Value: admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  1009. *************************** 337. row ***************************
  1010. Variable_name: log_slow_rate_limit
  1011. Value: 1
  1012. *************************** 338. row ***************************
  1013. Variable_name: log_slow_slave_statements
  1014. Value: ON
  1015. *************************** 339. row ***************************
  1016. Variable_name: log_slow_verbosity
  1017. Value:
  1018. *************************** 340. row ***************************
  1019. Variable_name: log_tc_size
  1020. Value: 24576
  1021. *************************** 341. row ***************************
  1022. Variable_name: log_warnings
  1023. Value: 2
  1024. *************************** 342. row ***************************
  1025. Variable_name: long_query_time
  1026. Value: 10.000000
  1027. *************************** 343. row ***************************
  1028. Variable_name: low_priority_updates
  1029. Value: OFF
  1030. *************************** 344. row ***************************
  1031. Variable_name: lower_case_file_system
  1032. Value: OFF
  1033. *************************** 345. row ***************************
  1034. Variable_name: lower_case_table_names
  1035. Value: 0
  1036. *************************** 346. row ***************************
  1037. Variable_name: master_verify_checksum
  1038. Value: OFF
  1039. *************************** 347. row ***************************
  1040. Variable_name: max_allowed_packet
  1041. Value: 16777216
  1042. *************************** 348. row ***************************
  1043. Variable_name: max_binlog_cache_size
  1044. Value: 18446744073709547520
  1045. *************************** 349. row ***************************
  1046. Variable_name: max_binlog_size
  1047. Value: 1073741824
  1048. *************************** 350. row ***************************
  1049. Variable_name: max_binlog_stmt_cache_size
  1050. Value: 18446744073709547520
  1051. *************************** 351. row ***************************
  1052. Variable_name: max_connect_errors
  1053. Value: 100
  1054. *************************** 352. row ***************************
  1055. Variable_name: max_connections
  1056. Value: 151
  1057. *************************** 353. row ***************************
  1058. Variable_name: max_delayed_threads
  1059. Value: 20
  1060. *************************** 354. row ***************************
  1061. Variable_name: max_digest_length
  1062. Value: 1024
  1063. *************************** 355. row ***************************
  1064. Variable_name: max_error_count
  1065. Value: 64
  1066. *************************** 356. row ***************************
  1067. Variable_name: max_heap_table_size
  1068. Value: 16777216
  1069. *************************** 357. row ***************************
  1070. Variable_name: max_insert_delayed_threads
  1071. Value: 20
  1072. *************************** 358. row ***************************
  1073. Variable_name: max_join_size
  1074. Value: 18446744073709551615
  1075. *************************** 359. row ***************************
  1076. Variable_name: max_length_for_sort_data
  1077. Value: 1024
  1078. *************************** 360. row ***************************
  1079. Variable_name: max_password_errors
  1080. Value: 4294967295
  1081. *************************** 361. row ***************************
  1082. Variable_name: max_prepared_stmt_count
  1083. Value: 16382
  1084. *************************** 362. row ***************************
  1085. Variable_name: max_recursive_iterations
  1086. Value: 4294967295
  1087. *************************** 363. row ***************************
  1088. Variable_name: max_relay_log_size
  1089. Value: 1073741824
  1090. *************************** 364. row ***************************
  1091. Variable_name: max_rowid_filter_size
  1092. Value: 131072
  1093. *************************** 365. row ***************************
  1094. Variable_name: max_seeks_for_key
  1095. Value: 4294967295
  1096. *************************** 366. row ***************************
  1097. Variable_name: max_session_mem_used
  1098. Value: 9223372036854775807
  1099. *************************** 367. row ***************************
  1100. Variable_name: max_sort_length
  1101. Value: 1024
  1102. *************************** 368. row ***************************
  1103. Variable_name: max_sp_recursion_depth
  1104. Value: 0
  1105. *************************** 369. row ***************************
  1106. Variable_name: max_statement_time
  1107. Value: 0.000000
  1108. *************************** 370. row ***************************
  1109. Variable_name: max_tmp_tables
  1110. Value: 32
  1111. *************************** 371. row ***************************
  1112. Variable_name: max_user_connections
  1113. Value: 0
  1114. *************************** 372. row ***************************
  1115. Variable_name: max_write_lock_count
  1116. Value: 4294967295
  1117. *************************** 373. row ***************************
  1118. Variable_name: metadata_locks_cache_size
  1119. Value: 1024
  1120. *************************** 374. row ***************************
  1121. Variable_name: metadata_locks_hash_instances
  1122. Value: 8
  1123. *************************** 375. row ***************************
  1124. Variable_name: min_examined_row_limit
  1125. Value: 0
  1126. *************************** 376. row ***************************
  1127. Variable_name: mrr_buffer_size
  1128. Value: 262144
  1129. *************************** 377. row ***************************
  1130. Variable_name: myisam_block_size
  1131. Value: 1024
  1132. *************************** 378. row ***************************
  1133. Variable_name: myisam_data_pointer_size
  1134. Value: 6
  1135. *************************** 379. row ***************************
  1136. Variable_name: myisam_max_sort_file_size
  1137. Value: 9223372036853727232
  1138. *************************** 380. row ***************************
  1139. Variable_name: myisam_mmap_size
  1140. Value: 18446744073709551615
  1141. *************************** 381. row ***************************
  1142. Variable_name: myisam_recover_options
  1143. Value: BACKUP,QUICK
  1144. *************************** 382. row ***************************
  1145. Variable_name: myisam_repair_threads
  1146. Value: 1
  1147. *************************** 383. row ***************************
  1148. Variable_name: myisam_sort_buffer_size
  1149. Value: 134216704
  1150. *************************** 384. row ***************************
  1151. Variable_name: myisam_stats_method
  1152. Value: NULLS_UNEQUAL
  1153. *************************** 385. row ***************************
  1154. Variable_name: myisam_use_mmap
  1155. Value: OFF
  1156. *************************** 386. row ***************************
  1157. Variable_name: mysql56_temporal_format
  1158. Value: ON
  1159. *************************** 387. row ***************************
  1160. Variable_name: net_buffer_length
  1161. Value: 16384
  1162. *************************** 388. row ***************************
  1163. Variable_name: net_read_timeout
  1164. Value: 30
  1165. *************************** 389. row ***************************
  1166. Variable_name: net_retry_count
  1167. Value: 10
  1168. *************************** 390. row ***************************
  1169. Variable_name: net_write_timeout
  1170. Value: 60
  1171. *************************** 391. row ***************************
  1172. Variable_name: old
  1173. Value: OFF
  1174. *************************** 392. row ***************************
  1175. Variable_name: old_alter_table
  1176. Value: DEFAULT
  1177. *************************** 393. row ***************************
  1178. Variable_name: old_mode
  1179. Value:
  1180. *************************** 394. row ***************************
  1181. Variable_name: old_passwords
  1182. Value: OFF
  1183. *************************** 395. row ***************************
  1184. Variable_name: open_files_limit
  1185. Value: 32183
  1186. *************************** 396. row ***************************
  1187. Variable_name: optimizer_max_sel_arg_weight
  1188. Value: 32000
  1189. *************************** 397. row ***************************
  1190. Variable_name: optimizer_prune_level
  1191. Value: 1
  1192. *************************** 398. row ***************************
  1193. Variable_name: optimizer_search_depth
  1194. Value: 62
  1195. *************************** 399. row ***************************
  1196. Variable_name: optimizer_selectivity_sampling_limit
  1197. Value: 100
  1198. *************************** 400. row ***************************
  1199. Variable_name: optimizer_switch
  1200. Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
  1201. *************************** 401. row ***************************
  1202. Variable_name: optimizer_trace
  1203. Value: enabled=off
  1204. *************************** 402. row ***************************
  1205. Variable_name: optimizer_trace_max_mem_size
  1206. Value: 1048576
  1207. *************************** 403. row ***************************
  1208. Variable_name: optimizer_use_condition_selectivity
  1209. Value: 4
  1210. *************************** 404. row ***************************
  1211. Variable_name: performance_schema
  1212. Value: OFF
  1213. *************************** 405. row ***************************
  1214. Variable_name: performance_schema_accounts_size
  1215. Value: -1
  1216. *************************** 406. row ***************************
  1217. Variable_name: performance_schema_digests_size
  1218. Value: -1
  1219. *************************** 407. row ***************************
  1220. Variable_name: performance_schema_events_stages_history_long_size
  1221. Value: -1
  1222. *************************** 408. row ***************************
  1223. Variable_name: performance_schema_events_stages_history_size
  1224. Value: -1
  1225. *************************** 409. row ***************************
  1226. Variable_name: performance_schema_events_statements_history_long_size
  1227. Value: -1
  1228. *************************** 410. row ***************************
  1229. Variable_name: performance_schema_events_statements_history_size
  1230. Value: -1
  1231. *************************** 411. row ***************************
  1232. Variable_name: performance_schema_events_transactions_history_long_size
  1233. Value: -1
  1234. *************************** 412. row ***************************
  1235. Variable_name: performance_schema_events_transactions_history_size
  1236. Value: -1
  1237. *************************** 413. row ***************************
  1238. Variable_name: performance_schema_events_waits_history_long_size
  1239. Value: -1
  1240. *************************** 414. row ***************************
  1241. Variable_name: performance_schema_events_waits_history_size
  1242. Value: -1
  1243. *************************** 415. row ***************************
  1244. Variable_name: performance_schema_hosts_size
  1245. Value: -1
  1246. *************************** 416. row ***************************
  1247. Variable_name: performance_schema_max_cond_classes
  1248. Value: 90
  1249. *************************** 417. row ***************************
  1250. Variable_name: performance_schema_max_cond_instances
  1251. Value: -1
  1252. *************************** 418. row ***************************
  1253. Variable_name: performance_schema_max_digest_length
  1254. Value: 1024
  1255. *************************** 419. row ***************************
  1256. Variable_name: performance_schema_max_file_classes
  1257. Value: 80
  1258. *************************** 420. row ***************************
  1259. Variable_name: performance_schema_max_file_handles
  1260. Value: 32768
  1261. *************************** 421. row ***************************
  1262. Variable_name: performance_schema_max_file_instances
  1263. Value: -1
  1264. *************************** 422. row ***************************
  1265. Variable_name: performance_schema_max_index_stat
  1266. Value: -1
  1267. *************************** 423. row ***************************
  1268. Variable_name: performance_schema_max_memory_classes
  1269. Value: 320
  1270. *************************** 424. row ***************************
  1271. Variable_name: performance_schema_max_metadata_locks
  1272. Value: -1
  1273. *************************** 425. row ***************************
  1274. Variable_name: performance_schema_max_mutex_classes
  1275. Value: 210
  1276. *************************** 426. row ***************************
  1277. Variable_name: performance_schema_max_mutex_instances
  1278. Value: -1
  1279. *************************** 427. row ***************************
  1280. Variable_name: performance_schema_max_prepared_statements_instances
  1281. Value: -1
  1282. *************************** 428. row ***************************
  1283. Variable_name: performance_schema_max_program_instances
  1284. Value: -1
  1285. *************************** 429. row ***************************
  1286. Variable_name: performance_schema_max_rwlock_classes
  1287. Value: 50
  1288. *************************** 430. row ***************************
  1289. Variable_name: performance_schema_max_rwlock_instances
  1290. Value: -1
  1291. *************************** 431. row ***************************
  1292. Variable_name: performance_schema_max_socket_classes
  1293. Value: 10
  1294. *************************** 432. row ***************************
  1295. Variable_name: performance_schema_max_socket_instances
  1296. Value: -1
  1297. *************************** 433. row ***************************
  1298. Variable_name: performance_schema_max_sql_text_length
  1299. Value: 1024
  1300. *************************** 434. row ***************************
  1301. Variable_name: performance_schema_max_stage_classes
  1302. Value: 160
  1303. *************************** 435. row ***************************
  1304. Variable_name: performance_schema_max_statement_classes
  1305. Value: 222
  1306. *************************** 436. row ***************************
  1307. Variable_name: performance_schema_max_statement_stack
  1308. Value: 10
  1309. *************************** 437. row ***************************
  1310. Variable_name: performance_schema_max_table_handles
  1311. Value: -1
  1312. *************************** 438. row ***************************
  1313. Variable_name: performance_schema_max_table_instances
  1314. Value: -1
  1315. *************************** 439. row ***************************
  1316. Variable_name: performance_schema_max_table_lock_stat
  1317. Value: -1
  1318. *************************** 440. row ***************************
  1319. Variable_name: performance_schema_max_thread_classes
  1320. Value: 50
  1321. *************************** 441. row ***************************
  1322. Variable_name: performance_schema_max_thread_instances
  1323. Value: -1
  1324. *************************** 442. row ***************************
  1325. Variable_name: performance_schema_session_connect_attrs_size
  1326. Value: -1
  1327. *************************** 443. row ***************************
  1328. Variable_name: performance_schema_setup_actors_size
  1329. Value: -1
  1330. *************************** 444. row ***************************
  1331. Variable_name: performance_schema_setup_objects_size
  1332. Value: -1
  1333. *************************** 445. row ***************************
  1334. Variable_name: performance_schema_users_size
  1335. Value: -1
  1336. *************************** 446. row ***************************
  1337. Variable_name: pid_file
  1338. Value: /home/mysql/portail-probance.pid
  1339. *************************** 447. row ***************************
  1340. Variable_name: plugin_dir
  1341. Value: /usr/lib64/mysql/plugin/
  1342. *************************** 448. row ***************************
  1343. Variable_name: plugin_maturity
  1344. Value: gamma
  1345. *************************** 449. row ***************************
  1346. Variable_name: port
  1347. Value: 3306
  1348. *************************** 450. row ***************************
  1349. Variable_name: preload_buffer_size
  1350. Value: 32768
  1351. *************************** 451. row ***************************
  1352. Variable_name: profiling
  1353. Value: OFF
  1354. *************************** 452. row ***************************
  1355. Variable_name: profiling_history_size
  1356. Value: 15
  1357. *************************** 453. row ***************************
  1358. Variable_name: progress_report_time
  1359. Value: 5
  1360. *************************** 454. row ***************************
  1361. Variable_name: protocol_version
  1362. Value: 10
  1363. *************************** 455. row ***************************
  1364. Variable_name: proxy_protocol_networks
  1365. Value:
  1366. *************************** 456. row ***************************
  1367. Variable_name: proxy_user
  1368. Value:
  1369. *************************** 457. row ***************************
  1370. Variable_name: pseudo_slave_mode
  1371. Value: OFF
  1372. *************************** 458. row ***************************
  1373. Variable_name: pseudo_thread_id
  1374. Value: 3637
  1375. *************************** 459. row ***************************
  1376. Variable_name: query_alloc_block_size
  1377. Value: 16384
  1378. *************************** 460. row ***************************
  1379. Variable_name: query_cache_limit
  1380. Value: 1048576
  1381. *************************** 461. row ***************************
  1382. Variable_name: query_cache_min_res_unit
  1383. Value: 4096
  1384. *************************** 462. row ***************************
  1385. Variable_name: query_cache_size
  1386. Value: 0
  1387. *************************** 463. row ***************************
  1388. Variable_name: query_cache_strip_comments
  1389. Value: OFF
  1390. *************************** 464. row ***************************
  1391. Variable_name: query_cache_type
  1392. Value: OFF
  1393. *************************** 465. row ***************************
  1394. Variable_name: query_cache_wlock_invalidate
  1395. Value: OFF
  1396. *************************** 466. row ***************************
  1397. Variable_name: query_prealloc_size
  1398. Value: 24576
  1399. *************************** 467. row ***************************
  1400. Variable_name: rand_seed1
  1401. Value: 786395661
  1402. *************************** 468. row ***************************
  1403. Variable_name: rand_seed2
  1404. Value: 376008273
  1405. *************************** 469. row ***************************
  1406. Variable_name: range_alloc_block_size
  1407. Value: 4096
  1408. *************************** 470. row ***************************
  1409. Variable_name: read_binlog_speed_limit
  1410. Value: 0
  1411. *************************** 471. row ***************************
  1412. Variable_name: read_buffer_size
  1413. Value: 131072
  1414. *************************** 472. row ***************************
  1415. Variable_name: read_only
  1416. Value: OFF
  1417. *************************** 473. row ***************************
  1418. Variable_name: read_rnd_buffer_size
  1419. Value: 262144
  1420. *************************** 474. row ***************************
  1421. Variable_name: relay_log
  1422. Value:
  1423. *************************** 475. row ***************************
  1424. Variable_name: relay_log_basename
  1425. Value:
  1426. *************************** 476. row ***************************
  1427. Variable_name: relay_log_index
  1428. Value:
  1429. *************************** 477. row ***************************
  1430. Variable_name: relay_log_info_file
  1431. Value: relay-log.info
  1432. *************************** 478. row ***************************
  1433. Variable_name: relay_log_purge
  1434. Value: ON
  1435. *************************** 479. row ***************************
  1436. Variable_name: relay_log_recovery
  1437. Value: OFF
  1438. *************************** 480. row ***************************
  1439. Variable_name: relay_log_space_limit
  1440. Value: 0
  1441. *************************** 481. row ***************************
  1442. Variable_name: replicate_annotate_row_events
  1443. Value: ON
  1444. *************************** 482. row ***************************
  1445. Variable_name: replicate_do_db
  1446. Value:
  1447. *************************** 483. row ***************************
  1448. Variable_name: replicate_do_table
  1449. Value:
  1450. *************************** 484. row ***************************
  1451. Variable_name: replicate_events_marked_for_skip
  1452. Value: REPLICATE
  1453. *************************** 485. row ***************************
  1454. Variable_name: replicate_ignore_db
  1455. Value:
  1456. *************************** 486. row ***************************
  1457. Variable_name: replicate_ignore_table
  1458. Value:
  1459. *************************** 487. row ***************************
  1460. Variable_name: replicate_wild_do_table
  1461. Value:
  1462. *************************** 488. row ***************************
  1463. Variable_name: replicate_wild_ignore_table
  1464. Value:
  1465. *************************** 489. row ***************************
  1466. Variable_name: report_host
  1467. Value:
  1468. *************************** 490. row ***************************
  1469. Variable_name: report_password
  1470. Value:
  1471. *************************** 491. row ***************************
  1472. Variable_name: report_port
  1473. Value: 3306
  1474. *************************** 492. row ***************************
  1475. Variable_name: report_user
  1476. Value:
  1477. *************************** 493. row ***************************
  1478. Variable_name: require_secure_transport
  1479. Value: OFF
  1480. *************************** 494. row ***************************
  1481. Variable_name: rowid_merge_buff_size
  1482. Value: 8388608
  1483. *************************** 495. row ***************************
  1484. Variable_name: rpl_semi_sync_master_enabled
  1485. Value: OFF
  1486. *************************** 496. row ***************************
  1487. Variable_name: rpl_semi_sync_master_timeout
  1488. Value: 10000
  1489. *************************** 497. row ***************************
  1490. Variable_name: rpl_semi_sync_master_trace_level
  1491. Value: 32
  1492. *************************** 498. row ***************************
  1493. Variable_name: rpl_semi_sync_master_wait_no_slave
  1494. Value: ON
  1495. *************************** 499. row ***************************
  1496. Variable_name: rpl_semi_sync_master_wait_point
  1497. Value: AFTER_COMMIT
  1498. *************************** 500. row ***************************
  1499. Variable_name: rpl_semi_sync_slave_delay_master
  1500. Value: OFF
  1501. *************************** 501. row ***************************
  1502. Variable_name: rpl_semi_sync_slave_enabled
  1503. Value: OFF
  1504. *************************** 502. row ***************************
  1505. Variable_name: rpl_semi_sync_slave_kill_conn_timeout
  1506. Value: 5
  1507. *************************** 503. row ***************************
  1508. Variable_name: rpl_semi_sync_slave_trace_level
  1509. Value: 32
  1510. *************************** 504. row ***************************
  1511. Variable_name: secure_auth
  1512. Value: ON
  1513. *************************** 505. row ***************************
  1514. Variable_name: secure_file_priv
  1515. Value:
  1516. *************************** 506. row ***************************
  1517. Variable_name: secure_timestamp
  1518. Value: NO
  1519. *************************** 507. row ***************************
  1520. Variable_name: server_id
  1521. Value: 1
  1522. *************************** 508. row ***************************
  1523. Variable_name: session_track_schema
  1524. Value: ON
  1525. *************************** 509. row ***************************
  1526. Variable_name: session_track_state_change
  1527. Value: OFF
  1528. *************************** 510. row ***************************
  1529. Variable_name: session_track_system_variables
  1530. Value: autocommit,character_set_client,character_set_connection,character_set_results,time_zone
  1531. *************************** 511. row ***************************
  1532. Variable_name: session_track_transaction_info
  1533. Value: OFF
  1534. *************************** 512. row ***************************
  1535. Variable_name: skip_external_locking
  1536. Value: ON
  1537. *************************** 513. row ***************************
  1538. Variable_name: skip_name_resolve
  1539. Value: OFF
  1540. *************************** 514. row ***************************
  1541. Variable_name: skip_networking
  1542. Value: OFF
  1543. *************************** 515. row ***************************
  1544. Variable_name: skip_parallel_replication
  1545. Value: OFF
  1546. *************************** 516. row ***************************
  1547. Variable_name: skip_replication
  1548. Value: OFF
  1549. *************************** 517. row ***************************
  1550. Variable_name: skip_show_database
  1551. Value: OFF
  1552. *************************** 518. row ***************************
  1553. Variable_name: slave_compressed_protocol
  1554. Value: OFF
  1555. *************************** 519. row ***************************
  1556. Variable_name: slave_ddl_exec_mode
  1557. Value: IDEMPOTENT
  1558. *************************** 520. row ***************************
  1559. Variable_name: slave_domain_parallel_threads
  1560. Value: 0
  1561. *************************** 521. row ***************************
  1562. Variable_name: slave_exec_mode
  1563. Value: STRICT
  1564. *************************** 522. row ***************************
  1565. Variable_name: slave_load_tmpdir
  1566. Value: /tmp
  1567. *************************** 523. row ***************************
  1568. Variable_name: slave_max_allowed_packet
  1569. Value: 1073741824
  1570. *************************** 524. row ***************************
  1571. Variable_name: slave_net_timeout
  1572. Value: 60
  1573. *************************** 525. row ***************************
  1574. Variable_name: slave_parallel_max_queued
  1575. Value: 131072
  1576. *************************** 526. row ***************************
  1577. Variable_name: slave_parallel_mode
  1578. Value: optimistic
  1579. *************************** 527. row ***************************
  1580. Variable_name: slave_parallel_threads
  1581. Value: 0
  1582. *************************** 528. row ***************************
  1583. Variable_name: slave_parallel_workers
  1584. Value: 0
  1585. *************************** 529. row ***************************
  1586. Variable_name: slave_run_triggers_for_rbr
  1587. Value: NO
  1588. *************************** 530. row ***************************
  1589. Variable_name: slave_skip_errors
  1590. Value: OFF
  1591. *************************** 531. row ***************************
  1592. Variable_name: slave_sql_verify_checksum
  1593. Value: ON
  1594. *************************** 532. row ***************************
  1595. Variable_name: slave_transaction_retries
  1596. Value: 10
  1597. *************************** 533. row ***************************
  1598. Variable_name: slave_transaction_retry_errors
  1599. Value: 1158,1159,1160,1161,1205,1213,1429,2013,12701
  1600. *************************** 534. row ***************************
  1601. Variable_name: slave_transaction_retry_interval
  1602. Value: 0
  1603. *************************** 535. row ***************************
  1604. Variable_name: slave_type_conversions
  1605. Value:
  1606. *************************** 536. row ***************************
  1607. Variable_name: slow_launch_time
  1608. Value: 2
  1609. *************************** 537. row ***************************
  1610. Variable_name: slow_query_log
  1611. Value: OFF
  1612. *************************** 538. row ***************************
  1613. Variable_name: slow_query_log_file
  1614. Value: portail-probance-slow.log
  1615. *************************** 539. row ***************************
  1616. Variable_name: socket
  1617. Value: /home/mysql/mysql.sock
  1618. *************************** 540. row ***************************
  1619. Variable_name: sort_buffer_size
  1620. Value: 2097152
  1621. *************************** 541. row ***************************
  1622. Variable_name: sql_auto_is_null
  1623. Value: OFF
  1624. *************************** 542. row ***************************
  1625. Variable_name: sql_big_selects
  1626. Value: ON
  1627. *************************** 543. row ***************************
  1628. Variable_name: sql_buffer_result
  1629. Value: OFF
  1630. *************************** 544. row ***************************
  1631. Variable_name: sql_if_exists
  1632. Value: OFF
  1633. *************************** 545. row ***************************
  1634. Variable_name: sql_log_bin
  1635. Value: ON
  1636. *************************** 546. row ***************************
  1637. Variable_name: sql_log_off
  1638. Value: OFF
  1639. *************************** 547. row ***************************
  1640. Variable_name: sql_mode
  1641. Value: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  1642. *************************** 548. row ***************************
  1643. Variable_name: sql_notes
  1644. Value: ON
  1645. *************************** 549. row ***************************
  1646. Variable_name: sql_quote_show_create
  1647. Value: ON
  1648. *************************** 550. row ***************************
  1649. Variable_name: sql_safe_updates
  1650. Value: OFF
  1651. *************************** 551. row ***************************
  1652. Variable_name: sql_select_limit
  1653. Value: 18446744073709551615
  1654. *************************** 552. row ***************************
  1655. Variable_name: sql_slave_skip_counter
  1656. Value: 0
  1657. *************************** 553. row ***************************
  1658. Variable_name: sql_warnings
  1659. Value: OFF
  1660. *************************** 554. row ***************************
  1661. Variable_name: ssl_ca
  1662. Value:
  1663. *************************** 555. row ***************************
  1664. Variable_name: ssl_capath
  1665. Value:
  1666. *************************** 556. row ***************************
  1667. Variable_name: ssl_cert
  1668. Value:
  1669. *************************** 557. row ***************************
  1670. Variable_name: ssl_cipher
  1671. Value:
  1672. *************************** 558. row ***************************
  1673. Variable_name: ssl_crl
  1674. Value:
  1675. *************************** 559. row ***************************
  1676. Variable_name: ssl_crlpath
  1677. Value:
  1678. *************************** 560. row ***************************
  1679. Variable_name: ssl_key
  1680. Value:
  1681. *************************** 561. row ***************************
  1682. Variable_name: standard_compliant_cte
  1683. Value: ON
  1684. *************************** 562. row ***************************
  1685. Variable_name: storage_engine
  1686. Value: InnoDB
  1687. *************************** 563. row ***************************
  1688. Variable_name: stored_program_cache
  1689. Value: 256
  1690. *************************** 564. row ***************************
  1691. Variable_name: strict_password_validation
  1692. Value: ON
  1693. *************************** 565. row ***************************
  1694. Variable_name: sync_binlog
  1695. Value: 0
  1696. *************************** 566. row ***************************
  1697. Variable_name: sync_frm
  1698. Value: ON
  1699. *************************** 567. row ***************************
  1700. Variable_name: sync_master_info
  1701. Value: 10000
  1702. *************************** 568. row ***************************
  1703. Variable_name: sync_relay_log
  1704. Value: 10000
  1705. *************************** 569. row ***************************
  1706. Variable_name: sync_relay_log_info
  1707. Value: 10000
  1708. *************************** 570. row ***************************
  1709. Variable_name: system_time_zone
  1710. Value: CEST
  1711. *************************** 571. row ***************************
  1712. Variable_name: system_versioning_alter_history
  1713. Value: ERROR
  1714. *************************** 572. row ***************************
  1715. Variable_name: system_versioning_asof
  1716. Value: DEFAULT
  1717. *************************** 573. row ***************************
  1718. Variable_name: table_definition_cache
  1719. Value: 400
  1720. *************************** 574. row ***************************
  1721. Variable_name: table_open_cache
  1722. Value: 2000
  1723. *************************** 575. row ***************************
  1724. Variable_name: table_open_cache_instances
  1725. Value: 8
  1726. *************************** 576. row ***************************
  1727. Variable_name: tcp_keepalive_interval
  1728. Value: 0
  1729. *************************** 577. row ***************************
  1730. Variable_name: tcp_keepalive_probes
  1731. Value: 0
  1732. *************************** 578. row ***************************
  1733. Variable_name: tcp_keepalive_time
  1734. Value: 0
  1735. *************************** 579. row ***************************
  1736. Variable_name: tcp_nodelay
  1737. Value: ON
  1738. *************************** 580. row ***************************
  1739. Variable_name: thread_cache_size
  1740. Value: 151
  1741. *************************** 581. row ***************************
  1742. Variable_name: thread_handling
  1743. Value: one-thread-per-connection
  1744. *************************** 582. row ***************************
  1745. Variable_name: thread_pool_dedicated_listener
  1746. Value: OFF
  1747. *************************** 583. row ***************************
  1748. Variable_name: thread_pool_exact_stats
  1749. Value: OFF
  1750. *************************** 584. row ***************************
  1751. Variable_name: thread_pool_idle_timeout
  1752. Value: 60
  1753. *************************** 585. row ***************************
  1754. Variable_name: thread_pool_max_threads
  1755. Value: 65536
  1756. *************************** 586. row ***************************
  1757. Variable_name: thread_pool_oversubscribe
  1758. Value: 3
  1759. *************************** 587. row ***************************
  1760. Variable_name: thread_pool_prio_kickup_timer
  1761. Value: 1000
  1762. *************************** 588. row ***************************
  1763. Variable_name: thread_pool_priority
  1764. Value: auto
  1765. *************************** 589. row ***************************
  1766. Variable_name: thread_pool_size
  1767. Value: 1
  1768. *************************** 590. row ***************************
  1769. Variable_name: thread_pool_stall_limit
  1770. Value: 500
  1771. *************************** 591. row ***************************
  1772. Variable_name: thread_stack
  1773. Value: 299008
  1774. *************************** 592. row ***************************
  1775. Variable_name: time_format
  1776. Value: %H:%i:%s
  1777. *************************** 593. row ***************************
  1778. Variable_name: time_zone
  1779. Value: SYSTEM
  1780. *************************** 594. row ***************************
  1781. Variable_name: timestamp
  1782. Value: 1645175913.355848
  1783. *************************** 595. row ***************************
  1784. Variable_name: tls_version
  1785. Value: TLSv1.1,TLSv1.2,TLSv1.3
  1786. *************************** 596. row ***************************
  1787. Variable_name: tmp_disk_table_size
  1788. Value: 18446744073709551615
  1789. *************************** 597. row ***************************
  1790. Variable_name: tmp_memory_table_size
  1791. Value: 16777216
  1792. *************************** 598. row ***************************
  1793. Variable_name: tmp_table_size
  1794. Value: 16777216
  1795. *************************** 599. row ***************************
  1796. Variable_name: tmpdir
  1797. Value: /tmp
  1798. *************************** 600. row ***************************
  1799. Variable_name: transaction_alloc_block_size
  1800. Value: 8192
  1801. *************************** 601. row ***************************
  1802. Variable_name: transaction_prealloc_size
  1803. Value: 4096
  1804. *************************** 602. row ***************************
  1805. Variable_name: tx_isolation
  1806. Value: REPEATABLE-READ
  1807. *************************** 603. row ***************************
  1808. Variable_name: tx_read_only
  1809. Value: OFF
  1810. *************************** 604. row ***************************
  1811. Variable_name: unique_checks
  1812. Value: ON
  1813. *************************** 605. row ***************************
  1814. Variable_name: updatable_views_with_limit
  1815. Value: YES
  1816. *************************** 606. row ***************************
  1817. Variable_name: use_stat_tables
  1818. Value: PREFERABLY_FOR_QUERIES
  1819. *************************** 607. row ***************************
  1820. Variable_name: userstat
  1821. Value: OFF
  1822. *************************** 608. row ***************************
  1823. Variable_name: version
  1824. Value: 10.5.12-MariaDB
  1825. *************************** 609. row ***************************
  1826. Variable_name: version_comment
  1827. Value: MariaDB Server
  1828. *************************** 610. row ***************************
  1829. Variable_name: version_compile_machine
  1830. Value: x86_64
  1831. *************************** 611. row ***************************
  1832. Variable_name: version_compile_os
  1833. Value: Linux
  1834. *************************** 612. row ***************************
  1835. Variable_name: version_malloc_library
  1836. Value: system
  1837. *************************** 613. row ***************************
  1838. Variable_name: version_source_revision
  1839. Value: b5569b62408375f35e2fe851158a7ff17e378ed1
  1840. *************************** 614. row ***************************
  1841. Variable_name: version_ssl_library
  1842. Value: OpenSSL 1.0.2k-fips 26 Jan 2017
  1843. *************************** 615. row ***************************
  1844. Variable_name: wait_timeout
  1845. Value: 28800
  1846. *************************** 616. row ***************************
  1847. Variable_name: warning_count
  1848. Value: 0
  1849. *************************** 617. row ***************************
  1850. Variable_name: wsrep_osu_method
  1851. Value: TOI
  1852. *************************** 618. row ***************************
  1853. Variable_name: wsrep_sr_store
  1854. Value: table
  1855. *************************** 619. row ***************************
  1856. Variable_name: wsrep_auto_increment_control
  1857. Value: ON
  1858. *************************** 620. row ***************************
  1859. Variable_name: wsrep_causal_reads
  1860. Value: OFF
  1861. *************************** 621. row ***************************
  1862. Variable_name: wsrep_certification_rules
  1863. Value: strict
  1864. *************************** 622. row ***************************
  1865. Variable_name: wsrep_certify_nonpk
  1866. Value: ON
  1867. *************************** 623. row ***************************
  1868. Variable_name: wsrep_cluster_address
  1869. Value: gcomm://
  1870. *************************** 624. row ***************************
  1871. Variable_name: wsrep_cluster_name
  1872. Value: Portail-MariadDB-Cluster
  1873. *************************** 625. row ***************************
  1874. Variable_name: wsrep_convert_lock_to_trx
  1875. Value: OFF
  1876. *************************** 626. row ***************************
  1877. Variable_name: wsrep_data_home_dir
  1878. Value: /home/mysql/
  1879. *************************** 627. row ***************************
  1880. Variable_name: wsrep_dbug_option
  1881. Value:
  1882. *************************** 628. row ***************************
  1883. Variable_name: wsrep_debug
  1884. Value: NONE
  1885. *************************** 629. row ***************************
  1886. Variable_name: wsrep_desync
  1887. Value: OFF
  1888. *************************** 630. row ***************************
  1889. Variable_name: wsrep_dirty_reads
  1890. Value: OFF
  1891. *************************** 631. row ***************************
  1892. Variable_name: wsrep_drupal_282555_workaround
  1893. Value: OFF
  1894. *************************** 632. row ***************************
  1895. Variable_name: wsrep_forced_binlog_format
  1896. Value: NONE
  1897. *************************** 633. row ***************************
  1898. Variable_name: wsrep_gtid_domain_id
  1899. Value: 0
  1900. *************************** 634. row ***************************
  1901. Variable_name: wsrep_gtid_mode
  1902. Value: OFF
  1903. *************************** 635. row ***************************
  1904. Variable_name: wsrep_gtid_seq_no
  1905. Value: 0
  1906. *************************** 636. row ***************************
  1907. Variable_name: wsrep_ignore_apply_errors
  1908. Value: 7
  1909. *************************** 637. row ***************************
  1910. Variable_name: wsrep_load_data_splitting
  1911. Value: OFF
  1912. *************************** 638. row ***************************
  1913. Variable_name: wsrep_log_conflicts
  1914. Value: OFF
  1915. *************************** 639. row ***************************
  1916. Variable_name: wsrep_max_ws_rows
  1917. Value: 0
  1918. *************************** 640. row ***************************
  1919. Variable_name: wsrep_max_ws_size
  1920. Value: 2147483647
  1921. *************************** 641. row ***************************
  1922. Variable_name: wsrep_mysql_replication_bundle
  1923. Value: 0
  1924. *************************** 642. row ***************************
  1925. Variable_name: wsrep_node_address
  1926. Value: 10.15.15.1
  1927. *************************** 643. row ***************************
  1928. Variable_name: wsrep_node_incoming_address
  1929. Value: AUTO
  1930. *************************** 644. row ***************************
  1931. Variable_name: wsrep_node_name
  1932. Value: portail-probance
  1933. *************************** 645. row ***************************
  1934. Variable_name: wsrep_notify_cmd
  1935. Value:
  1936. *************************** 646. row ***************************
  1937. Variable_name: wsrep_on
  1938. Value: ON
  1939. *************************** 647. row ***************************
  1940. Variable_name: wsrep_patch_version
  1941. Value: wsrep_26.22
  1942. *************************** 648. row ***************************
  1943. Variable_name: wsrep_provider
  1944. Value: /usr/lib64/galera-4/libgalera_smm.so
  1945. *************************** 649. row ***************************
  1946. Variable_name: wsrep_provider_options
  1947. Value: base_dir = /home/mysql/; base_host = 10.15.15.1; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 1; evs.view_forget_timeout = P1D; gcache.dir = /home/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 10.15.15.1; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 10; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
  1948. *************************** 650. row ***************************
  1949. Variable_name: wsrep_recover
  1950. Value: OFF
  1951. *************************** 651. row ***************************
  1952. Variable_name: wsrep_reject_queries
  1953. Value: NONE
  1954. *************************** 652. row ***************************
  1955. Variable_name: wsrep_replicate_myisam
  1956. Value: ON
  1957. *************************** 653. row ***************************
  1958. Variable_name: wsrep_restart_slave
  1959. Value: OFF
  1960. *************************** 654. row ***************************
  1961. Variable_name: wsrep_retry_autocommit
  1962. Value: 1
  1963. *************************** 655. row ***************************
  1964. Variable_name: wsrep_slave_fk_checks
  1965. Value: ON
  1966. *************************** 656. row ***************************
  1967. Variable_name: wsrep_slave_uk_checks
  1968. Value: OFF
  1969. *************************** 657. row ***************************
  1970. Variable_name: wsrep_slave_threads
  1971. Value: 1
  1972. *************************** 658. row ***************************
  1973. Variable_name: wsrep_sst_auth
  1974. Value:
  1975. *************************** 659. row ***************************
  1976. Variable_name: wsrep_sst_donor
  1977. Value: portail-probance
  1978. *************************** 660. row ***************************
  1979. Variable_name: wsrep_sst_donor_rejects_queries
  1980. Value: OFF
  1981. *************************** 661. row ***************************
  1982. Variable_name: wsrep_sst_method
  1983. Value: rsync
  1984. *************************** 662. row ***************************
  1985. Variable_name: wsrep_sst_receive_address
  1986. Value: AUTO
  1987. *************************** 663. row ***************************
  1988. Variable_name: wsrep_start_position
  1989. Value: cf360ed9-9e79-11e9-b507-eb92a2ddf7c4:1339989
  1990. *************************** 664. row ***************************
  1991. Variable_name: wsrep_strict_ddl
  1992. Value: OFF
  1993. *************************** 665. row ***************************
  1994. Variable_name: wsrep_sync_wait
  1995. Value: 0
  1996. *************************** 666. row ***************************
  1997. Variable_name: wsrep_trx_fragment_size
  1998. Value: 0
  1999. *************************** 667. row ***************************
  2000. Variable_name: wsrep_trx_fragment_unit
  2001. Value: bytes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement