Letakkan berkas disini

SQL upload ( 0 ) x-

Server: 127.0.0.1:3309
Page-related settingsKlik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueriPress 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: Time taken:
Bookmark
Segarkan
Tambah
Tidak ada bookmark
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data: Waktu eksekusi kueri:

Variabel dan pengaturan server Dokumentasi

Filters
TindakanVariabelNilai sesi / Nilai global
Ubah Ubaharia block size 8,192
Ubah Ubaharia checkpoint interval 30
Ubah Ubaharia checkpoint log activity 1,048,576
Ubah Ubaharia encrypt tables OFF
Ubah Ubaharia force start after recovery failures 0
Ubah Ubaharia group commit none
Ubah Ubaharia group commit interval 0
Ubah Ubaharia log file size 1,073,741,824
Ubah Ubaharia log purge type immediate
Ubah Ubaharia max sort file size 9,223,372,036,853,727,232
Ubah Ubaharia page checksum ON
Ubah Ubaharia pagecache age threshold 300
Ubah Ubaharia pagecache buffer size 134,217,728
Ubah Ubaharia pagecache division limit 100
Ubah Ubaharia pagecache file hash size 512
Ubah Ubaharia recover NORMAL
Ubah Ubaharia repair threads 1
Ubah Ubaharia sort buffer size 268,434,432
Ubah Ubaharia stats method nulls_unequal
Ubah Ubaharia sync log dir NEWFILE
Ubah Ubaharia used for temp tables ON
Ubah Ubahauto increment increment 1
Ubah Ubahauto increment offset 1
Ubah Ubahautocommit ON
Ubah Ubahautomatic sp privileges ON
Ubah Ubahback log 80
Ubah Ubahbasedir C:/xampp/mysql
Ubah Ubahbig tables OFF
Ubah Ubahbinlog annotate row events OFF
Ubah Ubahbinlog cache size 32 KB
Ubah Ubahbinlog checksum NONE
Ubah Ubahbinlog commit wait count 0
Ubah Ubahbinlog commit wait usec 100,000
Ubah Ubahbinlog direct non transactional updates OFF
Ubah Ubahbinlog format STATEMENT
Ubah Ubahbinlog optimize thread scheduling ON
Ubah Ubahbinlog row image FULL
Ubah Ubahbinlog stmt cache size 32 KB
Ubah Ubahbulk insert buffer size 8 MB
Ubah Ubahcharacter set client latin1
(Nilai sesi) utf8mb4
Ubah Ubahcharacter set connection latin1
(Nilai sesi) utf8mb4
Ubah Ubahcharacter set database latin1
Ubah Ubahcharacter set filesystem binary
Ubah Ubahcharacter set results latin1
(Nilai sesi) utf8mb4
Ubah Ubahcharacter set server latin1
Ubah Ubahcharacter set system utf8
Ubah Ubahcharacter sets dir C:\xampp\mysql\share\charsets\
Ubah Ubahcollation connection latin1_swedish_ci
(Nilai sesi) utf8mb4_general_ci
Ubah Ubahcollation database latin1_swedish_ci
Ubah Ubahcollation server latin1_swedish_ci
Ubah Ubahcompletion type NO_CHAIN
Ubah Ubahconcurrent insert AUTO
Ubah Ubahconnect timeout 10
Ubah Ubahdatadir C:\xampp\mysql\data\
Ubah Ubahdate format %Y-%m-%d
Ubah Ubahdatetime format %Y-%m-%d %H:%i:%s
Ubah Ubahdeadlock search depth long 15
Ubah Ubahdeadlock search depth short 4
Ubah Ubahdeadlock timeout long 50,000,000
Ubah Ubahdeadlock timeout short 10,000
Ubah Ubahdebug no thread alarm OFF
Ubah Ubahdefault regex flags 
Ubah Ubahdefault storage engine InnoDB
Ubah Ubahdefault tmp storage engine 
Ubah Ubahdefault week format 0
Ubah Ubahdelay key write ON
Ubah Ubahdelayed insert limit 100
Ubah Ubahdelayed insert timeout 300
Ubah Ubahdelayed queue size 1,000
Ubah Ubahdiv precision increment 4
Ubah Ubahencrypt binlog OFF
Ubah Ubahencrypt tmp disk tables OFF
Ubah Ubahencrypt tmp files OFF
Ubah Ubahenforce storage engine 
Ubah Ubahevent scheduler OFF
Ubah Ubahexpensive subquery limit 100
Ubah Ubahexpire logs days 0
Ubah Ubahexplicit defaults for timestamp OFF
Ubah Ubahextra max connections 1
Ubah Ubahextra port 0
Ubah Ubahflush OFF
Ubah Ubahflush time 0
Ubah Ubahforeign key checks ON
Ubah Ubahft boolean syntax + -><()~*:""&|
Ubah Ubahft max word len 84
Ubah Ubahft min word len 4
Ubah Ubahft query expansion limit 20
Ubah Ubahft stopword file (built-in)
Ubah Ubahgeneral log OFF
Ubah Ubahgeneral log file WIN-BFPA4FU6O44.log
Ubah Ubahgroup concat max len 1,024
Ubah Ubahgtid binlog pos 
Ubah Ubahgtid binlog state 
Ubah Ubahgtid current pos 
Ubah Ubahgtid domain id 0
Ubah Ubahgtid ignore duplicates OFF
Ubah Ubahgtid slave pos 
Ubah Ubahgtid strict mode OFF
Ubah Ubahhave compress YES
Ubah Ubahhave crypt NO
Ubah Ubahhave dynamic loading YES
Ubah Ubahhave geometry YES
Ubah Ubahhave openssl NO
Ubah Ubahhave profiling YES
Ubah Ubahhave query cache YES
Ubah Ubahhave rtree keys YES
Ubah Ubahhave ssl DISABLED
Ubah Ubahhave symlink NO
Ubah Ubahhistogram size 0
Ubah Ubahhistogram type SINGLE_PREC_HB
Ubah Ubahhost cache size 279
Ubah Ubahhostname WIN-BFPA4FU6O44
Ubah Ubahignore builtin innodb OFF
Ubah Ubahignore db dirs 
Ubah Ubahinit connect 
Ubah Ubahinit file 
Ubah Ubahinit slave 
Ubah Ubahinnodb adaptive flushing ON
Ubah Ubahinnodb adaptive flushing lwm 10
Ubah Ubahinnodb adaptive hash index ON
Ubah Ubahinnodb adaptive hash index partitions 1
Ubah Ubahinnodb adaptive max sleep delay 150,000
Ubah Ubahinnodb additional mem pool size 2 MB
Ubah Ubahinnodb api bk commit interval 5
Ubah Ubahinnodb api disable rowlock OFF
Ubah Ubahinnodb api enable binlog OFF
Ubah Ubahinnodb api enable mdl OFF
Ubah Ubahinnodb api trx level 0
Ubah Ubahinnodb autoextend increment 64
Ubah Ubahinnodb autoinc lock mode 1
Ubah Ubahinnodb background scrub data check interval 3,600
Ubah Ubahinnodb background scrub data compressed OFF
Ubah Ubahinnodb background scrub data interval 604,800
Ubah Ubahinnodb background scrub data uncompressed OFF
Ubah Ubahinnodb buf dump status frequency 0
Ubah Ubahinnodb buffer pool dump at shutdown OFF
Ubah Ubahinnodb buffer pool dump now OFF
Ubah Ubahinnodb buffer pool dump pct 100
Ubah Ubahinnodb buffer pool filename ib_buffer_pool
Ubah Ubahinnodb buffer pool instances 8
Ubah Ubahinnodb buffer pool load abort OFF
Ubah Ubahinnodb buffer pool load at startup OFF
Ubah Ubahinnodb buffer pool load now OFF
Ubah Ubahinnodb buffer pool populate OFF
Ubah Ubahinnodb buffer pool size 128 MB
Ubah Ubahinnodb change buffer max size 25
Ubah Ubahinnodb change buffering all
Ubah Ubahinnodb checksum algorithm INNODB
Ubah Ubahinnodb checksums ON
Ubah Ubahinnodb cleaner lsn age factor HIGH_CHECKPOINT
Ubah Ubahinnodb cmp per index enabled OFF
Ubah Ubahinnodb commit concurrency 0
Ubah Ubahinnodb compression algorithm zlib
Ubah Ubahinnodb compression failure threshold pct 5
Ubah Ubahinnodb compression level 6
Ubah Ubahinnodb compression pad pct max 50
Ubah Ubahinnodb concurrency tickets 5,000
Ubah Ubahinnodb corrupt table action assert
Ubah Ubahinnodb data file path ibdata1:10M:autoextend
Ubah Ubahinnodb data home dir C:\xampp\mysql\data
Ubah Ubahinnodb default encryption key id 1
Ubah Ubahinnodb defragment OFF
Ubah Ubahinnodb defragment fill factor 1
Ubah Ubahinnodb defragment fill factor n recs 20
Ubah Ubahinnodb defragment frequency 40
Ubah Ubahinnodb defragment n pages 7
Ubah Ubahinnodb defragment stats accuracy 0
Ubah Ubahinnodb disable sort file cache OFF
Ubah Ubahinnodb doublewrite ON
Ubah Ubahinnodb empty free list algorithm LEGACY
Ubah Ubahinnodb encrypt log OFF
Ubah Ubahinnodb encrypt tables OFF
Ubah Ubahinnodb encryption rotate key age 1
Ubah Ubahinnodb encryption rotation iops 100
Ubah Ubahinnodb encryption threads 0
Ubah Ubahinnodb fake changes OFF
Ubah Ubahinnodb fast shutdown 1
Ubah Ubahinnodb fatal semaphore wait threshold 600
Ubah Ubahinnodb file format Antelope
Ubah Ubahinnodb file format check ON
Ubah Ubahinnodb file format max Antelope
Ubah Ubahinnodb file per table ON
Ubah Ubahinnodb flush log at timeout 1
Ubah Ubahinnodb flush log at trx commit 1
Ubah Ubahinnodb flush method 
Ubah Ubahinnodb flush neighbors 1
Ubah Ubahinnodb flushing avg loops 30
Ubah Ubahinnodb force load corrupted OFF
Ubah Ubahinnodb force primary key OFF
Ubah Ubahinnodb force recovery 0
Ubah Ubahinnodb foreground preflush EXPONENTIAL_BACKOFF
Ubah Ubahinnodb ft aux table 
Ubah Ubahinnodb ft cache size 8,000,000
Ubah Ubahinnodb ft enable diag print OFF
Ubah Ubahinnodb ft enable stopword ON
Ubah Ubahinnodb ft max token size 84
Ubah Ubahinnodb ft min token size 3
Ubah Ubahinnodb ft num word optimize 2,000
Ubah Ubahinnodb ft result cache limit 2,000,000,000
Ubah Ubahinnodb ft server stopword table 
Ubah Ubahinnodb ft sort pll degree 2
Ubah Ubahinnodb ft total cache size 640,000,000
Ubah Ubahinnodb ft user stopword table 
Ubah Ubahinnodb idle flush pct 100
Ubah Ubahinnodb immediate scrub data uncompressed OFF
Ubah Ubahinnodb instrument semaphores OFF
Ubah Ubahinnodb io capacity 200
Ubah Ubahinnodb io capacity max 2,000
Ubah Ubahinnodb kill idle transaction 0
Ubah Ubahinnodb large prefix OFF
Ubah Ubahinnodb lock schedule algorithm fcfs
Ubah Ubahinnodb lock wait timeout 50
Ubah Ubahinnodb locking fake changes ON
Ubah Ubahinnodb locks unsafe for binlog OFF
Ubah Ubahinnodb log arch dir C:\xampp\mysql\data
Ubah Ubahinnodb log arch expire sec 0
Ubah Ubahinnodb log archive OFF
Ubah Ubahinnodb log block size 512
Ubah Ubahinnodb log buffer size 8 MB
Ubah Ubahinnodb log checksum algorithm INNODB
Ubah Ubahinnodb log compressed pages ON
Ubah Ubahinnodb log file size 32 MB
Ubah Ubahinnodb log files in group 2
Ubah Ubahinnodb log group home dir C:\xampp\mysql\data
Ubah Ubahinnodb lru scan depth 1,024
Ubah Ubahinnodb max bitmap file size 104,857,600
Ubah Ubahinnodb max changed pages 1,000,000
Ubah Ubahinnodb max dirty pages pct 75
Ubah Ubahinnodb max dirty pages pct lwm  <1
Ubah Ubahinnodb max purge lag 0
Ubah Ubahinnodb max purge lag delay 0
Ubah Ubahinnodb mirrored log groups 1
Ubah Ubahinnodb monitor disable 
Ubah Ubahinnodb monitor enable 
Ubah Ubahinnodb monitor reset 
Ubah Ubahinnodb monitor reset all 
Ubah Ubahinnodb mtflush threads 8
Ubah Ubahinnodb old blocks pct 37
Ubah Ubahinnodb old blocks time 1,000
Ubah Ubahinnodb online alter log max size 134,217,728
Ubah Ubahinnodb open files 2,000
Ubah Ubahinnodb optimize fulltext only OFF
Ubah Ubahinnodb page size 16,384
Ubah Ubahinnodb prefix index cluster optimization OFF
Ubah Ubahinnodb print all deadlocks OFF
Ubah Ubahinnodb purge batch size 300
Ubah Ubahinnodb purge threads 1
Ubah Ubahinnodb random read ahead OFF
Ubah Ubahinnodb read ahead threshold 56
Ubah Ubahinnodb read io threads 4
Ubah Ubahinnodb read only OFF
Ubah Ubahinnodb replication delay 0
Ubah Ubahinnodb rollback on timeout OFF
Ubah Ubahinnodb rollback segments 128
Ubah Ubahinnodb scrub log OFF
Ubah Ubahinnodb scrub log speed 256
Ubah Ubahinnodb show locks held 10
Ubah Ubahinnodb show verbose locks 0
Ubah Ubahinnodb simulate comp failures 0
Ubah Ubahinnodb sort buffer size 1,048,576
Ubah Ubahinnodb spin wait delay 6
Ubah Ubahinnodb stats auto recalc ON
Ubah Ubahinnodb stats include delete marked OFF
Ubah Ubahinnodb stats method nulls_equal
Ubah Ubahinnodb stats modified counter 0
Ubah Ubahinnodb stats on metadata OFF
Ubah Ubahinnodb stats persistent ON
Ubah Ubahinnodb stats persistent sample pages 20
Ubah Ubahinnodb stats sample pages 8
Ubah Ubahinnodb stats traditional ON
Ubah Ubahinnodb stats transient sample pages 8
Ubah Ubahinnodb status output OFF
Ubah Ubahinnodb status output locks OFF
Ubah Ubahinnodb strict mode OFF
Ubah Ubahinnodb support xa ON
Ubah Ubahinnodb sync array size 1
Ubah Ubahinnodb sync spin loops 30
Ubah Ubahinnodb table locks ON
Ubah Ubahinnodb thread concurrency 0
Ubah Ubahinnodb thread sleep delay 10,000
Ubah Ubahinnodb tmpdir 
Ubah Ubahinnodb track changed pages OFF
Ubah Ubahinnodb undo directory .
Ubah Ubahinnodb undo logs 128
Ubah Ubahinnodb undo tablespaces 0
Ubah Ubahinnodb use atomic writes OFF
Ubah Ubahinnodb use fallocate OFF
Ubah Ubahinnodb use global flush log at trx commit ON
Ubah Ubahinnodb use mtflush OFF
Ubah Ubahinnodb use native aio ON
Ubah Ubahinnodb use stacktrace OFF
Ubah Ubahinnodb use sys malloc ON
Ubah Ubahinnodb use trim OFF
Ubah Ubahinnodb version 5.6.36-82.2
Ubah Ubahinnodb write io threads 4
Ubah Ubahinteractive timeout 28,800
Ubah Ubahjoin buffer size 256 KB
Ubah Ubahjoin buffer space limit 2,097,152
Ubah Ubahjoin cache level 2
Ubah Ubahkeep files on create OFF
Ubah Ubahkey buffer size 16 MB
Ubah Ubahkey cache age threshold 300
Ubah Ubahkey cache block size 1 KB
Ubah Ubahkey cache division limit 100
Ubah Ubahkey cache file hash size 512
Ubah Ubahkey cache segments 0
Ubah Ubahlarge files support ON
Ubah Ubahlarge page size 0 B
Ubah Ubahlarge pages OFF
Ubah Ubahlc messages en_US
Ubah Ubahlc messages dir 
Ubah Ubahlc time names en_US
Ubah Ubahlicense GPL
Ubah Ubahlocal infile ON
Ubah Ubahlock wait timeout 31,536,000
Ubah Ubahlog bin OFF
Ubah Ubahlog bin basename 
Ubah Ubahlog bin index 
Ubah Ubahlog bin trust function creators OFF
Ubah Ubahlog error .\mysql_error.log
Ubah Ubahlog output FILE
Ubah Ubahlog queries not using indexes OFF
Ubah Ubahlog slave updates OFF
Ubah Ubahlog slow admin statements OFF
Ubah Ubahlog slow filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
Ubah Ubahlog slow rate limit 1
Ubah Ubahlog slow slave statements OFF
Ubah Ubahlog slow verbosity 
Ubah Ubahlog tc size 24,576
Ubah Ubahlog warnings 1
Ubah Ubahlong query time 10
Ubah Ubahlow priority updates OFF
Ubah Ubahlower case file system ON
Ubah Ubahlower case table names 1
Ubah Ubahmaster verify checksum OFF
Ubah Ubahmax allowed packet 536,870,912
Ubah Ubahmax binlog cache size 4 GB
Ubah Ubahmax binlog size 1 GB
Ubah Ubahmax binlog stmt cache size 4 GB
Ubah Ubahmax connect errors 100
Ubah Ubahmax connections 151
Ubah Ubahmax delayed threads 20
Ubah Ubahmax digest length 1,024
Ubah Ubahmax error count 64
Ubah Ubahmax heap table size 16 MB
Ubah Ubahmax insert delayed threads 20
Ubah Ubahmax join size 18,446,744,073,709,551,616
Ubah Ubahmax length for sort data 1,024
Ubah Ubahmax long data size 536,870,912
Ubah Ubahmax prepared stmt count 16,382
Ubah Ubahmax relay log size 1 GB
Ubah Ubahmax seeks for key 4,294,967,295
Ubah Ubahmax session mem used 9,223,372,036,854,775,808
Ubah Ubahmax sort length 1,024
Ubah Ubahmax sp recursion depth 0
Ubah Ubahmax statement time 0
Ubah Ubahmax tmp tables 32
Ubah Ubahmax user connections 0
Ubah Ubahmax write lock count 4,294,967,295
Ubah Ubahmetadata locks cache size 1,024
Ubah Ubahmetadata locks hash instances 8
Ubah Ubahmin examined row limit 0
Ubah Ubahmrr buffer size 262,144
Ubah Ubahmulti range count 256
Ubah Ubahmyisam block size 1,024
Ubah Ubahmyisam data pointer size 6 B
Ubah Ubahmyisam max sort file size 1.999 GB
Ubah Ubahmyisam mmap size 4 GB
Ubah Ubahmyisam recover options DEFAULT
Ubah Ubahmyisam repair threads 1
Ubah Ubahmyisam sort buffer size 8 MB
Ubah Ubahmyisam stats method NULLS_UNEQUAL
Ubah Ubahmyisam use mmap OFF
Ubah Ubahmysql56 temporal format ON
Ubah Ubahnamed pipe OFF
Ubah Ubahnet buffer length 8,192
Ubah Ubahnet read timeout 30
Ubah Ubahnet retry count 10
Ubah Ubahnet write timeout 60
Ubah Ubahold OFF
Ubah Ubahold alter table OFF
Ubah Ubahold mode 
Ubah Ubahold passwords OFF
Ubah Ubahopen files limit 6,210
Ubah Ubahoptimizer prune level 1
Ubah Ubahoptimizer search depth 62
Ubah Ubahoptimizer selectivity sampling limit 100
Ubah Ubahoptimizer 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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
Ubah Ubahoptimizer use condition selectivity 1
Ubah Ubahperformance schema OFF
Ubah Ubahperformance schema accounts size -1
Ubah Ubahperformance schema digests size -1
Ubah Ubahperformance schema events stages history long size -1
Ubah Ubahperformance schema events stages history size -1
Ubah Ubahperformance schema events statements history long size -1
Ubah Ubahperformance schema events statements history size -1
Ubah Ubahperformance schema events waits history long size -1
Ubah Ubahperformance schema events waits history size -1
Ubah Ubahperformance schema hosts size -1
Ubah Ubahperformance schema max cond classes 80
Ubah Ubahperformance schema max cond instances -1
Ubah Ubahperformance schema max digest length 1,024
Ubah Ubahperformance schema max file classes 50
Ubah Ubahperformance schema max file handles 32,768
Ubah Ubahperformance schema max file instances -1
Ubah Ubahperformance schema max mutex classes 200
Ubah Ubahperformance schema max mutex instances -1
Ubah Ubahperformance schema max rwlock classes 40
Ubah Ubahperformance schema max rwlock instances -1
Ubah Ubahperformance schema max socket classes 10
Ubah Ubahperformance schema max socket instances -1
Ubah Ubahperformance schema max stage classes 150
Ubah Ubahperformance schema max statement classes 178
Ubah Ubahperformance schema max table handles -1
Ubah Ubahperformance schema max table instances -1
Ubah Ubahperformance schema max thread classes 50
Ubah Ubahperformance schema max thread instances -1
Ubah Ubahperformance schema session connect attrs size -1
Ubah Ubahperformance schema setup actors size 100
Ubah Ubahperformance schema setup objects size 100
Ubah Ubahperformance schema users size -1
Ubah Ubahpid file C:\xampp\mysql\data\mysql.pid
Ubah Ubahplugin dir C:\xampp\mysql\lib\plugin\
Ubah Ubahplugin maturity unknown
Ubah Ubahport 3,309
Ubah Ubahpreload buffer size 32 KB
Ubah Ubahprofiling OFF
Ubah Ubahprofiling history size 15
Ubah Ubahprogress report time 5
Ubah Ubahprotocol version 10
Ubah Ubahquery alloc block size 16 KB
Ubah Ubahquery cache limit 1 MB
Ubah Ubahquery cache min res unit 4,096
Ubah Ubahquery cache size 1 MB
Ubah Ubahquery cache strip comments OFF
Ubah Ubahquery cache type OFF
Ubah Ubahquery cache wlock invalidate OFF
Ubah Ubahquery prealloc size 24 KB
Ubah Ubahrange alloc block size 4 KB
Ubah Ubahread buffer size 256 KB
Ubah Ubahread only OFF
Ubah Ubahread rnd buffer size 512 KB
Ubah Ubahrelay log 
Ubah Ubahrelay log basename 
Ubah Ubahrelay log index 
Ubah Ubahrelay log info file relay-log.info
Ubah Ubahrelay log purge ON
Ubah Ubahrelay log recovery OFF
Ubah Ubahrelay log space limit 0
Ubah Ubahreplicate annotate row events OFF
Ubah Ubahreplicate do db 
Ubah Ubahreplicate do table 
Ubah Ubahreplicate events marked for skip REPLICATE
Ubah Ubahreplicate ignore db 
Ubah Ubahreplicate ignore table 
Ubah Ubahreplicate wild do table 
Ubah Ubahreplicate wild ignore table 
Ubah Ubahreport host 
Ubah Ubahreport password 
Ubah Ubahreport port 3,309
Ubah Ubahreport user 
Ubah Ubahrowid merge buff size 8,388,608
Ubah Ubahsecure auth ON
Ubah Ubahsecure file priv 
Ubah Ubahserver id 1
Ubah Ubahshared memory OFF
Ubah Ubahshared memory base name MYSQL
Ubah Ubahskip external locking ON
Ubah Ubahskip name resolve OFF
Ubah Ubahskip networking OFF
Ubah Ubahskip show database OFF
Ubah Ubahslave compressed protocol OFF
Ubah Ubahslave ddl exec mode IDEMPOTENT
Ubah Ubahslave domain parallel threads 0
Ubah Ubahslave exec mode STRICT
Ubah Ubahslave load tmpdir C:\xampp\tmp
Ubah Ubahslave max allowed packet 1,073,741,824
Ubah Ubahslave net timeout 3,600
Ubah Ubahslave parallel max queued 131,072
Ubah Ubahslave parallel mode conservative
Ubah Ubahslave parallel threads 0
Ubah Ubahslave run triggers for rbr NO
Ubah Ubahslave skip errors OFF
Ubah Ubahslave sql verify checksum ON
Ubah Ubahslave transaction retries 10
Ubah Ubahslave type conversions 
Ubah Ubahslow launch time 2
Ubah Ubahslow query log OFF
Ubah Ubahslow query log file WIN-BFPA4FU6O44-slow.log
Ubah Ubahsocket C:/xampp/mysql/mysql.sock
Ubah Ubahsort buffer size 512 KB
Ubah Ubahsql auto is null OFF
Ubah Ubahsql big selects ON
Ubah Ubahsql buffer result OFF
Ubah Ubahsql log bin ON
Ubah Ubahsql log off OFF
Ubah Ubahsql mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Ubah Ubahsql notes ON
Ubah Ubahsql quote show create ON
Ubah Ubahsql safe updates OFF
Ubah Ubahsql select limit 18,446,744,073,709,551,616
Ubah Ubahsql slave skip counter 0
Ubah Ubahsql warnings OFF
Ubah Ubahssl ca 
Ubah Ubahssl capath 
Ubah Ubahssl cert 
Ubah Ubahssl cipher 
Ubah Ubahssl crl 
Ubah Ubahssl crlpath 
Ubah Ubahssl key 
Ubah Ubahstorage engine InnoDB
Ubah Ubahstored program cache 256
Ubah Ubahstrict password validation ON
Ubah Ubahsync binlog 0
Ubah Ubahsync frm ON
Ubah Ubahsync master info 10,000
Ubah Ubahsync relay log 10,000
Ubah Ubahsync relay log info 10,000
Ubah Ubahsystem time zone SE Asia Standard Time
Ubah Ubahtable definition cache 400
Ubah Ubahtable open cache 2,000
Ubah Ubahthread cache size 0
Ubah Ubahthread concurrency 10
Ubah Ubahthread handling pool-of-threads
Ubah Ubahthread pool max threads 1,000
Ubah Ubahthread pool min threads 1
Ubah Ubahthread stack 295,936
Ubah Ubahtime format %H:%i:%s
Ubah Ubahtime zone SYSTEM
Ubah Ubahtimed mutexes OFF
Ubah Ubahtmp table size 16 MB
Ubah Ubahtmpdir C:/xampp/tmp
Ubah Ubahtransaction alloc block size 8 KB
Ubah Ubahtransaction prealloc size 4 KB
Ubah Ubahtx isolation REPEATABLE-READ
Ubah Ubahtx read only OFF
Ubah Ubahunique checks ON
Ubah Ubahupdatable views with limit YES
Ubah Ubahuse stat tables NEVER
Ubah Ubahuserstat OFF
Ubah Ubahversion 10.1.30-MariaDB
Ubah Ubahversion comment mariadb.org binary distribution
Ubah Ubahversion compile machine 32
Ubah Ubahversion compile os Win32
Ubah Ubahversion malloc library system
Ubah Ubahversion ssl library YaSSL 2.4.4
Ubah Ubahwait timeout 28,800