· 6 years ago · Feb 19, 2020, 05:44 AM
1Action VariableValue
2Edit Edit auto generate certsON
3Edit Edit auto increment increment Documentation1
4Edit Edit auto increment offset Documentation1
5Edit Edit autocommit DocumentationON
6Edit Edit automatic sp privileges DocumentationON
7Edit Edit avoid temporal upgrade DocumentationOFF
8Edit Edit back log Documentation80
9Edit Edit basedir Documentation/usr/
10Edit Edit big tables DocumentationOFF
11Edit Edit bind address Documentation*
12Edit Edit binlog cache size Documentation32 KiB
13Edit Edit binlog checksum DocumentationCRC32
14Edit Edit binlog direct non transactional updates DocumentationOFF
15Edit Edit binlog error action DocumentationABORT_SERVER
16Edit Edit binlog format DocumentationROW
17Edit Edit binlog group commit sync delay Documentation0
18Edit Edit binlog group commit sync no delay count Documentation0
19Edit Edit binlog gtid simple recovery DocumentationON
20Edit Edit binlog max flush queue time Documentation0
21Edit Edit binlog order commits DocumentationON
22Edit Edit binlog row image DocumentationFULL
23Edit Edit binlog rows query log events DocumentationOFF
24Edit Edit binlog stmt cache size Documentation32 KiB
25Edit Edit binlog transaction dependency history size25,000
26Edit Edit binlog transaction dependency trackingCOMMIT_ORDER
27Edit Edit block encryption mode Documentationaes-128-ecb
28Edit Edit bulk insert buffer size Documentation8 MiB
29Edit Edit character set client Documentationlatin1
30(Session value) utf8mb4
31Edit Edit character set connection Documentationlatin1
32(Session value) utf8mb4
33Edit Edit character set database Documentationlatin1
34Edit Edit character set filesystem Documentationbinary
35Edit Edit character set results Documentationlatin1
36(Session value) utf8mb4
37Edit Edit character set server Documentationlatin1
38Edit Edit character set system Documentationutf8
39Edit Edit character sets dir Documentation/usr/share/mysql/charsets/
40Edit Edit check proxy users DocumentationOFF
41Edit Edit collation connection Documentationlatin1_swedish_ci
42(Session value) utf8mb4_unicode_ci
43Edit Edit collation database Documentationlatin1_swedish_ci
44Edit Edit collation server Documentationlatin1_swedish_ci
45Edit Edit completion type DocumentationNO_CHAIN
46Edit Edit concurrent insert DocumentationAUTO
47Edit Edit connect timeout Documentation10
48Edit Edit core file DocumentationOFF
49Edit Edit datadir Documentation/var/lib/mysql/
50Edit Edit date format Documentation%Y-%m-%d
51Edit Edit datetime format Documentation%Y-%m-%d %H:%i:%s
52Edit Edit default authentication plugin Documentationmysql_native_password
53Edit Edit default password lifetime Documentation0
54Edit Edit default storage engine DocumentationMyISAM
55Edit Edit default tmp storage engine DocumentationInnoDB
56Edit Edit default week format Documentation0
57Edit Edit delay key write DocumentationON
58Edit Edit delayed insert limit Documentation100
59Edit Edit delayed insert timeout Documentation300
60Edit Edit delayed queue size Documentation1,000
61Edit Edit disabled storage engines Documentation
62Edit Edit disconnect on expired password DocumentationON
63Edit Edit div precision increment Documentation4
64Edit Edit end markers in json DocumentationOFF
65Edit Edit enforce gtid consistency DocumentationOFF
66Edit Edit eq range index dive limit Documentation200
67Edit Edit event scheduler DocumentationOFF
68Edit Edit expire logs days Documentation0
69Edit Edit explicit defaults for timestamp DocumentationOFF
70Edit Edit flush DocumentationOFF
71Edit Edit flush time Documentation0
72Edit Edit foreign key checks DocumentationON
73Edit Edit ft boolean syntax Documentation+ -><()~*:""&|
74Edit Edit ft max word len Documentation84
75Edit Edit ft min word len Documentation4
76Edit Edit ft query expansion limit Documentation20
77Edit Edit ft stopword file Documentation(built-in)
78Edit Edit general log DocumentationOFF
79Edit Edit general log file Documentation/var/lib/mysql/server.log
80Edit Edit group concat max len Documentation1,024
81Edit Edit gtid executed Documentation
82Edit Edit gtid executed compression period Documentation1,000
83Edit Edit gtid mode DocumentationOFF
84Edit Edit gtid owned Documentation
85Edit Edit gtid purged Documentation
86Edit Edit have compress DocumentationYES
87Edit Edit have crypt DocumentationYES
88Edit Edit have dynamic loading DocumentationYES
89Edit Edit have geometry DocumentationYES
90Edit Edit have openssl DocumentationYES
91Edit Edit have profiling DocumentationYES
92Edit Edit have query cache DocumentationYES
93Edit Edit have rtree keys DocumentationYES
94Edit Edit have ssl DocumentationYES
95Edit Edit have statement timeout DocumentationYES
96Edit Edit have symlink DocumentationYES
97Edit Edit host cache size Documentation279
98Edit Edit hostname Documentationserver.isovle.net
99Edit Edit ignore builtin innodb DocumentationOFF
100Edit Edit ignore db dirs Documentation
101Edit Edit init connect Documentation
102Edit Edit init file Documentation
103Edit Edit init slave Documentation
104Edit Edit innodb adaptive flushing DocumentationON
105Edit Edit innodb adaptive flushing lwm Documentation10
106Edit Edit innodb adaptive hash index DocumentationON
107Edit Edit innodb adaptive hash index parts Documentation8
108Edit Edit innodb adaptive max sleep delay Documentation150,000
109Edit Edit innodb api bk commit interval Documentation5
110Edit Edit innodb api disable rowlock DocumentationOFF
111Edit Edit innodb api enable binlog DocumentationOFF
112Edit Edit innodb api enable mdl DocumentationOFF
113Edit Edit innodb api trx level Documentation0
114Edit Edit innodb autoextend increment Documentation64
115Edit Edit innodb autoinc lock mode Documentation1
116Edit Edit innodb buffer pool chunk size Documentation128 MiB
117Edit Edit innodb buffer pool dump at shutdown DocumentationON
118Edit Edit innodb buffer pool dump now DocumentationOFF
119Edit Edit innodb buffer pool dump pct Documentation25
120Edit Edit innodb buffer pool filename Documentationib_buffer_pool
121Edit Edit innodb buffer pool instances Documentation1
122Edit Edit innodb buffer pool load abort DocumentationOFF
123Edit Edit innodb buffer pool load at startup DocumentationON
124Edit Edit innodb buffer pool load now DocumentationOFF
125Edit Edit innodb buffer pool size Documentation128 MiB
126Edit Edit innodb change buffer max size Documentation25
127Edit Edit innodb change buffering Documentationall
128Edit Edit innodb checksum algorithm Documentationcrc32
129Edit Edit innodb checksums DocumentationON
130Edit Edit innodb cmp per index enabled DocumentationOFF
131Edit Edit innodb commit concurrency Documentation0
132Edit Edit innodb compression failure threshold pct Documentation5
133Edit Edit innodb compression level Documentation6
134Edit Edit innodb compression pad pct max Documentation50
135Edit Edit innodb concurrency tickets Documentation5,000
136Edit Edit innodb data file path Documentationibdata1:12M:autoextend
137Edit Edit innodb data home dir Documentation
138Edit Edit innodb deadlock detectON
139Edit Edit innodb default row formatdynamic
140Edit Edit innodb disable sort file cache DocumentationOFF
141Edit Edit innodb doublewrite DocumentationON
142Edit Edit innodb fast shutdown Documentation1
143Edit Edit innodb file format DocumentationBarracuda
144Edit Edit innodb file format check DocumentationON
145Edit Edit innodb file format max DocumentationBarracuda
146Edit Edit innodb file per table DocumentationON
147Edit Edit innodb fill factor Documentation100
148Edit Edit innodb flush log at timeout Documentation1
149Edit Edit innodb flush log at trx commit Documentation1
150Edit Edit innodb flush method Documentation
151Edit Edit innodb flush neighbors Documentation1
152Edit Edit innodb flush sync DocumentationON
153Edit Edit innodb flushing avg loops Documentation30
154Edit Edit innodb force load corrupted DocumentationOFF
155Edit Edit innodb force recovery Documentation0
156Edit Edit innodb ft aux table Documentation
157Edit Edit innodb ft cache size Documentation8,000,000
158Edit Edit innodb ft enable diag print DocumentationOFF
159Edit Edit innodb ft enable stopword DocumentationON
160Edit Edit innodb ft max token size Documentation84
161Edit Edit innodb ft min token size Documentation3
162Edit Edit innodb ft num word optimize Documentation2,000
163Edit Edit innodb ft result cache limit Documentation2,000,000,000
164Edit Edit innodb ft server stopword table Documentation
165Edit Edit innodb ft sort pll degree Documentation2
166Edit Edit innodb ft total cache size Documentation640,000,000
167Edit Edit innodb ft user stopword table Documentation
168Edit Edit innodb io capacity Documentation200
169Edit Edit innodb io capacity max Documentation2,000
170Edit Edit innodb large prefix DocumentationON
171Edit Edit innodb lock wait timeout Documentation50
172Edit Edit innodb locks unsafe for binlog DocumentationOFF
173Edit Edit innodb log buffer size Documentation16 MiB
174Edit Edit innodb log checksumsON
175Edit Edit innodb log compressed pages DocumentationON
176Edit Edit innodb log file size Documentation48 MiB
177Edit Edit innodb log files in group Documentation2
178Edit Edit innodb log group home dir Documentation./
179Edit Edit innodb log write ahead size Documentation8 KiB
180Edit Edit innodb lru scan depth Documentation1,024
181Edit Edit innodb max dirty pages pct Documentation75
182Edit Edit innodb max dirty pages pct lwm Documentation0
183Edit Edit innodb max purge lag Documentation0
184Edit Edit innodb max purge lag delay Documentation0
185Edit Edit innodb max undo log size Documentation1 GiB
186Edit Edit innodb monitor disable Documentation
187Edit Edit innodb monitor enable Documentation
188Edit Edit innodb monitor reset Documentation
189Edit Edit innodb monitor reset all Documentation
190Edit Edit innodb numa interleaveOFF
191Edit Edit innodb old blocks pct Documentation37
192Edit Edit innodb old blocks time Documentation1,000
193Edit Edit innodb online alter log max size Documentation128 MiB
194Edit Edit innodb open files Documentation2,000
195Edit Edit innodb optimize fulltext only DocumentationOFF
196Edit Edit innodb page cleaners Documentation1
197Edit Edit innodb page size Documentation16 KiB
198Edit Edit innodb print all deadlocks DocumentationOFF
199Edit Edit innodb purge batch size Documentation300
200Edit Edit innodb purge rseg truncate frequency Documentation128
201Edit Edit innodb purge threads Documentation4
202Edit Edit innodb random read ahead DocumentationOFF
203Edit Edit innodb read ahead threshold Documentation56
204Edit Edit innodb read io threads Documentation4
205Edit Edit innodb read only DocumentationOFF
206Edit Edit innodb replication delay Documentation0
207Edit Edit innodb rollback on timeout DocumentationOFF
208Edit Edit innodb rollback segments Documentation128
209Edit Edit innodb sort buffer size Documentation1 MiB
210Edit Edit innodb spin wait delay Documentation6
211Edit Edit innodb stats auto recalc DocumentationON
212Edit Edit innodb stats include delete markedOFF
213Edit Edit innodb stats method Documentationnulls_equal
214Edit Edit innodb stats on metadata DocumentationOFF
215Edit Edit innodb stats persistent DocumentationON
216Edit Edit innodb stats persistent sample pages Documentation20
217Edit Edit innodb stats sample pages Documentation8
218Edit Edit innodb stats transient sample pages Documentation8
219Edit Edit innodb status output DocumentationOFF
220Edit Edit innodb status output locks DocumentationOFF
221Edit Edit innodb strict mode DocumentationON
222Edit Edit innodb support xa DocumentationON
223Edit Edit innodb sync array size Documentation1
224Edit Edit innodb sync spin loops Documentation30
225Edit Edit innodb table locks DocumentationON
226Edit Edit innodb temp data file path Documentationibtmp1:12M:autoextend
227Edit Edit innodb thread concurrency Documentation0
228Edit Edit innodb thread sleep delay Documentation10,000
229Edit Edit innodb tmpdir
230Edit Edit innodb undo directory Documentation./
231Edit Edit innodb undo log truncate DocumentationOFF
232Edit Edit innodb undo logs Documentation128
233Edit Edit innodb undo tablespaces Documentation0
234Edit Edit innodb use native aio DocumentationON
235Edit Edit innodb version Documentation5.7.29
236Edit Edit innodb write io threads Documentation4
237Edit Edit interactive timeout Documentation28,800
238Edit Edit internal tmp disk storage engine DocumentationInnoDB
239Edit Edit join buffer size Documentation256 KiB
240Edit Edit keep files on create DocumentationOFF
241Edit Edit key buffer size Documentation8 MiB
242Edit Edit key cache age threshold Documentation300
243Edit Edit key cache block size Documentation1 KiB
244Edit Edit key cache division limit Documentation100
245Edit Edit keyring operationsON
246Edit Edit large files support DocumentationON
247Edit Edit large page size Documentation0 B
248Edit Edit large pages DocumentationOFF
249Edit Edit lc messages Documentationen_US
250Edit Edit lc messages dir Documentation/usr/share/mysql/
251Edit Edit lc time names Documentationen_US
252Edit Edit license DocumentationGPL
253Edit Edit local infile DocumentationON
254Edit Edit lock wait timeout Documentation31,536,000
255Edit Edit locked in memory DocumentationOFF
256Edit Edit log bin DocumentationOFF
257Edit Edit log bin basename Documentation
258Edit Edit log bin index Documentation
259Edit Edit log bin trust function creators DocumentationOFF
260Edit Edit log bin use v1 row events DocumentationOFF
261Edit Edit log builtin as identified by passwordOFF
262Edit Edit log error Documentationstderr
263Edit Edit log error verbosity Documentation3
264Edit Edit log output DocumentationFILE
265Edit Edit log queries not using indexes DocumentationOFF
266Edit Edit log slave updates DocumentationOFF
267Edit Edit log slow admin statements DocumentationOFF
268Edit Edit log slow slave statements DocumentationOFF
269Edit Edit log statements unsafe for binlogON
270Edit Edit log syslog DocumentationOFF
271Edit Edit log syslog facility Documentationdaemon
272Edit Edit log syslog include pid DocumentationON
273Edit Edit log syslog tag Documentation
274Edit Edit log throttle queries not using indexes Documentation0
275Edit Edit log timestamps DocumentationUTC
276Edit Edit log warnings Documentation2
277Edit Edit long query time Documentation10
278Edit Edit low priority updates DocumentationOFF
279Edit Edit lower case file system DocumentationOFF
280Edit Edit lower case table names Documentation0
281Edit Edit master info repository DocumentationFILE
282Edit Edit master verify checksum DocumentationOFF
283Edit Edit max allowed packet Documentation268,435,456
284Edit Edit max binlog cache size Documentation16 EiB
285Edit Edit max binlog size Documentation1 GiB
286Edit Edit max binlog stmt cache size Documentation16 EiB
287Edit Edit max connect errors Documentation100
288Edit Edit max connections Documentation151
289Edit Edit max delayed threads Documentation20
290Edit Edit max digest length Documentation1,024
291Edit Edit max error count Documentation64
292Edit Edit max execution time Documentation0
293Edit Edit max heap table size Documentation16 MiB
294Edit Edit max insert delayed threads Documentation20
295Edit Edit max join size Documentation18,446,744,073,709,551,616
296Edit Edit max length for sort data Documentation1,024
297Edit Edit max points in geometry Documentation65,536
298Edit Edit max prepared stmt count Documentation16,382
299Edit Edit max relay log size Documentation0 B
300Edit Edit max seeks for key Documentation18,446,744,073,709,551,616
301Edit Edit max sort length Documentation1,024
302Edit Edit max sp recursion depth Documentation0
303Edit Edit max tmp tables Documentation32
304Edit Edit max user connections Documentation0
305(Session value) 2,147,483,647
306Edit Edit max write lock count Documentation18,446,744,073,709,551,616
307Edit Edit metadata locks cache size Documentation1,024
308Edit Edit metadata locks hash instances Documentation8
309Edit Edit min examined row limit Documentation0
310Edit Edit multi range count Documentation256
311Edit Edit myisam data pointer size Documentation6 B
312Edit Edit myisam max sort file size Documentation8 EiB
313Edit Edit myisam mmap size Documentation16 EiB
314Edit Edit myisam recover options DocumentationOFF
315Edit Edit myisam repair threads Documentation1
316Edit Edit myisam sort buffer size Documentation8 MiB
317Edit Edit myisam stats method Documentationnulls_unequal
318Edit Edit myisam use mmap DocumentationOFF
319Edit Edit mysql native password proxy users DocumentationOFF
320Edit Edit net buffer length Documentation16,384
321Edit Edit net read timeout Documentation30
322Edit Edit net retry count Documentation10
323Edit Edit net write timeout Documentation60
324Edit Edit new DocumentationOFF
325Edit Edit ngram token size Documentation2
326Edit Edit offline mode DocumentationOFF
327Edit Edit old DocumentationOFF
328Edit Edit old alter table DocumentationOFF
329Edit Edit old passwords Documentation0
330Edit Edit open files limit Documentation10,000
331Edit Edit optimizer prune level Documentation1
332Edit Edit optimizer search depth Documentation62
333Edit Edit optimizer switch Documentationindex_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on
334Edit Edit optimizer trace Documentationenabled=off,one_line=off
335Edit Edit optimizer trace features Documentationgreedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
336Edit Edit optimizer trace limit Documentation1
337Edit Edit optimizer trace max mem size Documentation16,384
338Edit Edit optimizer trace offset Documentation-1
339Edit Edit parser max mem size18,446,744,073,709,551,616
340Edit Edit performance schema DocumentationOFF
341Edit Edit performance schema accounts size Documentation0
342Edit Edit performance schema digests size Documentation0
343Edit Edit performance schema events stages history long size Documentation0
344Edit Edit performance schema events stages history size Documentation0
345Edit Edit performance schema events statements history long size Documentation0
346Edit Edit performance schema events statements history size Documentation0
347Edit Edit performance schema events transactions history long size Documentation0
348Edit Edit performance schema events transactions history size Documentation0
349Edit Edit performance schema events waits history long size Documentation0
350Edit Edit performance schema events waits history size Documentation0
351Edit Edit performance schema hosts size Documentation0
352Edit Edit performance schema max cond classes Documentation0
353Edit Edit performance schema max cond instances Documentation0
354Edit Edit performance schema max digest length Documentation0
355Edit Edit performance schema max file classes Documentation0
356Edit Edit performance schema max file handles Documentation0
357Edit Edit performance schema max file instances Documentation0
358Edit Edit performance schema max index stat Documentation0
359Edit Edit performance schema max memory classes Documentation0
360Edit Edit performance schema max metadata locks Documentation0
361Edit Edit performance schema max mutex classes Documentation0
362Edit Edit performance schema max mutex instances Documentation0
363Edit Edit performance schema max prepared statements instances Documentation0
364Edit Edit performance schema max program instances Documentation0
365Edit Edit performance schema max rwlock classes Documentation0
366Edit Edit performance schema max rwlock instances Documentation0
367Edit Edit performance schema max socket classes Documentation0
368Edit Edit performance schema max socket instances Documentation0
369Edit Edit performance schema max sql text length Documentation0
370Edit Edit performance schema max stage classes Documentation0
371Edit Edit performance schema max statement classes Documentation0
372Edit Edit performance schema max statement stack Documentation0
373Edit Edit performance schema max table handles Documentation0
374Edit Edit performance schema max table instances Documentation0
375Edit Edit performance schema max table lock stat Documentation0
376Edit Edit performance schema max thread classes Documentation0
377Edit Edit performance schema max thread instances Documentation0
378Edit Edit performance schema session connect attrs size Documentation0
379Edit Edit performance schema setup actors size Documentation0
380Edit Edit performance schema setup objects size Documentation0
381Edit Edit performance schema users size Documentation0
382Edit Edit pid file Documentation/var/run/mysqld/mysqld.pid
383Edit Edit plugin dir Documentation/usr/lib64/mysql/plugin/
384Edit Edit port Documentation3,306
385Edit Edit preload buffer size Documentation32 KiB
386Edit Edit profiling DocumentationOFF
387Edit Edit profiling history size Documentation15
388Edit Edit protocol version Documentation10
389Edit Edit query alloc block size Documentation8 KiB
390Edit Edit query cache limit Documentation1 MiB
391Edit Edit query cache min res unit Documentation4,096
392Edit Edit query cache size Documentation1 MiB
393Edit Edit query cache type DocumentationOFF
394Edit Edit query cache wlock invalidate DocumentationOFF
395Edit Edit query prealloc size Documentation8 KiB
396Edit Edit range alloc block size Documentation4 KiB
397Edit Edit range optimizer max mem size8,388,608
398Edit Edit rbr exec mode DocumentationSTRICT
399Edit Edit read buffer size Documentation128 KiB
400Edit Edit read only DocumentationOFF
401Edit Edit read rnd buffer size Documentation256 KiB
402Edit Edit relay log Documentation
403Edit Edit relay log basename Documentation/var/lib/mysql/server-relay-bin
404Edit Edit relay log index Documentation/var/lib/mysql/server-relay-bin.index
405Edit Edit relay log info file Documentationrelay-log.info
406Edit Edit relay log info repository DocumentationFILE
407Edit Edit relay log purge DocumentationON
408Edit Edit relay log recovery DocumentationOFF
409Edit Edit relay log space limit Documentation0
410Edit Edit report host Documentation
411Edit Edit report password Documentation
412Edit Edit report port Documentation3,306
413Edit Edit report user Documentation
414Edit Edit require secure transport DocumentationOFF
415Edit Edit rpl stop slave timeout Documentation31,536,000
416Edit Edit secure auth DocumentationON
417Edit Edit secure file priv Documentation/var/lib/mysql-files/
418Edit Edit server id Documentation0
419Edit Edit server id bits Documentation32
420Edit Edit server uuid Documentationce19b1e4-3c3a-11e8-a645-fa163e247920
421Edit Edit session track gtids DocumentationOFF
422Edit Edit session track schema DocumentationON
423Edit Edit session track state change DocumentationOFF
424Edit Edit session track system variables Documentationtime_zone,autocommit,character_set_client,character_set_results,character_set_connection
425Edit Edit session track transaction info DocumentationOFF
426Edit Edit sha256 password auto generate rsa keysON
427Edit Edit sha256 password private key pathprivate_key.pem
428Edit Edit sha256 password proxy users DocumentationOFF
429Edit Edit sha256 password public key pathpublic_key.pem
430Edit Edit show compatibility 56 DocumentationOFF
431Edit Edit show create table verbosityOFF
432Edit Edit show old temporals DocumentationOFF
433Edit Edit skip external locking DocumentationON
434Edit Edit skip name resolve DocumentationOFF
435Edit Edit skip networking DocumentationOFF
436Edit Edit skip show database DocumentationOFF
437Edit Edit slave allow batching DocumentationOFF
438Edit Edit slave checkpoint group Documentation512
439Edit Edit slave checkpoint period Documentation300
440Edit Edit slave compressed protocol DocumentationOFF
441Edit Edit slave exec mode DocumentationSTRICT
442Edit Edit slave load tmpdir Documentation/tmp
443Edit Edit slave max allowed packet Documentation1,073,741,824
444Edit Edit slave net timeout Documentation60
445Edit Edit slave parallel type DocumentationDATABASE
446Edit Edit slave parallel workers Documentation0
447Edit Edit slave pending jobs size max Documentation16 MiB
448Edit Edit slave preserve commit order DocumentationOFF
449Edit Edit slave rows search algorithms DocumentationTABLE_SCAN,INDEX_SCAN
450Edit Edit slave skip errors DocumentationOFF
451Edit Edit slave sql verify checksum DocumentationON
452Edit Edit slave transaction retries Documentation10
453Edit Edit slave type conversions Documentation
454Edit Edit slow launch time Documentation2
455Edit Edit slow query log DocumentationOFF
456Edit Edit slow query log file Documentation/var/lib/mysql/server-slow.log
457Edit Edit socket Documentation/var/lib/mysql/mysql.sock
458Edit Edit sort buffer size Documentation256 KiB
459Edit Edit sql auto is null DocumentationOFF
460Edit Edit sql big selects DocumentationON
461Edit Edit sql buffer result DocumentationOFF
462Edit Edit sql log off DocumentationOFF
463Edit Edit sql mode DocumentationONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
464Edit Edit sql notes DocumentationON
465Edit Edit sql quote show create DocumentationON
466Edit Edit sql safe updates DocumentationOFF
467Edit Edit sql select limit Documentation18,446,744,073,709,551,616
468Edit Edit sql slave skip counter Documentation0
469Edit Edit sql warnings DocumentationOFF
470Edit Edit ssl ca Documentationca.pem
471Edit Edit ssl capath Documentation
472Edit Edit ssl cert Documentationserver-cert.pem
473Edit Edit ssl cipher Documentation
474Edit Edit ssl crl Documentation
475Edit Edit ssl crlpath Documentation
476Edit Edit ssl key Documentationserver-key.pem
477Edit Edit stored program cache Documentation256
478Edit Edit super read only DocumentationOFF
479Edit Edit sync binlog Documentation1
480Edit Edit sync frm DocumentationON
481Edit Edit sync master info Documentation10,000
482Edit Edit sync relay log Documentation10,000
483Edit Edit sync relay log info Documentation10,000
484Edit Edit system time zone DocumentationMST
485Edit Edit table definition cache Documentation1,400
486Edit Edit table open cache Documentation2,000
487Edit Edit table open cache instances Documentation16
488Edit Edit thread cache size Documentation9
489Edit Edit thread handling Documentationone-thread-per-connection
490Edit Edit thread stack Documentation262,144
491Edit Edit time format Documentation%H:%i:%s
492Edit Edit time zone DocumentationSYSTEM
493Edit Edit tls versionTLSv1,TLSv1.1,TLSv1.2
494Edit Edit tmp table size Documentation16 MiB
495Edit Edit tmpdir Documentation/tmp
496Edit Edit transaction alloc block size Documentation8 KiB
497Edit Edit transaction isolationREPEATABLE-READ
498Edit Edit transaction prealloc size Documentation4 KiB
499Edit Edit transaction read onlyOFF
500Edit Edit transaction write set extraction DocumentationOFF
501Edit Edit tx isolation DocumentationREPEATABLE-READ
502Edit Edit tx read only DocumentationOFF
503Edit Edit unique checks DocumentationON
504Edit Edit updatable views with limit DocumentationYES
505Edit Edit version Documentation5.7.29
506Edit Edit version comment DocumentationMySQL Community Server (GPL)
507Edit Edit version compile machine Documentationx86_64
508Edit Edit version compile os DocumentationLinux
509Edit Edit wait timeout Documentation28,800