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