-
Notifications
You must be signed in to change notification settings - Fork 96
/
Copy pathmariadb-variables-list.txt
2150 lines (2150 loc) · 72 KB
/
mariadb-variables-list.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-0, --log-long-format
-a (--ansii)
Aborted_clients
Aborted_connects
--abort-slave-event-count
Access_denied_errors
Acl_column_grants
Acl_database_grants
Acl_function_grants
Acl_package_body_grants
Acl_package_spec_grants
Acl_procedure_grants
Acl_proxy_users
Acl_role_grants
Acl_roles
Acl_table_grants
Acl_users
--allow-suspicious-udfs
--ansii
--aria-block-size, aria_block_size
--aria-checkpoint-interval, aria_checkpoint_interval
--aria-checkpoint-log-activity, aria_checkpoint_log_activity
--aria-encrypt-tables, aria_encrypt_tables
--aria-force-start-after-recovery-failures, aria_force_start_after_recovery_failures
--aria-group-commit, aria_group_commit
--aria-group-commit-interval, aria_group_commit_interval
--aria-log-file-size, aria_log_file_size
--aria-log-purge-type, aria_log_purge_type
--aria-max-sort-file-size, aria_max_sort_file_size
--aria-pagecache-age-threshold, aria_pagecache_age_threshold
Aria_pagecache_blocks_not_flushed
Aria_pagecache_blocks_unused
Aria_pagecache_blocks_used
--aria-pagecache-buffer-size, aria_pagecache_buffer_size
--aria-pagecache-division-limit, aria_pagecache_division_limit
--aria-pagecache-file-hash-size, aria_pagecache_file_hash_size
Aria_pagecache_read_requests
Aria_pagecache_reads
Aria_pagecache_write_requests
Aria_pagecache_writes
--aria-page-checksum, aria_page_checksum
--aria-recover, aria_recover
--aria-repair-threads, aria_repair_threads
--aria-sort-buffer-size, aria_sort_buffer_size
--aria-stats-method, aria_stats_method
--aria-sync-log-dir, aria_sync_log_dir
Aria_transaction_log_syncs
aria_used_for_temp_tables
--autocommit, autocommit
--auto-increment-increment, auto_increment_increment
--auto-increment-offset, auto_increment_offset
--automatic-sp-privileges, automatic_sp_privileges
aws_key_management_key_spec
aws_key_management_log_level
aws_key_management_master_key_id
aws_key_management_rotate_key
--back-log, back_log
-b, --basedir, basedir
--big-tables, big_tables
--bind-address, bind_address
--binlog-annotate-row-events, binlog_annotate_row_events
Binlog_bytes_written
Binlog_cache_disk_use
--binlog-cache-size, binlog_cache_size
Binlog_cache_use
--binlog-checksum, binlog_checksum
Binlog_commits
--binlog-commit-wait-count, binlog_commit_wait_count
--binlog-commit-wait-count, binlog_commit_wait_usec
--binlog-direct-non-transactional-updates, binlog_direct_non_transactional_updates
--binlog-do-db
--binlog-file-cache-size, binlog_file_cache_size
--binlog-format, binlog_format
Binlog_group_commits
Binlog_group_commit_trigger_count
Binlog_group_commit_trigger_lock_wait
Binlog_group_commit_trigger_timeout
--binlog-ignore-db
--binlog-optimize-thread-scheduling, binlog_optimize_thread_scheduling
--binlog-row-event-max-size
--binlog-row-image, binlog_row_image
Binlog_snapshot_file
Binlog_snapshot_position
Binlog_stmt_cache_disk_use
--binlog-stmt-cache-size, binlog_stmt_cache_size
Binlog_stmt_cache_use
--bootstrap
--bulk_insert-buffer-size, bulk_insert_buffer_size
Busy_time
Bytes_received
Bytes_sent
cassandra_default_thrift_host
cassandra_failure_retries
cassandra_insert_batch_size
cassandra_multiget_batch_size
Cassandra_multiget_keys_scanned
Cassandra_multiget_reads
Cassandra_multiget_rows_read
Cassandra_network_exceptions
cassandra_read_consistency
cassandra_rnd_batch_size
Cassandra_row_insert_batches
Cassandra_row_inserts
Cassandra_timeout_exceptions
Cassandra_unavailable_exceptions
cassandra_write_consistency
-C, --character-set-server, character_set_server
character_set_client
--character-set-client-handshake
character_set_connection
character_set_database
--character-set-filesystem, character_set_filesystem
character_set_results
--character-sets-dir, character_sets_dir
character_set_system
--check-constraint-checks, check_constraint_checks
collation_connection
collation_database
--collation-server, collation_server
Column_compressions
--column-compression-threshold, column_compression_threshold
--column-compression-zlib-level, column_compression_zlib_level
--column-compression-zlib-strategy, column_compression_zlib_strategy
--column-compression-zlib-wrap, column_compression_zlib_wrap
Column_decompressions
Com_admin_commands
Com_alter_db
Com_alter_db_upgrade
Com_alter_event
Com_alter_function
Com_alter_procedure
Com_alter_sequence
Com_alter_server
Com_alter_table
Com_alter_tablespace
Com_alter_user
Com_analyze
Com_assign_to_keycache
Com_backup_table
Com_begin
Com_binlog
Com_call_procedure
Com_change_db
Com_change_master
Com_check
Com_checksum
Com_commit
Com_compound_sql
Com_create_db
Com_create_event
Com_create_function
Com_create_index
Com_create_package
Com_create_package_body
Com_create_procedure
Com_create_role
Com_create_sequence
Com_create_server
Com_create_table
Com_create_temporary_table
Com_create_trigger
Com_create_udf
Com_create_user
Com_create_view
Com_dealloc_sql
Com_delete
Com_delete_multi
Com_do
Com_drop_db
Com_drop_event
Com_drop_function
Com_drop_index
Com_drop_package
Com_drop_package_body
Com_drop_procedure
Com_drop_role
Com_drop_sequence
Com_drop_server
Com_drop_table
Com_drop_temporary_table
Com_drop_trigger
Com_drop_user
Com_drop_view
Com_empty_query
Com_execute_immediate
Com_execute_sql
Com_flush
Com_get_diagnostics
Com_grant
Com_grant_role
Com_ha_close
Com_ha_open
Com_ha_read
Com_help
Com_insert
Com_insert_select
Com_install_plugin
Com_kill
Com_load
Com_load_master_data
Com_load_master_table
Com_lock_tables
Com_multi
Com_optimize
--completion-type, completion_type
Com_preload_keys
Com_prepare_sql
Compression
Com_purge
Com_purge_before_date
Com_release_savepoint
Com_rename_table
Com_rename_user
Com_repair
Com_replace
Com_replace_select
Com_reset
Com_resignal
Com_restore_table
Com_revoke
Com_revoke_all
Com_revoke_grant
Com_rollback
Com_rollback_to_savepoint
Com_savepoint
Com_select
Com_set_option
Com_show_authors
Com_show_binlog_events
Com_show_binlogs
Com_show_charsets
Com_show_client_statistics
Com_show_collations
Com_show_column_types
Com_show_contributors
Com_show_create_db
Com_show_create_event
Com_show_create_func
Com_show_create_package
Com_show_create_package_body
Com_show_create_proc
Com_show_create_table
Com_show_create_trigger
Com_show_create_user
Com_show_databases
Com_show_engine_logs
Com_show_engine_mutex
Com_show_engine_status
Com_show_errors
Com_show_events
Com_show_explain
Com_show_fields
Com_show_function_status
Com_show_generic
Com_show_grants
Com_show_index_statistics
Com_show_keys
Com_show_master_status
Com_show_new_master
Com_show_open_tables
Com_show_package_body_status
Com_show_package_status
Com_show_plugins
Com_show_privileges
Com_show_procedure_status
Com_show_processlist
Com_show_profile
Com_show_profiles
Com_show_relaylog_events
Com_show_slave_hosts
Com_show_slave_status
Com_show_status
Com_show_storage_engines
Com_show_tables
Com_show_table_statistics
Com_show_table_status
Com_show_triggers
Com_show_user_statistics
Com_show_variable
Com_show_warnings
Com_shutdown
Com_signal
Com_slave_start
Com_slave_stop
Com_start_all_slaves
Com_start_slave
Com_stmt_close
Com_stmt_execute
Com_stmt_fetch
Com_stmt_prepare
Com_stmt_reprepare
Com_stmt_reset
Com_stmt_send_long_data
Com_stop_all_slaves
Com_stop_slave
Com_truncate
Com_uninstall_plugin
Com_unlock_tables
Com_update
Com_update_multi
Com_xa_commit
Com_xa_end
Com_xa_prepare
Com_xa_recover
Com_xa_rollback
Com_xa_start
--concurrent-insert, concurrent_insert
--connect-class-path, connect_class_path
--connect-conv-size, connect_conv_size
--connect-enable-mongo, connect_enable_mongo
--connect-exact-info, connect_exact_info
--connect-indx-map, connect_indx_map
Connection_errors_accept
Connection_errors_internal
Connection_errors_max_connections
Connection_errors_peer_address
Connection_errors_select
Connection_errors_tcpwrap
Connections
--connect-java-wrapper, connect_java_wrapper
--connect-json-grp-size, connect_json_grp_size
--connect-json-null, connect_json_null
--connect-jvm-path, connect_jvm_path
--connect-timeout, connect_timeout
--connect-type-conv, connect_type_conv
--connect-use-tempfile, connect_use_tempfile
--connect-work-size, connect_work_size
--connect-xtrace, connect_xtrace
--console
--core-file
Cpu_time
cracklib-password-check, cracklib_password_check
cracklib-password-check-dictionary, cracklib_password_check-dictionary
Created_tmp_disk_tables
Created_tmp_files
Created_tmp_tables
--date-format, date_format
--datetime-format, datetime_format
--deadlock-search-depth-long, deadlock_search_depth_long
--deadlock-search-depth-short, deadlock_search_depth_short
--deadlock-timeout-long, deadlock_timeout_long
--deadlock-timeout-short, deadlock_timeout_short
--debug-assert-if-crashed-table
--debug_binlog_fsync_sleep=#
--debug-crc-break=#
-#, --debug, debug
--debug-flush
--debug-no-thread-alarm, debug_no_thread_alarm
debug_sync
--debug-sync-timeout[=#]
--default-character-set
--default-collation
--default-master-connection, default_master_connection
--default-regex-flags, default_regex_flags
--defaults-extra-file
--defaults-file
--default-storage-engine, default_storage_engine
--default-table-type, default_table_type
--default-time-zone
--default-tmp-storage-engine, default_tmp_storage_engine
--default-week-format, default_week_format
Delayed_errors
--delayed-insert-limit, delayed_insert_limit
Delayed_insert_threads
--delayed-insert-timeout, delayed_insert_timeout
--delayed-queue-size, delayed_queue_size
Delayed_writes
--delay-key-write, delay_key_write
--delay-key-write-for-all-tables
Delete_scan
--des-key-file
--disconnect-slave-event-count
--div-precision-increment, div_precision_increment
Empty_queries
--enable-locking
--enable-named-pipe
--encrypt-binlog, encrypt_binlog
--encryption-algorithm, encryption_algorithm
--encrypt-tmp-disk-tables, encrypt_tmp_disk_tables
--encrypt-tmp-files, encrypt_tmp_files
enforce_storage_engine
--engine-condition-pushdown, engine_condition_pushdown
error_count
--event-scheduler, event_scheduler
Executed_events
Executed_triggers
--expensive-subquery-limit, expensive_subquery_limit
--expire-logs-days, expire_logs_days
--explicit-defaults-for-timestamp, explicit_defaults_for_timestamp
--external-locking
external_user
--extra-max-connections, extra_max_connections
--extra-port, extra_port
Feature_check_constraint
Feature_delay_key_write
Feature_dynamic_columns
Feature_fulltext
Feature_gis
Feature_invisible_columns
Feature_locale
Feature_subquery
Feature_timezone
Feature_trigger
Feature_window_functions
Feature_xml
--feedback
--feedback-http-proxy, feedback_http_proxy
--feedback-send-retry-wait, feedback_send_retry_wait
--feedback-send-timeout, feedback_send_timeout
feedback_server_uid
--feedback-url, feedback_url
--feedback-user-info, feedback_user_info
--flashback
Flush_commands
--flush, flush
--flush-time, flush_time
foreign_key_checks
--ft-boolean-syntax, ft_boolean_syntax
--ft-max-word-len, ft_max_word_len
--ft-min-word-len, ft_min_word_len
--ft-query-expansion-limit, ft_query_expansion_limit
--ft-stopword-file, ft_stopword_file
--gdb
--general-log-file, general_log_file
--general-log, general_log
--getopt-prefix-matching
--group-concat-max-len, group_concat_max_len
gtid_binlog_pos
gtid_binlog_state
gtid_current_pos
--gtid-domain-id, gtid_domain_id
--gtid-ignore-duplicates, gtid_ignore_duplicates
gtid_pos_auto_engines
gtid_seq_no
gtid_slave_pos
--gtid-strict-mode, gtid_strict_mode
Handler_commit
Handler_delete
Handler_discover
Handler_external_lock
Handler_icp_attempts
Handler_icp_match
Handler_mrr_init
Handler_mrr_key_refills
Handler_mrr_rowid_refills
Handler_prepare
Handler_read_first
Handler_read_key
Handler_read_last
Handler_read_next
Handler_read_prev
Handler_read_retry
Handler_read_rnd
Handler_read_rnd_deleted
Handler_read_rnd_next
Handler_rollback
Handler_savepoint
Handler_savepoint_rollback
--handlersocket-accept-balance, handlersocket_accept_balance
--handlersocket-address, handlersocket_address
--handlersocket-backlog, handlersocket_backlog
--handlersocket-epoll, handlersocket_epoll
--handlersocket-plain-secret, handlersocket_plain_secret
--handlersocket-plain-secret-wr, handlersocket_plain_secret_wr
--handlersocket-port, handlersocket_port
--handlersocket-port-wr, handlersocket_port_wr
--handlersocket-rcvbuf, handlersocket_rcvbuf
--handlersocket-readsize, handlersocket_readsize
--handlersocket-sndbuf, handlersocket_sndbuf
--handlersocket-threads, handlersocket_threads
--handlersocket-threads_wr, handlersocket_threads_wr
--handlersocket-timeout, handlersocket_timeout
--handlersocket-verbose, handlersocket_verbose
--handlersocket-wrlock-timeout, handlersocket_wrlock_timeout
Handler_tmp_delete
Handler_tmp_update
Handler_tmp_write
Handler_update
Handler_write
have_compress
have_crypt
have_csv
have_dynamic_loading
have_geometry
have_innodb
have_ndbcluster
have_openssl
have_partitioning
have_profiling
have_query_cache
have_rtree_keys
have_ssl
have_symlink
-h, --datadir, datadir
--help
--histogram-size, histogram_size
--histogram-type, histogram_type
--host-cache-size, host_cache_size
hostname
identity
--idle-readonly-transaction-timeout, idle_readonly_transaction_timeout
--idle-transaction-timeout, idle_transaction_timeout
--idle-write-transaction-timeout, idle_write_transaction_timeout
--ignore-builtin-innodb, ignore_builtin_innodb
--ignore-db-dir
ignore_db_dirs
--init-connect, init_connect
--init-file, init_file
--init-rpl-role
--init-slave, init_slave
--innodb
--innodb-adaptive-checkpoint, innodb_adaptive_checkpoint
--innodb-adaptive-flushing, innodb_adaptive_flushing
--innodb-adaptive-flushing-lwm, innodb_adaptive_flushing_lwm
--innodb_adaptive-flushing-method, innodb_adaptive_flushing_method
Innodb_adaptive_hash_cells
Innodb_adaptive_hash_hash_searches
Innodb_adaptive_hash_heap_buffers
--innodb-adaptive-hash-index, innodb_adaptive_hash_index
--innodb-adaptive-hash-index-partitions, innodb_adaptive_hash_index_partitions
--innodb-adaptive-hash-index-parts, innodb_adaptive_hash_index_parts
Innodb_adaptive_hash_non_hash_searches
--innodb-adaptive-max-sleep-delay, innodb_adaptive_max_sleep_delay
--innodb-additional-mem-pool-size, innodb_additional_mem_pool_size
--innodb-api-bk-commit_interval, innodb_api_bk_commit_interval
--innodb-api-disable-rowlock, innodb_api_disable_rowlock
--innodb_api_enable_binlog, innodb_api_enable_binlog
--innodb-api-enable-mdl, innodb_api_enable_mdl
--innodb-api-trx-level, innodb_api_trx_level
--innodb-autoextend-increment, innodb_autoextend_increment
--innodb-autoinc-lock-mode, innodb_autoinc_lock_mode
--innodb-auto-lru-dump, innodb-auto-lru-dump
Innodb_available_undo_logs
Innodb_background_log_sync
--innodb-background-scrub-data-check-interval, innodb_background_scrub_data_check_interval
--innodb-background-scrub-data-compressed, innodb_background_scrub_data_compressed
--innodb-background-scrub-data-interval, innodb_background_scrub_data_interval
--innodb-background-scrub-data-uncompressed, innodb_background_scrub_data_uncompressed
--innodb-blocking-buffer-pool-restore, innodb_blocking_buffer_pool_restore
--innodb-buf-dump-status-frequency, innodb_buf_dump_status_frequency
Innodb_buffer_pool_bytes_data
Innodb_buffer_pool_bytes_dirty
--innodb-buffer-pool-chunk-size, innodb_buffer_pool_chunk_size
--innodb-buffer-pool-dump-at-shutdown, innodb_buffer_pool_dump_at_shutdown
--innodb-buffer-pool-dump-now, innodb_buffer_pool_dump_now
--innodb-buffer-pool-dump-pct, innodb_buffer_pool_dump_pct
Innodb_buffer_pool_dump_status
--innodb-buffer-pool-evict, innodb_buffer_pool_evict
--innodb-buffer-pool-filename, innodb_buffer_pool_filename
--innodb-buffer-pool-instances, innodb_buffer_pool_instances
--innodb-buffer-pool-load-abort, innodb_buffer_pool_load_abort
--innodb-buffer-pool-load-at-startup, innodb_buffer_pool_load_at_startup
Innodb_buffer_pool_load_incomplete
--innodb-buffer-pool-load-now, innodb_buffer_pool_load_now
Innodb_buffer_pool_load_status
--innodb-buffer-pool-pages
--innodb-buffer-pool-pages-blob
Innodb_buffer_pool_pages_data
Innodb_buffer_pool_pages_dirty
Innodb_buffer_pool_pages_flushed
Innodb_buffer_pool_pages_free
--innodb-buffer-pool-pages-index
Innodb_buffer_pool_pages_LRU_flushed
Innodb_buffer_pool_pages_made_not_young
Innodb_buffer_pool_pages_made_young
Innodb_buffer_pool_pages_misc
Innodb_buffer_pool_pages_old
Innodb_buffer_pool_pages_total
--innodb-buffer-pool-populate, innodb_buffer_pool_populate
Innodb_buffer_pool_read_ahead
Innodb_buffer_pool_read_ahead_evicted
Innodb_buffer_pool_read_ahead_rnd
Innodb_buffer_pool_read_requests
Innodb_buffer_pool_reads
Innodb_buffer_pool_resize_status
--innodb-buffer-pool-restore-at-startup, innodb_buffer_pool_restore_at_startup
--innodb-buffer-pool-shm-checksum, innodb_buffer_pool_shm_checksum
--innodb-buffer-pool-shm-key, innodb_buffer_pool_shm_key
--innodb-buffer-pool-size, innodb_buffer_pool_size
Innodb_buffer_pool_wait_free
Innodb_buffer_pool_write_requests
--innodb-change-buffering-debug, innodb_change_buffering_debug
--innodb-change-buffering, innodb_change_buffering
--innodb-change-buffer-max-size, innodb_change_buffer_max_size
Innodb_checkpoint_age
--innodb-checkpoint-age-target, innodb_checkpoint_age_target
Innodb_checkpoint_max_age
Innodb_checkpoint_target_age
--innodb-checksum-algorithm, innodb_checksum_algorithm
--innodb-checksums, innodb_checksums
--innodb-cleaner-lsn-age-factor, innodb_cleaner_lsn_age_factor
--innodb-cmp
--innodb-cmpmem
--innodb-cmpmem-reset
--innodb-cmp-per-index-enabled, innodb_cmp_per_index_enabled
--innodb-cmp-reset
--innodb-commit-concurrency, innodb_commit_concurrency
--innodb-compression-algorithm, innodb_compression_algorithm
--innodb-compression-default, innodb_compression_default
--innodb-compression-failure-threshold-pct, innodb_compression_failure_threshold_pct
--innodb-compression-level, innodb_compression_level
--innodb-compression-pad-pct-max, innodb_compression_pad_pct_max
--innodb-concurrency-tickets, innodb_concurrency_tickets
--innodb-corrupt-table-action, innodb_corrupt_table_action
Innodb_current_row_locks
--innodb-data-file-path, innodb_data_file_path
Innodb_data_fsyncs
--innodb-data-home-dir, innodb_data_home_dir
Innodb_data_pending_fsyncs
Innodb_data_pending_reads
Innodb_data_pending_writes
Innodb_data_read
Innodb_data_reads
Innodb_data_writes
Innodb_data_written
Innodb_dblwr_pages_written
Innodb_dblwr_writes
--innodb-deadlock-detect, innodb_deadlock_detect
Innodb_deadlocks
--innodb-default-encryption-key-id, innodb_default_encryption_key_id
--innodb-default-page-encryption-key, innodb_default_page_encryption_key
--innodb-default-row-format, innodb_default_row_format
Innodb_defragment_compression_failures
Innodb_defragment_count
Innodb_defragment_failures
--innodb-defragment-fill-factor, innodb_defragment_fill_factor
--innodb-defragment-fill-factor-n-recs, innodb_defragment_fill_factor_n_recs
--innodb-defragment-frequency, innodb_defragment_frequency
--innodb-defragment, innodb_defragment
--innodb-defragment-n-pages, innodb_defragment_n_pages
--innodb-defragment-stats-accuracy, innodb_defragment_stats_accuracy
--innodb-dict-size-limit, innodb_dict_size_limit
Innodb_dict_tables
--innodb-disable-sort-file-cache, innodb_disable_sort_file_cache
innodb_disallow_writes
--innodb-doublewrite-file, innodb_doublewrite_file
--innodb-doublewrite, innodb_doublewrite
--innodb_empty-free-list-algorithm, innodb_empty_free_list_algorithm
--innodb-enable-unsafe-group-commit, innodb_enable_unsafe_group_commit
Innodb_encryption_n_merge_blocks_decrypted
Innodb_encryption_n_merge_blocks_encrypted
Innodb_encryption_n_rowlog_blocks_decrypted
Innodb_encryption_n_rowlog_blocks_encrypted
Innodb_encryption_num_key_requests
--innodb-encryption-rotate-key-age, innodb_encryption_rotate_key_age
Innodb_encryption_rotation_estimated_iops
--innodb-encryption-rotation-iops, innodb_encryption_rotation_iops
Innodb_encryption_rotation_pages_flushed
Innodb_encryption_rotation_pages_modified
Innodb_encryption_rotation_pages_read_from_cache
Innodb_encryption_rotation_pages_read_from_disk
--innodb-encryption-threads, innodb_encryption_threads
--innodb-encrypt-log, innodb_encrypt_log
--innodb-encrypt-tables, innodb_encrypt_tables
--innodb-expand-import
--innodb-extra-rsegments, innodb_extra_rsegments
--innodb-extra-undoslots, innodb_extra_undoslots
--innodb-fake-changes, innodb_fake_changes
--innodb-fast-checksum, innodb_fast_checksum
--innodb-fast-recovery
--innodb-fast-shutdown, innodb_fast_shutdown
--innodb-fatal-semaphore-wait-threshold, innodb_fatal_semaphore_wait_threshold
--innodb-file-format-check, innodb_file_format_check
--innodb-file-format, innodb_file_format
--innodb-file-format-max, innodb_file_format_max
--innodb-file-io-threads
--innodb-file-per-table, innodb_file_per_table
--innodb-fill-factor, innodb_fill_factor
--innodb-flushing-avg-loops, innodb_flushing_avg_loops
--innodb_flush_log_at_timeout
--innodb-flush-log-at-trx-commit, innodb_flush_log_at_trx_commit
--innodb-flush-log-at-trx-commit-session
--innodb-flush-method, innodb_flush_method
--innodb-flush-neighbor-pages, innodb_flush_neighbor_pages
--innodb-flush-neighbors, innodb_flush_neighbors
--innodb-flush-sync, innodb_flush_sync
--innodb-force-load-corrupted, innodb_force_load_corrupted
--innodb-force-primary-key, innodb_force_primary_key
--innodb-force-recovery, innodb_force_recovery
--innodb-foreground-preflush, innodb_foreground_preflush
--innodb-ft-aux-table, innodb_ft_aux_table
--innodb-ft-cache-size, innodb_ft_cache_size
--innodb-ft-enable-diag-print, innodb_ft_enable_diag_print
--innodb-ft-enable-stopword, innodb_ft_enable_stopword
--innodb-ft-max-token-size, innodb_ft_max_token_size
--innodb-ft-min-token-size, innodb_ft_min_token_size
--innodb-ft-num-word-optimize, innodb_ft_num_word_optimize
--innodb-ft-result-cache-limit, innodb_ft_result_cache_limit
--innodb-ft-server-stopword-table, innodb_ft_server_stopword_table
--innodb-ft-sort-pll-degree, innodb_ft_sort_pll_degree
--innodb-ft-total-cache-size, innodb_ft_total_cache_size
--innodb-ft-user-stopword-table, innodb_ft_user_stopword_table
Innodb_have_atomic_builtins
Innodb_have_bzip2
Innodb_have_lz4
Innodb_have_lzma
Innodb_have_lzo
Innodb_have_punch_hole
Innodb_have_snappy
Innodb_history_list_length
--innodb-ibuf-accel-rate, innodb_ibuf_accel_rate
--innodb-ibuf-active-contract, innodb_ibuf_active_contract
Innodb_ibuf_discarded_delete_marks
Innodb_ibuf_discarded_deletes
Innodb_ibuf_discarded_inserts
Innodb_ibuf_free_list
--innodb-ibuf-max-size, innodb_ibuf_max_size
Innodb_ibuf_merged_delete_marks
Innodb_ibuf_merged_deletes
Innodb_ibuf_merged_inserts
Innodb_ibuf_merges
Innodb_ibuf_segment_size
Innodb_ibuf_size
--innodb-idle-flush-pct, innodb_idle_flush_pct
--innodb-immediate-scrub-data-uncompressed, innodb_immediate_scrub_data_uncompressed
--innodb-import-table-from-xtrabackup, innodb_import_table_from_xtrabackup
--innodb-index-stats
Innodb_instant_alter_column
--innodb-instrument-semaphores, innodb_instrument_semaphores
--innodb-io-capacity, innodb_io_capacity
--innodb-io-capacity-max, innodb_io_capacity_max
innodb_kill_idle_transaction
--innodb-large-prefix, innodb_large_prefix
--innodb-lazy-drop-table, innodb_lazy_drop_table
--innodb-locking-fake-changes, innodb_locking_fake_changes
--innodb-locks
--innodb-lock-schedule-algorithm, innodb_lock_schedule_algorithm
--innodb-locks-unsafe-for-binlog, innodb_locks_unsafe_for_binlog
--innodb-lock-waits
--innodb-lock-wait-timeout, innodb_lock_wait_timeout
--innodb-log-arch-dir, innodb_log_arch_dir
--innodb-log-arch-expire-sec, innodb_log_arch_expire_sec
--innodb-log-archive, innodb_log_archive
--innodb-log-block-size, innodb_log_block_size
--innodb-log-buffer-size, innodb_log_buffer_size
-- innodb-log-checksum-algorithm, innodb_log_checksum_algorithm
-- innodb-log-checksums, innodb_log_checksums
-- innodb-log-compressed-pages, innodb_log_compressed_pages
--innodb-log-files-in-group, innodb_log_files_in_group
--innodb-log-file-size, innodb_log_file_size
--innodb-log-group-home-dir, innodb_log_group_home_dir
Innodb_log_waits
--innodb-log-write-ahead-size, innodb_log_write_ahead_size
Innodb_log_write_requests
Innodb_log_writes
--innodb-lru-scan-depth, innodb_lru_scan_depth
Innodb_lsn_current
Innodb_lsn_flushed
Innodb_lsn_last_checkpoint
Innodb_master_thread_10_second_loops
Innodb_master_thread_1_second_loops
Innodb_master_thread_active_loops
Innodb_master_thread_background_loops
Innodb_master_thread_idle_loops
Innodb_master_thread_main_flush_loops
Innodb_master_thread_sleeps
--innodb-max-bitmap-file-size, innodb_max_bitmap_file_size
--innodb-max-changed-pages, innodb_max_changed_pages
--innodb-max-dirty-pages-pct, innodb_max_dirty_pages_pct
--innodb-max-dirty-pages-pct-lwm, innodb_max_dirty_pages_pct_lwm
--innodb-max-purge-lag-delay, innodb_max_purge_lag_delay
--innodb-max-purge-lag, innodb_max_purge_lag
Innodb_max_trx_id
--innodb-max-undo-log-size, innodb_max_undo_log_size
Innodb_mem_adaptive_hash
Innodb_mem_dictionary
Innodb_mem_total
--innodb-merge-sort-block-size, innodb_merge_sort_block_size
--innodb-mirrored-log-groups, innodb_mirrored_log_groups
--innodb-monitor-disable, innodb_monitor_disable
--innodb-monitor-enable, innodb_monitor_enable
--innodb-monitor-reset-all, innodb_monitor_reset_all
--innodb-monitor-reset, innodb_monitor_reset
--innodb-mtflush-threads, innodb_mtflush_threads
Innodb_mutex_os_waits
Innodb_mutex_spin_rounds
Innodb_mutex_spin_waits
--innodb-numa-interleave, innodb_numa_interleave
Innodb_num_index_pages_written
Innodb_num_non_index_pages_written
Innodb_num_open_files
Innodb_num_page_compressed_trim_op
Innodb_num_page_compressed_trim_op_saved
Innodb_num_pages_encrypted
Innodb_num_pages_page_compressed
Innodb_num_pages_page_compression_error
Innodb_num_pages_page_decompressed
Innodb_num_pages_page_decrypted
Innodb_num_pages_page_encryption_error
--innodb-old-blocks-pct, innodb_old_blocks_pct
--innodb-old-blocks-time, innodb_old_blocks_time
Innodb_oldest_view_low_limit_trx_id
--innodb-online-alter-log-max-size, innodb_online_alter_log_max_size
Innodb_onlineddl_pct_progress
Innodb_onlineddl_rowlog_pct_used
Innodb_onlineddl_rowlog_rows
--innodb-open-files, innodb_open_files
--innodb-optimize-fulltext-only, innodb_optimize_fulltext_only
Innodb_os_log_fsyncs
Innodb_os_log_pending_fsyncs
Innodb_os_log_pending_writes
Innodb_os_log_written
--innodb-overwrite-relay-log-info
--innodb-page-cleaners, innodb_page_cleaners
Innodb_page_compression_saved
Innodb_page_compression_trim_sect1024
Innodb_page_compression_trim_sect16384
Innodb_page_compression_trim_sect2048
Innodb_page_compression_trim_sect32768
Innodb_page_compression_trim_sect4096
Innodb_page_compression_trim_sect512
Innodb_page_compression_trim_sect8192
Innodb_pages0_read
Innodb_pages_created
Innodb_page_size
--innodb-page-size, innodb_page_size
Innodb_pages_read
Innodb_pages_written
--innodb-pass-corrupt-table, innodb-pass-corrupt-table
--innodb-prefix-index-cluster-optimization, innodb_prefix_index_cluster_optimization
--innodb-print-all-deadlocks, innodb_print_all_deadlocks
--innodb-purge-batch-size, innodb_purge_batch_size
--innodb-purge-rseg-truncate-frequency, innodb_purge_rseg_truncate_frequency
--innodb-purge-threads, innodb_purge_threads
Innodb_purge_trx_id
Innodb_purge_undo_no
--innodb-random-read-ahead, innodb_random_read_ahead
--innodb-read-ahead, innodb_read_ahead
--innodb-read-ahead-threshold, innodb_read_ahead_threshold
--innodb-read-io-threads, innodb_read_io_threads
--innodb-read-only, innodb_read_only
Innodb_read_views_memory
--innodb-recovery-stats, innodb_recovery_stats
--innodb-recovery-update-relay-log, innodb-recovery-update-relay-log
--innodb-replication-delay, innodb_replication_delay
--innodb-rollback-on-timeout, innodb_rollback_on_timeout
--innodb-rollback-segments, innodb_rollback_segments
Innodb_row_lock_current_waits
Innodb_row_lock_numbers
Innodb_row_lock_time
Innodb_row_lock_time_avg
Innodb_row_lock_time_max
Innodb_row_lock_time_waits
Innodb_rows_deleted
Innodb_rows_inserted
Innodb_rows_read
Innodb_rows_updated
--innodb-rseg
--innodb-sched-priority-cleaner, innodb_sched_priority_cleaner
Innodb_scrub_background_page_reorganizations
Innodb_scrub_background_page_split_failures_missing_index
Innodb_scrub_background_page_split_failures_out_of_filespace
Innodb_scrub_background_page_split_failures_underflow
Innodb_scrub_background_page_split_failures_unknown
Innodb_scrub_background_page_splits
Innodb_scrub_log
--innodb-scrub-log, innodb_scrub_log
--innodb-scrub-log-interval, innodb_scrub_log_interval
--innodb-scrub-log-speed, innodb_scrub_log_speed
Innodb_secondary_index_triggered_cluster_reads
Innodb_secondary_index_triggered_cluster_reads_avoided
--innodb-show-locks-held, innodb-show-locks-held
--innodb-show-verbose-locks, innodb_show_verbose_locks
innodb_simulate_comp_failures
Innodb_s_lock_os_waits
Innodb_s_lock_spin_rounds
Innodb_s_lock_spin_waits
--innodb-sort-buffer-size, innodb_sort_buffer_size
--innodb-spin-wait-delay, innodb_spin_wait_delay
--innodb-stats-auto-recalc, innodb_stats_auto_recalc
--innodb-stats-auto-update, innodb_stats_auto_update
--innodb-stats-include-delete-marked, innodb_stats_include_delete_marked
--innodb-stats-method, innodb_stats_method
--innodb-stats-modified-counter, innodb_stats_modified_counter
--innodb-stats-on-metadata, innodb-stats-on-metadata
--innodb-stats-persistent, innodb_stats_persistent
--innodb-stats-persistent-sample-pages, innodb_stats_persistent_sample_pages
--innodb-stats-sample-pages, innodb_stats_sample_pages
--innodb-stats-traditional, innodb_stats_traditional
--innodb-stats-transient-sample-pages, innodb_stats_transient_sample_pages
--innodb-stats-update-need-lock, innodb_stats_update_need_lock
--innodb-status-file
--innodb-status-output, innodb_status_output
--innodb-status-output-locks, innodb_status_output_locks
--innodb-strict-mode, innodb_strict_mode
--innodb-support-xa, innodb_support_xa
--innodb-sync-array-size, innodb_sync_array_size
--innodb-sync-spin-loops, innodb_sync_spin_loops
--innodb-sys-indexes
--innodb-sys-stats
--innodb-sys-tables
Innodb_system_rows_deleted
Innodb_system_rows_inserted
Innodb_system_rows_read
Innodb_system_rows_updated
--innodb-table-locks, innodb_table_locks
--innodb-table-stats
--innodb_temp_data_file_path, innodb_temp_data_file_path
--innodb-thread-concurrency, innodb_thread_concurrency
--innodb-thread-concurrency-timer-based, innodb_thread_concurrency_timer_based
--innodb-thread-sleep-delay, innodb_thread_sleep_delay
--innodb-tmpdir, innodb_tmpdir
--innodb-track-changed-pages, innodb_track_changed_pages
--innodb-track-redo-log-now, innodb_track_redo_log_now
Innodb_truncated_status_writes
--innodb-trx
--innodb-undo-directory, innodb_undo_directory
--innodb-undo-logs, innodb_undo_logs
--innodb-undo-log-truncate, innodb_undo_log_truncate
--innodb-undo-tablespaces, innodb_undo_tablespaces
--innodb-use-atomic-writes, innodb_use_atomic_writes
--innodb-use-fallocate, innodb_use_fallocate
--innodb-use-global-flush-log-at-trx-commit, innodb_use_global_flush_log_at_trx_commit
--innodb-use-mtflush, innodb_use_mtflush
--innodb-use-native_aio, innodb_use_native_aio
--innodb-use-purge-thread, innodb_use_purge_thread
--innodb-use-stacktrace, innodb_use_stacktrace
--innodb-use-sys-malloc, innodb_use_sys_malloc
--innodb-use-sys-stats-table, innodb_use_sys_stats_table
--innodb-use-trim, innodb_use_trim
innodb_version
--innodb-write-io-threads, innodb_write_io_threads
Innodb_x_lock_os_waits
Innodb_x_lock_spin_rounds
Innodb_x_lock_spin_waits
--insert_id
--interactive-timeout, interactive_timeout
in_transaction
--join-buffer-size, join_buffer_size
--join-buffer-space-limit, join_buffer_space_limit
--join-cache-level, join_cache_level
--keep-files-on-create, keep_files_on_create
Key_blocks_not_flushed
Key_blocks_unused
Key_blocks_used
Key_blocks_warm
--key-buffer-size, key_buffer_size
--key-cache-age-threshold, key_cache_age_threshold
--key-cache-block-size, key_cache_block_size
--key-cache-division-limit, key_cache_division_limit
--key-cache-file-hash-size, key_cache_file_hash_size
--key-cache-segments, key_cache_segments
Key_read_requests
Key_reads
Key_write_requests
Key_writes
large_files_support
large_page_size
--large-pages, large_pages
last_gtid
last_insert_id
Last_query_cost
--lc-messages-dir, lc_messages_dir
--lc-messages, lc_messages
--lc-time-names, lc_time_names
license
-L, --language, language
-l, --log, log
--local-infile, local_infile
locked_in_memory
--lock-wait-timeout, lock_wait_timeout
--log-basename
log_bin_basename
--log-bin-compress, log_bin_compress
--log-bin-compress-min-len, log_bin_compress_min_len
--log-bin-index, log_bin_index
--log-bin, log_bin
--log-bin-trust-function-creators, log_bin_trust_function_creators
--log-bin-trust-routine-creators
--log-disabled-statements, log_disabled_statements
--log-error, log_error
--log-isam
--log-output, log_output
--log-queries-not-using-indexes, log_queries_not_using_indexes
--log-short-format
--log-slave-updates, log_slave_updates
--log-slow-admin-statements, log_slow_admin_statements
--log-slow-disabled-statements, log_slow_disabled_statements
--log-slow-file
--log-slow-filter, log_slow_filter
--log-slow-queries, log_slow_queries
--log-slow-rate-limit, log_slow_rate_limit
--log-slow-slave-statements, log_slow_slave_statements
--log-slow-time
--log-slow-verbosity, log_slow_verbosity
--log-tc
--log-tc-size, log_tc_size
--log-update
--long-query-time, long_query_time
lower_case_file_system
--lower-case-table-names, lower_case_table_names
--low-priority-updates, low_priority_updates
--master-connect-retry
Master_gtid_wait_count
Master_gtid_wait_time
Master_gtid_wait_timeouts
--master-host
--master-info-file
--master-password
--master-port