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