按 Ctrl+Enter 键执行查询按 Enter 执行查询
崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: phpmyadmin 查询时间: 在当前会话期间
SELECT * FROM `pma__designer_settings`崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: herp 查询时间: 在当前会话期间
SELECT * FROM `account_invoice_billbook`- 表收藏夹为空。
将文件拖动至此
控制台 服务器变量和设置
| 操作 | 变量 | 会话值 / 全局值 |
| 编辑 | 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 | /opt/lampp |
| 编辑 | 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 | /opt/lampp/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 | /opt/lampp/var/mysql/ |
| 编辑 | 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 | OFF |
| 编辑 | general log file | ubuntu-s-1vcpu-2gb-blr1-01.log |
| 编辑 | 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 | YES |
| 编辑 | have dynamic loading | YES |
| 编辑 | have geometry | YES |
| 编辑 | have openssl | YES |
| 编辑 | have profiling | YES |
| 编辑 | have query cache | YES |
| 编辑 | have rtree keys | YES |
| 编辑 | have ssl | DISABLED |
| 编辑 | have symlink | YES |
| 编辑 | histogram size | 0 |
| 编辑 | histogram type | SINGLE_PREC_HB |
| 编辑 | host cache size | 279 |
| 编辑 | hostname | ubuntu-s-1vcpu-2gb-blr1-01 |
| 编辑 | 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 | 8 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 | 512 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 | /opt/lampp/var/mysql/ |
| 编辑 | 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 disallow writes | OFF |
| 编辑 | innodb doublewrite | ON |
| 编辑 | innodb empty free list algorithm | BACKOFF |
| 编辑 | 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 | /opt/lampp/var/mysql/ |
| 编辑 | 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 | /opt/lampp/var/mysql/ |
| 编辑 | 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 | 300 |
| 编辑 | 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 sched priority cleaner | 19 |
| 编辑 | 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 | OFF |
| 编辑 | 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 |
| 编辑 | locked in memory | OFF |
| 编辑 | log bin | OFF |
| 编辑 | log bin basename | |
| 编辑 | log bin index | |
| 编辑 | log bin trust function creators | OFF |
| 编辑 | log error | /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.err |
| 编辑 | 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 | OFF |
| 编辑 | lower case table names | 0 |
| 编辑 | master verify checksum | OFF |
| 编辑 | max allowed packet | 1,048,576 |
| 编辑 | max binlog cache size | 16 EB |
| 编辑 | max binlog size | 1 GB |
| 编辑 | max binlog stmt cache size | 16 EB |
| 编辑 | 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 | 8 EB |
| 编辑 | myisam mmap size | 16 EB |
| 编辑 | 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 |
| 编辑 | 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 | 1,024 |
| 编辑 | 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 | /opt/lampp/var/mysql/ubuntu-s-1vcpu-2gb-blr1-01.pid |
| 编辑 | plugin dir | /opt/lampp/lib/mysql/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 |
| 编辑 | 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 | /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 | ubuntu-s-1vcpu-2gb-blr1-01-slow.log |
| 编辑 | socket | /opt/lampp/var/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 | UTC |
| 编辑 | table definition cache | 400 |
| 编辑 | table open cache | 64 |
| 编辑 | thread cache size | 0 |
| 编辑 | thread concurrency | 10 |
| 编辑 | thread handling | one-thread-per-connection |
| 编辑 | thread pool idle timeout | 60 |
| 编辑 | thread pool max threads | 1,000 |
| 编辑 | thread pool oversubscribe | 3 |
| 编辑 | thread pool size | 1 |
| 编辑 | thread pool stall limit | 500 |
| 编辑 | thread stack | 295,936 |
| 编辑 | time format | %H:%i:%s |
| 编辑 | time zone | SYSTEM |
| 编辑 | timed mutexes | OFF |
| 编辑 | tmp table size | 16 MB |
| 编辑 | tmpdir | /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 | Source distribution |
| 编辑 | version compile machine | x86_64 |
| 编辑 | version compile os | Linux |
| 编辑 | version malloc library | system |
| 编辑 | version ssl library | OpenSSL 1.0.2j 26 Sep 2016 |
| 编辑 | wait timeout | 28,800 |
| 编辑 | wsrep osu method | TOI |
| 编辑 | wsrep auto increment control | ON |
| 编辑 | wsrep causal reads | OFF |
| 编辑 | wsrep certify nonpk | ON |
| 编辑 | wsrep cluster address | |
| 编辑 | wsrep cluster name | my_wsrep_cluster |
| 编辑 | wsrep convert lock to trx | OFF |
| 编辑 | wsrep data home dir | /opt/lampp/var/mysql/ |
| 编辑 | wsrep dbug option | |
| 编辑 | wsrep debug | OFF |
| 编辑 | wsrep desync | OFF |
| 编辑 | wsrep drupal 282555 workaround | OFF |
| 编辑 | wsrep forced binlog format | NONE |
| 编辑 | wsrep gtid domain id | 0 |
| 编辑 | wsrep gtid mode | OFF |
| 编辑 | wsrep load data splitting | ON |
| 编辑 | wsrep log conflicts | OFF |
| 编辑 | wsrep max ws rows | 0 |
| 编辑 | wsrep max ws size | 2,147,483,647 |
| 编辑 | wsrep mysql replication bundle | 0 |
| 编辑 | wsrep node address | |
| 编辑 | wsrep node incoming address | AUTO |
| 编辑 | wsrep node name | ubuntu-s-1vcpu-2gb-blr1-01 |
| 编辑 | wsrep notify cmd | |
| 编辑 | wsrep on | OFF |
| 编辑 | wsrep patch version | wsrep_25.16 |
| 编辑 | wsrep provider | none |
| 编辑 | wsrep provider options | |
| 编辑 | wsrep recover | OFF |
| 编辑 | wsrep replicate myisam | OFF |
| 编辑 | wsrep restart slave | OFF |
| 编辑 | wsrep retry autocommit | 1 |
| 编辑 | wsrep slave fk checks | ON |
| 编辑 | wsrep slave uk checks | OFF |
| 编辑 | wsrep slave threads | 1 |
| 编辑 | wsrep sst auth | |
| 编辑 | wsrep sst donor | |
| 编辑 | wsrep sst donor rejects queries | OFF |
| 编辑 | wsrep sst method | rsync |
| 编辑 | wsrep sst receive address | AUTO |
| 编辑 | wsrep start position | 00000000-0000-0000-0000-000000000000:-1 |
| 编辑 | wsrep sync wait | 0 |