Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Server variables and settings Documentation

Filters
ActionVariableSession value / Global value
Edit Editaria block size 8,192
Edit Editaria checkpoint interval 30
Edit Editaria checkpoint log activity 1,048,576
Edit Editaria encrypt tables OFF
Edit Editaria force start after recovery failures 0
Edit Editaria group commit none
Edit Editaria group commit interval 0
Edit Editaria log file size 1,073,741,824
Edit Editaria log purge type immediate
Edit Editaria max sort file size 9,223,372,036,853,727,232
Edit Editaria page checksum ON
Edit Editaria pagecache age threshold 300
Edit Editaria pagecache buffer size 134,217,728
Edit Editaria pagecache division limit 100
Edit Editaria pagecache file hash size 512
Edit Editaria recover NORMAL
Edit Editaria repair threads 1
Edit Editaria sort buffer size 268,434,432
Edit Editaria stats method nulls_unequal
Edit Editaria sync log dir NEWFILE
Edit Editaria used for temp tables ON
Edit Editauto increment increment 1
Edit Editauto increment offset 1
Edit Editautocommit ON
Edit Editautomatic sp privileges ON
Edit Editback log 80
Edit Editbasedir C:/xampp/mysql
Edit Editbig tables OFF
Edit Editbinlog annotate row events OFF
Edit Editbinlog cache size 32 KiB
Edit Editbinlog checksum NONE
Edit Editbinlog commit wait count 0
Edit Editbinlog commit wait usec 100,000
Edit Editbinlog direct non transactional updates OFF
Edit Editbinlog format STATEMENT
Edit Editbinlog optimize thread scheduling ON
Edit Editbinlog row image FULL
Edit Editbinlog stmt cache size 32 KiB
Edit Editbulk insert buffer size 8 MiB
Edit Editcharacter set client latin1
(Session value) utf8mb4
Edit Editcharacter set connection latin1
(Session value) utf8mb4
Edit Editcharacter set database latin1
Edit Editcharacter set filesystem binary
Edit Editcharacter set results latin1
(Session value) utf8mb4
Edit Editcharacter set server latin1
Edit Editcharacter set system utf8
Edit Editcharacter sets dir C:\xampp\mysql\share\charsets\
Edit Editcollation connection latin1_swedish_ci
(Session value) utf8mb4_unicode_ci
Edit Editcollation database latin1_swedish_ci
Edit Editcollation server latin1_swedish_ci
Edit Editcompletion type NO_CHAIN
Edit Editconcurrent insert AUTO
Edit Editconnect timeout 10
Edit Editdatadir C:\xampp\mysql\data\
Edit Editdate format %Y-%m-%d
Edit Editdatetime format %Y-%m-%d %H:%i:%s
Edit Editdeadlock search depth long 15
Edit Editdeadlock search depth short 4
Edit Editdeadlock timeout long 50,000,000
Edit Editdeadlock timeout short 10,000
Edit Editdebug no thread alarm OFF
Edit Editdefault regex flags 
Edit Editdefault storage engine InnoDB
Edit Editdefault tmp storage engine 
Edit Editdefault week format 0
Edit Editdelay key write ON
Edit Editdelayed insert limit 100
Edit Editdelayed insert timeout 300
Edit Editdelayed queue size 1,000
Edit Editdiv precision increment 4
Edit Editencrypt binlog OFF
Edit Editencrypt tmp disk tables OFF
Edit Editencrypt tmp files OFF
Edit Editenforce storage engine 
Edit Editevent scheduler OFF
Edit Editexpensive subquery limit 100
Edit Editexpire logs days 0
Edit Editexplicit defaults for timestamp OFF
Edit Editextra max connections 1
Edit Editextra port 0
Edit Editflush OFF
Edit Editflush time 0
Edit Editforeign key checks ON
Edit Editft boolean syntax + -><()~*:""&|
Edit Editft max word len 84
Edit Editft min word len 4
Edit Editft query expansion limit 20
Edit Editft stopword file (built-in)
Edit Editgeneral log OFF
Edit Editgeneral log file SERVERUTAMA.log
Edit Editgroup concat max len 1,024
Edit Editgtid binlog pos 
Edit Editgtid binlog state 
Edit Editgtid current pos 
Edit Editgtid domain id 0
Edit Editgtid ignore duplicates OFF
Edit Editgtid slave pos 
Edit Editgtid strict mode OFF
Edit Edithave compress YES
Edit Edithave crypt NO
Edit Edithave dynamic loading YES
Edit Edithave geometry YES
Edit Edithave openssl NO
Edit Edithave profiling YES
Edit Edithave query cache YES
Edit Edithave rtree keys YES
Edit Edithave ssl DISABLED
Edit Edithave symlink NO
Edit Edithistogram size 0
Edit Edithistogram type SINGLE_PREC_HB
Edit Edithost cache size 279
Edit Edithostname SERVERUTAMA
Edit Editignore builtin innodb OFF
Edit Editignore db dirs 
Edit Editinit connect 
Edit Editinit file 
Edit Editinit slave 
Edit Editinnodb adaptive flushing ON
Edit Editinnodb adaptive flushing lwm 10
Edit Editinnodb adaptive hash index ON
Edit Editinnodb adaptive hash index partitions 1
Edit Editinnodb adaptive max sleep delay 150,000
Edit Editinnodb additional mem pool size 2 MiB
Edit Editinnodb api bk commit interval 5
Edit Editinnodb api disable rowlock OFF
Edit Editinnodb api enable binlog OFF
Edit Editinnodb api enable mdl OFF
Edit Editinnodb api trx level 0
Edit Editinnodb autoextend increment 64
Edit Editinnodb autoinc lock mode 1
Edit Editinnodb background scrub data check interval 3,600
Edit Editinnodb background scrub data compressed OFF
Edit Editinnodb background scrub data interval 604,800
Edit Editinnodb background scrub data uncompressed OFF
Edit Editinnodb buf dump status frequency 0
Edit Editinnodb buffer pool dump at shutdown OFF
Edit Editinnodb buffer pool dump now OFF
Edit Editinnodb buffer pool dump pct 100
Edit Editinnodb buffer pool filename ib_buffer_pool
Edit Editinnodb buffer pool instances 8
Edit Editinnodb buffer pool load abort OFF
Edit Editinnodb buffer pool load at startup OFF
Edit Editinnodb buffer pool load now OFF
Edit Editinnodb buffer pool populate OFF
Edit Editinnodb buffer pool size 16 MiB
Edit Editinnodb change buffer max size 25
Edit Editinnodb change buffering all
Edit Editinnodb checksum algorithm INNODB
Edit Editinnodb checksums ON
Edit Editinnodb cleaner lsn age factor HIGH_CHECKPOINT
Edit Editinnodb cmp per index enabled OFF
Edit Editinnodb commit concurrency 0
Edit Editinnodb compression algorithm none
Edit Editinnodb compression failure threshold pct 5
Edit Editinnodb compression level 6
Edit Editinnodb compression pad pct max 50
Edit Editinnodb concurrency tickets 5,000
Edit Editinnodb corrupt table action assert
Edit Editinnodb data file path ibdata1:10M:autoextend
Edit Editinnodb data home dir C:\xampp\mysql\data
Edit Editinnodb default encryption key id 1
Edit Editinnodb defragment OFF
Edit Editinnodb defragment fill factor 1
Edit Editinnodb defragment fill factor n recs 20
Edit Editinnodb defragment frequency 40
Edit Editinnodb defragment n pages 7
Edit Editinnodb defragment stats accuracy 0
Edit Editinnodb disable sort file cache OFF
Edit Editinnodb doublewrite ON
Edit Editinnodb empty free list algorithm BACKOFF
Edit Editinnodb encrypt log OFF
Edit Editinnodb encrypt tables OFF
Edit Editinnodb encryption rotate key age 1
Edit Editinnodb encryption rotation iops 100
Edit Editinnodb encryption threads 0
Edit Editinnodb fake changes OFF
Edit Editinnodb fast shutdown 1
Edit Editinnodb fatal semaphore wait threshold 600
Edit Editinnodb file format Antelope
Edit Editinnodb file format check ON
Edit Editinnodb file format max Antelope
Edit Editinnodb file per table ON
Edit Editinnodb flush log at timeout 1
Edit Editinnodb flush log at trx commit 1
Edit Editinnodb flush method 
Edit Editinnodb flush neighbors 1
Edit Editinnodb flushing avg loops 30
Edit Editinnodb force load corrupted OFF
Edit Editinnodb force primary key OFF
Edit Editinnodb force recovery 0
Edit Editinnodb foreground preflush EXPONENTIAL_BACKOFF
Edit Editinnodb ft aux table 
Edit Editinnodb ft cache size 8,000,000
Edit Editinnodb ft enable diag print OFF
Edit Editinnodb ft enable stopword ON
Edit Editinnodb ft max token size 84
Edit Editinnodb ft min token size 3
Edit Editinnodb ft num word optimize 2,000
Edit Editinnodb ft result cache limit 2,000,000,000
Edit Editinnodb ft server stopword table 
Edit Editinnodb ft sort pll degree 2
Edit Editinnodb ft total cache size 640,000,000
Edit Editinnodb ft user stopword table 
Edit Editinnodb idle flush pct 100
Edit Editinnodb immediate scrub data uncompressed OFF
Edit Editinnodb instrument semaphores OFF
Edit Editinnodb io capacity 200
Edit Editinnodb io capacity max 2,000
Edit Editinnodb kill idle transaction 0
Edit Editinnodb large prefix OFF
Edit Editinnodb lock wait timeout 50
Edit Editinnodb locking fake changes ON
Edit Editinnodb locks unsafe for binlog OFF
Edit Editinnodb log arch dir C:\xampp\mysql\data
Edit Editinnodb log arch expire sec 0
Edit Editinnodb log archive OFF
Edit Editinnodb log block size 512
Edit Editinnodb log buffer size 8 MiB
Edit Editinnodb log checksum algorithm INNODB
Edit Editinnodb log compressed pages OFF
Edit Editinnodb log file size 5 MiB
Edit Editinnodb log files in group 2
Edit Editinnodb log group home dir C:\xampp\mysql\data
Edit Editinnodb lru scan depth 1,024
Edit Editinnodb max bitmap file size 104,857,600
Edit Editinnodb max changed pages 1,000,000
Edit Editinnodb max dirty pages pct 75
Edit Editinnodb max dirty pages pct lwm  <1
Edit Editinnodb max purge lag 0
Edit Editinnodb max purge lag delay 0
Edit Editinnodb mirrored log groups 1
Edit Editinnodb monitor disable 
Edit Editinnodb monitor enable 
Edit Editinnodb monitor reset 
Edit Editinnodb monitor reset all 
Edit Editinnodb mtflush threads 8
Edit Editinnodb old blocks pct 37
Edit Editinnodb old blocks time 1,000
Edit Editinnodb online alter log max size 134,217,728
Edit Editinnodb open files 2,000
Edit Editinnodb optimize fulltext only OFF
Edit Editinnodb page size 16,384
Edit Editinnodb prefix index cluster optimization OFF
Edit Editinnodb print all deadlocks OFF
Edit Editinnodb purge batch size 300
Edit Editinnodb purge threads 1
Edit Editinnodb random read ahead OFF
Edit Editinnodb read ahead threshold 56
Edit Editinnodb read io threads 4
Edit Editinnodb read only OFF
Edit Editinnodb replication delay 0
Edit Editinnodb rollback on timeout OFF
Edit Editinnodb rollback segments 128
Edit Editinnodb scrub log OFF
Edit Editinnodb scrub log speed 256
Edit Editinnodb show locks held 10
Edit Editinnodb show verbose locks 0
Edit Editinnodb simulate comp failures 0
Edit Editinnodb sort buffer size 1,048,576
Edit Editinnodb spin wait delay 6
Edit Editinnodb stats auto recalc ON
Edit Editinnodb stats method nulls_equal
Edit Editinnodb stats modified counter 0
Edit Editinnodb stats on metadata OFF
Edit Editinnodb stats persistent ON
Edit Editinnodb stats persistent sample pages 20
Edit Editinnodb stats sample pages 8
Edit Editinnodb stats traditional ON
Edit Editinnodb stats transient sample pages 8
Edit Editinnodb status output OFF
Edit Editinnodb status output locks OFF
Edit Editinnodb strict mode OFF
Edit Editinnodb support xa ON
Edit Editinnodb sync array size 1
Edit Editinnodb sync spin loops 30
Edit Editinnodb table locks ON
Edit Editinnodb thread concurrency 0
Edit Editinnodb thread sleep delay 10,000
Edit Editinnodb track changed pages OFF
Edit Editinnodb undo directory .
Edit Editinnodb undo logs 128
Edit Editinnodb undo tablespaces 0
Edit Editinnodb use atomic writes OFF
Edit Editinnodb use fallocate OFF
Edit Editinnodb use global flush log