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![Documentation Documentation](themes/dot.gif) | 1 |
Edit | auto increment offset![Documentation Documentation](themes/dot.gif) | 1 |
Edit | autocommit![Documentation Documentation](themes/dot.gif) | ON |
Edit | automatic sp privileges![Documentation Documentation](themes/dot.gif) | ON |
Edit | back log![Documentation Documentation](themes/dot.gif) | 80 |
Edit | basedir![Documentation Documentation](themes/dot.gif) | /opt/lampp |
Edit | big tables![Documentation Documentation](themes/dot.gif) | OFF |
Edit | binlog annotate row events | OFF |
Edit | binlog cache size![Documentation Documentation](themes/dot.gif) | 32 KiB |
Edit | binlog checksum![Documentation Documentation](themes/dot.gif) | NONE |
Edit | binlog commit wait count | 0 |
Edit | binlog commit wait usec | 100,000 |
Edit | binlog direct non transactional updates![Documentation Documentation](themes/dot.gif) | OFF |
Edit | binlog format![Documentation Documentation](themes/dot.gif) | STATEMENT |
Edit | binlog optimize thread scheduling | ON |
Edit | binlog row image![Documentation Documentation](themes/dot.gif) | FULL |
Edit | binlog stmt cache size![Documentation Documentation](themes/dot.gif) | 32 KiB |
Edit | bulk insert buffer size![Documentation Documentation](themes/dot.gif) | 8 MiB |
Edit | character set client![Documentation Documentation](themes/dot.gif) | latin1 |
| (Session value) | utf8mb4 |
Edit | character set connection![Documentation Documentation](themes/dot.gif) | latin1 |
| (Session value) | utf8mb4 |
Edit | character set database![Documentation Documentation](themes/dot.gif) | latin1 |
Edit | character set filesystem![Documentation Documentation](themes/dot.gif) | binary |
Edit | character set results![Documentation Documentation](themes/dot.gif) | latin1 |
| (Session value) | utf8mb4 |
Edit | character set server![Documentation Documentation](themes/dot.gif) | latin1 |
Edit | character set system![Documentation Documentation](themes/dot.gif) | utf8 |
Edit | character sets dir![Documentation Documentation](themes/dot.gif) | /opt/lampp/share/charsets/ |
Edit | collation connection![Documentation Documentation](themes/dot.gif) | latin1_swedish_ci |
| (Session value) | utf8mb4_general_ci |
Edit | collation database![Documentation Documentation](themes/dot.gif) | latin1_swedish_ci |
Edit | collation server![Documentation Documentation](themes/dot.gif) | latin1_swedish_ci |
Edit | completion type![Documentation Documentation](themes/dot.gif) | NO_CHAIN |
Edit | concurrent insert![Documentation Documentation](themes/dot.gif) | AUTO |
Edit | connect timeout![Documentation Documentation](themes/dot.gif) | 10 |
Edit | datadir![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/ |
Edit | date format![Documentation Documentation](themes/dot.gif) | %Y-%m-%d |
Edit | datetime format![Documentation Documentation](themes/dot.gif) | %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![Documentation Documentation](themes/dot.gif) | InnoDB |
Edit | default tmp storage engine![Documentation Documentation](themes/dot.gif) | |
Edit | default week format![Documentation Documentation](themes/dot.gif) | 0 |
Edit | delay key write![Documentation Documentation](themes/dot.gif) | ON |
Edit | delayed insert limit![Documentation Documentation](themes/dot.gif) | 100 |
Edit | delayed insert timeout![Documentation Documentation](themes/dot.gif) | 300 |
Edit | delayed queue size![Documentation Documentation](themes/dot.gif) | 1,000 |
Edit | div precision increment![Documentation Documentation](themes/dot.gif) | 4 |
Edit | encrypt binlog | OFF |
Edit | encrypt tmp disk tables | OFF |
Edit | encrypt tmp files | OFF |
Edit | enforce storage engine | |
Edit | event scheduler![Documentation Documentation](themes/dot.gif) | OFF |
Edit | expensive subquery limit | 100 |
Edit | expire logs days![Documentation Documentation](themes/dot.gif) | 0 |
Edit | explicit defaults for timestamp![Documentation Documentation](themes/dot.gif) | OFF |
Edit | extra max connections | 1 |
Edit | extra port | 0 |
Edit | flush![Documentation Documentation](themes/dot.gif) | OFF |
Edit | flush time![Documentation Documentation](themes/dot.gif) | 0 |
Edit | foreign key checks![Documentation Documentation](themes/dot.gif) | ON |
Edit | ft boolean syntax![Documentation Documentation](themes/dot.gif) | + -><()~*:""&| |
Edit | ft max word len![Documentation Documentation](themes/dot.gif) | 84 |
Edit | ft min word len![Documentation Documentation](themes/dot.gif) | 4 |
Edit | ft query expansion limit![Documentation Documentation](themes/dot.gif) | 20 |
Edit | ft stopword file![Documentation Documentation](themes/dot.gif) | (built-in) |
Edit | general log![Documentation Documentation](themes/dot.gif) | OFF |
Edit | general log file![Documentation Documentation](themes/dot.gif) | ubuntu-s-1vcpu-2gb-blr1-01.log |
Edit | group concat max len![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | YES |
Edit | have crypt![Documentation Documentation](themes/dot.gif) | YES |
Edit | have dynamic loading![Documentation Documentation](themes/dot.gif) | YES |
Edit | have geometry![Documentation Documentation](themes/dot.gif) | YES |
Edit | have openssl![Documentation Documentation](themes/dot.gif) | YES |
Edit | have profiling![Documentation Documentation](themes/dot.gif) | YES |
Edit | have query cache![Documentation Documentation](themes/dot.gif) | YES |
Edit | have rtree keys![Documentation Documentation](themes/dot.gif) | YES |
Edit | have ssl![Documentation Documentation](themes/dot.gif) | DISABLED |
Edit | have symlink![Documentation Documentation](themes/dot.gif) | YES |
Edit | histogram size | 0 |
Edit | histogram type | SINGLE_PREC_HB |
Edit | host cache size![Documentation Documentation](themes/dot.gif) | 279 |
Edit | hostname![Documentation Documentation](themes/dot.gif) | ubuntu-s-1vcpu-2gb-blr1-01 |
Edit | ignore builtin innodb![Documentation Documentation](themes/dot.gif) | OFF |
Edit | ignore db dirs![Documentation Documentation](themes/dot.gif) | |
Edit | init connect![Documentation Documentation](themes/dot.gif) | |
Edit | init file![Documentation Documentation](themes/dot.gif) | |
Edit | init slave![Documentation Documentation](themes/dot.gif) | |
Edit | innodb adaptive flushing![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb adaptive flushing lwm![Documentation Documentation](themes/dot.gif) | 10 |
Edit | innodb adaptive hash index![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb adaptive hash index partitions | 1 |
Edit | innodb adaptive max sleep delay![Documentation Documentation](themes/dot.gif) | 150,000 |
Edit | innodb additional mem pool size![Documentation Documentation](themes/dot.gif) | 8 MiB |
Edit | innodb api bk commit interval![Documentation Documentation](themes/dot.gif) | 5 |
Edit | innodb api disable rowlock![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb api enable binlog![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb api enable mdl![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb api trx level![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb autoextend increment![Documentation Documentation](themes/dot.gif) | 64 |
Edit | innodb autoinc lock mode![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb buffer pool dump now![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb buffer pool dump pct | 100 |
Edit | innodb buffer pool filename![Documentation Documentation](themes/dot.gif) | ib_buffer_pool |
Edit | innodb buffer pool instances![Documentation Documentation](themes/dot.gif) | 8 |
Edit | innodb buffer pool load abort![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb buffer pool load at startup![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb buffer pool load now![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb buffer pool populate | OFF |
Edit | innodb buffer pool size![Documentation Documentation](themes/dot.gif) | 512 MiB |
Edit | innodb change buffer max size![Documentation Documentation](themes/dot.gif) | 25 |
Edit | innodb change buffering![Documentation Documentation](themes/dot.gif) | all |
Edit | innodb checksum algorithm![Documentation Documentation](themes/dot.gif) | INNODB |
Edit | innodb checksums![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb cleaner lsn age factor | HIGH_CHECKPOINT |
Edit | innodb cmp per index enabled![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb commit concurrency![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb compression algorithm | none |
Edit | innodb compression failure threshold pct![Documentation Documentation](themes/dot.gif) | 5 |
Edit | innodb compression level![Documentation Documentation](themes/dot.gif) | 6 |
Edit | innodb compression pad pct max![Documentation Documentation](themes/dot.gif) | 50 |
Edit | innodb concurrency tickets![Documentation Documentation](themes/dot.gif) | 5,000 |
Edit | innodb corrupt table action | assert |
Edit | innodb data file path![Documentation Documentation](themes/dot.gif) | ibdata1:10M:autoextend |
Edit | innodb data home dir![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/ |
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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb disallow writes | OFF |
Edit | innodb doublewrite![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb fatal semaphore wait threshold | 600 |
Edit | innodb file format![Documentation Documentation](themes/dot.gif) | Antelope |
Edit | innodb file format check![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb file format max![Documentation Documentation](themes/dot.gif) | Antelope |
Edit | innodb file per table![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb flush log at timeout![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb flush log at trx commit![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb flush method![Documentation Documentation](themes/dot.gif) | |
Edit | innodb flush neighbors![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb flushing avg loops![Documentation Documentation](themes/dot.gif) | 30 |
Edit | innodb force load corrupted![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb force primary key | OFF |
Edit | innodb force recovery![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb foreground preflush | EXPONENTIAL_BACKOFF |
Edit | innodb ft aux table![Documentation Documentation](themes/dot.gif) | |
Edit | innodb ft cache size![Documentation Documentation](themes/dot.gif) | 8,000,000 |
Edit | innodb ft enable diag print![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb ft enable stopword![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb ft max token size![Documentation Documentation](themes/dot.gif) | 84 |
Edit | innodb ft min token size![Documentation Documentation](themes/dot.gif) | 3 |
Edit | innodb ft num word optimize![Documentation Documentation](themes/dot.gif) | 2,000 |
Edit | innodb ft result cache limit![Documentation Documentation](themes/dot.gif) | 2,000,000,000 |
Edit | innodb ft server stopword table![Documentation Documentation](themes/dot.gif) | |
Edit | innodb ft sort pll degree![Documentation Documentation](themes/dot.gif) | 2 |
Edit | innodb ft total cache size![Documentation Documentation](themes/dot.gif) | 640,000,000 |
Edit | innodb ft user stopword table![Documentation Documentation](themes/dot.gif) | |
Edit | innodb idle flush pct | 100 |
Edit | innodb immediate scrub data uncompressed | OFF |
Edit | innodb instrument semaphores | OFF |
Edit | innodb io capacity![Documentation Documentation](themes/dot.gif) | 200 |
Edit | innodb io capacity max![Documentation Documentation](themes/dot.gif) | 2,000 |
Edit | innodb kill idle transaction | 0 |
Edit | innodb large prefix![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb lock schedule algorithm | fcfs |
Edit | innodb lock wait timeout![Documentation Documentation](themes/dot.gif) | 50 |
Edit | innodb locking fake changes | ON |
Edit | innodb locks unsafe for binlog![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb log arch dir | /opt/lampp/var/mysql/ |
Edit | innodb log arch expire sec | 0 |
Edit | innodb log archive | OFF |
Edit | innodb log block size | 512 |
Edit | innodb log buffer size![Documentation Documentation](themes/dot.gif) | 8 MiB |
Edit | innodb log checksum algorithm | INNODB |
Edit | innodb log compressed pages![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb log file size![Documentation Documentation](themes/dot.gif) | 5 MiB |
Edit | innodb log files in group![Documentation Documentation](themes/dot.gif) | 2 |
Edit | innodb log group home dir![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/ |
Edit | innodb lru scan depth![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | 75 |
Edit | innodb max dirty pages pct lwm![Documentation Documentation](themes/dot.gif) | <1 |
Edit | innodb max purge lag![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb max purge lag delay![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb mirrored log groups![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb monitor disable![Documentation Documentation](themes/dot.gif) | |
Edit | innodb monitor enable![Documentation Documentation](themes/dot.gif) | |
Edit | innodb monitor reset![Documentation Documentation](themes/dot.gif) | |
Edit | innodb monitor reset all![Documentation Documentation](themes/dot.gif) | |
Edit | innodb mtflush threads | 8 |
Edit | innodb old blocks pct![Documentation Documentation](themes/dot.gif) | 37 |
Edit | innodb old blocks time![Documentation Documentation](themes/dot.gif) | 1,000 |
Edit | innodb online alter log max size![Documentation Documentation](themes/dot.gif) | 134,217,728 |
Edit | innodb open files![Documentation Documentation](themes/dot.gif) | 300 |
Edit | innodb optimize fulltext only![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb page size![Documentation Documentation](themes/dot.gif) | 16,384 |
Edit | innodb prefix index cluster optimization | OFF |
Edit | innodb print all deadlocks![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb purge batch size![Documentation Documentation](themes/dot.gif) | 300 |
Edit | innodb purge threads![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb random read ahead![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb read ahead threshold![Documentation Documentation](themes/dot.gif) | 56 |
Edit | innodb read io threads![Documentation Documentation](themes/dot.gif) | 4 |
Edit | innodb read only![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb replication delay![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb rollback on timeout![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb rollback segments![Documentation Documentation](themes/dot.gif) | 128 |
Edit | innodb sched priority cleaner | 19 |
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![Documentation Documentation](themes/dot.gif) | 1,048,576 |
Edit | innodb spin wait delay![Documentation Documentation](themes/dot.gif) | 6 |
Edit | innodb stats auto recalc![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb stats method![Documentation Documentation](themes/dot.gif) | nulls_equal |
Edit | innodb stats modified counter | 0 |
Edit | innodb stats on metadata![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb stats persistent![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb stats persistent sample pages![Documentation Documentation](themes/dot.gif) | 20 |
Edit | innodb stats sample pages![Documentation Documentation](themes/dot.gif) | 8 |
Edit | innodb stats traditional | ON |
Edit | innodb stats transient sample pages![Documentation Documentation](themes/dot.gif) | 8 |
Edit | innodb status output![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb status output locks![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb strict mode![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb support xa![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb sync array size![Documentation Documentation](themes/dot.gif) | 1 |
Edit | innodb sync spin loops![Documentation Documentation](themes/dot.gif) | 30 |
Edit | innodb table locks![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb thread concurrency![Documentation Documentation](themes/dot.gif) | 0 |
Edit | innodb thread sleep delay![Documentation Documentation](themes/dot.gif) | 10,000 |
Edit | innodb tmpdir | |
Edit | innodb track changed pages | OFF |
Edit | innodb undo directory![Documentation Documentation](themes/dot.gif) | . |
Edit | innodb undo logs![Documentation Documentation](themes/dot.gif) | 128 |
Edit | innodb undo tablespaces![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | innodb use stacktrace | OFF |
Edit | innodb use sys malloc![Documentation Documentation](themes/dot.gif) | ON |
Edit | innodb use trim | OFF |
Edit | innodb version![Documentation Documentation](themes/dot.gif) | 5.6.32-79.0 |
Edit | innodb write io threads![Documentation Documentation](themes/dot.gif) | 4 |
Edit | interactive timeout![Documentation Documentation](themes/dot.gif) | 28,800 |
Edit | join buffer size![Documentation Documentation](themes/dot.gif) | 256 KiB |
Edit | join buffer space limit | 2,097,152 |
Edit | join cache level | 2 |
Edit | keep files on create![Documentation Documentation](themes/dot.gif) | OFF |
Edit | key buffer size![Documentation Documentation](themes/dot.gif) | 16 MiB |
Edit | key cache age threshold![Documentation Documentation](themes/dot.gif) | 300 |
Edit | key cache block size![Documentation Documentation](themes/dot.gif) | 1 KiB |
Edit | key cache division limit![Documentation Documentation](themes/dot.gif) | 100 |
Edit | key cache file hash size | 512 |
Edit | key cache segments | 0 |
Edit | large files support![Documentation Documentation](themes/dot.gif) | ON |
Edit | large page size![Documentation Documentation](themes/dot.gif) | 0 B |
Edit | large pages![Documentation Documentation](themes/dot.gif) | OFF |
Edit | lc messages![Documentation Documentation](themes/dot.gif) | en_US |
Edit | lc messages dir![Documentation Documentation](themes/dot.gif) | |
Edit | lc time names![Documentation Documentation](themes/dot.gif) | en_US |
Edit | license![Documentation Documentation](themes/dot.gif) | GPL |
Edit | local infile![Documentation Documentation](themes/dot.gif) | ON |
Edit | lock wait timeout![Documentation Documentation](themes/dot.gif) | 31,536,000 |
Edit | locked in memory![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log bin![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log bin basename![Documentation Documentation](themes/dot.gif) | |
Edit | log bin index![Documentation Documentation](themes/dot.gif) | |
Edit | log bin trust function creators![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log error![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.err |
Edit | log output![Documentation Documentation](themes/dot.gif) | FILE |
Edit | log queries not using indexes![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log slave updates![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log slow admin statements![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | log slow verbosity | |
Edit | log tc size | 24,576 |
Edit | log warnings![Documentation Documentation](themes/dot.gif) | 1 |
Edit | long query time![Documentation Documentation](themes/dot.gif) | 10 |
Edit | low priority updates![Documentation Documentation](themes/dot.gif) | OFF |
Edit | lower case file system![Documentation Documentation](themes/dot.gif) | OFF |
Edit | lower case table names![Documentation Documentation](themes/dot.gif) | 0 |
Edit | master verify checksum![Documentation Documentation](themes/dot.gif) | OFF |
Edit | max allowed packet![Documentation Documentation](themes/dot.gif) | 1,048,576 |
Edit | max binlog cache size![Documentation Documentation](themes/dot.gif) | 16 EiB |
Edit | max binlog size![Documentation Documentation](themes/dot.gif) | 1 GiB |
Edit | max binlog stmt cache size![Documentation Documentation](themes/dot.gif) | 16 EiB |
Edit | max connect errors![Documentation Documentation](themes/dot.gif) | 100 |
Edit | max connections![Documentation Documentation](themes/dot.gif) | 151 |
Edit | max delayed threads![Documentation Documentation](themes/dot.gif) | 20 |
Edit | max digest length | 1,024 |
Edit | max error count![Documentation Documentation](themes/dot.gif) | 64 |
Edit | max heap table size![Documentation Documentation](themes/dot.gif) | 16 MiB |
Edit | max insert delayed threads![Documentation Documentation](themes/dot.gif) | 20 |
Edit | max join size![Documentation Documentation](themes/dot.gif) | 18,446,744,073,709,551,616 |
Edit | max length for sort data![Documentation Documentation](themes/dot.gif) | 1,024 |
Edit | max long data size![Documentation Documentation](themes/dot.gif) | 1,048,576 |
Edit | max prepared stmt count![Documentation Documentation](themes/dot.gif) | 16,382 |
Edit | max relay log size![Documentation Documentation](themes/dot.gif) | 1 GiB |
Edit | max seeks for key![Documentation Documentation](themes/dot.gif) | 4,294,967,295 |
Edit | max sort length![Documentation Documentation](themes/dot.gif) | 1,024 |
Edit | max sp recursion depth![Documentation Documentation](themes/dot.gif) | 0 |
Edit | max statement time | 0 |
Edit | max tmp tables![Documentation Documentation](themes/dot.gif) | 32 |
Edit | max user connections![Documentation Documentation](themes/dot.gif) | 0 |
Edit | max write lock count![Documentation Documentation](themes/dot.gif) | 4,294,967,295 |
Edit | metadata locks cache size![Documentation Documentation](themes/dot.gif) | 1,024 |
Edit | metadata locks hash instances![Documentation Documentation](themes/dot.gif) | 8 |
Edit | min examined row limit![Documentation Documentation](themes/dot.gif) | 0 |
Edit | mrr buffer size | 262,144 |
Edit | multi range count![Documentation Documentation](themes/dot.gif) | 256 |
Edit | myisam block size | 1,024 |
Edit | myisam data pointer size![Documentation Documentation](themes/dot.gif) | 6 B |
Edit | myisam max sort file size![Documentation Documentation](themes/dot.gif) | 8 EiB |
Edit | myisam mmap size![Documentation Documentation](themes/dot.gif) | 16 EiB |
Edit | myisam recover options![Documentation Documentation](themes/dot.gif) | DEFAULT |
Edit | myisam repair threads![Documentation Documentation](themes/dot.gif) | 1 |
Edit | myisam sort buffer size![Documentation Documentation](themes/dot.gif) | 8 MiB |
Edit | myisam stats method![Documentation Documentation](themes/dot.gif) | NULLS_UNEQUAL |
Edit | myisam use mmap![Documentation Documentation](themes/dot.gif) | OFF |
Edit | mysql56 temporal format | ON |
Edit | net buffer length![Documentation Documentation](themes/dot.gif) | 8,192 |
Edit | net read timeout![Documentation Documentation](themes/dot.gif) | 30 |
Edit | net retry count![Documentation Documentation](themes/dot.gif) | 10 |
Edit | net write timeout![Documentation Documentation](themes/dot.gif) | 60 |
Edit | old![Documentation Documentation](themes/dot.gif) | OFF |
Edit | old alter table![Documentation Documentation](themes/dot.gif) | OFF |
Edit | old mode | |
Edit | old passwords![Documentation Documentation](themes/dot.gif) | OFF |
Edit | open files limit![Documentation Documentation](themes/dot.gif) | 1,024 |
Edit | optimizer prune level![Documentation Documentation](themes/dot.gif) | 1 |
Edit | optimizer search depth![Documentation Documentation](themes/dot.gif) | 62 |
Edit | optimizer selectivity sampling limit | 100 |
Edit | optimizer switch![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | performance schema accounts size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema digests size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events stages history long size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events stages history size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events statements history long size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events statements history size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events waits history long size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema events waits history size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema hosts size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max cond classes![Documentation Documentation](themes/dot.gif) | 80 |
Edit | performance schema max cond instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max digest length | 1,024 |
Edit | performance schema max file classes![Documentation Documentation](themes/dot.gif) | 50 |
Edit | performance schema max file handles![Documentation Documentation](themes/dot.gif) | 32,768 |
Edit | performance schema max file instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max mutex classes![Documentation Documentation](themes/dot.gif) | 200 |
Edit | performance schema max mutex instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max rwlock classes![Documentation Documentation](themes/dot.gif) | 40 |
Edit | performance schema max rwlock instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max socket classes![Documentation Documentation](themes/dot.gif) | 10 |
Edit | performance schema max socket instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max stage classes![Documentation Documentation](themes/dot.gif) | 150 |
Edit | performance schema max statement classes![Documentation Documentation](themes/dot.gif) | 178 |
Edit | performance schema max table handles![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max table instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema max thread classes![Documentation Documentation](themes/dot.gif) | 50 |
Edit | performance schema max thread instances![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema session connect attrs size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | performance schema setup actors size![Documentation Documentation](themes/dot.gif) | 100 |
Edit | performance schema setup objects size![Documentation Documentation](themes/dot.gif) | 100 |
Edit | performance schema users size![Documentation Documentation](themes/dot.gif) | -1 |
Edit | pid file![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.pid |
Edit | plugin dir![Documentation Documentation](themes/dot.gif) | /opt/lampp/lib/mysql/plugin/ |
Edit | plugin maturity | unknown |
Edit | port![Documentation Documentation](themes/dot.gif) | 3,306 |
Edit | preload buffer size![Documentation Documentation](themes/dot.gif) | 32 KiB |
Edit | profiling![Documentation Documentation](themes/dot.gif) | OFF |
Edit | profiling history size![Documentation Documentation](themes/dot.gif) | 15 |
Edit | progress report time | 5 |
Edit | protocol version![Documentation Documentation](themes/dot.gif) | 10 |
Edit | query alloc block size![Documentation Documentation](themes/dot.gif) | 16 KiB |
Edit | query cache limit![Documentation Documentation](themes/dot.gif) | 1 MiB |
Edit | query cache min res unit![Documentation Documentation](themes/dot.gif) | 4,096 |
Edit | query cache size![Documentation Documentation](themes/dot.gif) | 1 MiB |
Edit | query cache strip comments | OFF |
Edit | query cache type![Documentation Documentation](themes/dot.gif) | OFF |
Edit | query cache wlock invalidate![Documentation Documentation](themes/dot.gif) | OFF |
Edit | query prealloc size![Documentation Documentation](themes/dot.gif) | 24 KiB |
Edit | range alloc block size![Documentation Documentation](themes/dot.gif) | 4 KiB |
Edit | read buffer size![Documentation Documentation](themes/dot.gif) | 256 KiB |
Edit | read only![Documentation Documentation](themes/dot.gif) | OFF |
Edit | read rnd buffer size![Documentation Documentation](themes/dot.gif) | 512 KiB |
Edit | relay log![Documentation Documentation](themes/dot.gif) | |
Edit | relay log basename![Documentation Documentation](themes/dot.gif) | |
Edit | relay log index![Documentation Documentation](themes/dot.gif) | |
Edit | relay log info file![Documentation Documentation](themes/dot.gif) | relay-log.info |
Edit | relay log purge![Documentation Documentation](themes/dot.gif) | ON |
Edit | relay log recovery![Documentation Documentation](themes/dot.gif) | OFF |
Edit | relay log space limit![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | |
Edit | report password![Documentation Documentation](themes/dot.gif) | |
Edit | report port![Documentation Documentation](themes/dot.gif) | 3,306 |
Edit | report user![Documentation Documentation](themes/dot.gif) | |
Edit | rowid merge buff size | 8,388,608 |
Edit | secure auth![Documentation Documentation](themes/dot.gif) | ON |
Edit | secure file priv![Documentation Documentation](themes/dot.gif) | |
Edit | server id![Documentation Documentation](themes/dot.gif) | 1 |
Edit | skip external locking![Documentation Documentation](themes/dot.gif) | ON |
Edit | skip name resolve![Documentation Documentation](themes/dot.gif) | OFF |
Edit | skip networking![Documentation Documentation](themes/dot.gif) | OFF |
Edit | skip show database![Documentation Documentation](themes/dot.gif) | OFF |
Edit | slave compressed protocol![Documentation Documentation](themes/dot.gif) | OFF |
Edit | slave ddl exec mode | IDEMPOTENT |
Edit | slave domain parallel threads | 0 |
Edit | slave exec mode![Documentation Documentation](themes/dot.gif) | STRICT |
Edit | slave load tmpdir![Documentation Documentation](themes/dot.gif) | /tmp |
Edit | slave max allowed packet![Documentation Documentation](themes/dot.gif) | 1,073,741,824 |
Edit | slave net timeout![Documentation Documentation](themes/dot.gif) | 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![Documentation Documentation](themes/dot.gif) | OFF |
Edit | slave sql verify checksum![Documentation Documentation](themes/dot.gif) | ON |
Edit | slave transaction retries![Documentation Documentation](themes/dot.gif) | 10 |
Edit | slave type conversions![Documentation Documentation](themes/dot.gif) | |
Edit | slow launch time![Documentation Documentation](themes/dot.gif) | 2 |
Edit | slow query log![Documentation Documentation](themes/dot.gif) | OFF |
Edit | slow query log file![Documentation Documentation](themes/dot.gif) | ubuntu-s-1vcpu-2gb-blr1-01-slow.log |
Edit | socket![Documentation Documentation](themes/dot.gif) | /opt/lampp/var/mysql/mysql.sock |
Edit | sort buffer size![Documentation Documentation](themes/dot.gif) | 512 KiB |
Edit | sql auto is null![Documentation Documentation](themes/dot.gif) | OFF |
Edit | sql big selects![Documentation Documentation](themes/dot.gif) | ON |
Edit | sql buffer result![Documentation Documentation](themes/dot.gif) | OFF |
Edit | sql log bin![Documentation Documentation](themes/dot.gif) | ON |
Edit | sql log off![Documentation Documentation](themes/dot.gif) | OFF |
Edit | sql mode![Documentation Documentation](themes/dot.gif) | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
Edit | sql notes![Documentation Documentation](themes/dot.gif) | ON |
Edit | sql quote show create![Documentation Documentation](themes/dot.gif) | ON |
Edit | sql safe updates![Documentation Documentation](themes/dot.gif) | OFF |
Edit | sql select limit![Documentation Documentation](themes/dot.gif) | 18,446,744,073,709,551,616 |
Edit | sql slave skip counter![Documentation Documentation](themes/dot.gif) | 0 |
Edit | sql warnings![Documentation Documentation](themes/dot.gif) | OFF |
Edit | ssl ca![Documentation Documentation](themes/dot.gif) | |
Edit | ssl capath![Documentation Documentation](themes/dot.gif) | |
Edit | ssl cert![Documentation Documentation](themes/dot.gif) | |
Edit | ssl cipher![Documentation Documentation](themes/dot.gif) | |
Edit | ssl crl![Documentation Documentation](themes/dot.gif) | |
Edit | ssl crlpath![Documentation Documentation](themes/dot.gif) | |
Edit | ssl key![Documentation Documentation](themes/dot.gif) | |
Edit | storage engine![Documentation Documentation](themes/dot.gif) | InnoDB |
Edit | stored program cache![Documentation Documentation](themes/dot.gif) | 256 |
Edit | strict password validation | ON |
Edit | sync binlog![Documentation Documentation](themes/dot.gif) | 0 |
Edit | sync frm![Documentation Documentation](themes/dot.gif) | ON |
Edit | sync master info![Documentation Documentation](themes/dot.gif) | 10,000 |
Edit | sync relay log![Documentation Documentation](themes/dot.gif) | 10,000 |
Edit | sync relay log info![Documentation Documentation](themes/dot.gif) | 10,000 |
Edit | system time zone![Documentation Documentation](themes/dot.gif) | UTC |
Edit | table definition cache![Documentation Documentation](themes/dot.gif) | 400 |
Edit | table open cache![Documentation Documentation](themes/dot.gif) | 64 |
Edit | thread cache size![Documentation Documentation](themes/dot.gif) | 0 |
Edit | thread concurrency![Documentation Documentation](themes/dot.gif) | 10 |
Edit | thread handling![Documentation Documentation](themes/dot.gif) | one-thread-per-connection |
Edit | thread pool idle timeout | 60 |
Edit | thread pool max threads | 1,000 |
Edit | thread pool oversubscribe | 3 |
Edit | thread pool size | 1 |
Edit | thread pool stall limit | 500 |
Edit | thread stack![Documentation Documentation](themes/dot.gif) | 295,936 |
Edit | time format![Documentation Documentation](themes/dot.gif) | %H:%i:%s |
Edit | time zone![Documentation Documentation](themes/dot.gif) | SYSTEM |
Edit | timed mutexes![Documentation Documentation](themes/dot.gif) | OFF |
Edit | tmp table size![Documentation Documentation](themes/dot.gif) | 16 MiB |
Edit | tmpdir![Documentation Documentation](themes/dot.gif) | /tmp |
Edit | transaction alloc block size![Documentation Documentation](themes/dot.gif) | 8 KiB |
Edit | transaction prealloc size![Documentation Documentation](themes/dot.gif) | 4 KiB |
Edit | tx isolation![Documentation Documentation](themes/dot.gif) | REPEATABLE-READ |
Edit | tx read only![Documentation Documentation](themes/dot.gif) | OFF |
Edit | unique checks![Documentation Documentation](themes/dot.gif) | ON |
Edit | updatable views with limit![Documentation Documentation](themes/dot.gif) | YES |
Edit | use stat tables | NEVER |
Edit | userstat | OFF |
Edit | version![Documentation Documentation](themes/dot.gif) | 10.1.19-MariaDB |
Edit | version comment![Documentation Documentation](themes/dot.gif) | Source distribution |
Edit | version compile machine![Documentation Documentation](themes/dot.gif) | x86_64 |
Edit | version compile os![Documentation Documentation](themes/dot.gif) | Linux |
Edit | version malloc library | system |
Edit | version ssl library | OpenSSL 1.0.2j 26 Sep 2016 |
Edit | wait timeout![Documentation Documentation](themes/dot.gif) | 28,800 |
Edit | wsrep osu method | TOI |
Edit | wsrep auto increment control | ON |
Edit | wsrep causal reads | OFF |
Edit | wsrep certify nonpk | ON |
Edit | wsrep cluster address | |
Edit | wsrep cluster name | my_wsrep_cluster |
Edit | wsrep convert lock to trx | OFF |
Edit | wsrep data home dir | /opt/lampp/var/mysql/ |
Edit | wsrep dbug option | |
Edit | wsrep debug | OFF |
Edit | wsrep desync | OFF |
Edit | wsrep drupal 282555 workaround | OFF |
Edit | wsrep forced binlog format | NONE |
Edit | wsrep gtid domain id | 0 |
Edit | wsrep gtid mode | OFF |
Edit | wsrep load data splitting | ON |
Edit | wsrep log conflicts | OFF |
Edit | wsrep max ws rows | 0 |
Edit | wsrep max ws size | 2,147,483,647 |
Edit | wsrep mysql replication bundle | 0 |
Edit | wsrep node address | |
Edit | wsrep node incoming address | AUTO |
Edit | wsrep node name | ubuntu-s-1vcpu-2gb-blr1-01 |
Edit | wsrep notify cmd | |
Edit | wsrep on | OFF |
Edit | wsrep patch version | wsrep_25.16 |
Edit | wsrep provider | none |
Edit | wsrep provider options | |
Edit | wsrep recover | OFF |
Edit | wsrep replicate myisam | OFF |
Edit | wsrep restart slave | OFF |
Edit | wsrep retry autocommit | 1 |
Edit | wsrep slave fk checks | ON |
Edit | wsrep slave uk checks | OFF |
Edit | wsrep slave threads | 1 |
Edit | wsrep sst auth | |
Edit | wsrep sst donor | |
Edit | wsrep sst donor rejects queries | OFF |
Edit | wsrep sst method | rsync |
Edit | wsrep sst receive address | AUTO |
Edit | wsrep start position | 00000000-0000-0000-0000-000000000000:-1 |
Edit | wsrep sync wait | 0 |