Letakkan berkas disini

SQL upload ( 0 ) x-

Server: localhost
Pengaturan Halaman-relasiKlik 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
Tindakan Variabel Nilai sesi / Nilai global
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  NORMAL
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  80
Ubah Ubah basedir  /opt/lampp
Ubah Ubah big tables  OFF
Ubah Ubah binlog annotate row events  OFF
Ubah Ubah binlog cache size  <abbr title="32,768">32 KB</abbr>
Ubah Ubah binlog checksum  NONE
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 format  STATEMENT
Ubah Ubah binlog optimize thread scheduling  ON
Ubah Ubah binlog row image  FULL
Ubah Ubah binlog stmt cache size  <abbr title="32,768">32 KB</abbr>
Ubah Ubah bulk insert buffer size  <abbr title="8,388,608">8 MB</abbr>
Ubah Ubah character set client  latin1
(Nilai sesi )  utf8mb4
Ubah Ubah character set connection  latin1
(Nilai sesi )  utf8mb4
Ubah Ubah character set database  latin1
Ubah Ubah character set filesystem  binary
Ubah Ubah character set results  latin1
(Nilai sesi )  utf8mb4
Ubah Ubah character set server  latin1
Ubah Ubah character set system  utf8
Ubah Ubah character sets dir  /opt/lampp/share/charsets/
Ubah Ubah collation connection  latin1_swedish_ci
(Nilai sesi )  utf8mb4_unicode_ci
Ubah Ubah collation database  latin1_swedish_ci
Ubah Ubah collation server  latin1_swedish_ci
Ubah Ubah completion type  NO_CHAIN
Ubah Ubah concurrent insert  AUTO
Ubah Ubah connect timeout  10
Ubah Ubah datadir  /opt/lampp/var/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 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 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 event scheduler  OFF
Ubah Ubah expensive subquery limit  100
Ubah Ubah expire logs days  0
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  ubuntu.log
Ubah Ubah group concat max len  1,024
Ubah Ubah gtid binlog pos  
Ubah Ubah gtid binlog state  
Ubah Ubah gtid current pos  
Ubah Ubah gtid domain id  0
Ubah Ubah gtid ignore duplicates  OFF
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  0
Ubah Ubah histogram type  SINGLE_PREC_HB
Ubah Ubah host cache size  279
Ubah Ubah hostname  ubuntu
Ubah Ubah ignore builtin innodb  OFF
Ubah Ubah ignore db dirs  
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 partitions  1
Ubah Ubah innodb adaptive max sleep delay  150,000
Ubah Ubah innodb additional mem pool size  <abbr title="8,388,608">8 MB</abbr>
Ubah Ubah innodb api bk commit interval  5
Ubah Ubah innodb api disable rowlock  OFF
Ubah Ubah innodb api enable binlog  OFF
Ubah Ubah innodb api enable mdl  OFF
Ubah Ubah innodb api trx level  0
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 dump at shutdown  OFF
Ubah Ubah innodb buffer pool dump now  OFF
Ubah Ubah innodb buffer pool dump pct  100
Ubah Ubah innodb buffer pool filename  ib_buffer_pool
Ubah Ubah innodb buffer pool instances  8
Ubah Ubah innodb buffer pool load abort  OFF
Ubah Ubah innodb buffer pool load at startup  OFF
Ubah Ubah innodb buffer pool load now  OFF
Ubah Ubah innodb buffer pool populate  OFF
Ubah Ubah innodb buffer pool size  <abbr title="16,777,216">16 MB</abbr>
Ubah Ubah innodb change buffer max size  25
Ubah Ubah innodb change buffering  all
Ubah Ubah innodb checksum algorithm  INNODB
Ubah Ubah innodb checksums  ON
Ubah Ubah innodb cleaner lsn age factor  HIGH_CHECKPOINT
Ubah Ubah innodb cmp per index enabled  OFF
Ubah Ubah innodb commit concurrency  0
Ubah Ubah innodb compression algorithm  none
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 corrupt table action  assert
Ubah Ubah innodb data file path  ibdata1:10M:autoextend
Ubah Ubah innodb data home dir  /opt/lampp/var/mysql/
Ubah Ubah innodb default encryption key id  1
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 empty free list algorithm  LEGACY
Ubah Ubah innodb encrypt log  OFF
Ubah Ubah innodb encrypt 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 fake changes  OFF
Ubah Ubah innodb fast shutdown  1
Ubah Ubah innodb fatal semaphore wait threshold  600
Ubah Ubah innodb file format  Antelope
Ubah Ubah innodb file format check  ON
Ubah Ubah innodb file format max  Antelope
Ubah Ubah innodb file per table  ON
Ubah Ubah innodb flush log at timeout  1
Ubah Ubah innodb flush log at trx commit  1
Ubah Ubah innodb flush method  
Ubah Ubah innodb flush neighbors  1
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 foreground preflush  EXPONENTIAL_BACKOFF
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 instrument semaphores  OFF
Ubah Ubah innodb io capacity  200
Ubah Ubah innodb io capacity max  2,000
Ubah Ubah innodb kill idle transaction  0
Ubah Ubah innodb large prefix  OFF
Ubah Ubah innodb lock schedule algorithm  fcfs
Ubah Ubah innodb lock wait timeout  50
Ubah Ubah innodb locking fake changes  ON
Ubah Ubah innodb locks unsafe for binlog  OFF
Ubah Ubah innodb log arch dir  /opt/lampp/var/mysql/
Ubah Ubah innodb log arch expire sec  0
Ubah Ubah innodb log archive  OFF
Ubah Ubah innodb log block size  512
Ubah Ubah innodb log buffer size  <abbr title="8,388,608">8 MB</abbr>
Ubah Ubah innodb log checksum algorithm  INNODB
Ubah Ubah innodb log compressed pages  OFF
Ubah Ubah innodb log file size  <abbr title="5,242,880">5 MB</abbr>
Ubah Ubah innodb log files in group  2
Ubah Ubah innodb log group home dir  /opt/lampp/var/mysql/
Ubah Ubah innodb lru scan depth  1,024
Ubah Ubah innodb max bitmap file size  104,857,600
Ubah Ubah innodb max changed pages  1,000,000
Ubah Ubah innodb max dirty pages pct  75
Ubah Ubah innodb max dirty pages pct lwm   <1
Ubah Ubah innodb max purge lag  0
Ubah Ubah innodb max purge lag delay  0
Ubah Ubah innodb mirrored log groups  1
Ubah Ubah innodb monitor disable  
Ubah Ubah innodb monitor enable  
Ubah Ubah innodb monitor reset  
Ubah Ubah innodb monitor reset all  
Ubah Ubah innodb mtflush threads  8
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  300
Ubah Ubah innodb optimize fulltext only  OFF
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 threads  1
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 sched priority cleaner  19
Ubah Ubah innodb scrub log  OFF
Ubah Ubah innodb scrub log speed  256
Ubah Ubah innodb show locks held  10
Ubah Ubah innodb show verbose locks  0
Ubah Ubah innodb simulate comp failures  0
Ubah Ubah innodb sort buffer size  1,048,576
Ubah Ubah innodb spin wait delay  6
Ubah Ubah innodb stats auto recalc  ON
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  OFF
Ubah Ubah innodb support xa  ON
Ubah Ubah innodb sync array size  1
Ubah Ubah innodb sync spin loops  30
Ubah Ubah innodb table locks  ON
Ubah Ubah innodb thread concurrency  0
Ubah Ubah innodb thread sleep delay  10,000
Ubah Ubah innodb tmpdir  
Ubah Ubah innodb track changed pages  OFF
Ubah Ubah innodb undo directory  .
Ubah Ubah innodb undo logs  128
Ubah Ubah innodb undo tablespaces  0
Ubah Ubah innodb use atomic writes  OFF
Ubah Ubah innodb use fallocate  OFF
Ubah Ubah innodb use global flush log at trx commit  ON
Ubah Ubah innodb use mtflush  OFF
Ubah Ubah innodb use native aio  OFF
Ubah Ubah innodb use stacktrace  OFF
Ubah Ubah innodb use sys malloc  ON
Ubah Ubah innodb use trim  OFF
Ubah Ubah innodb version  5.6.34-79.1
Ubah Ubah innodb write io threads  4
Ubah Ubah interactive timeout  28,800
Ubah Ubah join buffer size  <abbr title="262,144">256 KB</abbr>
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  <abbr title="16,777,216">16 MB</abbr>
Ubah Ubah key cache age threshold  300
Ubah Ubah key cache block size  <abbr title="1,024">1 KB</abbr>
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  <abbr title="0">0 B</abbr>
Ubah Ubah large pages  OFF
Ubah Ubah lc messages  en_US
(Nilai sesi )  id_ID
Ubah Ubah lc messages dir  
Ubah Ubah lc time names  en_US
Ubah Ubah license  GPL
Ubah Ubah local infile  ON
Ubah Ubah lock wait timeout  31,536,000
Ubah Ubah locked in memory  OFF
Ubah Ubah log bin  OFF
Ubah Ubah log bin basename  
Ubah Ubah log bin index  
Ubah Ubah log bin trust function creators  OFF
Ubah Ubah log error  /opt/lampp/var/mysql/ubuntu.err
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  OFF
Ubah Ubah log slow filter  admin,filesort,filesort_on_disk,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  OFF
Ubah Ubah log slow verbosity  
Ubah Ubah log tc size  24,576
Ubah Ubah log warnings  1
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  1,048,576
Ubah Ubah max binlog cache size  <abbr title="18,446,744,073,709,547,520">16 EB</abbr>
Ubah Ubah max binlog size  <abbr title="1,073,741,824">1 GB</abbr>
Ubah Ubah max binlog stmt cache size  <abbr title="18,446,744,073,709,547,520">16 EB</abbr>
Ubah Ubah max connect errors  100
Ubah Ubah max connections  151
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  <abbr title="16,777,216">16 MB</abbr>
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  1,048,576
Ubah Ubah max prepared stmt count  16,382
Ubah Ubah max relay log size  <abbr title="1,073,741,824">1 GB</abbr>
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  <abbr title="6">6 B</abbr>
Ubah Ubah myisam max sort file size  <abbr title="9,223,372,036,853,727,232">8 EB</abbr>
Ubah Ubah myisam mmap size  <abbr title="18,446,744,073,709,551,616">16 EB</abbr>
Ubah Ubah myisam recover options  DEFAULT
Ubah Ubah myisam repair threads  1
Ubah Ubah myisam sort buffer size  <abbr title="8,388,608">8 MB</abbr>
Ubah Ubah myisam stats method  NULLS_UNEQUAL
Ubah Ubah myisam use mmap  OFF
Ubah Ubah mysql56 temporal format  ON
Ubah Ubah net buffer length  8,192
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  OFF
Ubah Ubah old mode  
Ubah Ubah old passwords  OFF
Ubah Ubah open files limit  1,024
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=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
Ubah Ubah optimizer use condition selectivity  1
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  150
Ubah Ubah performance schema max statement classes  178
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  /opt/lampp/var/mysql/ubuntu.pid
Ubah Ubah plugin dir  /opt/lampp/lib/mysql/plugin/
Ubah Ubah plugin maturity  unknown
Ubah Ubah port  3,306
Ubah Ubah preload buffer size  <abbr title="32,768">32 KB</abbr>
Ubah Ubah profiling  OFF
Ubah Ubah profiling history size  15
Ubah Ubah progress report time  5
Ubah Ubah protocol version  10
Ubah Ubah query alloc block size  <abbr title="16,384">16 KB</abbr>
Ubah Ubah query cache limit  <abbr title="1,048,576">1 MB</abbr>
Ubah Ubah query cache min res unit  4,096
Ubah Ubah query cache size  <abbr title="1,048,576">1 MB</abbr>
Ubah Ubah query cache strip comments  OFF
Ubah Ubah query cache type  OFF
Ubah Ubah query cache wlock invalidate  OFF
Ubah Ubah query prealloc size  <abbr title="24,576">24 KB</abbr>
Ubah Ubah range alloc block size  <abbr title="4,096">4 KB</abbr>
Ubah Ubah read buffer size  <abbr title="262,144">256 KB</abbr>
Ubah Ubah read only  OFF
Ubah Ubah read rnd buffer size  <abbr title="524,288">512 KB</abbr>
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  OFF
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 secure auth  ON
Ubah Ubah secure file priv  
Ubah Ubah server id  1
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  3,600
Ubah Ubah slave parallel max queued  131,072
Ubah Ubah slave parallel mode  conservative
Ubah Ubah slave parallel threads  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 type conversions  
Ubah Ubah slow launch time  2
Ubah Ubah slow query log  OFF
Ubah Ubah slow query log file  ubuntu-slow.log
Ubah Ubah socket  /opt/lampp/var/mysql/mysql.sock
Ubah Ubah sort buffer size  <abbr title="524,288">512 KB</abbr>
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  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 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  8
Ubah Ubah table definition cache  400
Ubah Ubah table open cache  64
Ubah Ubah thread cache size  0
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  1,000
Ubah Ubah thread pool oversubscribe  3
Ubah Ubah thread pool size  5
Ubah Ubah thread pool stall limit  500
Ubah Ubah thread stack  295,936
Ubah Ubah time format  %H:%i:%s
Ubah Ubah time zone  SYSTEM
Ubah Ubah timed mutexes  OFF
Ubah Ubah tmp table size  <abbr title="16,777,216">16 MB</abbr>
Ubah Ubah tmpdir  /tmp
Ubah Ubah transaction alloc block size  <abbr title="8,192">8 KB</abbr>
Ubah Ubah transaction prealloc size  <abbr title="4,096">4 KB</abbr>
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  NEVER
Ubah Ubah userstat  OFF
Ubah Ubah version  10.1.21-MariaDB
Ubah Ubah version comment  Source distribution
Ubah Ubah version compile machine  x86_64
Ubah Ubah version compile os  Linux
Ubah Ubah version malloc library  system
Ubah Ubah version ssl library  OpenSSL 1.0.2j 26 Sep 2016
Ubah Ubah wait timeout  28,800
Ubah Ubah wsrep osu method  TOI
Ubah Ubah wsrep auto increment control  ON
Ubah Ubah wsrep causal reads  OFF
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  /opt/lampp/var/mysql/
Ubah Ubah wsrep dbug option  
Ubah Ubah wsrep debug  OFF
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 load data splitting  ON
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  ubuntu
Ubah Ubah wsrep notify cmd  
Ubah Ubah wsrep on  OFF
Ubah Ubah wsrep patch version  wsrep_25.16
Ubah Ubah wsrep provider  none
Ubah Ubah wsrep provider options  
Ubah Ubah wsrep recover  OFF
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