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 | 32 KiB |
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 | 32 KiB |
Edit | bulk insert buffer size | 8 MiB |
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 | SERVERUTAMA.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 | SERVERUTAMA |
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 | 2 MiB |
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 | 16 MiB |
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 | BACKOFF |
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 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 | 8 MiB |
Edit | innodb log checksum algorithm | INNODB |
Edit | innodb log compressed pages | OFF |
Edit | innodb log file size | 5 MiB |
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 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 |