Press Ctrl+Enter to execute queryPress Enter to execute query
Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: mysql Queried time: During current session
SELECT * FROM `user`
Server variables and settings

| Action | Variable | Session value / Global value |
Edit
|
aria block size | 8,192 |
Edit
|
aria checkpoint interval | 30 |
Edit
|
aria checkpoint log activity | 1,048,576 |
Edit
|
aria encrypt tables | OFF |
Edit
|
aria force start after recovery failures | 0 |
Edit
|
aria group commit | none |
Edit
|
aria group commit interval | 0 |
Edit
|
aria log file size | 1,073,741,824 |
Edit
|
aria log purge type | immediate |
Edit
|
aria max sort file size | 9,223,372,036,853,727,232 |
Edit
|
aria page checksum | ON |
Edit
|
aria pagecache age threshold | 300 |
Edit
|
aria pagecache buffer size | 134,217,728 |
Edit
|
aria pagecache division limit | 100 |
Edit
|
aria pagecache file hash size | 512 |
Edit
|
aria recover | NORMAL |
Edit
|
aria repair threads | 1 |
Edit
|
aria sort buffer size | 268,434,432 |
Edit
|
aria stats method | nulls_unequal |
Edit
|
aria sync log dir | NEWFILE |
Edit
|
aria used for temp tables | ON |
Edit
|
auto increment increment | 1 |
Edit
|
auto increment offset | 1 |
Edit
|
autocommit | ON |
Edit
|
automatic sp privileges | ON |
Edit
|
back log | 80 |
Edit
|
basedir | C:/xampp/mysql |
Edit
|
big tables | OFF |
Edit
|
binlog annotate row events | OFF |
Edit
|
binlog cache size | <abbr title="32,768">32 KiB</abbr> |
Edit
|
binlog checksum | NONE |
Edit
|
binlog commit wait count | 0 |
Edit
|
binlog commit wait usec | 100,000 |
Edit
|
binlog direct non transactional updates | OFF |
Edit
|
binlog format | STATEMENT |
Edit
|
binlog optimize thread scheduling | ON |
Edit
|
binlog row image | FULL |
Edit
|
binlog stmt cache size | <abbr title="32,768">32 KiB</abbr> |
Edit
|
bulk insert buffer size | <abbr title="8,388,608">8 MiB</abbr> |
Edit
|
character set client | latin1 |
| (Session value ) | utf8mb4 | |
Edit
|
character set connection | latin1 |
| (Session value ) | utf8mb4 | |
Edit
|
character set database | latin1 |
Edit
|
character set filesystem | binary |
Edit
|
character set results | latin1 |
| (Session value ) | utf8mb4 | |
Edit
|
character set server | latin1 |
Edit
|
character set system | utf8 |
Edit
|
character sets dir | C:\xampp\mysql\share\charsets\ |
Edit
|
collation connection | latin1_swedish_ci |
| (Session value ) | utf8mb4_unicode_ci | |
Edit
|
collation database | latin1_swedish_ci |
Edit
|
collation server | latin1_swedish_ci |
Edit
|
completion type | NO_CHAIN |
Edit
|
concurrent insert | AUTO |
Edit
|
connect timeout | 10 |
Edit
|
datadir | C:\xampp\mysql\data\ |
Edit
|
date format | %Y-%m-%d |
Edit
|
datetime format | %Y-%m-%d %H:%i:%s |
Edit
|
deadlock search depth long | 15 |
Edit
|
deadlock search depth short | 4 |
Edit
|
deadlock timeout long | 50,000,000 |
Edit
|
deadlock timeout short | 10,000 |
Edit
|
debug no thread alarm | OFF |
Edit
|
default regex flags | |
Edit
|
default storage engine | InnoDB |
Edit
|
default tmp storage engine | |
Edit
|
default week format | 0 |
Edit
|
delay key write | ON |
Edit
|
delayed insert limit | 100 |
Edit
|
delayed insert timeout | 300 |
Edit
|
delayed queue size | 1,000 |
Edit
|
div precision increment | 4 |
Edit
|
encrypt binlog | OFF |
Edit
|
encrypt tmp disk tables | OFF |
Edit
|
encrypt tmp files | OFF |
Edit
|
enforce storage engine | |
Edit
|
event scheduler | OFF |
Edit
|
expensive subquery limit | 100 |
Edit
|
expire logs days | 0 |
Edit
|
explicit defaults for timestamp | OFF |
Edit
|
extra max connections | 1 |
Edit
|
extra port | 0 |
Edit
|
flush | OFF |
Edit
|
flush time | 0 |
Edit
|
foreign key checks | ON |
Edit
|
ft boolean syntax | + -><()~*:""&| |
Edit
|
ft max word len | 84 |
Edit
|
ft min word len | 4 |
Edit
|
ft query expansion limit | 20 |
Edit
|
ft stopword file | (built-in) |
Edit
|
general log | OFF |
Edit
|
general log file | SCCBBKSV02.log |
Edit
|
group concat max len | 1,024 |
Edit
|
gtid binlog pos | |
Edit
|
gtid binlog state | |
Edit
|
gtid current pos | |
Edit
|
gtid domain id | 0 |
Edit
|
gtid ignore duplicates | OFF |
Edit
|
gtid slave pos | |
Edit
|
gtid strict mode | OFF |
Edit
|
have compress | YES |
Edit
|
have crypt | NO |
Edit
|
have dynamic loading | YES |
Edit
|
have geometry | YES |
Edit
|
have openssl | NO |
Edit
|
have profiling | YES |
Edit
|
have query cache | YES |
Edit
|
have rtree keys | YES |
Edit
|
have ssl | DISABLED |
Edit
|
have symlink | NO |
Edit
|
histogram size | 0 |
Edit
|
histogram type | SINGLE_PREC_HB |
Edit
|
host cache size | 279 |
Edit
|
hostname | SCCBBKSV02 |
Edit
|
ignore builtin innodb | OFF |
Edit
|
ignore db dirs | |
Edit
|
init connect | |
Edit
|
init file | |
Edit
|
init slave | |
Edit
|
innodb adaptive flushing | ON |
Edit
|
innodb adaptive flushing lwm | 10 |
Edit
|
innodb adaptive hash index | ON |
Edit
|
innodb adaptive hash index partitions | 1 |
Edit
|
innodb adaptive max sleep delay | 150,000 |
Edit
|
innodb additional mem pool size | <abbr title="2,097,152">2 MiB</abbr> |
Edit
|
innodb api bk commit interval | 5 |
Edit
|
innodb api disable rowlock | OFF |
Edit
|
innodb api enable binlog | OFF |
Edit
|
innodb api enable mdl | OFF |
Edit
|
innodb api trx level | 0 |
Edit
|
innodb autoextend increment | 64 |
Edit
|
innodb autoinc lock mode | 1 |
Edit
|
innodb background scrub data check interval | 3,600 |
Edit
|
innodb background scrub data compressed | OFF |
Edit
|
innodb background scrub data interval | 604,800 |
Edit
|
innodb background scrub data uncompressed | OFF |
Edit
|
innodb buf dump status frequency | 0 |
Edit
|
innodb buffer pool dump at shutdown | OFF |
Edit
|
innodb buffer pool dump now | OFF |
Edit
|
innodb buffer pool dump pct | 100 |
Edit
|
innodb buffer pool filename | ib_buffer_pool |
Edit
|
innodb buffer pool instances | 8 |
Edit
|
innodb buffer pool load abort | OFF |
Edit
|
innodb buffer pool load at startup | OFF |
Edit
|
innodb buffer pool load now | OFF |
Edit
|
innodb buffer pool populate | OFF |
Edit
|
innodb buffer pool size | <abbr title="16,777,216">16 MiB</abbr> |
Edit
|
innodb change buffer max size | 25 |
Edit
|
innodb change buffering | all |
Edit
|
innodb checksum algorithm | INNODB |
Edit
|
innodb checksums | ON |
Edit
|
innodb cleaner lsn age factor | HIGH_CHECKPOINT |
Edit
|
innodb cmp per index enabled | OFF |
Edit
|
innodb commit concurrency | 0 |
Edit
|
innodb compression algorithm | none |
Edit
|
innodb compression failure threshold pct | 5 |
Edit
|
innodb compression level | 6 |
Edit
|
innodb compression pad pct max | 50 |
Edit
|
innodb concurrency tickets | 5,000 |
Edit
|
innodb corrupt table action | assert |
Edit
|
innodb data file path | ibdata1:10M:autoextend |
Edit
|
innodb data home dir | C:\xampp\mysql\data |
Edit
|
innodb default encryption key id | 1 |
Edit
|
innodb defragment | OFF |
Edit
|
innodb defragment fill factor | 1 |
Edit
|
innodb defragment fill factor n recs | 20 |
Edit
|
innodb defragment frequency | 40 |
Edit
|
innodb defragment n pages | 7 |
Edit
|
innodb defragment stats accuracy | 0 |
Edit
|
innodb disable sort file cache | OFF |
Edit
|
innodb doublewrite | ON |
Edit
|
innodb empty free list algorithm | LEGACY |
Edit
|
innodb encrypt log | OFF |
Edit
|
innodb encrypt tables | OFF |
Edit
|
innodb encryption rotate key age | 1 |
Edit
|
innodb encryption rotation iops | 100 |
Edit
|
innodb encryption threads | 0 |
Edit
|
innodb fake changes | OFF |
Edit
|
innodb fast shutdown | 1 |
Edit
|
innodb fatal semaphore wait threshold | 600 |
Edit
|
innodb file format | Antelope |
Edit
|
innodb file format check | ON |
Edit
|
innodb file format max | Antelope |
Edit
|
innodb file per table | ON |
Edit
|
innodb flush log at timeout | 1 |
Edit
|
innodb flush log at trx commit | 1 |
Edit
|
innodb flush method | |
Edit
|
innodb flush neighbors | 1 |
Edit
|
innodb flushing avg loops | 30 |
Edit
|
innodb force load corrupted | OFF |
Edit
|
innodb force primary key | OFF |
Edit
|
innodb force recovery | 0 |
Edit
|
innodb foreground preflush | EXPONENTIAL_BACKOFF |
Edit
|
innodb ft aux table | |
Edit
|
innodb ft cache size | 8,000,000 |
Edit
|
innodb ft enable diag print | OFF |
Edit
|
innodb ft enable stopword | ON |
Edit
|
innodb ft max token size | 84 |
Edit
|
innodb ft min token size | 3 |
Edit
|
innodb ft num word optimize | 2,000 |
Edit
|
innodb ft result cache limit | 2,000,000,000 |
Edit
|
innodb ft server stopword table | |
Edit
|
innodb ft sort pll degree | 2 |
Edit
|
innodb ft total cache size | 640,000,000 |
Edit
|
innodb ft user stopword table | |
Edit
|
innodb idle flush pct | 100 |
Edit
|
innodb immediate scrub data uncompressed | OFF |
Edit
|
innodb instrument semaphores | OFF |
Edit
|
innodb io capacity | 200 |
Edit
|
innodb io capacity max | 2,000 |
Edit
|
innodb kill idle transaction | 0 |
Edit
|
innodb large prefix | OFF |
Edit
|
innodb lock schedule algorithm | fcfs |
Edit
|
innodb lock wait timeout | 50 |
Edit
|
innodb locking fake changes | ON |
Edit
|
innodb locks unsafe for binlog | OFF |
Edit
|
innodb log arch dir | C:\xampp\mysql\data |
Edit
|
innodb log arch expire sec | 0 |
Edit
|
innodb log archive | OFF |
Edit
|
innodb log block size | 512 |
Edit
|
innodb log buffer size | <abbr title="8,388,608">8 MiB</abbr> |
Edit
|
innodb log checksum algorithm | INNODB |
Edit
|
innodb log compressed pages | OFF |
Edit
|
innodb log file size | <abbr title="5,242,880">5 MiB</abbr> |
Edit
|
innodb log files in group | 2 |
Edit
|
innodb log group home dir | C:\xampp\mysql\data |
Edit
|
innodb lru scan depth | 1,024 |
Edit
|
innodb max bitmap file size | 104,857,600 |
Edit
|
innodb max changed pages | 1,000,000 |
Edit
|
innodb max dirty pages pct | 75 |
Edit
|
innodb max dirty pages pct lwm | <1 |
Edit
|
innodb max purge lag | 0 |
Edit
|
innodb max purge lag delay | 0 |
Edit
|
innodb mirrored log groups | 1 |
Edit
|
innodb monitor disable | |
Edit
|
innodb monitor enable | |
Edit
|
innodb monitor reset | |
Edit
|
innodb monitor reset all | |
Edit
|
innodb mtflush threads | 8 |
Edit
|
innodb old blocks pct | 37 |
Edit
|
innodb old blocks time | 1,000 |
Edit
|
innodb online alter log max size | 134,217,728 |
Edit
|
innodb open files | 2,000 |
Edit
|
innodb optimize fulltext only | OFF |
Edit
|
innodb page size | 16,384 |
Edit
|
innodb prefix index cluster optimization | OFF |
Edit
|
innodb print all deadlocks | OFF |
Edit
|
innodb purge batch size | 300 |
Edit
|
innodb purge threads | 1 |
Edit
|
innodb random read ahead | OFF |
Edit
|
innodb read ahead threshold | 56 |
Edit
|
innodb read io threads | 4 |
Edit
|
innodb read only | OFF |
Edit
|
innodb replication delay | 0 |
Edit
|
innodb rollback on timeout | OFF |
Edit
|
innodb rollback segments | 128 |
Edit
|
innodb scrub log | OFF |
Edit
|
innodb scrub log speed | 256 |
Edit
|
innodb show locks held | 10 |
Edit
|
innodb show verbose locks | 0 |
Edit
|
innodb simulate comp failures | 0 |
Edit
|
innodb sort buffer size | 1,048,576 |
Edit
|
innodb spin wait delay | 6 |
Edit
|
innodb stats auto recalc | ON |
Edit
|
innodb stats method | nulls_equal |
Edit
|
innodb stats modified counter | 0 |
Edit
|
innodb stats on metadata | OFF |
Edit
|
innodb stats persistent | ON |
Edit
|
innodb stats persistent sample pages | 20 |
Edit
|
innodb stats sample pages | 8 |
Edit
|
innodb stats traditional | ON |
Edit
|
innodb stats transient sample pages | 8 |
Edit
|
innodb status output | OFF |
Edit
|
innodb status output locks | OFF |
Edit
|
innodb strict mode | OFF |
Edit
|
innodb support xa | ON |
Edit
|
innodb sync array size | 1 |
Edit
|
innodb sync spin loops | 30 |
Edit
|
innodb table locks | ON |
Edit
|
innodb thread concurrency | 0 |
Edit
|
innodb thread sleep delay | 10,000 |
Edit
|
innodb tmpdir | |
Edit
|
innodb track changed pages | OFF |
Edit
|
innodb undo directory | . |
Edit
|
innodb undo logs | 128 |
Edit
|
innodb undo tablespaces | 0 |
Edit
|
innodb use atomic writes | OFF |
Edit
|
innodb use fallocate | OFF |
Edit
|
innodb use global flush log at trx commit | ON |
Edit
|
innodb use mtflush | OFF |
Edit
|
innodb use native aio | ON |
Edit
|
innodb use stacktrace | OFF |
Edit
|
innodb use sys malloc | ON |
Edit
|
innodb use trim | OFF |
Edit
|
innodb version | 5.6.34-79.1 |
Edit
|
innodb write io threads | 4 |
Edit
|
interactive timeout | 28,800 |
Edit
|
join buffer size | <abbr title="262,144">256 KiB</abbr> |
Edit
|
join buffer space limit | 2,097,152 |
Edit
|
join cache level | 2 |
Edit
|
keep files on create | OFF |
Edit
|
key buffer size | <abbr title="16,777,216">16 MiB</abbr> |
Edit
|
key cache age threshold | 300 |
Edit
|
key cache block size | <abbr title="1,024">1 KiB</abbr> |
Edit
|
key cache division limit | 100 |
Edit
|
key cache file hash size | 512 |
Edit
|
key cache segments | 0 |
Edit
|
large files support | ON |
Edit
|
large page size | <abbr title="0">0 B</abbr> |
Edit
|
large pages | OFF |
Edit
|
lc messages | en_US |
Edit
|
lc messages dir | |
Edit
|
lc time names | en_US |
Edit
|
license | GPL |
Edit
|
local infile | ON |
Edit
|
lock wait timeout | 31,536,000 |
Edit
|
log bin | OFF |
Edit
|
log bin basename | |
Edit
|
log bin index | |
Edit
|
log bin trust function creators | OFF |
Edit
|
log error | .\mysql_error.log |
Edit
|
log output | FILE |
Edit
|
log queries not using indexes | OFF |
Edit
|
log slave updates | OFF |
Edit
|
log slow admin statements | OFF |
Edit
|
log slow filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
Edit
|
log slow rate limit | 1 |
Edit
|
log slow slave statements | OFF |
Edit
|
log slow verbosity | |
Edit
|
log tc size | 24,576 |
Edit
|
log warnings | 1 |
Edit
|
long query time | 10 |
Edit
|
low priority updates | OFF |
Edit
|
lower case file system | ON |
Edit
|
lower case table names | 1 |
Edit
|
master verify checksum | OFF |
Edit
|
max allowed packet | 1,048,576 |
Edit
|
max binlog cache size | <abbr title="4,294,963,200">4 GiB</abbr> |
Edit
|
max binlog size | <abbr title="1,073,741,824">1 GiB</abbr> |
Edit
|
max binlog stmt cache size | <abbr title="4,294,963,200">4 GiB</abbr> |
Edit
|
max connect errors | 100 |
Edit
|
max connections | 151 |
Edit
|
max delayed threads | 20 |
Edit
|
max digest length | 1,024 |
Edit
|
max error count | 64 |
Edit
|
max heap table size | <abbr title="16,777,216">16 MiB</abbr> |
Edit
|
max insert delayed threads | 20 |
Edit
|
max join size | 18,446,744,073,709,551,616 |
Edit
|
max length for sort data | 1,024 |
Edit
|
max long data size | 1,048,576 |
Edit
|
max prepared stmt count | 16,382 |
Edit
|
max relay log size | <abbr title="1,073,741,824">1 GiB</abbr> |
Edit
|
max seeks for key | 4,294,967,295 |
Edit
|
max session mem used | 9,223,372,036,854,775,808 |
Edit
|
max sort length | 1,024 |
Edit
|
max sp recursion depth | 0 |
Edit
|
max statement time | 0 |
Edit
|
max tmp tables | 32 |
Edit
|
max user connections | 0 |
Edit
|
max write lock count | 4,294,967,295 |
Edit
|
metadata locks cache size | 1,024 |
Edit
|
metadata locks hash instances | 8 |
Edit
|
min examined row limit | 0 |
Edit
|
mrr buffer size | 262,144 |
Edit
|
multi range count | 256 |
Edit
|
myisam block size | 1,024 |
Edit
|
myisam data pointer size | <abbr title="6">6 B</abbr> |
Edit
|
myisam max sort file size | <abbr title="2,146,435,072">1.999 GiB</abbr> |
Edit
|
myisam mmap size | <abbr title="4,294,967,295">4 GiB</abbr> |
Edit
|
myisam recover options | DEFAULT |
Edit
|
myisam repair threads | 1 |
Edit
|
myisam sort buffer size | <abbr title="8,388,608">8 MiB</abbr> |
Edit
|
myisam stats method | NULLS_UNEQUAL |
Edit
|
myisam use mmap | OFF |
Edit
|
mysql56 temporal format | ON |
Edit
|
named pipe | OFF |
Edit
|
net buffer length | 8,192 |
Edit
|
net read timeout | 30 |
Edit
|
net retry count | 10 |
Edit
|
net write timeout | 60 |
Edit
|
old | OFF |
Edit
|
old alter table | OFF |
Edit
|
old mode | |
Edit
|
old passwords | OFF |
Edit
|
open files limit | 6,210 |
Edit
|
optimizer prune level | 1 |
Edit
|
optimizer search depth | 62 |
Edit
|
optimizer selectivity sampling limit | 100 |
Edit
|
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 |
Edit
|
optimizer use condition selectivity | 1 |
Edit
|
performance schema | OFF |
Edit
|
performance schema accounts size | -1 |
Edit
|
performance schema digests size | -1 |
Edit
|
performance schema events stages history long size | -1 |
Edit
|
performance schema events stages history size | -1 |
Edit
|
performance schema events statements history long size | -1 |
Edit
|
performance schema events statements history size | -1 |
Edit
|
performance schema events waits history long size | -1 |
Edit
|
performance schema events waits history size | -1 |
Edit
|
performance schema hosts size | -1 |
Edit
|
performance schema max cond classes | 80 |
Edit
|
performance schema max cond instances | -1 |
Edit
|
performance schema max digest length | 1,024 |
Edit
|
performance schema max file classes | 50 |
Edit
|
performance schema max file handles | 32,768 |
Edit
|
performance schema max file instances | -1 |
Edit
|
performance schema max mutex classes | 200 |
Edit
|
performance schema max mutex instances | -1 |
Edit
|
performance schema max rwlock classes | 40 |
Edit
|
performance schema max rwlock instances | -1 |
Edit
|
performance schema max socket classes | 10 |
Edit
|
performance schema max socket instances | -1 |
Edit
|
performance schema max stage classes | 150 |
Edit
|
performance schema max statement classes | 178 |
Edit
|
performance schema max table handles | -1 |
Edit
|
performance schema max table instances | -1 |
Edit
|
performance schema max thread classes | 50 |
Edit
|
performance schema max thread instances | -1 |
Edit
|
performance schema session connect attrs size | -1 |
Edit
|
performance schema setup actors size | 100 |
Edit
|
performance schema setup objects size | 100 |
Edit
|
performance schema users size | -1 |
Edit
|
pid file | C:\xampp\mysql\data\mysql.pid |
Edit
|
plugin dir | C:\xampp\mysql\lib\plugin\ |
Edit
|
plugin maturity | unknown |
Edit
|
port | 3,306 |
Edit
|
preload buffer size | <abbr title="32,768">32 KiB</abbr> |
Edit
|
profiling | OFF |
Edit
|
profiling history size | 15 |
Edit
|
progress report time | 5 |
Edit
|
protocol version | 10 |
Edit
|
query alloc block size | <abbr title="16,384">16 KiB</abbr> |
Edit
|
query cache limit | <abbr title="1,048,576">1 MiB</abbr> |
Edit
|
query cache min res unit | 4,096 |
Edit
|
query cache size | <abbr title="1,048,576">1 MiB</abbr> |
Edit
|
query cache strip comments | OFF |
Edit
|
query cache type | OFF |
Edit
|
query cache wlock invalidate | OFF |
Edit
|
query prealloc size | <abbr title="24,576">24 KiB</abbr> |
Edit
|
range alloc block size | <abbr title="4,096">4 KiB</abbr> |
Edit
|
read buffer size | <abbr title="262,144">256 KiB</abbr> |
Edit
|
read only | OFF |
Edit
|
read rnd buffer size | <abbr title="524,288">512 KiB</abbr> |
Edit
|
relay log | |
Edit
|
relay log basename | |
Edit
|
relay log index | |
Edit
|
relay log info file | relay-log.info |
Edit
|
relay log purge | ON |
Edit
|
relay log recovery | OFF |
Edit
|
relay log space limit | 0 |
Edit
|
replicate annotate row events | OFF |
Edit
|
replicate do db | |
Edit
|
replicate do table | |
Edit
|
replicate events marked for skip | REPLICATE |
Edit
|
replicate ignore db | |
Edit
|
replicate ignore table | |
Edit
|
replicate wild do table | |
Edit
|
replicate wild ignore table | |
Edit
|
report host | |
Edit
|
report password | |
Edit
|
report port | 3,306 |
Edit
|
report user | |
Edit
|
rowid merge buff size | 8,388,608 |
Edit
|
secure auth | ON |
Edit
|
secure file priv | |
Edit
|
server id | 1 |
Edit
|
shared memory | OFF |
Edit
|
shared memory base name | MYSQL |
Edit
|
skip external locking | ON |
Edit
|
skip name resolve | OFF |
Edit
|
skip networking | OFF |
Edit
|
skip show database | OFF |
Edit
|
slave compressed protocol | OFF |
Edit
|
slave ddl exec mode | IDEMPOTENT |
Edit
|
slave domain parallel threads | 0 |
Edit
|
slave exec mode | STRICT |
Edit
|
slave load tmpdir | C:\xampp\tmp |
Edit
|
slave max allowed packet | 1,073,741,824 |
Edit
|
slave net timeout | 3,600 |
Edit
|
slave parallel max queued | 131,072 |
Edit
|
slave parallel mode | conservative |
Edit
|
slave parallel threads | 0 |
Edit
|
slave run triggers for rbr | NO |
Edit
|
slave skip errors | OFF |
Edit
|
slave sql verify checksum | ON |
Edit
|
slave transaction retries | 10 |
Edit
|
slave type conversions | |
Edit
|
slow launch time | 2 |
Edit
|
slow query log | OFF |
Edit
|
slow query log file | SCCBBKSV02-slow.log |
Edit
|
socket | C:/xampp/mysql/mysql.sock |
Edit
|
sort buffer size | <abbr title="524,288">512 KiB</abbr> |
Edit
|
sql auto is null | OFF |
Edit
|
sql big selects | ON |
Edit
|
sql buffer result | OFF |
Edit
|
sql log bin | ON |
Edit
|
sql log off | OFF |
Edit
|
sql mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
Edit
|
sql notes | ON |
Edit
|
sql quote show create | ON |
Edit
|
sql safe updates | OFF |
Edit
|
sql select limit | 18,446,744,073,709,551,616 |
Edit
|
sql slave skip counter | 0 |
Edit
|
sql warnings | OFF |
Edit
|
ssl ca | |
Edit
|
ssl capath | |
Edit
|
ssl cert | |
Edit
|
ssl cipher | |
Edit
|
ssl crl | |
Edit
|
ssl crlpath | |
Edit
|
ssl key | |
Edit
|
storage engine | InnoDB |
Edit
|
stored program cache | 256 |
Edit
|
strict password validation | ON |
Edit
|
sync binlog | 0 |
Edit
|
sync frm | ON |
Edit
|
sync master info | 10,000 |
Edit
|
sync relay log | 10,000 |
Edit
|
sync relay log info | 10,000 |
Edit
|
system time zone | SE Asia Standard Time |
Edit
|
table definition cache | 400 |
Edit
|
table open cache | 2,000 |
Edit
|
thread cache size | 0 |
Edit
|
thread concurrency | 10 |
Edit
|
thread handling | pool-of-threads |
Edit
|
thread pool max threads | 1,000 |
Edit
|
thread pool min threads | 1 |
Edit
|
thread stack | 295,936 |
Edit
|
time format | %H:%i:%s |
Edit
|
time zone | SYSTEM |
Edit
|
timed mutexes | OFF |
Edit
|
tmp table size | <abbr title="16,777,216">16 MiB</abbr> |
Edit
|
tmpdir | C:/xampp/tmp |
Edit
|
transaction alloc block size | <abbr title="8,192">8 KiB</abbr> |
Edit
|
transaction prealloc size | <abbr title="4,096">4 KiB</abbr> |
Edit
|
tx isolation | REPEATABLE-READ |
Edit
|
tx read only | OFF |
Edit
|
unique checks | ON |
Edit
|
updatable views with limit | YES |
Edit
|
use stat tables | NEVER |
Edit
|
userstat | OFF |
Edit
|
version | 10.1.21-MariaDB |
Edit
|
version comment | mariadb.org binary distribution |
Edit
|
version compile machine | 32 |
Edit
|
version compile os | Win32 |
Edit
|
version malloc library | system |
Edit
|
version ssl library | YaSSL 2.4.2 |
Edit
|
wait timeout | 28,800 |
session_regenerate_id(): Session object destruction failed