Optimizer problem with primarykey

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-------+-------------+

| id   | select_type | table                      | type  | possible_keys | key     | key_len | ref  | rows  | Extra       |

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-------+-------------+

|    1 | SIMPLE      | transactionStatesOverviews | range | PRIMARY       | PRIMARY | 4       | NULL | 99755 | Using where |

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-------+-------------+

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-----------+-------------+

| id   | select_type | table                      | type  | possible_keys | key     | key_len | ref  | rows      | Extra       |

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-----------+-------------+

|    1 | SIMPLE      | transactionStatesOverviews | index | NULL          | PRIMARY | 4       | NULL | 612605036 | Using where |

+------+-------------+----------------------------+-------+---------------+---------+---------+------+-----------+-------------+

UPDATE `transactionStatesOverviews`

SET lastIdStep = '10'

WHERE idTransaction IN ('1797100710',

'1797101072',

'1797101246',

... => ~99 755 (id different)

'1798587112')

AND (lastIdStep < '10' OR lastIdStep = '8' OR lastIdStep = '9' OR lastIdStep = '6');

MariaDB [pc_aggregation]> show index from transactionStatesOverviews;

+----------------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

| Table                      | Non_unique | Key_name             | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |

+----------------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

| transactionStatesOverviews |          0 | PRIMARY              |            1 | idTransaction    | A         |   630064619 |     NULL | NULL   |      | BTREE      |         |               | NO      |

| transactionStatesOverviews |          1 | TRANSFERDATE         |            1 | transferDate     | A         |      701630 |     NULL | NULL   | YES  | BTREE      |         |               | NO      |

| transactionStatesOverviews |          1 | CHARGED_DATE         |            1 | chargedDate      | A         |      681150 |     NULL | NULL   | YES  | BTREE      |         |               | NO      |

| transactionStatesOverviews |          1 | _sql_created_at_idx |            1 | _sql_created_at | A         |     2681126 |     NULL | NULL   |      | BTREE      |         |               | NO      |

| transactionStatesOverviews |          1 | _sql_updated_at_idx |            1 | _sql_updated_at | A         |    90009231 |     NULL | NULL   |      | BTREE      |         |               | NO      |

+----------------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

5 rows in set (0.000 sec)

