Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Count: Waktu yang dipakai:
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Restore default values
Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data: Waktu eksekusi kueri:

Variabel dan pengaturan server Dokumentasi

Simpan Simpan Batal Batal Dokumentasi
Filters
Tindakan Variabel Nilai
Ubah Ubah alter algorithm DEFAULT
Ubah Ubah analyze sample percentage 100
Ubah Ubah aria block size 8,​192
Ubah Ubah aria checkpoint interval 30
Ubah Ubah aria checkpoint log activity 1,​048,​576
Ubah Ubah aria encrypt tables OFF
Ubah Ubah aria force start after recovery failures 0
Ubah Ubah aria group commit none
Ubah Ubah aria group commit interval 0
Ubah Ubah aria log file size 1,​073,​741,​824
Ubah Ubah aria log purge type immediate
Ubah Ubah aria max sort file size 9,​223,​372,​036,​853,​727,​232
Ubah Ubah aria page checksum ON
Ubah Ubah aria pagecache age threshold 300
Ubah Ubah aria pagecache buffer size 134,​217,​728
Ubah Ubah aria pagecache division limit 100
Ubah Ubah aria pagecache file hash size 512
Ubah Ubah aria recover options BACKUP,​QUICK
Ubah Ubah aria repair threads 1
Ubah Ubah aria sort buffer size 268,​434,​432
Ubah Ubah aria stats method nulls_unequal
Ubah Ubah aria sync log dir NEWFILE
Ubah Ubah aria used for temp tables ON
Ubah Ubah auto increment increment 1
Ubah Ubah auto increment offset 1
Ubah Ubah autocommit ON
Ubah Ubah automatic sp privileges ON
Ubah Ubah back log 70
Ubah Ubah basedir /usr
Ubah Ubah big tables OFF
Ubah Ubah bind address 192.168.30.22
Ubah Ubah binlog annotate row events ON
Ubah Ubah binlog cache size 32,​768
Ubah Ubah binlog checksum CRC32
Ubah Ubah binlog commit wait count 0
Ubah Ubah binlog commit wait usec 100,​000
Ubah Ubah binlog direct non transactional updates OFF
Ubah Ubah binlog file cache size 16,​384
Ubah Ubah binlog format MIXED
Ubah Ubah binlog optimize thread scheduling ON
Ubah Ubah binlog row image FULL
Ubah Ubah binlog stmt cache size 32,​768
Ubah Ubah bulk insert buffer size 16,​777,​216
Ubah Ubah character set client utf8mb4
Ubah Ubah character set connection utf8mb4
Ubah Ubah character set database utf8mb4
Ubah Ubah character set filesystem binary
Ubah Ubah character set results utf8mb4
Ubah Ubah character set server utf8mb4
Ubah Ubah character set system utf8
Ubah Ubah character sets dir /usr/share/mysql/charsets/
Ubah Ubah check constraint checks ON
Ubah Ubah collation connection utf8mb4_general_ci
collation connection (Nilai sesi) utf8mb4_unicode_ci
Ubah Ubah collation database utf8mb4_general_ci
Ubah Ubah collation server utf8mb4_general_ci
Ubah Ubah column compression threshold 100
Ubah Ubah column compression zlib level 6
Ubah Ubah column compression zlib strategy DEFAULT_STRATEGY
Ubah Ubah column compression zlib wrap OFF
Ubah Ubah completion type NO_CHAIN
Ubah Ubah concurrent insert ALWAYS
Ubah Ubah connect timeout 5
Ubah Ubah core file OFF
Ubah Ubah datadir /var/lib/mysql/
Ubah Ubah date format %Y-%m-%d
Ubah Ubah datetime format %Y-%m-%d %H:%i:%s
Ubah Ubah deadlock search depth long 15
Ubah Ubah deadlock search depth short 4
Ubah Ubah deadlock timeout long 50,​000,​000
Ubah Ubah deadlock timeout short 10,​000
Ubah Ubah debug no thread alarm OFF
Ubah Ubah default password lifetime 0
Ubah Ubah default regex flags
Ubah Ubah default storage engine InnoDB
Ubah Ubah default tmp storage engine
Ubah Ubah default week format 0
Ubah Ubah delay key write ON
Ubah Ubah delayed insert limit 100
Ubah Ubah delayed insert timeout 300
Ubah Ubah delayed queue size 1,​000
Ubah Ubah disconnect on expired password OFF
Ubah Ubah div precision increment 4
Ubah Ubah encrypt binlog OFF
Ubah Ubah encrypt tmp disk tables OFF
Ubah Ubah encrypt tmp files OFF
Ubah Ubah enforce storage engine
Ubah Ubah eq range index dive limit 200
Ubah Ubah event scheduler OFF
Ubah Ubah expensive subquery limit 100
Ubah Ubah expire logs days 10
Ubah Ubah explicit defaults for timestamp OFF
Ubah Ubah extra max connections 1
Ubah Ubah extra port 0
Ubah Ubah flush OFF
Ubah Ubah flush time 0
Ubah Ubah foreign key checks ON
Ubah Ubah ft boolean syntax + -><()~*:""&|
Ubah Ubah ft max word len 84
Ubah Ubah ft min word len 4
Ubah Ubah ft query expansion limit 20
Ubah Ubah ft stopword file (built-in)
Ubah Ubah general log OFF
Ubah Ubah general log file demo-mariadb.log
Ubah Ubah group concat max len 1,​048,​576
Ubah Ubah gtid binlog pos 0-1-11956
Ubah Ubah gtid binlog state 0-1-11956
Ubah Ubah gtid cleanup batch size 64
Ubah Ubah gtid current pos 0-1-11956
Ubah Ubah gtid domain id 0
Ubah Ubah gtid ignore duplicates OFF
Ubah Ubah gtid pos auto engines
Ubah Ubah gtid slave pos
Ubah Ubah gtid strict mode OFF
Ubah Ubah have compress YES
Ubah Ubah have crypt YES
Ubah Ubah have dynamic loading YES
Ubah Ubah have geometry YES
Ubah Ubah have openssl YES
Ubah Ubah have profiling YES
Ubah Ubah have query cache YES
Ubah Ubah have rtree keys YES
Ubah Ubah have ssl DISABLED
Ubah Ubah have symlink YES
Ubah Ubah histogram size 254
Ubah Ubah histogram type DOUBLE_PREC_HB
Ubah Ubah host cache size 228
Ubah Ubah hostname demo-mariadb
Ubah Ubah idle readonly transaction timeout 0
Ubah Ubah idle transaction timeout 0
Ubah Ubah idle write transaction timeout 0
Ubah Ubah ignore builtin innodb OFF
Ubah Ubah ignore db dirs
Ubah Ubah in predicate conversion threshold 1,​000
Ubah Ubah init connect
Ubah Ubah init file
Ubah Ubah init slave
Ubah Ubah innodb adaptive flushing ON
Ubah Ubah innodb adaptive flushing lwm 10
Ubah Ubah innodb adaptive hash index ON
Ubah Ubah innodb adaptive hash index parts 8
Ubah Ubah innodb adaptive max sleep delay 150,​000
Ubah Ubah innodb autoextend increment 64
Ubah Ubah innodb autoinc lock mode 1
Ubah Ubah innodb background scrub data check interval 3,​600
Ubah Ubah innodb background scrub data compressed OFF
Ubah Ubah innodb background scrub data interval 604,​800
Ubah Ubah innodb background scrub data uncompressed OFF
Ubah Ubah innodb buf dump status frequency 0
Ubah Ubah innodb buffer pool chunk size 134,​217,​728
Ubah Ubah innodb buffer pool dump at shutdown ON
Ubah Ubah innodb buffer pool dump now OFF
Ubah Ubah innodb buffer pool dump pct 25
Ubah Ubah innodb buffer pool filename ib_buffer_pool
Ubah Ubah innodb buffer pool instances 1
Ubah Ubah innodb buffer pool load abort OFF
Ubah Ubah innodb buffer pool load at startup ON
Ubah Ubah innodb buffer pool load now OFF
Ubah Ubah innodb buffer pool size 268,​435,​456
Ubah Ubah innodb change buffer max size 25
Ubah Ubah innodb change buffering all
Ubah Ubah innodb checksum algorithm crc32
Ubah Ubah innodb checksums ON
Ubah Ubah innodb cmp per index enabled OFF
Ubah Ubah innodb commit concurrency 0
Ubah Ubah innodb compression algorithm zlib
Ubah Ubah innodb compression default OFF
Ubah Ubah innodb compression failure threshold pct 5
Ubah Ubah innodb compression level 6
Ubah Ubah innodb compression pad pct max 50
Ubah Ubah innodb concurrency tickets 5,​000
Ubah Ubah innodb data file path ibdata1:12M:autoextend
Ubah Ubah innodb data home dir
Ubah Ubah innodb deadlock detect ON
Ubah Ubah innodb default encryption key id 1
Ubah Ubah innodb default row format dynamic
Ubah Ubah innodb defragment OFF
Ubah Ubah innodb defragment fill factor 1
Ubah Ubah innodb defragment fill factor n recs 20
Ubah Ubah innodb defragment frequency 40
Ubah Ubah innodb defragment n pages 7
Ubah Ubah innodb defragment stats accuracy 0
Ubah Ubah innodb disable sort file cache OFF
Ubah Ubah innodb disallow writes OFF
Ubah Ubah innodb doublewrite ON
Ubah Ubah innodb encrypt log OFF
Ubah Ubah innodb encrypt tables OFF
Ubah Ubah innodb encrypt temporary tables OFF
Ubah Ubah innodb encryption rotate key age 1
Ubah Ubah innodb encryption rotation iops 100
Ubah Ubah innodb encryption threads 0
Ubah Ubah innodb fast shutdown 1
Ubah Ubah innodb fatal semaphore wait threshold 600
Ubah Ubah innodb file format
Ubah Ubah innodb file per table ON
Ubah Ubah innodb fill factor 100
Ubah Ubah innodb flush log at timeout 1
Ubah Ubah innodb flush log at trx commit 1
Ubah Ubah innodb flush method O_DIRECT
Ubah Ubah innodb flush neighbors 1
Ubah Ubah innodb flush sync ON
Ubah Ubah innodb flushing avg loops 30
Ubah Ubah innodb force load corrupted OFF
Ubah Ubah innodb force primary key OFF
Ubah Ubah innodb force recovery 0
Ubah Ubah innodb ft aux table
Ubah Ubah innodb ft cache size 8,​000,​000
Ubah Ubah innodb ft enable diag print OFF
Ubah Ubah innodb ft enable stopword ON
Ubah Ubah innodb ft max token size 84
Ubah Ubah innodb ft min token size 3
Ubah Ubah innodb ft num word optimize 2,​000
Ubah Ubah innodb ft result cache limit 2,​000,​000,​000
Ubah Ubah innodb ft server stopword table
Ubah Ubah innodb ft sort pll degree 2
Ubah Ubah innodb ft total cache size 640,​000,​000
Ubah Ubah innodb ft user stopword table
Ubah Ubah innodb idle flush pct 100
Ubah Ubah innodb immediate scrub data uncompressed OFF
Ubah Ubah innodb io capacity 400
Ubah Ubah innodb io capacity max 2,​000
Ubah Ubah innodb large prefix
Ubah Ubah innodb lock schedule algorithm fcfs
Ubah Ubah innodb lock wait timeout 50
Ubah Ubah innodb locks unsafe for binlog OFF
Ubah Ubah innodb log buffer size 8,​388,​608
Ubah Ubah innodb log checksums ON
Ubah Ubah innodb log compressed pages ON
Ubah Ubah innodb log file size 50,​331,​648
Ubah Ubah innodb log files in group 2
Ubah Ubah innodb log group home dir ./
Ubah Ubah innodb log optimize ddl ON
Ubah Ubah innodb log write ahead size 8,​192
Ubah Ubah innodb lru scan depth 1,​024
Ubah Ubah innodb max dirty pages pct 75
Ubah Ubah innodb max dirty pages pct lwm 0
Ubah Ubah innodb max purge lag 0
Ubah Ubah innodb max purge lag delay 0
Ubah Ubah innodb max undo log size 10,​485,​760
Ubah Ubah innodb monitor disable
Ubah Ubah innodb monitor enable
Ubah Ubah innodb monitor reset
Ubah Ubah innodb monitor reset all
Ubah Ubah innodb old blocks pct 37
Ubah Ubah innodb old blocks time 1,​000
Ubah Ubah innodb online alter log max size 134,​217,​728
Ubah Ubah innodb open files 400
Ubah Ubah innodb optimize fulltext only OFF
Ubah Ubah innodb page cleaners 1
Ubah Ubah innodb page size 16,​384
Ubah Ubah innodb prefix index cluster optimization OFF
Ubah Ubah innodb print all deadlocks OFF
Ubah Ubah innodb purge batch size 300
Ubah Ubah innodb purge rseg truncate frequency 128
Ubah Ubah innodb purge threads 4
Ubah Ubah innodb random read ahead OFF
Ubah Ubah innodb read ahead threshold 56
Ubah Ubah innodb read io threads 4
Ubah Ubah innodb read only OFF
Ubah Ubah innodb replication delay 0
Ubah Ubah innodb rollback on timeout OFF
Ubah Ubah innodb rollback segments 128
Ubah Ubah innodb scrub log OFF
Ubah Ubah innodb scrub log speed 256
Ubah Ubah innodb sort buffer size 1,​048,​576
Ubah Ubah innodb spin wait delay 4
Ubah Ubah innodb stats auto recalc ON
Ubah Ubah innodb stats include delete marked OFF
Ubah Ubah innodb stats method nulls_equal
Ubah Ubah innodb stats modified counter 0
Ubah Ubah innodb stats on metadata OFF
Ubah Ubah innodb stats persistent ON
Ubah Ubah innodb stats persistent sample pages 20
Ubah Ubah innodb stats sample pages 8
Ubah Ubah innodb stats traditional ON
Ubah Ubah innodb stats transient sample pages 8
Ubah Ubah innodb status output OFF
Ubah Ubah innodb status output locks OFF
Ubah Ubah innodb strict mode ON
Ubah Ubah innodb sync array size 1
Ubah Ubah innodb sync spin loops 30
Ubah Ubah innodb table locks ON
Ubah Ubah innodb temp data file path ibtmp1:12M:autoextend
Ubah Ubah innodb thread concurrency 0
Ubah Ubah innodb thread sleep delay 10,​000
Ubah Ubah innodb tmpdir
Ubah Ubah innodb undo directory ./
Ubah Ubah innodb undo log truncate OFF
Ubah Ubah innodb undo logs 128
Ubah Ubah innodb undo tablespaces 0
Ubah Ubah innodb use atomic writes ON
Ubah Ubah innodb use native aio ON
Ubah Ubah innodb version 10.4.8
Ubah Ubah innodb write io threads 4
Ubah Ubah interactive timeout 28,​800
Ubah Ubah join buffer size 262,​144
Ubah Ubah join buffer space limit 2,​097,​152
Ubah Ubah join cache level 2
Ubah Ubah keep files on create OFF
Ubah Ubah key buffer size 16,​777,​216
Ubah Ubah key cache age threshold 300
Ubah Ubah key cache block size 1,​024
Ubah Ubah key cache division limit 100
Ubah Ubah key cache file hash size 512
Ubah Ubah key cache segments 0
Ubah Ubah large files support ON
Ubah Ubah large page size 0
Ubah Ubah large pages OFF
Ubah Ubah lc messages en_US
lc messages (Nilai sesi) uk_UA
Ubah Ubah lc messages dir /usr/share/mysql
Ubah Ubah lc time names en_US
Ubah Ubah license GPL
Ubah Ubah local infile ON
Ubah Ubah lock wait timeout 86,​400
Ubah Ubah locked in memory OFF
Ubah Ubah log bin ON
Ubah Ubah log bin basename /var/log/mysql/mariadb-bin
Ubah Ubah log bin compress OFF
Ubah Ubah log bin compress min len 256
Ubah Ubah log bin index /var/log/mysql/mariadb-bin.index
Ubah Ubah log bin trust function creators OFF
Ubah Ubah log disabled statements sp
Ubah Ubah log error /var/log/mysql/error.log
Ubah Ubah log output FILE
Ubah Ubah log queries not using indexes OFF
Ubah Ubah log slave updates OFF
Ubah Ubah log slow admin statements ON
Ubah Ubah log slow disabled statements sp
Ubah Ubah log slow filter admin,​filesort,​filesort_on_disk,​filesort_priority_queue,​full_join,​full_scan,​query_cache,​query_cache_miss,​tmp_table,​tmp_table_on_disk
Ubah Ubah log slow rate limit 1
Ubah Ubah log slow slave statements ON
Ubah Ubah log slow verbosity query_plan
Ubah Ubah log tc size 24,​576
Ubah Ubah log warnings 2
Ubah Ubah long query time 10
Ubah Ubah low priority updates OFF
Ubah Ubah lower case file system OFF
Ubah Ubah lower case table names 0
Ubah Ubah master verify checksum OFF
Ubah Ubah max allowed packet 16,​777,​216
Ubah Ubah max binlog cache size 18,​446,​744,​073,​709,​547,​520
Ubah Ubah max binlog size 104,​857,​600
Ubah Ubah max binlog stmt cache size 18,​446,​744,​073,​709,​547,​520
Ubah Ubah max connect errors 100
Ubah Ubah max connections 100
Ubah Ubah max delayed threads 20
Ubah Ubah max digest length 1,​024
Ubah Ubah max error count 64
Ubah Ubah max heap table size 33,​554,​432
Ubah Ubah max insert delayed threads 20
Ubah Ubah max join size 18,​446,​744,​073,​709,​551,​616
Ubah Ubah max length for sort data 1,​024
Ubah Ubah max long data size 16,​777,​216
Ubah Ubah max password errors 4,​294,​967,​295
Ubah Ubah max prepared stmt count 16,​382
Ubah Ubah max recursive iterations 4,​294,​967,​295
Ubah Ubah max relay log size 104,​857,​600
Ubah Ubah max rowid filter size 131,​072
Ubah Ubah max seeks for key 4,​294,​967,​295
Ubah Ubah max session mem used 9,​223,​372,​036,​854,​775,​808
Ubah Ubah max sort length 1,​024
Ubah Ubah max sp recursion depth 0
Ubah Ubah max statement time 0
Ubah Ubah max tmp tables 32
Ubah Ubah max user connections 0
Ubah Ubah max write lock count 4,​294,​967,​295
Ubah Ubah metadata locks cache size 1,​024
Ubah Ubah metadata locks hash instances 8
Ubah Ubah min examined row limit 0
Ubah Ubah mrr buffer size 262,​144
Ubah Ubah multi range count 256
Ubah Ubah myisam block size 1,​024
Ubah Ubah myisam data pointer size 6
Ubah Ubah myisam max sort file size 9,​223,​372,​036,​853,​727,​232
Ubah Ubah myisam mmap size 18,​446,​744,​073,​709,​551,​616
Ubah Ubah myisam recover options BACKUP
Ubah Ubah myisam repair threads 1
Ubah Ubah myisam sort buffer size 536,​870,​912
Ubah Ubah myisam stats method NULLS_UNEQUAL
Ubah Ubah myisam use mmap OFF
Ubah Ubah mysql56 temporal format ON
Ubah Ubah net buffer length 16,​384
Ubah Ubah net read timeout 30
Ubah Ubah net retry count 10
Ubah Ubah net write timeout 60
Ubah Ubah old OFF
Ubah Ubah old alter table DEFAULT
Ubah Ubah old mode
Ubah Ubah old passwords OFF
Ubah Ubah open files limit 933
Ubah Ubah optimizer prune level 1
Ubah Ubah optimizer search depth 62
Ubah Ubah optimizer selectivity sampling limit 100
Ubah Ubah optimizer switch 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
Ubah Ubah optimizer trace enabled=off
Ubah Ubah optimizer trace max mem size 1,​048,​576
Ubah Ubah optimizer use condition selectivity 4
Ubah Ubah performance schema OFF
Ubah Ubah performance schema accounts size -1
Ubah Ubah performance schema digests size -1
Ubah Ubah performance schema events stages history long size -1
Ubah Ubah performance schema events stages history size -1
Ubah Ubah performance schema events statements history long size -1
Ubah Ubah performance schema events statements history size -1
Ubah Ubah performance schema events waits history long size -1
Ubah Ubah performance schema events waits history size -1
Ubah Ubah performance schema hosts size -1
Ubah Ubah performance schema max cond classes 80
Ubah Ubah performance schema max cond instances -1
Ubah Ubah performance schema max digest length 1,​024
Ubah Ubah performance schema max file classes 50
Ubah Ubah performance schema max file handles 32,​768
Ubah Ubah performance schema max file instances -1
Ubah Ubah performance schema max mutex classes 200
Ubah Ubah performance schema max mutex instances -1
Ubah Ubah performance schema max rwlock classes 40
Ubah Ubah performance schema max rwlock instances -1
Ubah Ubah performance schema max socket classes 10
Ubah Ubah performance schema max socket instances -1
Ubah Ubah performance schema max stage classes 160
Ubah Ubah performance schema max statement classes 202
Ubah Ubah performance schema max table handles -1
Ubah Ubah performance schema max table instances -1
Ubah Ubah performance schema max thread classes 50
Ubah Ubah performance schema max thread instances -1
Ubah Ubah performance schema session connect attrs size -1
Ubah Ubah performance schema setup actors size 100
Ubah Ubah performance schema setup objects size 100
Ubah Ubah performance schema users size -1
Ubah Ubah pid file /var/run/mysqld/mysqld.pid
Ubah Ubah plugin dir /usr/lib/mysql/plugin/
Ubah Ubah plugin maturity gamma
Ubah Ubah port 3,​306
Ubah Ubah preload buffer size 32,​768
Ubah Ubah profiling OFF
Ubah Ubah profiling history size 15
Ubah Ubah progress report time 5
Ubah Ubah protocol version 10
Ubah Ubah proxy protocol networks
Ubah Ubah query alloc block size 16,​384
Ubah Ubah query cache limit 1,​048,​576
Ubah Ubah query cache min res unit 4,​096
Ubah Ubah query cache size 16,​777,​216
Ubah Ubah query cache strip comments OFF
Ubah Ubah query cache type ON
Ubah Ubah query cache wlock invalidate OFF
Ubah Ubah query prealloc size 24,​576
Ubah Ubah range alloc block size 4,​096
Ubah Ubah read binlog speed limit 0
Ubah Ubah read buffer size 2,​097,​152
Ubah Ubah read only OFF
Ubah Ubah read rnd buffer size 1,​048,​576
Ubah Ubah relay log
Ubah Ubah relay log basename
Ubah Ubah relay log index
Ubah Ubah relay log info file relay-log.info
Ubah Ubah relay log purge ON
Ubah Ubah relay log recovery OFF
Ubah Ubah relay log space limit 0
Ubah Ubah replicate annotate row events ON
Ubah Ubah replicate do db
Ubah Ubah replicate do table
Ubah Ubah replicate events marked for skip REPLICATE
Ubah Ubah replicate ignore db
Ubah Ubah replicate ignore table
Ubah Ubah replicate wild do table
Ubah Ubah replicate wild ignore table
Ubah Ubah report host
Ubah Ubah report password
Ubah Ubah report port 3,​306
Ubah Ubah report user
Ubah Ubah rowid merge buff size 8,​388,​608
Ubah Ubah rpl semi sync master enabled OFF
Ubah Ubah rpl semi sync master timeout 10,​000
Ubah Ubah rpl semi sync master trace level 32
Ubah Ubah rpl semi sync master wait no slave ON
Ubah Ubah rpl semi sync master wait point AFTER_COMMIT
Ubah Ubah rpl semi sync slave delay master OFF
Ubah Ubah rpl semi sync slave enabled OFF
Ubah Ubah rpl semi sync slave kill conn timeout 5
Ubah Ubah rpl semi sync slave trace level 32
Ubah Ubah secure auth ON
Ubah Ubah secure file priv
Ubah Ubah secure timestamp NO
Ubah Ubah server id 1
Ubah Ubah session track schema ON
Ubah Ubah session track state change OFF
Ubah Ubah session track system variables autocommit,​character_set_client,​character_set_connection,​character_set_results,​time_zone
Ubah Ubah session track transaction info OFF
Ubah Ubah skip external locking ON
Ubah Ubah skip name resolve OFF
Ubah Ubah skip networking OFF
Ubah Ubah skip show database OFF
Ubah Ubah slave compressed protocol OFF
Ubah Ubah slave ddl exec mode IDEMPOTENT
Ubah Ubah slave domain parallel threads 0
Ubah Ubah slave exec mode STRICT
Ubah Ubah slave load tmpdir /tmp
Ubah Ubah slave max allowed packet 1,​073,​741,​824
Ubah Ubah slave net timeout 60
Ubah Ubah slave parallel max queued 131,​072
Ubah Ubah slave parallel mode conservative
Ubah Ubah slave parallel threads 0
Ubah Ubah slave parallel workers 0
Ubah Ubah slave run triggers for rbr NO
Ubah Ubah slave skip errors OFF
Ubah Ubah slave sql verify checksum ON
Ubah Ubah slave transaction retries 10
Ubah Ubah slave transaction retry errors 1158,​1159,​1160,​1161,​1205,​1213,​1429,​2013,​12701
Ubah Ubah slave transaction retry interval 0
Ubah Ubah slave type conversions
Ubah Ubah slow launch time 2
Ubah Ubah slow query log OFF
Ubah Ubah slow query log file /var/log/mysql/mariadb-slow.log
Ubah Ubah socket /var/run/mysqld/mysqld.sock
Ubah Ubah sort buffer size 4,​194,​304
Ubah Ubah sql auto is null OFF
Ubah Ubah sql big selects ON
Ubah Ubah sql buffer result OFF
Ubah Ubah sql log bin ON
Ubah Ubah sql log off OFF
Ubah Ubah sql mode STRICT_TRANS_TABLES,​ERROR_FOR_DIVISION_BY_ZERO,​NO_AUTO_CREATE_USER,​NO_ENGINE_SUBSTITUTION
Ubah Ubah sql notes ON
Ubah Ubah sql quote show create ON
Ubah Ubah sql safe updates OFF
Ubah Ubah sql select limit 18,​446,​744,​073,​709,​551,​616
Ubah Ubah sql slave skip counter 0
Ubah Ubah sql warnings OFF
Ubah Ubah ssl ca
Ubah Ubah ssl capath
Ubah Ubah ssl cert
Ubah Ubah ssl cipher
Ubah Ubah ssl crl
Ubah Ubah ssl crlpath
Ubah Ubah ssl key
Ubah Ubah standard compliant cte ON
Ubah Ubah storage engine InnoDB
Ubah Ubah stored program cache 256
Ubah Ubah strict password validation ON
Ubah Ubah sync binlog 0
Ubah Ubah sync frm ON
Ubah Ubah sync master info 10,​000
Ubah Ubah sync relay log 10,​000
Ubah Ubah sync relay log info 10,​000
Ubah Ubah system time zone CET
Ubah Ubah system versioning alter history ERROR
Ubah Ubah system versioning asof DEFAULT
Ubah Ubah table definition cache 400
Ubah Ubah table open cache 400
Ubah Ubah table open cache instances 8
Ubah Ubah tcp keepalive interval 0
Ubah Ubah tcp keepalive probes 0
Ubah Ubah tcp keepalive time 0
Ubah Ubah tcp nodelay ON
Ubah Ubah thread cache size 8
Ubah Ubah thread concurrency 10
Ubah Ubah thread handling one-thread-per-connection
Ubah Ubah thread pool idle timeout 60
Ubah Ubah thread pool max threads 65,​536
Ubah Ubah thread pool oversubscribe 3
Ubah Ubah thread pool prio kickup timer 1,​000
Ubah Ubah thread pool priority auto
Ubah Ubah thread pool size 2
Ubah Ubah thread pool stall limit 500
Ubah Ubah thread stack 196,​608
Ubah Ubah time format %H:%i:%s
Ubah Ubah time zone SYSTEM
Ubah Ubah timed mutexes OFF
Ubah Ubah tls version TLSv1.1,​TLSv1.2,​TLSv1.3
Ubah Ubah tmp disk table size 18,​446,​744,​073,​709,​551,​616
Ubah Ubah tmp memory table size 33,​554,​432
Ubah Ubah tmp table size 33,​554,​432
Ubah Ubah tmpdir /tmp
Ubah Ubah transaction alloc block size 8,​192
Ubah Ubah transaction prealloc size 4,​096
Ubah Ubah tx isolation REPEATABLE-READ
Ubah Ubah tx read only OFF
Ubah Ubah unique checks ON
Ubah Ubah updatable views with limit YES
Ubah Ubah use stat tables PREFERABLY_FOR_QUERIES
Ubah Ubah userstat OFF
Ubah Ubah version 10.4.8-MariaDB-1:10.4.8+maria~stretch-log
Ubah Ubah version comment mariadb.org binary distribution
Ubah Ubah version compile machine x86_64
Ubah Ubah version compile os debian-linux-gnu
Ubah Ubah version malloc library system
Ubah Ubah version source revision 4c2464b87d58a43d1292e166bae6720b51f4b000
Ubah Ubah version ssl library OpenSSL 1.1.0l 10 Sep 2019
Ubah Ubah wait timeout 600
Ubah Ubah wsrep osu method TOI
Ubah Ubah wsrep sr store table
Ubah Ubah wsrep auto increment control ON
Ubah Ubah wsrep causal reads OFF
Ubah Ubah wsrep certification rules strict
Ubah Ubah wsrep certify nonpk ON
Ubah Ubah wsrep cluster address
Ubah Ubah wsrep cluster name my_wsrep_cluster
Ubah Ubah wsrep convert lock to trx OFF
Ubah Ubah wsrep data home dir /var/lib/mysql/
Ubah Ubah wsrep dbug option
Ubah Ubah wsrep debug NONE
Ubah Ubah wsrep desync OFF
Ubah Ubah wsrep dirty reads OFF
Ubah Ubah wsrep drupal 282555 workaround OFF
Ubah Ubah wsrep forced binlog format NONE
Ubah Ubah wsrep gtid domain id 0
Ubah Ubah wsrep gtid mode OFF
Ubah Ubah wsrep ignore apply errors 7
Ubah Ubah wsrep load data splitting OFF
Ubah Ubah wsrep log conflicts OFF
Ubah Ubah wsrep max ws rows 0
Ubah Ubah wsrep max ws size 2,​147,​483,​647
Ubah Ubah wsrep mysql replication bundle 0
Ubah Ubah wsrep node address
Ubah Ubah wsrep node incoming address AUTO
Ubah Ubah wsrep node name demo-mariadb
Ubah Ubah wsrep notify cmd
Ubah Ubah wsrep on OFF
Ubah Ubah wsrep patch version wsrep_26.22
Ubah Ubah wsrep provider none
Ubah Ubah wsrep provider options
Ubah Ubah wsrep recover OFF
Ubah Ubah wsrep reject queries NONE
Ubah Ubah wsrep replicate myisam OFF
Ubah Ubah wsrep restart slave OFF
Ubah Ubah wsrep retry autocommit 1
Ubah Ubah wsrep slave fk checks ON
Ubah Ubah wsrep slave uk checks OFF
Ubah Ubah wsrep slave threads 1
Ubah Ubah wsrep sst auth
Ubah Ubah wsrep sst donor
Ubah Ubah wsrep sst donor rejects queries OFF
Ubah Ubah wsrep sst method rsync
Ubah Ubah wsrep sst receive address AUTO
Ubah Ubah wsrep start position 00000000-0000-0000-0000-000000000000:-1
Ubah Ubah wsrep sync wait 0
Ubah Ubah wsrep trx fragment size 0
Ubah Ubah wsrep trx fragment unit bytes