· 6 years ago · Sep 10, 2019, 11:46 PM
1aria block size 8,192
2aria checkpoint interval 30
3aria checkpoint log activity 1,048,576
4aria force start after recovery failures 0
5aria group commit none
6aria group commit interval 0
7aria log file size 1,073,741,824
8aria log purge type immediate
9aria max sort file size 9,223,372,036,853,727,232
10aria page checksum ON
11aria pagecache age threshold 300
12aria pagecache buffer size 134,217,728
13aria pagecache division limit 100
14aria pagecache file hash size 512
15aria recover NORMAL
16aria repair threads 1
17aria sort buffer size 268,434,432
18aria stats method nulls_unequal
19aria sync log dir NEWFILE
20aria used for temp tables ON
21auto increment increment : 1
22auto increment offset : 1
23autocommit : ON
24automatic sp privileges : ON
25back log : 150
26basedir : /usr
27big tables : OFF
28binlog annotate row events OFF
29binlog cache size : 32 KiB
30binlog checksum : NONE
31binlog commit wait count 0
32binlog commit wait usec 100,000
33binlog direct non transactional updates : OFF
34binlog format : ROW
35binlog optimize thread scheduling ON
36binlog stmt cache size : 32 KiB
37bulk insert buffer size : 8 MiB
38character set client : utf8
39(Session value) utf8mb4
40character set connection : utf8
41(Session value) utf8mb4
42character set database : utf8
43character set filesystem : binary
44character set results : utf8
45(Session value) utf8mb4
46character set server : utf8
47character set system : utf8
48character sets dir : /usr/share/mariadb/charsets/
49collation connection : utf8_general_ci
50(Session value) utf8mb4_unicode_ci
51collation database : utf8_general_ci
52collation server : utf8_general_ci
53completion type : NO_CHAIN
54concurrent insert : AUTO
55connect timeout : 10
56datadir : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/data/
57date format : %Y-%m-%d
58datetime format : %Y-%m-%d %H:%i:%s
59deadlock search depth long 15
60deadlock search depth short 4
61deadlock timeout long 50,000,000
62deadlock timeout short 10,000
63debug no thread alarm OFF
64default regex flags
65default storage engine : InnoDB
66default week format : 0
67delay key write : ON
68delayed insert limit : 100
69delayed insert timeout : 300
70delayed queue size : 1,000
71div precision increment : 4
72event scheduler : OFF
73expensive subquery limit 100
74expire logs days : 1
75extra max connections 1
76extra port 0
77flush : OFF
78flush time : 0
79foreign key checks : ON
80ft boolean syntax : + -><()~*:""&|
81ft max word len : 84
82ft min word len : 4
83ft query expansion limit : 20
84ft stopword file : (built-in)
85general log : OFF
86general log file : dbserver-5c33bf8f.log
87group concat max len : 1,024
88gtid binlog pos 0-3007739044-977265507
89gtid binlog state 0-3007739044-977265507
90gtid current pos 0-3007739044-977265507
91gtid domain id 0
92gtid ignore duplicates OFF
93gtid slave pos 0-2634665632-975073334
94gtid strict mode OFF
95have compress : YES
96have crypt : YES
97have dynamic loading : YES
98have geometry : YES
99have openssl : YES
100have profiling : YES
101have query cache : YES
102have rtree keys : YES
103have ssl : YES
104have symlink : DISABLED
105histogram size 0
106histogram type SINGLE_PREC_HB
107host cache size : 128
108hostname : dbserver-5c33bf8f.c.pantheon-dmz.internal
109ignore builtin innodb : OFF
110ignore db dirs Documentation
111init connect Documentation
112init file Documentation
113init slave Documentation
114innodb adaptive flushing : ON
115innodb adaptive flushing lwm : 10
116innodb adaptive hash index : ON
117innodb adaptive hash index partitions 1
118innodb adaptive max sleep delay : 150,000
119innodb additional mem pool size : 8 MiB
120innodb api bk commit interval : 5
121innodb api disable rowlock : OFF
122innodb api enable binlog : OFF
123innodb api enable mdl : OFF
124innodb api trx level : 0
125innodb autoextend increment : 64
126innodb autoinc lock mode : 1
127innodb buffer pool dump at shutdown : OFF
128innodb buffer pool dump now : OFF
129innodb buffer pool dump pct : 100
130innodb buffer pool filename : ib_buffer_pool
131innodb buffer pool instances : 8
132innodb buffer pool load abort : OFF
133innodb buffer pool load at startup : OFF
134innodb buffer pool load now : OFF
135innodb buffer pool populate OFF
136innodb buffer pool size : 1 GiB
137innodb change buffer max size : 25
138innodb change buffering : all
139innodb checksum algorithm : innodb
140innodb checksums : ON
141innodb cleaner lsn age factor high_checkpoint
142innodb cmp per index enabled : OFF
143innodb commit concurrency : 0
144innodb compression failure threshold pct : 5
145innodb compression level : 6
146innodb compression pad pct max : 50
147innodb concurrency tickets : 5,000
148innodb corrupt table action assert
149innodb data file path : ibdata1:12M:autoextend
150innodb data home dir Documentation
151innodb disable sort file cache : OFF
152innodb doublewrite : ON
153innodb empty free list algorithm backoff
154innodb fake changes OFF
155innodb fast shutdown : 0
156innodb file format : Barracuda
157innodb file format check : ON
158innodb file format max : Antelope
159innodb file per table : ON
160innodb flush log at timeout : 1
161innodb flush log at trx commit : 2
162innodb flush method : O_DIRECT
163innodb flush neighbors : 1
164innodb flushing avg loops : 30
165innodb force load corrupted : OFF
166innodb force recovery : 0
167innodb foreground preflush exponential_backoff
168innodb ft aux table Documentation
169innodb ft cache size : 8,000,000
170innodb ft enable diag print : OFF
171innodb ft enable stopword : ON
172innodb ft max token size : 84
173innodb ft min token size : 3
174innodb ft num word optimize : 2,000
175innodb ft result cache limit : 2,000,000,000
176innodb ft server stopword table Documentation
177innodb ft sort pll degree : 2
178innodb ft total cache size : 640,000,000
179innodb ft user stopword table Documentation
180innodb io capacity : 200
181innodb io capacity max : 2,000
182innodb kill idle transaction 0
183innodb large prefix : ON
184innodb lock wait timeout : 50
185innodb locking fake changes ON
186innodb locks unsafe for binlog : OFF
187innodb log arch dir ./
188innodb log arch expire sec 0
189innodb log archive OFF
190innodb log block size 512
191innodb log buffer size : 8 MiB
192innodb log checksum algorithm : innodb
193innodb log compressed pages : ON
194innodb log file size : 48 MiB
195innodb log files in group : 2
196innodb log group home dir : ./
197innodb lru scan depth : 1,024
198innodb max bitmap file size 104,857,600
199innodb max changed pages 1,000,000
200innodb max dirty pages pct : 75
201innodb max dirty pages pct lwm : <1
202innodb max purge lag : 0
203innodb max purge lag delay : 0
204innodb mirrored log groups : 1
205innodb old blocks pct : 37
206innodb old blocks time : 1,000
207innodb online alter log max size : 128 MiB
208innodb open files : 400
209innodb optimize fulltext only : OFF
210innodb page size : 16 KiB
211innodb print all deadlocks : OFF
212innodb purge batch size : 300
213innodb purge threads : 1
214innodb random read ahead : OFF
215innodb read ahead threshold : 56
216innodb read io threads : 4
217innodb read only : OFF
218innodb replication delay : 0
219innodb rollback on timeout : OFF
220innodb rollback segments : 128
221innodb sched priority cleaner 19
222innodb show locks held 10
223innodb show verbose locks 0
224innodb simulate comp failures 0
225innodb sort buffer size : 1 MiB
226innodb spin wait delay : 6
227innodb stats auto recalc : ON
228innodb stats method : nulls_equal
229innodb stats modified counter 0
230innodb stats on metadata : OFF
231innodb stats persistent : ON
232innodb stats persistent sample pages : 20
233innodb stats sample pages : 8
234innodb stats traditional ON
235innodb stats transient sample pages : 8
236innodb status output : OFF
237innodb status output locks : OFF
238innodb strict mode : OFF
239innodb support xa : ON
240innodb sync array size : 1
241innodb sync spin loops : 30
242innodb table locks : ON
243innodb thread concurrency : 0
244innodb thread sleep delay : 10,000
245innodb track changed pages OFF
246innodb undo directory : .
247innodb undo logs : 128
248innodb undo tablespaces : 0
249innodb use atomic writes OFF
250innodb use fallocate OFF
251innodb use global flush log at trx commit ON
252innodb use native aio : OFF
253innodb use stacktrace OFF
254innodb use sys malloc : ON
255innodb version : 5.6.26-76.0
256innodb write io threads : 4
257interactive timeout : 420
258join buffer size : 128 KiB
259join buffer space limit 2,097,152
260join cache level 2
261keep files on create : OFF
262key buffer size : 20 MiB
263key cache age threshold : 300
264key cache block size : 1 KiB
265key cache division limit : 100
266key cache file hash size 512
267key cache segments 0
268large files support : ON
269large page size : 0 B
270large pages : OFF
271lc messages : en_US
272lc messages dir Documentation
273lc time names : en_US
274license : GPL
275local infile : ON
276lock wait timeout : 31,536,000
277locked in memory : OFF
278log bin : ON
279log bin trust function creators : OFF
280log error : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/logs/mysqld.log
281log output : FILE
282log queries not using indexes : OFF
283log slave updates : OFF
284log slow filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
285log slow rate limit 1
286log slow verbosity
287log warnings : 1
288long query time : 1
289low priority updates : OFF
290lower case file system : OFF
291lower case table names : 0
292master verify checksum : OFF
293max allowed packet : 67,108,864
294max binlog cache size : 16 EiB
295max binlog size : 1 GiB
296max binlog stmt cache size : 16 EiB
297max connect errors : 1,000
298max connections : 1,024
299max delayed threads : 20
300max digest length : 1,024
301max error count : 64
302max heap table size : 16 MiB
303max insert delayed threads : 20
304max join size : 18,446,744,073,709,551,616
305max length for sort data : 1,024
306max long data size : 67,108,864
307max prepared stmt count : 16,382
308max relay log size : 1 GiB
309max seeks for key : 4,294,967,295
310max sort length : 1,024
311max sp recursion depth : 0
312max tmp tables : 32
313max user connections : 0
314max write lock count : 4,294,967,295
315metadata locks cache size : 1,024
316metadata locks hash instances : 8
317min examined row limit : 0
318mrr buffer size 262,144
319multi range count : 256
320myisam block size 1,024
321myisam data pointer size : 6 B
322myisam max sort file size : 8 EiB
323myisam mmap size : 16 EiB
324myisam recover options : DEFAULT
325myisam repair threads : 1
326myisam sort buffer size : 127.999 MiB
327myisam stats method : nulls_unequal
328myisam use mmap : OFF
329net buffer length : 16,384
330net read timeout : 90
331net retry count : 10
332net write timeout : 90
333old : OFF
334old alter table : OFF
335old mode
336old passwords : OFF
337open files limit : 4,096
338optimizer prune level : 1
339optimizer search depth : 62
340optimizer selectivity sampling limit 100
341optimizer 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
342optimizer use condition selectivity 1
343performance schema : OFF
344performance schema accounts size : -1
345performance schema digests size : -1
346performance schema events stages history long size : -1
347performance schema events stages history size : -1
348performance schema events statements history long size Documentation -1
349performance schema events statements history size : -1
350performance schema events waits history long size : -1
351performance schema events waits history size : -1
352performance schema hosts size : -1
353performance schema max cond classes : 80
354performance schema max cond instances : -1
355performance schema max digest length : 1,024
356performance schema max file classes : 50
357performance schema max file handles : 32,768
358performance schema max file instances : -1
359performance schema max mutex classes : 200
360performance schema max mutex instances : -1
361performance schema max rwlock classes : 40
362performance schema max rwlock instances : -1
363performance schema max socket classes : 10
364performance schema max socket instances : -1
365performance schema max stage classes : 150
366performance schema max statement classes : 180
367performance schema max table handles : -1
368performance schema max table instances : -1
369performance schema max thread classes : 50
370performance schema max thread instances : -1
371performance schema session connect attrs size : -1
372performance schema setup actors size : 100
373performance schema setup objects size : 100
374performance schema users size : -1
375pid file : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/mysqld.pid
376plugin dir : /usr/lib64/mysql/plugin/
377plugin maturity unknown
378port : 23,456
379preload buffer size : 32 KiB
380profiling : OFF
381profiling history size : 15
382progress report time 5
383protocol version : 10
384query alloc block size : 8 KiB
385query cache limit : 1 MiB
386query cache min res unit : 4,096
387query cache size : 0 B
388query cache strip comments OFF
389query cache type : OFF
390query cache wlock invalidate : OFF
391query prealloc size : 8 KiB
392range alloc block size : 4 KiB
393read buffer size : 128 KiB
394read only : OFF
395read rnd buffer size : 256 KiB
396relay log Documentation
397relay log index Documentation
398relay log info file : relay-log.info
399relay log purge : ON
400relay log recovery : OFF
401relay log space limit : 0
402replicate annotate row events OFF
403replicate do db pantheon
404replicate do table
405replicate events marked for skip replicate
406replicate ignore db
407replicate ignore table
408replicate wild do table
409replicate wild ignore table
410report host Documentation
411report password Documentation
412report port : 23,456
413report user Documentation
414rowid merge buff size 8,388,608
415rpl recovery rank : 0
416secure auth : OFF
417secure file priv : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/tmp/
418server id : 3,007,739,044
419skip external locking : ON
420skip name resolve : ON
421skip networking : OFF
422skip show database : OFF
423slave compressed protocol : OFF
424slave ddl exec mode IDEMPOTENT
425slave domain parallel threads 0
426slave exec mode : STRICT
427slave load tmpdir : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/tmp
428slave max allowed packet : 1,073,741,824
429slave net timeout : 3,600
430slave parallel max queued 3,145,728
431slave parallel threads 8
432slave skip errors : OFF
433slave sql verify checksum : ON
434slave transaction retries : 10
435slave type conversions Documentation
436slow launch time : 2
437slow query log : ON
438slow query log file : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/logs/mysqld-slow-query.log
439socket : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/data/mysql.sock
440sort buffer size : 2 MiB
441sql auto is null : OFF
442sql big selects : ON
443sql buffer result : OFF
444sql log bin : ON
445sql log off : OFF
446sql mode Documentation
447sql notes : ON
448sql quote show create : ON
449sql safe updates : OFF
450sql select limit : 18,446,744,073,709,551,616
451sql slave skip counter : 0
452sql warnings : OFF
453ssl ca : /etc/pantheon/ca.crt
454ssl capath Documentation
455ssl cert : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/certs/binding.crt
456ssl cipher Documentation
457ssl crl Documentation
458ssl crlpath Documentation
459ssl key : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/certs/binding.key
460storage engine : InnoDB
461stored program cache : 256
462sync binlog : 1
463sync frm : ON
464sync master info : 0
465sync relay log : 0
466sync relay log info : 0
467system time zone : UTC
468table definition cache : 400
469table open cache : 400
470thread cache size : 0
471thread concurrency : 10
472thread handling : one-thread-per-connection
473thread pool idle timeout 60
474thread pool max threads 500
475thread pool oversubscribe 3
476thread pool size 32
477thread pool stall limit 500
478thread stack : 294,912
479time format : %H:%i:%s
480time zone : SYSTEM
481timed mutexes : OFF
482tmp table size : 16 MiB
483tmpdir : /srv/bindings/867b26fdb7344bd18abb0597b34674a4/tmp
484transaction alloc block size : 8 KiB
485transaction prealloc size : 4 KiB
486tx isolation : READ-COMMITTED
487tx read only : OFF
488unique checks : ON
489updatable views with limit : YES
490use stat tables NEVER
491userstat OFF
492version : 10.0.23-MariaDB-log
493version comment : MariaDB Server
494version compile machine : x86_64
495version compile os : Linux
496version malloc library system
497wait timeout : 420