Create Table: CREATE TABLE `transactionStatesOverviews` (

  `idTransaction` int(11) NOT NULL,

  `isRefund` enum('yes','no') DEFAULT 'no',

  `isThreeDSecure` enum('yes','no') DEFAULT 'no',

  `isRecurrent` enum('yes','no') DEFAULT 'no',

  `isOneClick` enum('yes','no') DEFAULT 'no',

  `isSubscription` enum('yes','no') DEFAULT 'no',

  `isNTimes` enum('yes','no') DEFAULT 'no',

  `isCancelled` enum('yes','no') DEFAULT 'no',

  `isCaptured` enum('yes','no') DEFAULT 'no',

  `isRefunded` enum('yes','no') DEFAULT 'no',

  `isVoided` enum('yes','no') DEFAULT 'no',

  `isRetrievalRequested` enum('yes','no') DEFAULT 'no',

  `isChargebacked` enum('yes','no') DEFAULT 'no',

  `isRepresentment` enum('yes','no') DEFAULT 'no',

  `isChargebackCancelled` enum('yes','no') DEFAULT 'no',

  `isSentToT24` enum('yes','no') DEFAULT 'no',

  `isNfc` enum('yes','no') DEFAULT 'no',

  `isRDR` enum('yes','no') DEFAULT 'no',

  `isRDRReversal` enum('yes','no') DEFAULT 'no',

  `isScheduledCapture` enum('yes','no') DEFAULT 'no',

  `terminalType` tinyint(3) DEFAULT NULL,

  `lastIdStep` tinyint(3) unsigned NOT NULL,

  `refundedBy` varchar(1024) NOT NULL DEFAULT '' COMMENT 'Liste des publicIDs des refunds',

  `capturedBy` varchar(1024) NOT NULL DEFAULT '' COMMENT 'Liste des publicIDs des captures',

  `voidedBy` varchar(1024) NOT NULL DEFAULT '' COMMENT 'Liste des publicIDs des voids',

  `transferDate` date DEFAULT NULL,

  `transferReference` varchar(45) DEFAULT NULL,

  `transactionRules` varchar(125) NOT NULL DEFAULT '',

  `transactionFraudRuleIds` varchar(255) NOT NULL,

  `idSupplier` tinyint(3) NOT NULL,

  `tags` text DEFAULT NULL,

  `publicTags` text DEFAULT NULL,

  `avsResponseCode` varchar(10) DEFAULT NULL,

  `submerchantsExternalIds` varchar(255) DEFAULT NULL,

  `lastNotificationId` int(10) unsigned DEFAULT NULL,

  `transactionRuleSetScope` varchar(20) DEFAULT NULL,

  `chargedDate` date DEFAULT NULL COMMENT 'Date at witch the transfer has been set to charged state from flagToPaid',

  `chargedReference` varchar(45) DEFAULT NULL COMMENT 'T24 charged transfer reference',

  `lastTryout` int(10) unsigned DEFAULT NULL,

  `isFraudulent` enum('yes','no') DEFAULT 'no',

  `idFraudReason` char(2) DEFAULT NULL,

  `bankProcessingDate` datetime DEFAULT NULL,

  `FTMatchingDate` datetime DEFAULT NULL,

  `isRepresentmentCancelled` enum('yes','no') DEFAULT 'no',

  `idStandardInvoiceMode` smallint(3) unsigned DEFAULT 1 COMMENT 'Define invoice standard mode.',

  `__sql_created_at` timestamp NOT NULL DEFAULT current_timestamp(),

  `__sql_updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),

  PRIMARY KEY (`idTransaction`),

  KEY `TRANSFERDATE` (`transferDate`),

  KEY `CHARGED_DATE` (`chargedDate`),

  KEY `__sql_created_at_idx` (`__sql_created_at`),

  KEY `__sql_updated_at_idx` (`__sql_updated_at`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

SET GLOBAL eq_range_index_dive_limit = 0;

SET GLOBAL eq_range_index_dive_limit = 100;

SET GLOBAL eq_range_index_dive_limit = 200;

SET GLOBAL eq_range_index_dive_limit = 100000;

rowid_filter=off

optimize_join_buffer_size=off

Top	Diff	Variable_name (MariaDB  10.1)	gcp-prod-oos-sql-0001-mariadb-g01-001 (MariaDB 10.7.7)

1	1	alter_algorithm	N/A	DEFAULT

2	2	analyze_sample_percentage	N/A	100.000000

3	2	aria_block_size	8 Ko	8 Ko

4	2	aria_checkpoint_interval	30	30

5	2	aria_checkpoint_log_activity	1048576	1048576

6	2	aria_encrypt_tables	OFF	OFF

7	2	aria_force_start_after_recovery_failures	0	0

8	2	aria_group_commit	none	none

9	2	aria_group_commit_interval	0	0

10	2	aria_log_file_size	1 Go	1 Go

11	2	aria_log_purge_type	immediate	immediate

12	2	aria_max_sort_file_size	8 Eo	8 Eo

13	2	aria_page_checksum	ON	ON

14	2	aria_pagecache_age_threshold	300	300

15	2	aria_pagecache_buffer_size	128 Mo	128 Mo

16	2	aria_pagecache_division_limit	100	100

17	2	aria_pagecache_file_hash_size	512	512

18	3	aria_recover_options	N/A	BACKUP,QUICK

19	3	aria_repair_threads	1	1

20	3	aria_sort_buffer_size	256 Mo	256 Mo

21	3	aria_stats_method	nulls_unequal	nulls_unequal

22	3	aria_sync_log_dir	NEWFILE	NEWFILE

23	3	aria_used_for_temp_tables	ON	ON

24	4	auto_increment_increment	2	1

25	5	auto_increment_offset	2	1

26	5	autocommit	ON	ON

27	5	automatic_sp_privileges	ON	ON

28	6	back_log	869	250

29	7	basedir	/usr/	/usr

30	7	big_tables	OFF	OFF

31	8	bind_address	N/A	0.0.0.0

32	9	binlog_annotate_row_events	OFF	ON

33	9	binlog_cache_size	32 Ko	32 Ko

34	10	binlog_checksum	NONE	CRC32

35	10	binlog_commit_wait_count	0	0

36	10	binlog_commit_wait_usec	100000	100000

37	10	binlog_direct_non_transactional_updates	OFF	OFF

38	11	binlog_expire_logs_seconds	N/A	864000

39	12	binlog_file_cache_size	N/A	16 Ko

40	12	binlog_format	ROW	ROW

41	12	binlog_optimize_thread_scheduling	ON	ON

42	12	binlog_row_image	FULL	FULL

43	13	binlog_row_metadata	N/A	NO_LOG

44	13	binlog_stmt_cache_size	32 Ko	32 Ko

45	14	bulk_insert_buffer_size	8 Mo	16 Mo

46	15	character_set_client	latin1	utf8mb4

47	16	character_set_connection	latin1	utf8mb4

48	17	character_set_database	latin1	utf8mb4

49	17	character_set_filesystem	binary	binary

50	18	character_set_results	latin1	utf8mb4

51	19	character_set_server	latin1	utf8mb4

52	20	character_set_system	utf8	utf8mb3

53	20	character_sets_dir	/usr/share/mysql/charsets/	/usr/share/mysql/charsets/

54	21	check_constraint_checks	N/A	ON

55	22	collation_connection	latin1_swedish_ci	utf8mb4_general_ci

56	23	collation_database	latin1_swedish_ci	utf8mb4_general_ci

57	24	collation_server	latin1_swedish_ci	utf8mb4_general_ci

58	25	column_compression_threshold	N/A	100

59	26	column_compression_zlib_level	N/A	6

60	27	column_compression_zlib_strategy	N/A	DEFAULT_STRATEGY

61	28	column_compression_zlib_wrap	N/A	OFF

62	28	completion_type	NO_CHAIN	NO_CHAIN

63	29	concurrent_insert	AUTO	ALWAYS

64	29	connect_timeout	10	10

65	29	core_file	OFF	OFF

66	29	datadir	/srv/mysql/data/	/srv/mysql/data/

67	29	date_format	%Y-%m-%d	%Y-%m-%d

68	29	datetime_format	%Y-%m-%d %H:%i:%s	%Y-%m-%d %H:%i:%s

69	29	deadlock_search_depth_long	15	15

70	29	deadlock_search_depth_short	4	4

71	29	deadlock_timeout_long	50000000	50000000

72	29	deadlock_timeout_short	10000	10000

73	29	debug_no_thread_alarm	OFF	OFF

74	30	default_password_lifetime	N/A	0

75	30	default_regex_flags		

76	30	default_storage_engine	InnoDB	InnoDB

77	30	default_tmp_storage_engine		

78	30	default_week_format	0	0

79	30	delay_key_write	ON	ON

80	30	delayed_insert_limit	100	100

81	30	delayed_insert_timeout	300	300

82	30	delayed_queue_size	1000	1000

83	31	disconnect_on_expired_password	N/A	OFF

84	31	div_precision_increment	4	4

85	31	encrypt_binlog	OFF	OFF

86	31	encrypt_tmp_disk_tables	OFF	OFF

87	31	encrypt_tmp_files	OFF	OFF

88	31	enforce_storage_engine		

89	32	eq_range_index_dive_limit	N/A	200

90	32	event_scheduler	OFF	OFF

91	32	expensive_subquery_limit	100	100

92	33	expire_logs_days	7	10.000000

93	33	explicit_defaults_for_timestamp	OFF	OFF

94	33	extra_max_connections	1	1

95	33	extra_port	0	0

96	33	flush	OFF	OFF

97	33	flush_time	0	0

98	33	foreign_key_checks	ON	ON

99	33	ft_boolean_syntax	+ -><()~*:""&|	+ -><()~*:""&|

100	33	ft_max_word_len	84	84

101	33	ft_min_word_len	4	4

102	33	ft_query_expansion_limit	20	20

103	33	ft_stopword_file	(built-in)	(built-in)

104	33	general_log	OFF	OFF

105	34	general_log_file	pc-db11-1.log	/srv/mysql/log/general.log

106	35	group_concat_max_len	1024	1048576

107	36	gtid_binlog_pos	111-111-8021169341,112-112-410468766	0-4255000500-28754522,111-111-8021162042

108	37	gtid_binlog_state	111-111-8021169341,112-112-410468766	0-4255000500-28754522,111-111-8021162042

109	38	gtid_cleanup_batch_size	N/A	64

110	39	gtid_current_pos	0-111-31146,111-111-8021169341,112-112-410468766	0-4255000500-28754522,111-111-8021169341,112-112-410468766

111	40	gtid_domain_id	111	0

112	40	gtid_ignore_duplicates	OFF	OFF

113	41	gtid_pos_auto_engines	N/A	

114	42	gtid_slave_pos	0-111-31146,111-111-8021169341,112-112-410468766	111-111-8021169341,112-112-410468766

115	42	gtid_strict_mode	OFF	OFF

116	42	have_compress	YES	YES

117	42	have_crypt	YES	YES

118	42	have_dynamic_loading	YES	YES

119	42	have_geometry	YES	YES

120	43	have_openssl	NO	YES

121	43	have_profiling	YES	YES

122	43	have_query_cache	YES	YES

123	43	have_rtree_keys	YES	YES

124	43	have_ssl	DISABLED	DISABLED

125	43	have_symlink	YES	YES

126	44	histogram_size		254

127	45	histogram_type	SINGLE_PREC_HB	DOUBLE_PREC_HB

128	46	host_cache_size	807	653

129	47	hostname	pc-db11-1	gcp-prod-oos-sql-0001-mariadb-g01-001

130	48	idle_readonly_transaction_timeout	N/A	0

131	49	idle_transaction_timeout	N/A	0

132	50	idle_write_transaction_timeout	N/A	0

133	50	ignore_builtin_innodb	OFF	OFF

134	50	ignore_db_dirs		

135	51	in_predicate_conversion_threshold	N/A	1000

136	51	init_connect		

137	51	init_file		

138	51	init_slave		

139	51	innodb_adaptive_flushing	ON	ON

140	51	innodb_adaptive_flushing_lwm	10.000000	10.000000

141	51	innodb_adaptive_hash_index	ON	ON

142	52	innodb_adaptive_hash_index_parts	N/A	8

143	52	innodb_autoextend_increment	1000	1000

144	52	innodb_autoinc_lock_mode	2	2

145	52	innodb_buf_dump_status_frequency	0	0

146	53	innodb_buffer_pool_chunk_size	N/A	128 Mo

147	54	innodb_buffer_pool_dump_at_shutdown	OFF	ON

148	54	innodb_buffer_pool_dump_now	OFF	OFF

149	55	innodb_buffer_pool_dump_pct	100	25

150	55	innodb_buffer_pool_filename	ib_buffer_pool	ib_buffer_pool

151	55	innodb_buffer_pool_load_abort	OFF	OFF

152	56	innodb_buffer_pool_load_at_startup	OFF	ON

153	56	innodb_buffer_pool_load_now	OFF	OFF

154	57	innodb_buffer_pool_size	800 Go	189 Go

155	57	innodb_change_buffer_max_size	25	25

156	58	innodb_change_buffering	all	none

157	59	innodb_checksum_algorithm	INNODB	full_crc32

158	59	innodb_cmp_per_index_enabled	OFF	OFF

159	59	innodb_compression_algorithm	zlib	zlib

160	60	innodb_compression_default	N/A	OFF

161	60	innodb_compression_failure_threshold_pct	5	5

162	60	innodb_compression_level	6	6

163	60	innodb_compression_pad_pct_max	50	50

164	61	innodb_data_file_path	ibdata1:1G:autoextend	ibdata1:12M:autoextend

165	62	innodb_data_home_dir	/srv/mysql/data	

166	63	innodb_deadlock_detect	N/A	ON

167	64	innodb_deadlock_report	N/A	full

168	64	innodb_default_encryption_key_id	1	1

169	65	innodb_default_row_format	compact	dynamic

170	65	innodb_defragment	OFF	OFF

171	65	innodb_defragment_fill_factor	0.900000	0.900000

172	65	innodb_defragment_fill_factor_n_recs	20	20

173	65	innodb_defragment_frequency	40	40

174	65	innodb_defragment_n_pages	7	7

175	65	innodb_defragment_stats_accuracy	0	0

176	65	innodb_disable_sort_file_cache	OFF	OFF

177	65	innodb_doublewrite	ON	ON

178	65	innodb_encrypt_log	OFF	OFF

179	65	innodb_encrypt_tables	OFF	OFF

180	66	innodb_encrypt_temporary_tables	N/A	OFF

181	66	innodb_encryption_rotate_key_age	1	1

182	66	innodb_encryption_rotation_iops	100	100

183	66	innodb_encryption_threads	0	0

184	66	innodb_fast_shutdown	1	1

185	66	innodb_fatal_semaphore_wait_threshold	600	600

186	66	innodb_file_per_table	ON	ON

187	67	innodb_fill_factor	N/A	100

188	67	innodb_flush_log_at_timeout	1	1

189	68	innodb_flush_log_at_trx_commit	1	2

190	68	innodb_flush_method	O_DIRECT	O_DIRECT

191	69	innodb_flush_neighbors	0	1

192	70	innodb_flush_sync	N/A	ON

193	70	innodb_flushing_avg_loops	30	30

194	70	innodb_force_primary_key	OFF	OFF

195	70	innodb_force_recovery	0	0

196	70	innodb_ft_aux_table		

197	70	innodb_ft_cache_size	8 Mo	8 Mo

198	70	innodb_ft_enable_diag_print	OFF	OFF

199	70	innodb_ft_enable_stopword	ON	ON

200	70	innodb_ft_max_token_size	84	84

201	70	innodb_ft_min_token_size	3	3

202	70	innodb_ft_num_word_optimize	2000	2000

203	70	innodb_ft_result_cache_limit	2000000000	2000000000

204	70	innodb_ft_server_stopword_table		

205	70	innodb_ft_sort_pll_degree	2	2

206	70	innodb_ft_total_cache_size	610 Mo	610 Mo

207	70	innodb_ft_user_stopword_table		

208	70	innodb_immediate_scrub_data_uncompressed	OFF	OFF

209	71	innodb_instant_alter_column_allowed	N/A	add_drop_reorder

210	72	innodb_io_capacity	200	2000

211	73	innodb_io_capacity_max	2000	4000

212	74	innodb_lock_wait_timeout	10	50

213	75	innodb_log_buffer_size	128 Mo	8 Mo

214	75	innodb_log_file_size	2 Go	2 Go

215	75	innodb_log_group_home_dir	./	./

216	76	innodb_log_write_ahead_size	N/A	8 Ko

217	77	innodb_lru_flush_size	N/A	32

218	78	innodb_lru_scan_depth	100	1536

219	79	innodb_max_dirty_pages_pct	75.000000	90.000000

220	80	innodb_max_dirty_pages_pct_lwm	0.001000	0.000000

221	80	innodb_max_purge_lag	0	0

222	80	innodb_max_purge_lag_delay	0	0

223	81	innodb_max_purge_lag_wait	N/A	4294967295

224	82	innodb_max_undo_log_size	N/A	10 Mo

225	82	innodb_monitor_disable		

226	82	innodb_monitor_enable		

227	82	innodb_monitor_reset		

228	82	innodb_monitor_reset_all		

229	82	innodb_old_blocks_pct	37	37

230	82	innodb_old_blocks_time	1000	1000

231	82	innodb_online_alter_log_max_size	128 Mo	128 Mo

232	83	innodb_open_files	1024	400

233	83	innodb_optimize_fulltext_only	OFF	OFF

234	83	innodb_page_size	16 Ko	16 Ko

235	83	innodb_prefix_index_cluster_optimization	OFF	OFF

236	83	innodb_print_all_deadlocks	OFF	OFF

237	83	innodb_purge_batch_size	300	300

238	84	innodb_purge_rseg_truncate_frequency	N/A	128

239	85	innodb_purge_threads	1	4

240	85	innodb_random_read_ahead	OFF	OFF

241	85	innodb_read_ahead_threshold	56	56

242	85	innodb_read_io_threads	4	4

243	85	innodb_read_only	OFF	OFF

244	86	innodb_read_only_compressed	N/A	OFF

245	86	innodb_rollback_on_timeout	ON	ON

246	86	innodb_sort_buffer_size	1 Mo	1 Mo

247	87	innodb_spin_wait_delay	6	4

248	87	innodb_stats_auto_recalc	ON	ON

249	87	innodb_stats_include_delete_marked	OFF	OFF

250	87	innodb_stats_method	nulls_equal	nulls_equal

251	87	innodb_stats_modified_counter	0	0

252	87	innodb_stats_on_metadata	OFF	OFF

253	87	innodb_stats_persistent	ON	ON

254	87	innodb_stats_persistent_sample_pages	20	20

255	87	innodb_stats_traditional	ON	ON

256	87	innodb_stats_transient_sample_pages	8	8

257	87	innodb_status_output	OFF	OFF

258	87	innodb_status_output_locks	OFF	OFF

259	87	innodb_strict_mode	OFF	OFF

260	87	innodb_sync_spin_loops	30	30

261	87	innodb_table_locks	ON	ON

262	88	innodb_temp_data_file_path	N/A	ibtmp1:12M:autoextend

263	88	innodb_tmpdir		

264	89	innodb_undo_directory	.	./

265	90	innodb_undo_log_truncate	N/A	OFF

266	90	innodb_undo_tablespaces	0	0

267	91	innodb_use_atomic_writes	OFF	ON

268	91	innodb_use_native_aio	ON	ON

269	92	innodb_version	5.6.49-89.0	10.7.4

270	92	innodb_write_io_threads	4	4

271	92	interactive_timeout	28800	28800

272	93	join_buffer_size	1 Mo	6 Mo

273	93	join_buffer_space_limit	2 Mo	2 Mo

274	93	join_cache_level	2	2

275	93	keep_files_on_create	OFF	OFF

276	93	key_buffer_size	128 Mo	128 Mo

277	93	key_cache_age_threshold	300	300

278	93	key_cache_block_size	1 Ko	1 Ko

279	93	key_cache_division_limit	100	100

280	93	key_cache_file_hash_size	512	512

281	94	key_cache_segments	0	64

282	94	large_files_support	ON	ON

283	94	large_page_size		

284	94	large_pages	OFF	OFF

285	94	lc_messages	en_US	en_US

286	95	lc_messages_dir		/usr/share/mysql

287	95	lc_time_names	en_US	en_US

288	95	license	GPL	GPL

289	95	local_infile	ON	ON

290	96	lock_wait_timeout	31536000	86400

291	96	locked_in_memory	OFF	OFF

292	96	log_bin	ON	ON

293	97	log_bin_basename	/srv/mysql/binlog/mysql-bin	/srv/mysql/binlog/mariadb-bin

294	98	log_bin_compress	N/A	OFF

295	99	log_bin_compress_min_len	N/A	256

296	100	log_bin_index	/srv/mysql/binlog/mysql-bin.index	/srv/mysql/binlog/mariadb-bin.index

297	100	log_bin_trust_function_creators	OFF	OFF

298	101	log_disabled_statements	N/A	sp

299	101	log_error	/srv/mysql/log/error.log	/srv/mysql/log/error.log

300	101	log_output	FILE	FILE

301	101	log_queries_not_using_indexes	OFF	OFF

302	101	log_slave_updates	ON	ON

303	102	log_slow_admin_statements	OFF	ON

304	103	log_slow_disabled_statements	N/A	sp

305	104	log_slow_filter	admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on...	admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_mis...

306	104	log_slow_rate_limit	1	1

307	105	log_slow_slave_statements	OFF	ON

308	106	log_slow_verbosity		query_plan

309	106	log_tc_size	24 Ko	24 Ko

310	107	log_warnings	1	2

311	108	long_query_time	2.000000	1.000000

312	108	low_priority_updates	OFF	OFF

313	108	lower_case_file_system	OFF	OFF

314	108	lower_case_table_names	0	0

315	108	master_verify_checksum	OFF	OFF

316	108	max_allowed_packet	268435456	268435456

317	108	max_binlog_cache_size	16 Eo	16 Eo

318	108	max_binlog_size	1 Go	1 Go

319	108	max_binlog_stmt_cache_size	16 Eo	16 Eo

320	109	max_connect_errors	10	100

321	110	max_connections	4096	2000

322	110	max_delayed_threads	20	20

323	110	max_digest_length	1024	1024

324	110	max_error_count	64	64

325	111	max_heap_table_size	16 Mo	256 Mo

326	111	max_insert_delayed_threads	20	20

327	111	max_join_size	16 Eo	16 Eo

328	111	max_length_for_sort_data	1024	1024

329	112	max_password_errors	N/A	4294967295

330	112	max_prepared_stmt_count	16382	16382

331	113	max_recursive_iterations	N/A	1000

332	113	max_relay_log_size	1 Go	1 Go

333	114	max_rowid_filter_size	N/A	128 Ko

334	114	max_seeks_for_key	4294967295	4294967295

335	114	max_session_mem_used	9,22337203685478E+018	9,22337203685478E+018

336	114	max_sort_length	1024	1024

337	114	max_sp_recursion_depth	0	0

338	114	max_statement_time	0.000000	0.000000

339	114	max_tmp_tables	32	32

340	114	max_user_connections	0	0

341	114	max_write_lock_count	4294967295	4294967295

342	114	metadata_locks_cache_size	1 Ko	1 Ko

343	114	metadata_locks_hash_instances	8	8

344	114	min_examined_row_limit	0	0

345	115	mrr_buffer_size	256 Ko	6 Mo

346	115	myisam_block_size	1 Ko	1 Ko

347	115	myisam_data_pointer_size	6	6

348	115	myisam_max_sort_file_size	8 Eo	8 Eo

349	115	myisam_mmap_size	16 Eo	16 Eo

350	116	myisam_recover_options	DEFAULT	BACKUP

351	116	myisam_repair_threads	1	1

352	117	myisam_sort_buffer_size	128 Mo	512 Mo

353	117	myisam_stats_method	NULLS_UNEQUAL	NULLS_UNEQUAL

354	117	myisam_use_mmap	OFF	OFF

355	117	mysql56_temporal_format	ON	ON

356	117	net_buffer_length	16384	16384

357	117	net_read_timeout	30	30

358	117	net_retry_count	10	10

359	117	net_write_timeout	60	60

360	117	old	OFF	OFF

361	118	old_alter_table	OFF	DEFAULT

362	119	old_mode		UTF8_IS_UTF8MB3

363	119	old_passwords	OFF	OFF

364	120	open_files_limit	16384	7463

365	121	optimizer_max_sel_arg_weight	N/A	32000

366	121	optimizer_prune_level	1	1

367	121	optimizer_search_depth	62	62

368	121	optimizer_selectivity_sampling_limit	100	100

369	121	optimizer_switch__index_merge	ON	ON

370	121	optimizer_switch__index_merge_union	ON	ON

371	121	optimizer_switch__index_merge_sort_union	ON	ON

372	121	optimizer_switch__index_merge_intersection	ON	ON

373	121	optimizer_switch__index_merge_sort_intersection	OFF	OFF

374	121	optimizer_switch__engine_condition_pushdown	OFF	OFF

375	121	optimizer_switch__index_condition_pushdown	ON	ON

376	121	optimizer_switch__derived_merge	ON	ON

377	121	optimizer_switch__derived_with_keys	ON	ON

378	121	optimizer_switch__firstmatch	ON	ON

379	121	optimizer_switch__loosescan	ON	ON

380	121	optimizer_switch__materialization	ON	ON

381	121	optimizer_switch__in_to_exists	ON	ON

382	121	optimizer_switch__semijoin	ON	ON

383	121	optimizer_switch__partial_match_rowid_merge	ON	ON

384	121	optimizer_switch__partial_match_table_scan	ON	ON

385	121	optimizer_switch__subquery_cache	ON	ON

386	121	optimizer_switch__mrr	OFF	OFF

387	121	optimizer_switch__mrr_cost_based	OFF	OFF

388	121	optimizer_switch__mrr_sort_keys	OFF	OFF

389	121	optimizer_switch__outer_join_with_cache	ON	ON

390	121	optimizer_switch__semijoin_with_cache	ON	ON

391	121	optimizer_switch__join_cache_incremental	ON	ON

392	121	optimizer_switch__join_cache_hashed	ON	ON

393	121	optimizer_switch__join_cache_bka	ON	ON

394	122	optimizer_switch__optimize_join_buffer_size	OFF	ON

395	122	optimizer_switch__table_elimination	ON	ON

396	122	optimizer_switch__extended_keys	ON	ON

397	122	optimizer_switch__exists_to_in	ON	ON

398	123	optimizer_switch__orderby_uses_equalities	N/A	ON

399	124	optimizer_switch__condition_pushdown_for_derived	N/A	ON

400	125	optimizer_switch__split_materialized	N/A	ON

401	126	optimizer_switch__condition_pushdown_for_subquery	N/A	ON

402	127	optimizer_switch__rowid_filter	N/A	ON

403	128	optimizer_switch__condition_pushdown_from_having	N/A	ON

404	129	optimizer_trace	N/A	enabled=off

405	130	optimizer_trace_max_mem_size	N/A	1 Mo

406	131	optimizer_use_condition_selectivity	1	4

407	132	performance_schema	OFF	ON

408	132	performance_schema_accounts_size	-1	-1

409	133	performance_schema_digests_size	-1	10000

410	134	performance_schema_events_stages_history_long_size	-1	10000

411	135	performance_schema_events_stages_history_size	-1	10

412	136	performance_schema_events_statements_history_long_size	-1	10000

413	137	performance_schema_events_statements_history_size	-1	10

414	138	performance_schema_events_transactions_history_long_size	N/A	10000

415	139	performance_schema_events_transactions_history_size	N/A	10

416	140	performance_schema_events_waits_history_long_size	-1	10000

417	141	performance_schema_events_waits_history_size	-1	10

418	141	performance_schema_hosts_size	-1	-1

419	142	performance_schema_max_cond_classes	80	90

420	142	performance_schema_max_cond_instances	-1	-1

421	142	performance_schema_max_digest_length	1024	1024

422	143	performance_schema_max_file_classes	50	80

423	143	performance_schema_max_file_handles	32768	32768

424	143	performance_schema_max_file_instances	-1	-1

425	144	performance_schema_max_index_stat	N/A	-1

426	145	performance_schema_max_memory_classes	N/A	320

427	146	performance_schema_max_metadata_locks	N/A	-1

428	147	performance_schema_max_mutex_classes	200	210

429	147	performance_schema_max_mutex_instances	-1	-1

430	148	performance_schema_max_prepared_statements_instances	N/A	-1

431	149	performance_schema_max_program_instances	N/A	-1

432	150	performance_schema_max_rwlock_classes	40	50

433	150	performance_schema_max_rwlock_instances	-1	-1

434	150	performance_schema_max_socket_classes	10	10

435	150	performance_schema_max_socket_instances	-1	-1

436	151	performance_schema_max_sql_text_length	N/A	1024

437	152	performance_schema_max_stage_classes	150	160

438	153	performance_schema_max_statement_classes	178	221

439	154	performance_schema_max_statement_stack	N/A	10

440	154	performance_schema_max_table_handles	-1	-1

441	154	performance_schema_max_table_instances	-1	-1

442	155	performance_schema_max_table_lock_stat	N/A	-1

443	155	performance_schema_max_thread_classes	50	50

444	155	performance_schema_max_thread_instances	-1	-1

445	156	performance_schema_session_connect_attrs_size	-1	512

446	157	performance_schema_setup_actors_size	100	-1

447	158	performance_schema_setup_objects_size	100	-1

448	158	performance_schema_users_size	-1	-1

449	158	pid_file	/var/run/mysqld/mysqld.pid	/var/run/mysqld/mysqld.pid

450	159	plugin_dir	/usr/lib/x86_64-linux-gnu/mariadb18/plugin/	/usr/lib/mysql/plugin/

451	160	plugin_maturity	unknown	gamma

452	160	port	3306	3306

453	160	preload_buffer_size	32 Ko	32 Ko

454	160	profiling	OFF	OFF

455	160	profiling_history_size	15	15

456	160	progress_report_time	5	5

457	160	protocol_version	10	10

458	161	proxy_protocol_networks	N/A	

459	161	query_alloc_block_size	16 Ko	16 Ko

460	162	query_cache_limit	67108864	131072

461	162	query_cache_min_res_unit	4096	4096

462	163	query_cache_size	32 Mo	

463	163	query_cache_strip_comments	OFF	OFF

464	163	query_cache_type	OFF	OFF

465	163	query_cache_wlock_invalidate	OFF	OFF

466	163	query_prealloc_size	24 Ko	24 Ko

467	164	query_response_time_flush	N/A	OFF

468	165	query_response_time_range_base	N/A	10

469	166	query_response_time_stats	N/A	ON

470	166	range_alloc_block_size	4 Ko	4 Ko

471	167	read_binlog_speed_limit	N/A	0

472	167	read_buffer_size	2 Mo	2 Mo

473	167	read_only	OFF	OFF

474	168	read_rnd_buffer_size	256 Ko	6 Mo

475	169	relay_log	/srv/mysql/relaylog/relay-bin.log	/srv/mysql/relaylog/relay-bin

476	169	relay_log_basename	/srv/mysql/relaylog/relay-bin	/srv/mysql/relaylog/relay-bin

477	169	relay_log_index	/srv/mysql/relaylog/relay-bin.index	/srv/mysql/relaylog/relay-bin.index

478	170	relay_log_info_file	relay-log.info	/srv/mysql/relaylog/relay-bin.info

479	170	relay_log_purge	ON	ON

480	170	relay_log_recovery	OFF	OFF

481	170	relay_log_space_limit	0	0

482	171	replicate_annotate_row_events	OFF	ON

483	172	replicate_do_db		pc_aggregation

484	172	replicate_do_table		

485	172	replicate_events_marked_for_skip	REPLICATE	REPLICATE

486	172	replicate_ignore_db		

487	172	replicate_ignore_table		

488	172	replicate_wild_do_table		

489	172	replicate_wild_ignore_table		

490	173	report_host		gcp-prod-oos-sql-0001-mariadb-g01-001

491	173	report_password		

492	173	report_port	3306	3306

493	173	report_user		

494	174	require_secure_transport	N/A	OFF

495	174	rowid_merge_buff_size	8 Mo	8 Mo

496	175	rpl_semi_sync_master_enabled	N/A	OFF

497	176	rpl_semi_sync_master_timeout	N/A	10000

498	177	rpl_semi_sync_master_trace_level	N/A	32

499	178	rpl_semi_sync_master_wait_no_slave	N/A	ON

500	179	rpl_semi_sync_master_wait_point	N/A	AFTER_COMMIT

501	180	rpl_semi_sync_slave_delay_master	N/A	OFF

502	181	rpl_semi_sync_slave_enabled	N/A	OFF

503	182	rpl_semi_sync_slave_kill_conn_timeout	N/A	5

504	183	rpl_semi_sync_slave_trace_level	N/A	32

505	183	secure_auth	ON	ON

506	183	secure_file_priv		

507	184	secure_timestamp	N/A	NO

508	184	server_audit_events	CONNECT,QUERY_DDL	CONNECT,QUERY_DDL

509	184	server_audit_excl_users		

510	184	server_audit_file_path	/srv/mysql/log/audit.log	/srv/mysql/log/audit.log

511	184	server_audit_file_rotate_now	OFF	OFF

512	184	server_audit_file_rotate_size	977 Ko	977 Ko

513	184	server_audit_file_rotations	9	9

514	184	server_audit_incl_users		

515	184	server_audit_logging	ON	ON

516	184	server_audit_mode	0	0

517	184	server_audit_output_type	file	file

518	184	server_audit_query_log_limit	1024	1024

519	184	server_audit_syslog_facility	LOG_USER	LOG_USER

520	184	server_audit_syslog_ident	mysql-server_auditing	mysql-server_auditing

521	184	server_audit_syslog_info		

522	184	server_audit_syslog_priority	LOG_INFO	LOG_INFO

523	185	server_id	111	4255000500

524	186	session_track_schema	N/A	ON

525	187	session_track_state_change	N/A	OFF

526	188	session_track_system_variables	N/A	autocommit,character_set_client,character_set_connection,character_set_results,time_zone

527	189	session_track_transaction_info	N/A	OFF

528	189	skip_external_locking	ON	ON

529	189	skip_name_resolve	ON	ON

530	189	skip_networking	OFF	OFF

531	189	skip_show_database	OFF	OFF

532	189	slave_compressed_protocol	OFF	OFF

533	189	slave_ddl_exec_mode	IDEMPOTENT	IDEMPOTENT

534	189	slave_domain_parallel_threads	0	0

535	189	slave_exec_mode	STRICT	STRICT

536	189	slave_load_tmpdir	/srv/mysql/tmp	/srv/mysql/tmp

537	189	slave_max_allowed_packet	1073741824	1073741824

538	190	slave_net_timeout	3600	60

539	190	slave_parallel_max_queued	131072	131072

540	191	slave_parallel_mode	conservative	optimistic

541	191	slave_parallel_threads	0	0

542	192	slave_parallel_workers	N/A	0

543	192	slave_run_triggers_for_rbr	NO	NO

544	192	slave_skip_errors	OFF	OFF

545	192	slave_sql_verify_checksum	ON	ON

546	192	slave_transaction_retries	10	10

547	193	slave_transaction_retry_errors	N/A	1158,1159,1160,1161,1205,1213,1429,2013,12701

548	194	slave_transaction_retry_interval	N/A	0

549	194	slave_type_conversions		

550	194	slow_launch_time	2	2

551	194	slow_query_log	ON	ON

552	195	slow_query_log_file	/srv/mysql/log/mysql-slow.log	/srv/mysql/log/mariadb-slow.log

553	195	socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock

554	196	sort_buffer_size	2 Mo	4 Mo

555	196	sql_auto_is_null	OFF	OFF

556	196	sql_big_selects	ON	ON

557	196	sql_buffer_result	OFF	OFF

558	197	sql_if_exists	N/A	OFF

559	197	sql_log_bin	ON	ON

560	197	sql_log_off	OFF	OFF

561	197	sql_mode	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION	NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

562	197	sql_notes	ON	ON

563	197	sql_quote_show_create	ON	ON

564	197	sql_safe_updates	OFF	OFF

565	197	sql_select_limit	1,84467440737096E+019	1,84467440737096E+019

566	197	sql_slave_skip_counter	0	0

567	197	sql_warnings	OFF	OFF

568	197	ssl_ca		

569	197	ssl_capath		

570	197	ssl_cert		

571	197	ssl_cipher		

572	197	ssl_crl		

573	197	ssl_crlpath		

574	197	ssl_key		

575	198	standard_compliant_cte	N/A	ON

576	198	storage_engine	InnoDB	InnoDB

577	198	stored_program_cache	256	256

578	198	strict_password_validation	ON	ON

579	198	sync_binlog	0	0

580	198	sync_frm	ON	ON

581	198	sync_master_info	10000	10000

582	198	sync_relay_log	10000	10000

583	198	sync_relay_log_info	10000	10000

584	199	system_time_zone	CEST	UTC

585	200	system_versioning_alter_history	N/A	ERROR

586	201	system_versioning_asof	N/A	DEFAULT

587	202	table_definition_cache	1024	400

588	203	table_open_cache	1024	400

589	204	table_open_cache_instances	N/A	8

590	205	tcp_keepalive_interval	N/A	0

591	206	tcp_keepalive_probes	N/A	0

592	207	tcp_keepalive_time	N/A	0

593	208	tcp_nodelay	N/A	ON

594	209	thread_cache_size	200	128

595	209	thread_handling	one-thread-per-connection	one-thread-per-connection

596	210	thread_pool_dedicated_listener	N/A	OFF

597	211	thread_pool_exact_stats	N/A	OFF

598	211	thread_pool_idle_timeout	60	60

599	212	thread_pool_max_threads	1000	65536

600	212	thread_pool_oversubscribe	3	3

601	213	thread_pool_prio_kickup_timer	N/A	1000

602	214	thread_pool_priority	N/A	auto

603	214	thread_pool_size	32	32

604	214	thread_pool_stall_limit	500	500

605	214	thread_stack	299008	299008

606	214	time_format	%H:%i:%s	%H:%i:%s

607	215	time_zone	utc	SYSTEM

608	216	tls_version	N/A	TLSv1.1,TLSv1.2,TLSv1.3

609	217	tmp_disk_table_size	N/A	16 Eo

610	218	tmp_memory_table_size	N/A	256 Mo

611	219	tmp_table_size	512 Mo	256 Mo

612	219	tmpdir	/srv/mysql/tmp	/srv/mysql/tmp

613	219	transaction_alloc_block_size	8 Ko	8 Ko

614	219	transaction_prealloc_size	4 Ko	4 Ko

615	219	tx_isolation	REPEATABLE-READ	REPEATABLE-READ

616	219	tx_read_only	OFF	OFF

617	219	unique_checks	ON	ON

618	219	updatable_views_with_limit	YES	YES

619	220	use_stat_tables	NEVER	PREFERABLY_FOR_QUERIES

620	221	userstat	OFF	ON

621	222	version	10.1.48-MariaDB-0+deb9u2	10.7.4-MariaDB-1:10.7.4+maria~bullseye-log

622	223	version_comment	Debian 9.13	mariadb.org binary distribution

623	223	version_compile_machine	x86_64	x86_64

624	223	version_compile_os	debian-linux-gnu	debian-linux-gnu

625	224	version_malloc_library	system jemalloc	system

626	225	version_source_revision	N/A	99a433ed1cc2cebad93d6ece2b65691f2f49d3ea

627	226	version_ssl_library	YaSSL 2.4.4	OpenSSL 1.1.1n 15 Mar 2022

628	226	wait_timeout	18000	18000

629	226	wsrep_osu_method	TOI	TOI

630	227	wsrep_sr_store	N/A	table

631	227	wsrep_auto_increment_control	ON	ON

632	227	wsrep_causal_reads	OFF	OFF

633	227	wsrep_certification_rules	strict	strict

634	227	wsrep_certify_nonpk	ON	ON

635	228	wsrep_cluster_address		gcomm://

636	229	wsrep_cluster_name	my_wsrep_cluster	68Koncept

637	229	wsrep_convert_lock_to_trx	OFF	OFF

638	229	wsrep_data_home_dir	/srv/mysql/data/	/srv/mysql/data/

639	229	wsrep_dbug_option		

640	230	wsrep_debug	OFF	NONE

641	230	wsrep_desync	OFF	OFF

642	230	wsrep_dirty_reads	OFF	OFF

643	230	wsrep_drupal_282555_workaround	OFF	OFF

644	230	wsrep_forced_binlog_format	NONE	NONE

645	230	wsrep_gtid_domain_id	0	0

646	231	wsrep_gtid_mode	OFF	ON

647	232	wsrep_ignore_apply_errors	N/A	7

648	233	wsrep_load_data_splitting	ON	OFF

649	234	wsrep_log_conflicts	OFF	ON

650	235	wsrep_max_ws_rows	0	131072

651	236	wsrep_max_ws_size	2 Go	1 Go

652	237	wsrep_mode	N/A	

653	237	wsrep_mysql_replication_bundle	0	0

654	238	wsrep_node_address		10.122.5.14

655	238	wsrep_node_incoming_address	AUTO	AUTO

656	239	wsrep_node_name	pc-db11-1	gcp-prod-oos-sql-0001-mariadb-g01-001

657	239	wsrep_notify_cmd		

658	239	wsrep_on	OFF	OFF

659	240	wsrep_patch_version	wsrep_25.24	wsrep_26.22

660	241	wsrep_provider	none	/usr/lib/galera/libgalera_smm.so

661	241	wsrep_recover	OFF	OFF

662	241	wsrep_reject_queries	NONE	NONE

663	241	wsrep_restart_slave	OFF	OFF

664	241	wsrep_retry_autocommit	1	1

665	241	wsrep_slave_fk_checks	ON	ON

666	241	wsrep_slave_uk_checks	OFF	OFF

667	242	wsrep_slave_threads	1	4

668	243	wsrep_sst_auth		sst:QSEDWGRg133

669	243	wsrep_sst_donor		

670	243	wsrep_sst_donor_rejects_queries	OFF	OFF

671	244	wsrep_sst_method	rsync	xtrabackup-v2

672	244	wsrep_sst_receive_address	AUTO	AUTO

673	244	wsrep_start_position	00000000-0000-0000-0000-000000000000:-1	00000000-0000-0000-0000-000000000000:-1

674	244	wsrep_sync_wait	0	0

675	245	wsrep_trx_fragment_size	N/A	

676	246	wsrep_trx_fragment_unit	N/A	bytes

677	247	aria_recover	NORMAL	N/A

678	248	innodb_adaptive_hash_index_partitions	13	N/A

679	249	innodb_adaptive_max_sleep_delay	150000	N/A

680	250	innodb_additional_mem_pool_size	256 Mo	N/A

681	251	innodb_api_bk_commit_interval	5	N/A

682	252	innodb_api_disable_rowlock	OFF	N/A

683	253	innodb_api_enable_binlog	OFF	N/A

684	254	innodb_api_enable_mdl	OFF	N/A

685	255	innodb_api_trx_level	0	N/A

686	256	innodb_background_scrub_data_check_interval	3600	N/A

687	257	innodb_background_scrub_data_compressed	OFF	N/A

688	258	innodb_background_scrub_data_interval	604800	N/A

689	259	innodb_background_scrub_data_uncompressed	OFF	N/A

690	260	innodb_buffer_pool_instances	64	N/A

691	261	innodb_buffer_pool_populate	OFF	N/A

692	262	innodb_checksums	ON	N/A

693	263	innodb_cleaner_lsn_age_factor	HIGH_CHECKPOINT	N/A

694	264	innodb_commit_concurrency	0	N/A

695	265	innodb_concurrency_tickets	5000	N/A

696	266	innodb_corrupt_table_action	assert	N/A

697	267	innodb_disallow_writes	OFF	N/A

698	268	innodb_empty_free_list_algorithm	BACKOFF	N/A

699	269	innodb_fake_changes	OFF	N/A

700	270	innodb_file_format	Barracuda	N/A

701	271	innodb_file_format_check	ON	N/A

702	272	innodb_file_format_max	Barracuda	N/A

703	273	innodb_force_load_corrupted	OFF	N/A

704	274	innodb_foreground_preflush	EXPONENTIAL_BACKOFF	N/A

705	275	innodb_idle_flush_pct	100	N/A

706	276	innodb_instrument_semaphores	OFF	N/A

707	277	innodb_kill_idle_transaction	0	N/A

708	278	innodb_large_prefix	OFF	N/A

709	279	innodb_lock_schedule_algorithm	fcfs	N/A

710	280	innodb_locking_fake_changes	ON	N/A

711	281	innodb_locks_unsafe_for_binlog	OFF	N/A

712	282	innodb_log_arch_dir	./	N/A

713	283	innodb_log_arch_expire_sec	0	N/A

714	284	innodb_log_archive	OFF	N/A

715	285	innodb_log_block_size	512	N/A

716	286	innodb_log_checksum_algorithm	INNODB	N/A

717	287	innodb_log_compressed_pages	ON	N/A

718	288	innodb_log_files_in_group	2	N/A

719	289	innodb_max_bitmap_file_size	100 Mo	N/A

720	290	innodb_max_changed_pages	1000000	N/A

721	291	innodb_mirrored_log_groups	1	N/A

722	292	innodb_mtflush_threads	8	N/A

723	293	innodb_print_lock_wait_timeout_info	OFF	N/A

724	294	innodb_replication_delay	0	N/A

725	295	innodb_rollback_segments	128	N/A

726	296	innodb_sched_priority_cleaner	19	N/A

727	297	innodb_scrub_log	OFF	N/A

728	298	innodb_scrub_log_speed	256	N/A

729	299	innodb_show_locks_held	10	N/A

730	300	innodb_show_verbose_locks	0	N/A

731	301	innodb_simulate_comp_failures	0	N/A

732	302	innodb_stats_sample_pages	8	N/A

733	303	innodb_support_xa	ON	N/A

734	304	innodb_sync_array_size	1	N/A

735	305	innodb_thread_concurrency	32	N/A

736	306	innodb_thread_sleep_delay	0	N/A

737	307	innodb_track_changed_pages	OFF	N/A

738	308	innodb_undo_logs	128	N/A

739	309	innodb_use_fallocate	OFF	N/A

740	310	innodb_use_global_flush_log_at_trx_commit	ON	N/A

741	311	innodb_use_mtflush	OFF	N/A

742	312	innodb_use_stacktrace	OFF	N/A

743	313	innodb_use_sys_malloc	ON	N/A

744	314	innodb_use_trim	OFF	N/A

745	315	max_long_data_size	16 Mo	N/A

746	316	multi_range_count	256	N/A

747	317	thread_concurrency	10	N/A

748	318	timed_mutexes	OFF	N/A

749	319	wsrep_replicate_myisam	OFF	N/A