1
ropts = [ { 'caption': 'federated',
2
'description': 'Enables the FEDERATED storage engine',
4
'values': [{ 'type': 'numeric'}],
5
'versions': [ ((5, 1, 26), (6, 0, 7)),
6
((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
8
{ 'caption': 'abort-slave-event-count',
9
'description': 'Option used by mysql-test for debugging and testing of replication',
10
'name': 'abort-slave-event-count',
11
'values': [{ 'default': '0', 'minimum': '0', 'type': 'numeric'}],
13
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
15
{ 'caption': 'allow-suspicious-udfs',
16
'description': 'Allows use of UDFs consisting of only one symbol xxx() without corresponding xxx_init() or xxx_deinit()',
17
'name': 'allow-suspicious-udfs',
18
'values': [ { 'default': 'false',
22
'versions': [ ((4, 1, 10), (5, 0, 3)),
23
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
26
'description': 'Use ANSI SQL syntax instead of MySQL syntax',
28
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
30
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
32
{ 'caption': 'auto_increment_increment',
33
'description': 'AUTO_INCREMENT columns are incremented by this value',
34
'name': 'auto_increment_increment',
35
'values': [ { 'default': '1',
39
'versions': [ ((5, 0, 2),),
40
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
42
{ 'caption': 'auto_increment_offset',
43
'description': 'Offset added to AUTO_INCREMENT columns',
44
'name': 'auto_increment_offset',
45
'values': [ { 'default': '1',
49
'versions': [ ((5, 0, 2),),
50
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
52
{ 'caption': 'autocommit',
53
'description': 'Sets the autocommit mode',
55
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
57
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
59
{ 'caption': 'backup_elevation',
60
'description': 'Enable or disable BACKUP DATABASE privilege elevation',
61
'name': 'backup_elevation',
62
'values': [ { 'default': 'on',
66
'versions': [((6, 0, 14),), ((5, 6), (6, 0)), ()]},
67
{ 'caption': 'backup_history_log',
68
'description': 'Enable or disable MySQL Backup history log',
69
'name': 'backup_history_log',
70
'values': [ { 'default': 'on',
74
'versions': [((6, 0, 8),), ((5, 6), (6, 0)), ()]},
75
{ 'caption': 'backup_history_log_file',
76
'description': 'Name of the MySQL Backup history log file',
77
'name': 'backup_history_log_file',
78
'values': [{ 'default': 'backup_history.log', 'type': 'filename'}],
79
'versions': [((6, 0, 8),), ((5, 6), (6, 0)), ()]},
80
{ 'caption': 'backup_progress_log',
81
'description': 'Enable or disable MySQL Backup progress log',
82
'name': 'backup_progress_log',
83
'values': [ { 'default': 'on',
87
'versions': [((6, 0, 8),), ((5, 6), (6, 0)), ()]},
88
{ 'caption': 'backup_progress_log_file',
89
'description': 'Name of the MySQL Backup progress log file',
90
'name': 'backup_progress_log_file',
91
'values': [{ 'default': 'backup_progress.log', 'type': 'filename'}],
92
'versions': [((6, 0, 8),), ((5, 6), (6, 0)), ()]},
93
{ 'caption': 'back_log',
94
'description': 'The number of outstanding connection requests MySQL can have',
96
'values': [ { 'default': '50',
101
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
103
{ 'caption': 'backupdir',
104
'description': 'Default backup image file directory',
106
'values': [{ 'type': 'filename'}],
107
'versions': [((6, 0, 7),), ((5, 6), (6, 0)), ()]},
108
{ 'caption': 'basedir',
109
'description': 'Path to installation directory',
111
'values': [{ 'type': 'filename'}],
113
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
115
{ 'caption': 'big-tables',
116
'description': 'Allow big result sets by saving all temporary sets on file',
117
'name': 'big-tables',
118
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
120
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
122
{ 'caption': 'bind-address',
123
'description': 'IP address or host name to bind to',
124
'name': 'bind-address',
125
'optype': { 'format': 'bind-address=name'},
126
'values': [ { 'default': '0.0.0.0',
127
'maximum': '255.255.255.255',
128
'minimum': '0.0.0.0',
131
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
133
{ 'caption': 'binlog-do-db',
134
'description': 'Limits binary logging to specific databases',
135
'name': 'binlog-do-db',
136
'values': [{ 'type': 'string'}],
138
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
140
{ 'caption': 'binlog-ignore-db',
141
'description': 'Tells the master that updates to the given database should not be logged to the binary log',
142
'name': 'binlog-ignore-db',
143
'values': [{ 'type': 'string'}],
145
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
147
{ 'caption': 'binlog-row-event-max-size',
148
'description': 'Binary log max event size',
149
'name': 'binlog-row-event-max-size',
150
'values': [ { 'bitsize': '32',
152
'maximum': '4294967295',
157
'maximum': '18446744073709547520',
160
'versions': [((5, 1, 5),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
161
{ 'caption': 'binlog_cache_size',
162
'description': 'The size of the cache to hold the SQL statements for the binary log during a transaction',
163
'name': 'binlog_cache_size',
164
'values': [ { 'bitsize': '32',
166
'maximum': '4294967295',
171
'maximum': '18446744073709547520',
175
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
177
{ 'caption': 'binlog_stmt_cache_size',
178
'description': 'The size of the cache to hold nontransactional statements for the binary log during a transaction',
179
'name': 'binlog_stmt_cache_size',
180
'values': [ { 'bitsize': '32',
182
'maximum': '4294967295',
187
'maximum': '18446744073709547520',
190
'versions': [((5, 5, 9), (5, 6, 1)), ((5, 5), (5, 6)), ()]},
191
{ 'caption': 'binlog-format',
192
'description': 'Specifies the format of the binary log',
193
'name': 'binlog-format',
194
'optype': { 'format': 'binlog-format=format'},
195
'values': [ { 'choice': ['ROW', 'STATEMENT'],
196
'default': 'STATEMENT',
197
'inversion': (5, 1, 5),
198
'outversion': (5, 1, 7),
200
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
201
'default': 'STATEMENT',
202
'inversion': (5, 1, 8),
203
'outversion': (5, 1, 11),
205
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
207
'inversion': (5, 1, 12),
208
'outversion': (5, 1, 28),
210
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
212
'inversion': (5, 1, 14),
214
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
216
'inversion': (5, 1, 16),
218
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
220
'inversion': (5, 1, 19),
222
{ 'choice': ['ROW', 'STATEMENT', 'MIXED'],
223
'default': 'STATEMENT',
224
'inversion': (5, 1, 29),
226
'versions': [((5, 1, 5),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
227
{ 'caption': 'binlog_direct_non_transactional_updates',
228
'description': 'Causes updates using statement format to nontransactional engines to be written directly to binary log. See documentation before using.',
229
'name': 'binlog_direct_non_transactional_updates',
230
'values': [ { 'default': 'off',
234
'versions': [ ((5, 1, 44), (5, 5, 2), (6, 0, 14)),
235
((5, 1), (5, 5), (5, 6), (6, 0)),
237
{ 'caption': 'bootstrap',
238
'description': 'Used by mysql installation scripts',
240
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
242
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
244
{ 'caption': 'bulk_insert_buffer_size',
245
'description': 'Size of tree cache used in bulk insert optimization',
246
'name': 'bulk_insert_buffer_size',
247
'values': [ { 'bitsize': '32',
248
'default': '8388608',
249
'maximum': '4294967295',
253
'default': '8388608',
254
'maximum': '18446744073709547520',
258
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
260
{ 'caption': 'character-set-client-handshake',
261
'description': "Don't ignore client side character set value sent during handshake",
262
'name': 'character-set-client-handshake',
263
'values': [ { 'default': 'true',
267
'versions': [ ((4, 1, 15),),
268
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
270
{ 'caption': 'character-set-filesystem',
271
'description': 'Set the file system character set',
272
'name': 'character-set-filesystem',
273
'values': [{ 'type': 'string'}],
274
'versions': [ ((5, 0, 19), (5, 1, 6)),
275
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
277
{ 'caption': 'character-set-server',
278
'description': 'Set the default character set',
279
'name': 'character-set-server',
280
'values': [{ 'type': 'string'}],
281
'versions': [ ((4, 1, 3),),
282
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
284
{ 'caption': 'character-sets-dir',
285
'description': 'Directory where character sets are',
286
'name': 'character-sets-dir',
287
'optype': { 'format': 'character-sets-dir=path'},
288
'values': [{ 'type': 'dirname'}],
289
'versions': [ ((4, 1, 2),),
290
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
292
{ 'caption': 'chroot',
293
'description': 'Chroot mysqld daemon during startup',
295
'values': [{ 'type': 'filename'}],
297
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
299
{ 'caption': 'collation-server',
300
'description': 'Set the default collation',
301
'name': 'collation-server',
302
'values': [{ 'type': 'string'}],
303
'versions': [ ((4, 1, 1),),
304
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
306
{ 'caption': 'completion_type',
307
'description': 'Default completion type',
308
'name': 'completion_type',
309
'values': [ { 'choice': ['0', '1', '2'],
311
'inversion': (5, 0, 3),
312
'outversion': (5, 5, 2),
314
{ 'choice': ['NO_CHAIN', 'CHAIN', 'RELEASE', '0', '1', '2'],
315
'default': 'NO_CHAIN',
316
'inversion': (5, 5, 3),
318
{ 'choice': ['0', '1', '2'],
320
'inversion': (6, 0, 0),
321
'outversion': (6, 0, 14),
323
{ 'choice': ['NO_CHAIN', 'CHAIN', 'RELEASE', '0', '1', '2'],
324
'default': 'NO_CHAIN',
325
'inversion': (6, 0, 14),
327
'versions': [ ((5, 0, 3),),
328
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
330
{ 'caption': 'concurrent_insert',
331
'description': 'Use concurrent insert with MyISAM',
332
'disabledby': 'skip-concurrent-insert',
333
'name': 'concurrent_insert',
334
'values': [ { 'default': 'true',
337
'outversion': (5, 0, 5),
339
{ 'choice': ['0', '1', '2'],
341
'inversion': (5, 0, 6),
342
'outversion': (5, 5, 2),
344
{ 'choice': ['NEVER', 'AUTO', 'ALWAYS', '0', '1', '2'],
346
'inversion': (5, 5, 3),
348
{ 'choice': ['0', '1', '2'],
350
'inversion': (6, 0, 0),
351
'outversion': (6, 0, 14),
353
{ 'choice': ['NEVER', 'AUTO', 'ALWAYS', '0', '1', '2'],
355
'inversion': (6, 0, 14),
358
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
360
{ 'caption': 'connect_timeout',
361
'description': "The number of seconds the mysqld server waits for a connect packet before responding with 'Bad handshake'",
362
'name': 'connect_timeout',
363
'values': [ { 'default': '5',
365
'outversion': (5, 0, 51),
368
'inversion': (5, 0, 52),
371
'outversion': (5, 1, 22),
374
'inversion': (5, 1, 23),
377
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
379
{ 'caption': 'console',
380
'description': 'Write error output on screen; do not remove the console window on Windows',
382
'values': [ { 'off': '0',
384
'platform': 'windows',
387
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
389
{ 'caption': 'core-file',
390
'description': 'Write core on errors',
392
'values': [ { 'default': 'false',
397
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
399
{ 'caption': 'datadir',
400
'description': 'Path to the database root',
402
'values': [{ 'type': 'filename'}],
404
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
406
{ 'caption': 'debug-sync-timeout',
407
'description': 'Timeout for Debug Sync synchronization points',
408
'name': 'debug-sync-timeout',
409
'values': [{ 'type': 'numeric'}],
410
'versions': [ ((5, 1, 41), (6, 0, 6)),
411
((5, 1), (5, 5), (5, 6), (6, 0)),
413
{ 'caption': 'default-character-set',
414
'deprecated': (5, 0),
415
'description': 'Set the default character set',
416
'name': 'default-character-set',
417
'optype': { 'format': 'default-character-set=name'},
418
'values': [{ 'type': 'string'}],
419
'versions': [((4, 1, 3),), ((4, 1), (5, 0)), ()]},
420
{ 'caption': 'default-collation',
421
'deprecated': (4, 1, 3),
422
'description': 'Set the default collation',
423
'name': 'default-collation',
424
'optype': { 'format': 'default-collation=name'},
425
'values': [{ 'type': 'string'}],
426
'versions': [(), ((4, 1),), ()]},
427
{ 'caption': 'default-storage-engine',
428
'description': 'Set the default storage engine (table type) for tables',
429
'name': 'default-storage-engine',
430
'values': [ { 'default': 'MyISAM',
431
'outversion': (5, 5, 4),
433
{ 'default': 'InnoDB',
434
'inversion': (5, 5, 5),
436
{ 'default': 'MyISAM',
437
'inversion': (6, 0, 0),
439
'versions': [ ((4, 1, 2),),
440
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
442
{ 'caption': 'default-table-type',
443
'deprecated': (5, 0),
444
'description': 'This option is a synonym for --default-storage-engine',
445
'name': 'default-table-type',
446
'values': [{ 'type': 'string'}],
447
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (6, 0)), ((6, 0, 8),)]},
448
{ 'caption': 'default-time-zone',
449
'description': 'Set the default time zone',
450
'name': 'default-time-zone',
451
'values': [{ 'type': 'string'}],
452
'versions': [ ((4, 1, 3),),
453
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
455
{ 'caption': 'default_week_format',
456
'description': 'The default week format used by WEEK() functions',
457
'name': 'default_week_format',
458
'values': [ { 'default': '0',
463
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
465
{ 'caption': 'delay-key-write',
466
'description': 'Type of DELAY_KEY_WRITE',
467
'name': 'delay-key-write',
468
'values': [ { 'choice': ['ON', 'OFF', 'ALL'],
472
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
474
{ 'caption': 'delayed_insert_limit',
475
'description': 'After inserting delayed_insert_limit rows, the INSERT DELAYED handler will check if there are any SELECT statements pending. If so, it allows these to execute before continuing',
476
'name': 'delayed_insert_limit',
477
'values': [ { 'bitsize': '32',
479
'maximum': '4294967295',
484
'maximum': '18446744073709547520',
488
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
490
{ 'caption': 'delayed_insert_timeout',
491
'description': 'How many seconds an INSERT DELAYED thread should wait for INSERT statements before terminating',
492
'name': 'delayed_insert_timeout',
493
'values': [{ 'default': '300', 'type': 'numeric'}],
495
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
497
{ 'caption': 'delayed_queue_size',
498
'description': 'What size queue (in rows) should be allocated for handling INSERT DELAYED',
499
'name': 'delayed_queue_size',
500
'values': [ { 'bitsize': '32',
502
'maximum': '4294967295',
507
'maximum': '18446744073709547520',
511
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
513
{ 'caption': 'des-key-file',
514
'description': 'Load keys for des_encrypt() and des_encrypt from given file',
515
'name': 'des-key-file',
516
'optype': { 'format': 'des-key-file=file_name'},
519
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
521
{ 'caption': 'disconnect-slave-event-count',
522
'description': 'Option used by mysql-test for debugging and testing of replication',
523
'name': 'disconnect-slave-event-count',
524
'values': [{ 'default': '0', 'type': 'numeric'}],
526
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
528
{ 'caption': 'div_precision_increment',
529
'description': "Scale of the result of '/' operator will be increased by this many digits",
530
'name': 'div_precision_increment',
531
'values': [ { 'default': '4',
535
'versions': [ ((5, 0, 6),),
536
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
538
{ 'caption': 'enable-locking',
539
'deprecated': (4, 0, 3),
540
'description': 'Deprecated option, use --external-locking instead',
541
'name': 'enable-locking',
542
'values': [ { 'default': 'false',
547
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
549
{ 'caption': 'enable-pstack',
550
'deprecated': (5, 1, 54),
551
'description': 'Print a symbolic stack trace on failure',
552
'name': 'enable-pstack',
553
'values': [ { 'default': 'false',
558
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)),
560
{ 'caption': 'engine-condition-pushdown',
561
'deprecated': (5, 5, 3),
562
'description': 'Push supported query conditions to the storage engine',
563
'name': 'engine-condition-pushdown',
564
'values': [ { 'default': 'off',
565
'inversion': (5, 0, 3),
570
'inversion': (5, 1, 0),
574
'versions': [ ((5, 0, 3),),
575
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
577
{ 'caption': 'event-scheduler',
578
'description': 'Enable/disable and start/stop the event scheduler. Note that this variable underwent significant changes in behavior and permitted values in MySQL 5.1.11 and 5.1.12',
579
'name': 'event-scheduler',
580
'values': [ { 'choice': ['ON', 'OFF', 'DISABLED'],
583
'versions': [((5, 1, 6),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
584
{ 'caption': 'exit-info',
585
'description': 'Used for debugging; Use at your own risk!',
587
'values': [{ 'type': 'numeric'}],
589
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
591
{ 'caption': 'expire_logs_days',
592
'description': 'If nonzero, binary logs will be purged after expire_logs_days days; possible purges happen at startup and at binary log rotation',
593
'name': 'expire_logs_days',
594
'values': [ { 'default': '0',
599
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
601
{ 'caption': 'external-locking',
602
'description': 'Use system (external) locking',
603
'disabledby': 'skip-external-locking',
604
'name': 'external-locking',
605
'values': [ { 'default': 'false',
610
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
612
{ 'caption': 'flush',
613
'description': 'Flush tables to disk between SQL statements',
615
'values': [ { 'default': 'off',
620
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
622
{ 'caption': 'flush_time',
623
'description': 'A dedicated thread is created to flush all tables at the given interval',
624
'name': 'flush_time',
625
'values': [ { 'default': '0', 'minimum': '0', 'type': 'numeric'},
628
'platform': 'windows',
631
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
633
{ 'caption': 'ft_boolean_syntax',
634
'description': 'List of operators for MATCH ... AGAINST ( ... IN BOOLEAN MODE)',
635
'name': 'ft_boolean_syntax',
636
'values': [{ 'default': '+-><()~*:""&', 'type': 'string'}],
638
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
640
{ 'caption': 'ft_max_word_len',
641
'description': 'The maximum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable',
642
'name': 'ft_max_word_len',
643
'values': [{ 'minimum': '10', 'type': 'numeric'}],
645
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
647
{ 'caption': 'ft_min_word_len',
648
'description': 'The minimum length of the word to be included in a FULLTEXT index. Note: FULLTEXT indexes must be rebuilt after changing this variable',
649
'name': 'ft_min_word_len',
650
'values': [{ 'default': '4', 'minimum': '1', 'type': 'numeric'}],
652
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
654
{ 'caption': 'ft_query_expansion_limit',
655
'description': 'Number of best matches to use for query expansion',
656
'name': 'ft_query_expansion_limit',
657
'values': [ { 'default': '20',
661
'versions': [ ((4, 1, 1),),
662
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
664
{ 'caption': 'ft_stopword_file',
665
'description': 'Use stopwords from this file instead of built-in list',
666
'name': 'ft_stopword_file',
667
'optype': { 'format': 'ft_stopword_file=file_name'},
668
'values': [{ 'type': 'filename'}],
669
'versions': [ ((4, 1, 10),),
670
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
673
'description': 'Set up signals usable for debugging',
675
'values': [ { 'default': 'false',
680
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
682
{ 'caption': 'general-log',
683
'description': 'Enable|disable general log',
684
'name': 'general-log',
685
'values': [ { 'default': 'off',
689
'versions': [((5, 1, 12),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
690
{ 'caption': 'general_log_file',
691
'description': 'Name of the general query log file',
692
'name': 'general_log_file',
693
'optype': { 'inversion': '5.1.29'},
694
'values': [{ 'default': 'host_name.log', 'type': 'filename'}],
695
'versions': [((5, 1, 12),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
696
{ 'caption': 'group_concat_max_len',
697
'description': 'The maximum length of the result of function group_concat',
698
'name': 'group_concat_max_len',
699
'values': [ { 'bitsize': '32',
701
'maximum': '4294967295',
706
'maximum': '18446744073709547520',
709
'versions': [ ((4, 1, 10),),
710
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
712
{ 'caption': 'ignore-builtin-innodb',
713
'description': 'Ignore the built-in InnoDB',
714
'name': 'ignore-builtin-innodb',
715
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
716
'versions': [((5, 1, 33),), ((5, 1), (5, 4), (5, 5), (5, 6)), ()]},
717
{ 'caption': 'init_connect',
718
'description': 'Statements that are executed for each new connection',
719
'name': 'init_connect',
720
'values': [{ 'type': 'string'}],
721
'versions': [ ((4, 1, 2),),
722
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
724
{ 'caption': 'init-file',
725
'description': 'Read SQL statements from this file at startup',
727
'optype': { 'format': 'init-file=file_name'},
728
'values': [{ 'type': 'filename'}],
730
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
732
{ 'caption': 'init-rpl-role',
733
'description': 'Set the replication role (not used)',
734
'name': 'init-rpl-role',
735
'values': [{ 'type': 'string'}],
736
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)), ()]},
737
{ 'caption': 'init_slave',
738
'description': 'Command(s) that are executed when a slave connects to a master',
739
'name': 'init_slave',
740
'values': [{ 'type': 'string'}],
741
'versions': [ ((4, 1, 2),),
742
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
744
{ 'caption': 'innodb',
745
'description': 'Enable InnoDB (if this version of MySQL supports it)',
747
'values': [ { 'off': '0',
749
'outversion': (5, 1, 35),
751
{ 'choice': ['OFF', 'ON', 'FORCE'],
752
'inversion': (5, 1, 36),
754
{ 'inversion': (5, 4, 0),
757
'outversion': (5, 4, 1),
759
{ 'choice': ['OFF', 'ON', 'FORCE'],
760
'inversion': (5, 4, 2),
762
{ 'inversion': (6, 0, 0),
767
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
769
{ 'caption': 'innodb_adaptive_flushing',
770
'description': 'Control InnoDB adaptive flushing of dirty pages',
771
'name': 'innodb_adaptive_flushing',
772
'values': [ { 'default': 'on',
776
'versions': [ ((5, 1, 38), (5, 4, 2)),
777
((5, 1), (5, 4), (5, 5), (5, 6)),
779
{ 'caption': 'innodb_adaptive_hash_index',
780
'description': 'Enable or disable InnoDB adaptive hash indexes',
781
'name': 'innodb_adaptive_hash_index',
782
'values': [ { 'default': 'on',
786
'versions': [ ((5, 0, 52), (5, 1, 24), (6, 0, 5)),
787
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
789
{ 'caption': 'innodb_additional_mem_pool_size',
790
'description': 'Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures',
791
'name': 'innodb_additional_mem_pool_size',
792
'values': [ { 'default': '1048576',
793
'maximum': '4294967295',
796
{ 'default': '8388608',
797
'inversion': (5, 4, 0),
798
'maximum': '4294967295',
799
'minimum': '2097152',
801
{ 'default': '1048576',
802
'inversion': (6, 0, 0),
803
'maximum': '4294967295',
807
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
809
{ 'caption': 'innodb_autoextend_increment',
810
'description': 'Data file autoextend increment in megabytes',
811
'name': 'innodb_autoextend_increment',
812
'values': [ { 'default': '8',
817
'inversion': (5, 4, 0),
820
'outversion': (5, 4, 2),
823
'inversion': (5, 4, 3),
827
'versions': [ ((4, 1, 5),),
828
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
830
{ 'caption': 'innodb_autoinc_lock_mode',
831
'description': 'Set InnoDB auto-increment lock mode',
832
'name': 'innodb_autoinc_lock_mode',
833
'values': [ { 'choice': ['0', '1', '2'],
836
'versions': [((5, 1, 22),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
837
{ 'caption': 'innodb_buffer_pool_awe_mem_mb',
838
'description': 'If Windows AWE is used, the size in Megabytes of InnoDB buffer pool allocated from the AWE memory',
839
'name': 'innodb_buffer_pool_awe_mem_mb',
840
'values': [ { 'default': '0',
843
'platform': 'windows',
845
'versions': [(), ((4, 1), (5, 0), (5, 1)), ((5, 1, 13),)]},
846
{ 'caption': 'innodb_buffer_pool_instances',
848
'name': 'innodb_buffer_pool_instances',
849
'values': [ { 'default': '1',
853
'versions': [((5, 5, 4),), ((5, 5),), ()]},
854
{ 'caption': 'innodb_buffer_pool_size',
855
'description': 'The size of the memory buffer InnoDB uses to cache data and indexes of its tables',
856
'name': 'innodb_buffer_pool_size',
857
'values': [ { 'bitsize': '32',
858
'default': '134217728',
859
'maximum': '2**32-1',
860
'minimum': '1048576',
863
'default': '134217728',
864
'maximum': '2**64-1',
865
'minimum': '1048576',
868
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
870
{ 'caption': 'innodb_change_buffering',
871
'description': 'Whether InnoDB performs insert buffering.',
872
'name': 'innodb_change_buffering',
873
'values': [ { 'choice': ['inserts', 'none'],
874
'default': 'inserts',
875
'outversion': (5, 5, 3),
877
{ 'choice': [ 'inserts',
884
'inversion': (5, 5, 4),
886
'versions': [ ((5, 1, 38), (5, 4, 2)),
887
((5, 1), (5, 4), (5, 5), (5, 6)),
889
{ 'caption': 'innodb_checksums',
890
'description': 'Enable InnoDB checksums validation',
891
'name': 'innodb_checksums',
892
'values': [ { 'default': 'on',
896
'versions': [ ((5, 0, 3),),
897
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
899
{ 'caption': 'innodb_commit_concurrency',
900
'description': 'Helps in performance tuning in heavily concurrent environments',
901
'name': 'innodb_commit_concurrency',
902
'values': [ { 'default': '0',
906
'versions': [ ((5, 0, 12),),
907
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
909
{ 'caption': 'innodb_concurrency_tickets',
910
'description': 'Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket',
911
'name': 'innodb_concurrency_tickets',
912
'values': [ { 'default': '500',
913
'maximum': '4294967295',
916
'versions': [ ((5, 0, 3),),
917
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
919
{ 'caption': 'innodb_data_file_path',
920
'description': 'Path to individual files and their sizes',
921
'name': 'innodb_data_file_path',
922
'values': [{ 'type': 'filename'}],
924
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
926
{ 'caption': 'innodb_data_home_dir',
927
'description': 'The common part for InnoDB table spaces',
928
'name': 'innodb_data_home_dir',
929
'values': [{ 'type': 'filename'}],
931
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
933
{ 'caption': 'innodb_doublewrite',
934
'description': 'Enable InnoDB doublewrite buffer',
935
'name': 'innodb_doublewrite',
936
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
937
'versions': [ ((5, 0, 3),),
938
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
940
{ 'caption': 'innodb_extra_dirty_writes',
941
'description': 'Whether to flush dirty buffer pages when the percentage of dirty pages is less than the maximum dirty percent',
942
'name': 'innodb_extra_dirty_writes',
943
'values': [ { 'default': 'on',
947
'versions': [(), ((5, 4),), ((5, 4, 2),)]},
948
{ 'caption': 'innodb_fast_shutdown',
949
'description': 'Speeds up the shutdown process of the InnoDB storage engine',
950
'name': 'innodb_fast_shutdown',
951
'values': [ { 'choice': ['0', '1', '2'],
955
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
957
{ 'caption': 'innodb_file_format',
958
'description': 'The format for new InnoDB tables',
959
'name': 'innodb_file_format',
960
'values': [ { 'default': 'Antelope',
961
'inversion': (5, 1, 38),
963
{ 'choice': ['Antelope', 'Barracuda'],
964
'default': 'Barracuda',
965
'inversion': (5, 5, 0),
966
'outversion': (5, 5, 6),
968
{ 'choice': ['Antelope', 'Barracuda'],
969
'default': 'Antelope',
970
'inversion': (5, 5, 7),
972
{ 'choice': ['Antelope', 'Barracuda'],
973
'default': 'Antelope',
974
'inversion': (5, 6, 1),
976
'versions': [ ((5, 1, 38), (5, 4, 2)),
977
((5, 1), (5, 4), (5, 5), (5, 6)),
979
{ 'caption': 'innodb_file_format_check',
980
'description': 'Whether InnoDB performs file format compatibility checking',
981
'name': 'innodb_file_format_check',
982
'values': [ { 'default': 'Antelope',
983
'outversion': (5, 1, 41),
985
{ 'default': 'Barracuda',
986
'inversion': (5, 1, 42),
988
{ 'default': 'Antelope',
989
'outversion': (5, 5, 0),
991
{ 'default': 'Barracuda',
992
'inversion': (5, 5, 4),
995
'inversion': (5, 5, 5),
999
'versions': [ ((5, 1, 38), (5, 4, 2)),
1000
((5, 1), (5, 4), (5, 5), (5, 6)),
1002
{ 'caption': 'innodb_file_format_max',
1003
'description': 'The file format tag in the shared tablespace',
1004
'name': 'innodb_file_format_max',
1005
'values': [ { 'choice': ['Antelope', 'Barracuda'],
1006
'default': 'Antelope',
1008
'versions': [((5, 5, 5),), ((5, 5), (5, 6)), ()]},
1009
{ 'caption': 'innodb_file_io_threads',
1010
'description': 'Number of file I/O threads in InnoDB',
1011
'name': 'innodb_file_io_threads',
1012
'values': [ { 'default': '4',
1015
'type': 'numeric'}],
1016
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ()]},
1017
{ 'caption': 'innodb_file_per_table',
1018
'description': 'Stores each InnoDB table to an .ibd file in the database dir',
1019
'name': 'innodb_file_per_table',
1020
'values': [ { 'default': 'off',
1021
'inversion': (4, 1, 1),
1026
'inversion': (5, 5, 0),
1029
'outversion': (5, 5, 6),
1032
'inversion': (5, 5, 7),
1037
'inversion': (5, 6, 1),
1040
'type': 'boolean'}],
1041
'versions': [ ((4, 1, 1),),
1042
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1044
{ 'caption': 'innodb_flush_log_at_trx_commit',
1045
'description': 'Set to 0 (write and flush once per second), 1 (write and flush at each commit) or 2 (write at commit, flush once per second)',
1046
'name': 'innodb_flush_log_at_trx_commit',
1047
'values': [ { 'choice': ['0', '1', '2'],
1049
'type': 'numeric'}],
1051
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1053
{ 'caption': 'innodb_flush_method',
1054
'description': 'With which method to flush data',
1055
'name': 'innodb_flush_method',
1056
'values': [ { 'default': 'async_unbuffered',
1057
'platform': 'windows',
1059
{ 'choice': ['fdatasync', 'O_DSYNC', 'O_DIRECT'],
1060
'default': 'fdatasync',
1061
'outversion': (5, 1, 23),
1062
'platform': 'linux',
1064
{ 'choice': ['O_DSYNC', 'O_DIRECT'],
1065
'default': 'fdatasync',
1066
'inversion': (5, 1, 24),
1067
'platform': 'linux',
1069
{ 'choice': ['fdatasync', 'O_DSYNC', 'O_DIRECT'],
1070
'default': 'fdatasync',
1071
'outversion': (5, 1, 23),
1074
{ 'choice': ['O_DSYNC', 'O_DIRECT'],
1075
'default': 'fdatasync',
1076
'inversion': (5, 1, 24),
1079
{ 'choice': ['fdatasync', 'O_DSYNC', 'O_DIRECT'],
1080
'default': 'fdatasync',
1081
'outversion': (5, 1, 23),
1082
'platform': 'solaris',
1084
{ 'choice': ['O_DSYNC', 'O_DIRECT'],
1085
'default': 'fdatasync',
1086
'inversion': (5, 1, 24),
1087
'platform': 'solaris',
1090
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1092
{ 'caption': 'innodb_force_recovery',
1093
'description': 'Helps to save your data in case the disk image of the database becomes corrupt',
1094
'name': 'innodb_force_recovery',
1095
'values': [ { 'choice': ['0', '1', '2', '3', '4', '5', '6'],
1099
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1101
{ 'caption': 'innodb_io_capacity',
1102
'description': 'The limit on the maximum number of I/O operations per second',
1103
'name': 'innodb_io_capacity',
1104
'values': [ { 'bitsize': '32',
1106
'maximum': '2**32-1',
1111
'maximum': '2**64-1',
1113
'type': 'numeric'}],
1114
'versions': [((5, 1, 38),), ((5, 1), (5, 4), (5, 5), (5, 6)), ()]},
1115
{ 'caption': 'innodb_lock_wait_timeout',
1116
'description': 'Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back',
1117
'name': 'innodb_lock_wait_timeout',
1118
'values': [ { 'default': '50',
1119
'maximum': '1073741824',
1121
'type': 'numeric'}],
1123
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1125
{ 'caption': 'innodb_locks_unsafe_for_binlog',
1126
'description': 'Force InnoDB not to use next-key locking. Instead use only row-level locking',
1127
'name': 'innodb_locks_unsafe_for_binlog',
1128
'values': [ { 'default': 'off',
1131
'type': 'boolean'}],
1132
'versions': [ ((4, 1, 4),),
1133
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1135
{ 'caption': 'innodb_log_arch_dir',
1136
'deprecated': (5, 0, 24),
1137
'description': 'Where full logs should be archived',
1138
'name': 'innodb_log_arch_dir',
1139
'values': [{ 'type': 'filename'}],
1140
'versions': [(), ((4, 1), (5, 0), (5, 1)), ((5, 1, 21),)]},
1141
{ 'caption': 'innodb_log_archive',
1142
'description': 'Unused',
1143
'name': 'innodb_log_archive',
1144
'values': [{ 'default': '0', 'type': 'numeric'}],
1145
'versions': [(), ((4, 1), (5, 0), (5, 1)), ((5, 1, 18),)]},
1146
{ 'caption': 'innodb_log_buffer_size',
1147
'description': 'The size of the buffer which InnoDB uses to write log to the log files on disk',
1148
'name': 'innodb_log_buffer_size',
1149
'values': [ { 'default': '1048576',
1150
'maximum': '4294967295',
1151
'minimum': '1048576',
1153
{ 'default': '16777216',
1154
'inversion': (5, 4, 0),
1155
'maximum': '4294967295',
1156
'minimum': '2097152',
1157
'outversion': (5, 4, 1),
1159
{ 'default': '16777216',
1160
'inversion': (5, 4, 2),
1161
'maximum': '4294967295',
1162
'minimum': '262144',
1163
'outversion': (5, 4, 2),
1165
{ 'default': '8388608',
1166
'inversion': (5, 4, 3),
1167
'maximum': '4294967295',
1168
'minimum': '262144',
1170
{ 'default': '1048576',
1171
'inversion': (6, 0, 0),
1172
'maximum': '4294967295',
1173
'minimum': '1048576',
1174
'type': 'numeric'}],
1176
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1178
{ 'caption': 'innodb_log_file_size',
1179
'description': 'Size of each log file in a log group',
1180
'name': 'innodb_log_file_size',
1181
'values': [ { 'default': '5242880',
1182
'maximum': '4294967295',
1183
'minimum': '1048576',
1185
{ 'default': '134217728',
1186
'inversion': (5, 4, 0),
1187
'maximum': '4294967295',
1188
'minimum': '33554432',
1189
'outversion': (5, 4, 1),
1191
{ 'default': '134217728',
1192
'inversion': (5, 4, 2),
1193
'maximum': '4294967295',
1194
'minimum': '108576',
1195
'outversion': (5, 4, 2),
1197
{ 'default': '5242880',
1198
'inversion': (5, 4, 3),
1199
'maximum': '4294967295',
1200
'minimum': '108576',
1202
{ 'default': '5242880',
1203
'inversion': (6, 0, 0),
1204
'maximum': '4294967295',
1205
'minimum': '1048576',
1206
'type': 'numeric'}],
1208
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1210
{ 'caption': 'innodb_log_files_in_group',
1211
'description': 'Number of InnoDB log files in the log group',
1212
'name': 'innodb_log_files_in_group',
1213
'values': [ { 'default': '2',
1218
'inversion': (5, 4, 0),
1221
'outversion': (5, 4, 2),
1224
'inversion': (5, 4, 3),
1227
'type': 'numeric'}],
1229
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1231
{ 'caption': 'innodb_log_group_home_dir',
1232
'description': 'Path to InnoDB log files',
1233
'name': 'innodb_log_group_home_dir',
1234
'values': [{ 'type': 'filename'}],
1236
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1238
{ 'caption': 'innodb_max_dirty_pages_pct',
1239
'description': 'Percentage of dirty pages allowed in bufferpool',
1240
'name': 'innodb_max_dirty_pages_pct',
1241
'values': [ { 'default': '90',
1246
'inversion': (5, 4, 0),
1251
'inversion': (6, 0, 0),
1254
'type': 'numeric'}],
1256
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1258
{ 'caption': 'innodb_max_merged_io',
1259
'description': 'The maximum number of background I/O requests to merge to issue a larger I/O request',
1260
'name': 'innodb_max_merged_io',
1261
'values': [{ 'default': '64', 'type': 'numeric'}],
1262
'versions': [(), ((5, 4),), ((5, 4, 2),)]},
1263
{ 'caption': 'innodb_max_purge_lag',
1264
'description': 'Desired maximum length of the purge queue (0 = no limit)',
1265
'name': 'innodb_max_purge_lag',
1266
'values': [ { 'default': '0',
1267
'maximum': '4294967295',
1269
'type': 'numeric'}],
1270
'versions': [ ((4, 1, 6),),
1271
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1273
{ 'caption': 'innodb_mirrored_log_groups',
1274
'description': 'Number of identical copies of log groups we keep for the database',
1275
'name': 'innodb_mirrored_log_groups',
1276
'values': [ { 'default': '1',
1279
'type': 'numeric'}],
1281
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1283
{ 'caption': 'innodb_old_blocks_pct',
1284
'description': 'Percentage of the InnoDB buffer pool to reserve for old blocks',
1285
'name': 'innodb_old_blocks_pct',
1286
'values': [ { 'default': '37',
1289
'type': 'numeric'}],
1290
'versions': [((5, 1, 41),), ((5, 1), (5, 5), (5, 6)), ()]},
1291
{ 'caption': 'innodb_old_blocks_time',
1292
'description': 'How long (in ms) blocks must remain in old end of InnoDB buffer pool before moving to new end',
1293
'name': 'innodb_old_blocks_time',
1294
'values': [ { 'default': '0',
1295
'maximum': '2**32-1',
1297
'type': 'numeric'}],
1298
'versions': [((5, 1, 41),), ((5, 1), (5, 5), (5, 6)), ()]},
1299
{ 'caption': 'innodb_open_files',
1300
'description': 'The maximum number of files that InnoDB keeps open at the same time',
1301
'name': 'innodb_open_files',
1302
'values': [ { 'default': '300',
1303
'maximum': '4294967295',
1305
'type': 'numeric'}],
1306
'versions': [ ((4, 1, 1),),
1307
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1309
{ 'caption': 'innodb_purge_batch_size',
1310
'description': 'Specifies the number of InnoDB redo logs that trigger a purge operation.',
1311
'name': 'innodb_purge_batch_size',
1312
'values': [ { 'default': '20',
1315
'type': 'numeric'}],
1316
'versions': [((5, 5, 4),), ((5, 5), (5, 6)), ()]},
1317
{ 'caption': 'innodb_purge_threads',
1318
'description': 'Specifies whether the InnoDB purge operation should be performed in a separate thread. By default, this operation is part of the InnoDB master thread.',
1319
'name': 'innodb_purge_threads',
1320
'values': [ { 'default': '0',
1323
'type': 'numeric'}],
1324
'versions': [((5, 5, 4),), ((5, 5), (5, 6)), ()]},
1325
{ 'caption': 'innodb_read_ahead_threshold',
1326
'description': 'The sensitivity of InnoDB linear read-ahead',
1327
'name': 'innodb_read_ahead_threshold',
1328
'values': [ { 'default': '56',
1331
'type': 'numeric'}],
1332
'versions': [ ((5, 1, 38), (5, 4, 2)),
1333
((5, 1), (5, 4), (5, 5), (5, 6)),
1335
{ 'caption': 'innodb_read_io_threads',
1336
'description': 'The number of background I/O threads for read prefetch requests',
1337
'name': 'innodb_read_io_threads',
1338
'values': [ { 'default': '4',
1341
'type': 'numeric'}],
1342
'versions': [((5, 1, 38),), ((5, 1), (5, 4), (5, 5), (5, 6)), ()]},
1343
{ 'caption': 'innodb_replication_delay',
1344
'description': 'The slave server replication thread delay',
1345
'name': 'innodb_replication_delay',
1346
'values': [ { 'default': '0',
1347
'maximum': '4294967295',
1349
'type': 'numeric'}],
1350
'versions': [ ((5, 1, 38), (5, 4, 2)),
1351
((5, 1), (5, 4), (5, 5), (5, 6)),
1353
{ 'caption': 'innodb_rollback_on_timeout',
1354
'description': 'Roll back entire transaction on transaction timeout, not just last statement',
1355
'name': 'innodb_rollback_on_timeout',
1357
'versions': [ ((5, 0, 32), (5, 1, 15)),
1358
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1360
{ 'caption': 'innodb-safe-binlog',
1361
'deprecated': (5, 0, 3),
1362
'description': 'Truncates the binary log after last nonrolled-back transaction after InnoDB crash recovery',
1363
'name': 'innodb-safe-binlog',
1364
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
1365
'versions': [((4, 1, 3),), ((4, 1), (5, 0)), ((5, 0, 3),)]},
1366
{ 'caption': 'innodb_stats_on_metadata',
1367
'description': 'Enable or disable InnoDB table statistics updates for metadata statements',
1368
'name': 'innodb_stats_on_metadata',
1369
'values': [ { 'default': 'on',
1372
'type': 'boolean'}],
1373
'versions': [ ((5, 1, 17), (5, 5, 4)),
1374
((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1376
{ 'caption': 'innodb-status-file',
1377
'description': 'Enable SHOW INNODB STATUS output in the innodb_status.[pid] file',
1378
'name': 'innodb-status-file',
1379
'values': [ { 'default': 'off',
1382
'type': 'boolean'}],
1384
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1386
{ 'caption': 'innodb_support_xa',
1387
'description': 'Enable InnoDB support for the XA two-phase commit',
1388
'name': 'innodb_support_xa',
1389
'values': [ { 'default': 'true',
1392
'type': 'boolean'}],
1393
'versions': [ ((5, 0, 3),),
1394
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1396
{ 'caption': 'innodb_sync_spin_loops',
1397
'description': 'Count of spin-loop rounds in InnoDB mutexes',
1398
'name': 'innodb_sync_spin_loops',
1399
'values': [ { 'default': '20',
1400
'maximum': '4294967295',
1402
'outversion': (5, 4, 1),
1405
'inversion': (5, 4, 2),
1406
'maximum': '4294967295',
1408
'type': 'numeric'}],
1409
'versions': [ ((5, 0, 3),),
1410
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1412
{ 'caption': 'innodb_spin_wait_delay',
1413
'description': 'The maximum delay between polls for a spin lock',
1414
'name': 'innodb_spin_wait_delay',
1415
'values': [ { 'default': '6',
1416
'maximum': '4294967295',
1418
'type': 'numeric'}],
1419
'versions': [ ((5, 1, 38), (5, 4, 2)),
1420
((5, 1), (5, 4), (5, 5), (5, 6)),
1422
{ 'caption': 'innodb_stats_sample_pages',
1423
'description': 'The number of index pages to sample for index distribution statistics',
1424
'name': 'innodb_stats_sample_pages',
1425
'values': [ { 'default': '8',
1426
'maximum': '2**64-1',
1428
'type': 'numeric'}],
1429
'versions': [ ((5, 1, 38), (5, 4, 2)),
1430
((5, 1), (5, 4), (5, 5), (5, 6)),
1432
{ 'caption': 'innodb_strict_mode',
1433
'description': 'Whether InnoDB returns errors rather than warnings for exceptional conditions',
1434
'name': 'innodb_strict_mode',
1435
'values': [ { 'default': 'off',
1438
'type': 'boolean'}],
1439
'versions': [ ((5, 1, 38), (5, 4, 2)),
1440
((5, 1), (5, 4), (5, 5), (5, 6)),
1442
{ 'caption': 'innodb_table_locks',
1443
'description': 'Enable InnoDB locking in LOCK TABLES',
1444
'name': 'innodb_table_locks',
1445
'values': [ { 'default': 'true',
1448
'type': 'boolean'}],
1449
'versions': [ ((4, 1, 2),),
1450
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1452
{ 'caption': 'innodb_thread_concurrency',
1453
'description': 'Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling',
1454
'name': 'innodb_thread_concurrency',
1455
'values': [ { 'default': '8',
1460
'inversion': (5, 0, 9),
1465
'inversion': (5, 0, 19),
1470
'inversion': (5, 4, 0),
1475
'inversion': (6, 0, 0),
1478
'type': 'numeric'}],
1480
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1482
{ 'caption': 'innodb_thread_concurrency_timer_based',
1483
'description': 'Whether to use the lock-free method of handling thread concurrency',
1484
'name': 'innodb_thread_concurrency_timer_based',
1485
'values': [ { 'default': 'on',
1488
'type': 'boolean'}],
1489
'versions': [(), ((5, 4),), ((5, 4, 2),)]},
1490
{ 'caption': 'innodb_thread_sleep_delay',
1491
'description': 'Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep',
1492
'name': 'innodb_thread_sleep_delay',
1493
'values': [ { 'default': '0',
1494
'inversion': (5, 0, 8),
1495
'maximum': '4294967295',
1497
'outversion': (5, 0, 18),
1500
'inversion': (5, 0, 19),
1501
'maximum': '4294967295',
1503
'outversion': (5, 0, 20),
1505
{ 'default': '8', 'inversion': (5, 0, 21), 'type': 'numeric'},
1506
{ 'default': '10000',
1507
'inversion': (5, 1, 0),
1509
{ 'default': '10000',
1510
'maximum': '4294967295',
1512
'type': 'numeric'}],
1513
'versions': [ ((5, 0, 3),),
1514
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1516
{ 'caption': 'innodb_use_legacy_cardinality_algorithm',
1517
'description': 'Whether to use legacy InnoDB index cardinality calculation algorithm',
1518
'name': 'innodb_use_legacy_cardinality_algorithm',
1519
'values': [ { 'default': 'on',
1522
'type': 'boolean'}],
1523
'versions': [((5, 0, 82), (5, 1, 35)), ((5, 0), (5, 1)), ()]},
1524
{ 'caption': 'innodb_use_native_aio',
1525
'description': 'Whether to disable asynchronous I/O subsystem',
1526
'name': 'innodb_use_native_aio',
1527
'values': [ { 'default': 'on',
1530
'type': 'boolean'}],
1531
'versions': [((5, 5, 4),), ((5, 5), (5, 6)), ()]},
1532
{ 'caption': 'innodb_use_sys_malloc',
1533
'description': 'Whether InnoDB uses the OS or its own memory allocator',
1534
'name': 'innodb_use_sys_malloc',
1535
'values': [ { 'default': 'on',
1538
'type': 'boolean'}],
1539
'versions': [ ((5, 1, 38), (5, 4, 2)),
1540
((5, 1), (5, 4), (5, 5), (5, 6)),
1542
{ 'caption': 'innodb_write_io_threads',
1543
'description': 'The number of background I/O threads for writing dirty pages from the buffer cache to disk',
1544
'name': 'innodb_write_io_threads',
1545
'values': [ { 'default': '4',
1548
'type': 'numeric'}],
1549
'versions': [((5, 1, 38),), ((5, 1), (5, 4), (5, 5), (5, 6)), ()]},
1550
{ 'caption': 'interactive_timeout',
1551
'description': 'The number of seconds the server waits for activity on an interactive connection before closing it',
1552
'name': 'interactive_timeout',
1553
'values': [{ 'default': '28800', 'minimum': '1', 'type': 'numeric'}],
1555
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1557
{ 'caption': 'isam',
1559
'description': 'Obsolete. ISAM storage engine is no longer supported',
1561
'values': [ { 'default': 'false',
1564
'type': 'boolean'}],
1565
'versions': [(), ((4, 1),), ()]},
1566
{ 'caption': 'join_buffer_size',
1567
'description': 'The size of the buffer that is used for full joins',
1568
'name': 'join_buffer_size',
1569
'values': [ { 'bitsize': '32',
1570
'default': '131072',
1571
'maximum': '4294967295',
1573
'outversion': (6, 0, 8),
1576
'default': '131072',
1577
'inversion': (6, 0, 9),
1578
'maximum': '4294967295',
1582
'default': '131072',
1583
'maximum': '18446744073709547520',
1585
'outversion': (6, 0, 8),
1588
'default': '131072',
1589
'inversion': (6, 0, 9),
1590
'maximum': '18446744073709547520',
1592
'type': 'numeric'}],
1594
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1596
{ 'caption': 'join_cache_level',
1597
'description': 'How join buffers are used',
1598
'name': 'join_cache_level',
1599
'values': [ { 'default': '1',
1602
'type': 'numeric'}],
1603
'versions': [((6, 0, 9),), ((6, 0),), ((6, 0, 14),)]},
1604
{ 'caption': 'keep_files_on_create',
1605
'description': 'Do not overwrite existing .MYD/.MYI files in default database directory',
1606
'name': 'keep_files_on_create',
1607
'values': [ { 'default': 'off',
1610
'type': 'boolean'}],
1611
'versions': [ ((5, 0, 48), (5, 1, 21)),
1612
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1614
{ 'caption': 'key_buffer_size',
1615
'description': 'The size of the buffer used for index blocks for MyISAM tables',
1616
'name': 'key_buffer_size',
1617
'values': [ { 'default': '8388608',
1618
'maximum': '4294967295',
1620
'outversion': (5, 1, 22),
1623
'default': '8388608',
1624
'inversion': (5, 1, 23),
1625
'maximum': '4294967295',
1629
'default': '8388608',
1630
'inversion': (5, 1, 23),
1631
'maximum': 'OS_PER_PROCESS_LIMIT',
1633
'type': 'numeric'}],
1635
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1637
{ 'caption': 'key_cache_age_threshold',
1638
'description': 'This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in key cache',
1639
'name': 'key_cache_age_threshold',
1640
'values': [ { 'bitsize': '32',
1642
'maximum': '4294967295',
1647
'maximum': '18446744073709547520',
1649
'type': 'numeric'}],
1650
'versions': [ ((4, 1, 1),),
1651
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1653
{ 'caption': 'key_cache_block_size',
1654
'description': 'The default size of key cache blocks',
1655
'name': 'key_cache_block_size',
1656
'values': [ { 'default': '1024',
1659
'type': 'numeric'}],
1660
'versions': [ ((4, 1, 1),),
1661
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1663
{ 'caption': 'key_cache_division_limit',
1664
'description': 'The minimum percentage of warm blocks in key cache',
1665
'name': 'key_cache_division_limit',
1666
'values': [ { 'default': '100',
1669
'type': 'numeric'}],
1670
'versions': [ ((4, 1, 1),),
1671
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1673
{ 'caption': 'language',
1674
'deprecated': (5, 5, 0),
1675
'description': 'Client error messages in given language. May be given as a full path',
1677
'values': [ { 'default': '/usr/local/mysql/share/mysql/english/',
1678
'type': 'dirname'}],
1679
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)), ()]},
1680
{ 'caption': 'large-pages',
1681
'description': 'Enable support for large pages',
1682
'name': 'large-pages',
1683
'values': [ { 'default': 'false',
1686
'platform': 'linux',
1687
'type': 'boolean'}],
1688
'versions': [ ((5, 0, 3),),
1689
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1691
{ 'caption': 'lc-messages',
1692
'description': 'The locale for error messages',
1693
'name': 'lc-messages',
1694
'values': [{ 'type': 'string'}],
1695
'versions': [((6, 0, 14),), ((5, 5), (5, 6), (6, 0)), ()]},
1696
{ 'caption': 'lc-messages-dir',
1697
'description': 'The directory where error messages are located',
1698
'name': 'lc-messages-dir',
1699
'values': [{ 'type': 'dirname'}],
1700
'versions': [((6, 0, 14),), ((5, 5), (5, 6), (6, 0)), ()]},
1701
{ 'caption': 'local-infile',
1702
'description': 'Enable/disable LOAD DATA LOCAL INFILE (takes values 1|0)',
1703
'name': 'local-infile',
1704
'values': [{ 'default': 'true',
1707
'type': 'boolean'}],
1709
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1711
{ 'caption': 'lock_wait_timeout',
1712
'description': 'Timeout for metadata locks',
1713
'name': 'lock_wait_timeout',
1714
'values': [ { 'default': '31536000',
1715
'maximum': '31536000',
1717
'type': 'numeric'}],
1718
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
1720
'deprecated': (5, 1, 29),
1721
'description': 'Log connections and queries to file',
1723
'values': [{ 'default': 'OFF', 'type': 'string'}],
1725
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1727
{ 'caption': 'log-backup-output',
1728
'description': 'The destination for MySQL Backup history and progress log output. Syntax: log-backup-output[=value[,value...]], where "value" could be TABLE, FILE, or NONE',
1729
'name': 'log-backup-output',
1730
'values': [ { 'choice': ['TABLE', 'FILE', 'NONE'],
1733
'versions': [((6, 0, 8),), ((5, 6), (6, 0)), ()]},
1734
{ 'caption': 'log-bin',
1735
'description': 'Enables binary log',
1737
'values': [{ 'default': 'OFF', 'type': 'filename'}],
1739
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1741
{ 'caption': 'log-bin-index',
1742
'description': 'File that holds the names for last binary log files',
1743
'name': 'log-bin-index',
1744
'values': [{ 'default': 'OFF', 'type': 'filename'}],
1746
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1748
{ 'caption': 'log-bin-trust-function-creators',
1749
'description': 'If equal to 0 (the default), then when --log-bin is used, creation of a stored function is allowed only to users having the SUPER privilege and only if the function created does not break binary logging',
1750
'name': 'log-bin-trust-function-creators',
1751
'values': [ { 'default': 'false',
1754
'type': 'boolean'}],
1755
'versions': [ ((5, 0, 16),),
1756
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1758
{ 'caption': 'log-bin-trust-routine-creators',
1759
'deprecated': (5, 0, 16),
1760
'description': '(deprecated) Use log-bin-trust-function-creators',
1761
'name': 'log-bin-trust-routine-creators',
1762
'values': [ { 'default': 'false',
1765
'type': 'boolean'}],
1766
'versions': [ ((5, 0, 6),),
1767
((5, 0), (5, 1), (5, 2), (5, 4), (5, 5), (5, 6)),
1768
((5, 2, 5), (5, 5, 3))]},
1769
{ 'caption': 'log-error',
1770
'description': 'Error log file',
1771
'name': 'log-error',
1772
'values': [{ 'type': 'filename'}],
1774
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1776
{ 'caption': 'log-isam',
1777
'description': 'Log all MyISAM changes to file',
1779
'values': [{ 'type': 'filename'}],
1781
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1783
{ 'caption': 'log-long-format',
1784
'deprecated': (4, 1),
1785
'description': 'Log some extra information to update log. Please note that this option is deprecated; see --log-short-format option',
1786
'name': 'log-long-format',
1788
'versions': [(), ((4, 1),), ()]},
1789
{ 'caption': 'log-output',
1790
'description': 'The destination for general query log and slow query log output. Syntax: log-output[=value[,value...]], where "value" could be TABLE, FILE, or NONE',
1791
'name': 'log-output',
1792
'values': [ { 'choice': ['TABLE', 'FILE', 'NONE'],
1795
'versions': [((5, 1, 6),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
1796
{ 'caption': 'log-queries-not-using-indexes',
1797
'description': 'Log queries that are executed without benefit of any index to the slow query log if it is open',
1798
'name': 'log-queries-not-using-indexes',
1799
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
1800
'versions': [ ((4, 1, 1),),
1801
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1803
{ 'caption': 'log-short-format',
1804
'description': "Don't log extra information to update and slow-query logs",
1805
'name': 'log-short-format',
1806
'values': [ { 'default': 'false',
1809
'type': 'boolean'}],
1811
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1813
{ 'caption': 'log-slave-updates',
1814
'description': 'This option tells the slave to log the updates performed by its SQL thread to its own binary log',
1815
'name': 'log-slave-updates',
1816
'values': [ { 'default': 'false',
1819
'type': 'boolean'}],
1821
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1823
{ 'caption': 'log-slow-admin-statements',
1824
'description': 'Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow query log if it is open',
1825
'name': 'log-slow-admin-statements',
1826
'values': [ { 'default': 'false',
1829
'type': 'boolean'}],
1830
'versions': [ ((4, 1, 13),),
1831
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1833
{ 'caption': 'log-slow-queries',
1834
'deprecated': (5, 1, 29),
1835
'description': 'Whether or not to log slow queries. Logging defaults to hostname-slow.log file. Must be enabled to activate other slow query log options',
1836
'name': 'log-slow-queries',
1837
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
1839
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1841
{ 'caption': 'log-slow-slave-statements',
1842
'description': 'Cause slow statements as executed by the slave to be written to the slow query log',
1843
'name': 'log-slow-slave-statements',
1844
'values': [ { 'default': 'off',
1847
'type': 'boolean'}],
1848
'versions': [ ((5, 1, 21), (6, 0, 4)),
1849
((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1851
{ 'caption': 'log-tc',
1852
'description': 'Path to transaction coordinator log (used for transactions that affect more than one storage engine, when binary log is disabled)',
1854
'values': [{ 'default': 'tc.log', 'type': 'filename'}],
1855
'versions': [ ((5, 0, 3),),
1856
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1858
{ 'caption': 'log-tc-size',
1859
'description': 'Size in KB of transaction coordinator log',
1860
'name': 'log-tc-size',
1861
'values': [ { 'bitsize': '32',
1863
'maximum': '4294967295',
1867
'maximum': '18446744073709547520',
1868
'type': 'numeric'}],
1869
'versions': [ ((5, 0, 3),),
1870
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1872
{ 'caption': 'log-warnings',
1873
'description': 'Log some noncritical warnings to the log file',
1874
'disabledby': 'skip-log-warnings',
1875
'name': 'log-warnings',
1876
'values': [ { 'bitsize': '32',
1878
'inversion': (4, 1, 3),
1879
'maximum': '4294967295',
1884
'inversion': (4, 1, 3),
1885
'maximum': '18446744073709547520',
1887
'type': 'numeric'}],
1889
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1891
{ 'caption': 'long_query_time',
1892
'description': 'Log all queries that have taken more than long_query_time seconds to execute to file',
1893
'name': 'long_query_time',
1894
'values': [ { 'default': '10',
1896
'outversion': (5, 0, 20),
1899
'inversion': (5, 1, 21),
1904
'outversion': (6, 0, 3),
1907
'inversion': (6, 0, 4),
1909
'type': 'numeric'}],
1911
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1913
{ 'caption': 'low-priority-updates',
1914
'description': 'INSERT/DELETE/UPDATE has lower priority than selects',
1915
'name': 'low-priority-updates',
1916
'values': [ { 'default': 'false',
1919
'type': 'boolean'}],
1921
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1923
{ 'caption': 'lower_case_table_names',
1924
'description': 'If set to 1, table names are stored in lowercase on disk and table names will be case insensitive. Should be set to 2 if you are using a case-insensitive file system.',
1925
'name': 'lower_case_table_names',
1926
'values': [ { 'default': '0',
1929
'type': 'numeric'}],
1931
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1933
{ 'caption': 'master-bind',
1934
'description': 'The network interface which is to be used for connecting to the master by a replication slave having multiple network connections',
1935
'name': 'master-bind',
1936
'values': [{ 'type': 'string'}],
1937
'versions': [((5, 1, 22),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
1938
{ 'caption': 'master-connect-retry',
1939
'deprecated': (5, 1, 17),
1940
'description': 'The number of seconds the slave thread will sleep before retrying to connect to the master in case the master goes down or the connection is lost',
1941
'name': 'master-connect-retry',
1942
'values': [{ 'default': '60', 'type': 'numeric'}],
1943
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
1944
{ 'caption': 'master-host',
1945
'deprecated': (5, 1, 17),
1946
'description': 'Master host name or IP address for replication',
1947
'name': 'master-host',
1948
'values': [{ 'type': 'string'}],
1949
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
1950
{ 'caption': 'master-info-file',
1951
'description': "The location and name of the file that remembers the master and where the I/O replication thread is in the master's binlogs",
1952
'name': 'master-info-file',
1953
'optype': { 'format': 'master-info-file=file_name'},
1954
'values': [{ 'default': 'master.info', 'type': 'filename'}],
1956
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1958
{ 'caption': 'master-password',
1959
'deprecated': (5, 1, 17),
1960
'description': 'The password the slave thread will authenticate with when connecting to the master',
1961
'name': 'master-password',
1962
'values': [{ 'type': 'string'}],
1963
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
1964
{ 'caption': 'master-port',
1965
'deprecated': (5, 1, 17),
1966
'description': 'The port the master is listening on',
1967
'name': 'master-port',
1968
'values': [{ 'default': '3306', 'type': 'numeric'}],
1969
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
1970
{ 'caption': 'master-retry-count',
1971
'description': 'The number of tries the slave will make to connect to the master before giving up',
1972
'name': 'master-retry-count',
1973
'values': [ { 'bitsize': '32',
1975
'maximum': '4294967295',
1980
'maximum': '18446744073709551615',
1982
'type': 'numeric'}],
1984
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
1986
{ 'caption': 'master-ssl',
1987
'deprecated': (5, 1, 17),
1988
'description': 'Enable the slave to connect to the master using SSL',
1989
'name': 'master-ssl',
1990
'values': [ { 'default': 'false',
1993
'type': 'boolean'}],
1994
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
1995
{ 'caption': 'master-ssl-ca',
1996
'deprecated': (5, 1, 17),
1997
'description': 'Master SSL CA file. Only applies if you have enabled master-ssl',
1998
'name': 'master-ssl-ca',
1999
'values': [{ 'type': 'filename'}],
2000
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2001
{ 'caption': 'master-ssl-capath',
2002
'deprecated': (5, 1, 17),
2003
'description': 'Master SSL CA path. Only applies if you have enabled master-ssl',
2004
'name': 'master-ssl-capath',
2005
'values': [{ 'type': 'filename'}],
2006
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2007
{ 'caption': 'master-ssl-cert',
2008
'deprecated': (5, 1, 17),
2009
'description': 'Master SSL certificate file name. Only applies if you have enabled master-ssl',
2010
'name': 'master-ssl-cert',
2011
'values': [{ 'type': 'filename'}],
2012
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2013
{ 'caption': 'master-ssl-cipher',
2014
'deprecated': (5, 1, 17),
2015
'description': 'Master SSL cipher. Only applies if you have enabled master-ssl',
2016
'name': 'master-ssl-cipher',
2017
'values': [{ 'type': 'filename'}],
2018
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2019
{ 'caption': 'master-ssl-key',
2020
'deprecated': (5, 1, 17),
2021
'description': 'Master SSL keyfile name. Only applies if you have enabled master-ssl',
2022
'name': 'master-ssl-key',
2023
'values': [{ 'type': 'filename'}],
2024
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2025
{ 'caption': 'master-user',
2026
'deprecated': (5, 1, 17),
2027
'description': 'The user name the slave thread will use for authentication when connecting to the master. The user must have FILE privilege. If the master user is not set, user test is assumed. The value in master.info will take precedence if it can be read',
2028
'name': 'master-user',
2029
'values': [{ 'default': 'test', 'type': 'string'}],
2030
'versions': [(), ((4, 1), (5, 0), (5, 1), (5, 4), (5, 5)), ((5, 5, 3),)]},
2031
{ 'caption': 'max-binlog-dump-events',
2032
'description': 'Option used by mysql-test for debugging and testing of replication',
2033
'name': 'max-binlog-dump-events',
2034
'values': [{ 'default': '0', 'type': 'numeric'}],
2036
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2038
{ 'caption': 'max_allowed_packet',
2039
'description': 'Max packetlength to send/receive from to server',
2040
'name': 'max_allowed_packet',
2041
'values': [ { 'default': '1048576',
2042
'maximum': '1073741824',
2044
'type': 'numeric'}],
2046
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2048
{ 'caption': 'max_binlog_cache_size',
2049
'description': 'Can be used to restrict the total size used to cache a multi-statement transaction',
2050
'name': 'max_binlog_cache_size',
2051
'values': [ { 'default': '4294967295',
2052
'maximum': '4294967295',
2054
'outversion': (5, 1, 35),
2056
{ 'default': '18446744073709547520',
2057
'inversion': (5, 1, 36),
2058
'maximum': '18446744073709547520',
2061
{ 'default': '4294967295',
2062
'inversion': (5, 4, 0),
2063
'maximum': '4294967295',
2065
'outversion': (5, 4, 1),
2067
{ 'default': '18446744073709547520',
2068
'inversion': (5, 4, 2),
2069
'maximum': '18446744073709547520',
2072
{ 'default': '4294967295',
2073
'inversion': (6, 0, 0),
2074
'maximum': '4294967295',
2076
'type': 'numeric'}],
2078
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2080
{ 'caption': 'max_binlog_size',
2081
'description': 'Binary log will be rotated automatically when the size exceeds this value',
2082
'name': 'max_binlog_size',
2083
'values': [ { 'default': '1073741824',
2084
'maximum': '1073741824',
2086
'type': 'numeric'}],
2088
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2090
{ 'caption': 'max_binlog_stmt_cache_size',
2091
'description': 'Can be used to restrict the total size used to cache all nontransactional statements during a transaction',
2092
'name': 'max_binlog_stmt_cache_size',
2093
'values': [ { 'default': '18446744073709547520',
2094
'maximum': '18446744073709547520',
2096
'type': 'numeric'}],
2097
'versions': [((5, 5, 9), (5, 6, 1)), ((5, 5), (5, 6)), ()]},
2098
{ 'caption': 'max_connect_errors',
2099
'description': 'If there is more than this number of interrupted connections from a host this host will be blocked from further connections',
2100
'name': 'max_connect_errors',
2101
'values': [ { 'bitsize': '32',
2103
'maximum': '4294967295',
2108
'maximum': '18446744073709547520',
2110
'type': 'numeric'}],
2112
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2114
{ 'caption': 'max_connections',
2115
'description': 'The number of simultaneous clients allowed',
2116
'name': 'max_connections',
2117
'values': [ { 'default': '100',
2118
'outversion': (5, 1, 14),
2121
'inversion': (5, 1, 15),
2126
'inversion': (5, 1, 17),
2127
'maximum': '100000',
2129
'type': 'numeric'}],
2131
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2133
{ 'caption': 'max_delayed_threads',
2134
'description': "Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero, which means INSERT DELAYED is not used",
2135
'name': 'max_delayed_threads',
2136
'values': [ { 'default': '20',
2139
'type': 'numeric'}],
2141
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2143
{ 'caption': 'max_error_count',
2144
'description': 'Max number of errors/warnings to store for a statement',
2145
'name': 'max_error_count',
2146
'values': [ { 'default': '64',
2149
'type': 'numeric'}],
2151
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2153
{ 'caption': 'max_heap_table_size',
2154
'description': "Don't allow creation of heap tables bigger than this",
2155
'name': 'max_heap_table_size',
2156
'values': [ { 'bitsize': '32',
2157
'default': '16777216',
2158
'maximum': '4294967295',
2162
'default': '16777216',
2163
'maximum': '1844674407370954752',
2165
'type': 'numeric'}],
2167
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2169
{ 'caption': 'max_join_size',
2170
'description': 'Joins that are probably going to read more than max_join_size records return an error',
2171
'name': 'max_join_size',
2172
'values': [ { 'default': '4294967295',
2173
'maximum': '4294967295',
2176
{ 'default': '18446744073709551615',
2177
'inversion': (5, 5, 0),
2178
'maximum': '18446744073709551615',
2180
'type': 'numeric'}],
2182
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2184
{ 'caption': 'max_length_for_sort_data',
2185
'description': 'Max number of bytes in sorted records',
2186
'name': 'max_length_for_sort_data',
2187
'values': [ { 'default': '1024',
2188
'maximum': '8388608',
2190
'type': 'numeric'}],
2191
'versions': [ ((4, 1, 1),),
2192
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2194
{ 'caption': 'max_prepared_stmt_count',
2195
'description': 'Maximum number of prepared statements in the server',
2196
'name': 'max_prepared_stmt_count',
2197
'optype': { 'inversion': '5.0.21'},
2198
'values': [ { 'default': '16382',
2199
'maximum': '1048576',
2201
'type': 'numeric'}],
2202
'versions': [ ((4, 1, 19), (5, 0, 21), (5, 1, 10)),
2203
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2205
{ 'caption': 'max_relay_log_size',
2206
'description': 'If nonzero, relay log will be rotated automatically when the size exceeds this value',
2207
'name': 'max_relay_log_size',
2208
'values': [ { 'default': '0',
2209
'maximum': '1073741824',
2211
'type': 'numeric'}],
2213
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2215
{ 'caption': 'max_seeks_for_key',
2216
'description': 'Limit assumed max number of seeks when looking up rows based on a key',
2217
'name': 'max_seeks_for_key',
2218
'values': [ { 'bitsize': '32',
2219
'default': '4294967295',
2220
'maximum': '4294967295',
2224
'default': '18446744073709547520',
2225
'maximum': '18446744073709547520',
2227
'type': 'numeric'}],
2229
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2231
{ 'caption': 'max_sort_length',
2232
'description': 'The number of bytes to use when sorting BLOB or TEXT values',
2233
'name': 'max_sort_length',
2234
'values': [ { 'default': '1024',
2235
'maximum': '8388608',
2237
'type': 'numeric'}],
2239
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2241
{ 'caption': 'max_sp_recursion_depth',
2242
'description': 'Maximum stored procedure recursion depth',
2243
'name': 'max_sp_recursion_depth',
2244
'values': [{ 'default': '0', 'maximum': '255', 'type': 'numeric'}],
2245
'versions': [ ((5, 0, 17),),
2246
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2248
{ 'caption': 'max_tmp_tables',
2249
'description': 'Maximum number of temporary tables a client can keep open at a time',
2250
'name': 'max_tmp_tables',
2251
'values': [ { 'bitsize': '32',
2253
'maximum': '4294967295',
2258
'maximum': '18446744073709547520',
2260
'type': 'numeric'}],
2262
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2264
{ 'caption': 'max_user_connections',
2265
'description': 'The maximum number of active connections for a single user (0 = no limit)',
2266
'name': 'max_user_connections',
2267
'values': [ { 'default': '0',
2268
'maximum': '4294967295',
2270
'type': 'numeric'}],
2272
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2274
{ 'caption': 'max_write_lock_count',
2275
'description': 'After this many write locks, allow some read locks to run in between',
2276
'name': 'max_write_lock_count',
2277
'values': [ { 'bitsize': '32',
2278
'default': '4294967295',
2279
'maximum': '4294967295',
2283
'default': '18446744073709547520',
2284
'maximum': '18446744073709547520',
2286
'type': 'numeric'}],
2288
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2290
{ 'caption': 'memlock',
2291
'description': 'Lock the mysqld process in memory',
2293
'values': [ { 'default': 'false',
2296
'type': 'boolean'}],
2298
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2300
{ 'caption': 'merge',
2301
'description': 'Enable Merge storage engine',
2302
'disabledby': 'skip-merge',
2304
'values': [ { 'default': 'true',
2305
'off': 'disabledby',
2307
'type': 'boolean'}],
2308
'versions': [ ((4, 1, 21), (5, 0, 24), (5, 1, 12)),
2309
((4, 1), (5, 0), (5, 1)),
2311
{ 'caption': 'min-examined-row-limit',
2312
'description': 'Queries examining fewer than this number of rows are not logged to slow query log',
2313
'name': 'min-examined-row-limit',
2314
'values': [ { 'bitsize': '32',
2316
'maximum': '4294967295',
2321
'maximum': '18446744073709547520',
2323
'type': 'numeric'}],
2324
'versions': [ ((5, 1, 21), (6, 0, 4)),
2325
((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2327
{ 'caption': 'skip-isam',
2329
'description': 'Disable the ISAM storage engine',
2330
'name': 'skip-isam',
2331
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
2332
'versions': [((4, 1, 1),), ((4, 1),), ()]},
2333
{ 'caption': 'multi_range_count',
2334
'description': 'The maximum number of ranges to send to a table handler at once during range selects',
2335
'name': 'multi_range_count',
2336
'values': [ { 'default': '256',
2337
'maximum': '4294967295',
2339
'type': 'numeric'}],
2340
'versions': [ ((5, 0, 3),),
2341
((5, 0), (5, 1), (5, 2)),
2342
((5, 2, 4), (6, 0, 3))]},
2343
{ 'caption': 'mutex-deadlock-detector',
2344
'description': 'Enable detection of incorrect mutex usage',
2345
'name': 'mutex-deadlock-detector',
2346
'values': [ { 'default': 'true',
2349
'type': 'boolean'}],
2350
'versions': [((6, 0, 9),), ((6, 0),), ()]},
2351
{ 'caption': 'myisam-block-size',
2352
'description': 'Block size to be used for MyISAM index pages',
2353
'name': 'myisam-block-size',
2354
'values': [ { 'default': '1024',
2357
'type': 'numeric'}],
2359
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2361
{ 'caption': 'myisam_data_pointer_size',
2362
'description': 'Default pointer size to be used for MyISAM tables',
2363
'name': 'myisam_data_pointer_size',
2364
'values': [ { 'default': '4',
2367
'outversion': (5, 0, 5),
2370
'inversion': (5, 0, 6),
2373
'type': 'numeric'}],
2374
'versions': [ ((4, 1, 2),),
2375
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2377
{ 'caption': 'myisam_max_extra_sort_file_size',
2378
'deprecated': (5, 0, 6),
2379
'description': 'Deprecated option',
2380
'name': 'myisam_max_extra_sort_file_size',
2381
'optype': { 'outversion': '5.0.6'},
2382
'values': [ { 'default': '2147483648',
2383
'outversion': (5, 0, 6),
2384
'type': 'numeric'}],
2385
'versions': [(), ((4, 1), (5, 0)), ()]},
2386
{ 'caption': 'myisam_max_sort_file_size',
2387
'description': "Don't use the fast sort index method to create index if the temporary file would get bigger than this",
2388
'name': 'myisam_max_sort_file_size',
2389
'values': [{ 'default': '2147483648', 'type': 'numeric'}],
2391
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2393
{ 'caption': 'myisam_mmap_size',
2394
'description': 'The maximum amount of memory to use for memory mapping compressed MyISAM files.',
2395
'name': 'myisam_mmap_size',
2396
'values': [ { 'bitsize': '32',
2397
'default': '4294967295',
2398
'maximum': '4294967295',
2402
'default': '18446744073709547520',
2403
'maximum': '18446744073709547520',
2405
'type': 'numeric'}],
2406
'versions': [ ((5, 0, 90), (5, 1, 43), (5, 5, 1), (6, 0, 14)),
2407
((5, 0), (5, 1), (5, 5), (5, 6), (6, 0)),
2409
{ 'caption': 'myisam-recover',
2410
'description': 'Set the mode for automatic MyISAM recovery',
2411
'name': 'myisam-recover',
2412
'values': [ { 'choice': ['DEFAULT', 'BACKUP', 'FORCE', 'QUICK'],
2416
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)),
2417
((5, 5, 3), (6, 0, 14))]},
2418
{ 'caption': 'myisam-recover-options',
2419
'description': 'Set the mode for automatic MyISAM recovery',
2420
'name': 'myisam-recover-options',
2421
'values': [ { 'choice': ['OFF', 'DEFAULT', 'BACKUP', 'FORCE', 'QUICK'],
2424
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2425
{ 'caption': 'myisam_repair_threads',
2426
'description': 'Number of threads to use when repairing MyISAM tables. The value of 1 disables parallel repair',
2427
'name': 'myisam_repair_threads',
2428
'values': [ { 'bitsize': '32',
2430
'maximum': '4294967295',
2435
'maximum': '18446744073709547520',
2437
'type': 'numeric'}],
2439
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2441
{ 'caption': 'myisam_sort_buffer_size',
2442
'description': 'The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE',
2443
'name': 'myisam_sort_buffer_size',
2444
'values': [ { 'bitsize': '32',
2445
'default': '8388608',
2446
'maximum': '4294967295',
2450
'default': '8388608',
2451
'maximum': '18446744073709547520',
2453
'type': 'numeric'}],
2455
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2457
{ 'caption': 'myisam_stats_method',
2458
'description': 'Specifies how MyISAM index statistics collection code should treat NULLs',
2459
'name': 'myisam_stats_method',
2460
'values': [ { 'default': 'nulls_unequal',
2461
'inversion': (4, 1),
2463
{ 'choice': [ 'nulls_equal',
2466
'inversion': (5, 0),
2468
'versions': [ ((4, 1, 15), (5, 0, 14)),
2469
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2471
{ 'caption': 'myisam_use_mmap',
2472
'description': 'Use memory mapping for reading and writing MyISAM tables',
2473
'name': 'myisam_use_mmap',
2474
'values': [ { 'default': 'off',
2477
'type': 'boolean'}],
2478
'versions': [((5, 1, 4),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
2479
{ 'caption': 'mysql-backup',
2480
'description': 'Enable MySQL Backup features',
2481
'name': 'mysql-backup',
2483
'versions': [((6, 0, 14),), ((5, 6), (6, 0)), ()]},
2484
{ 'caption': 'ndb_autoincrement_prefetch_sz',
2485
'description': 'NDB auto-increment prefetch size',
2486
'name': 'ndb_autoincrement_prefetch_sz',
2487
'values': [ { 'default': '32',
2490
'outversion': (5, 0, 54),
2493
'inversion': (5, 0, 56),
2500
'outversion': (5, 1, 22),
2503
'inversion': (5, 1, 23),
2510
'outversion': (5, 1, 22),
2513
'inversion': (5, 1, 23),
2516
'outversion': (5, 1, 39),
2519
'inversion': (5, 1, 41),
2526
'outversion': (5, 1, 39),
2529
'inversion': (5, 1, 41),
2536
'outversion': (5, 1, 22),
2539
'inversion': (5, 1, 23),
2542
'type': 'numeric'}],
2543
'versions': [ ((4, 1, 8),),
2544
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2546
{ 'caption': 'ndb-batch-size',
2547
'description': 'The size (in bytes) to use for NDB transaction batches',
2548
'name': 'ndb-batch-size',
2549
'values': [ { 'default': '32768',
2550
'maximum': '31536000',
2552
'type': 'numeric'}],
2553
'versions': [((5, 1, 23),), ((5, 1),), ()]},
2554
{ 'caption': 'ndb-blob-read-batch-bytes',
2555
'description': 'Specifies the size in bytes that large BLOB reads should be batched into. 0 = no limit.',
2556
'name': 'ndb-blob-read-batch-bytes',
2557
'values': [ { 'default': '65535',
2558
'maximum': '4294967295',
2560
'type': 'numeric'}],
2561
'versions': [((5, 1, 51),), ((5, 1),), ()]},
2562
{ 'caption': 'ndb-blob-write-batch-bytes',
2563
'description': 'Specifies the size in bytes that large BLOB writes should be batched into. 0 = no limit.',
2564
'name': 'ndb-blob-write-batch-bytes',
2565
'values': [ { 'default': '65535',
2566
'maximum': '4294967295',
2568
'type': 'numeric'}],
2569
'versions': [((5, 1, 51),), ((5, 1),), ()]},
2570
{ 'caption': 'ndb_cache_check_time',
2571
'description': 'The number of milliseconds between checks of cluster SQL nodes made by the MySQL query cache',
2572
'name': 'ndb_cache_check_time',
2573
'values': [{ 'default': '0', 'type': 'numeric'}],
2574
'versions': [(), ((4, 1), (5, 0), (5, 1)), ()]},
2575
{ 'caption': 'ndb-cluster-connection-pool',
2576
'description': 'The number of connections to the cluster used by MySQL',
2577
'name': 'ndb-cluster-connection-pool',
2578
'values': [ { 'default': '1',
2581
'type': 'numeric'}],
2582
'versions': [((5, 1, 19),), ((5, 1),), ()]},
2583
{ 'caption': 'ndb-connectstring',
2584
'description': 'The management server that distributes the cluster configuration',
2585
'name': 'ndb-connectstring',
2586
'values': [{ 'type': 'string'}],
2587
'versions': [(), ((5, 1),), ()]},
2588
{ 'caption': 'ndb_extra_logging',
2589
'description': 'Controls logging of MySQL Cluster schema, connection, and data distribution events in the MySQL error log',
2590
'name': 'ndb_extra_logging',
2591
'values': [{ 'default': '0', 'type': 'numeric'}],
2592
'versions': [((5, 1, 6),), ((5, 1),), ()]},
2593
{ 'caption': 'ndb_force_send',
2594
'description': 'Forces sending of buffers to NDB immediately, without waiting for other threads',
2595
'name': 'ndb_force_send',
2596
'values': [ { 'default': 'true',
2599
'type': 'boolean'}],
2600
'versions': [((4, 1, 8),), ((4, 1), (5, 0), (5, 1)), ()]},
2601
{ 'caption': 'ndb-log-apply-status',
2602
'description': 'Cause a MySQL server acting as a slave to log mysql.ndb_apply_status updates received from its immediate master in its own binary log, using its own server ID. Effective only if the server is started with the --ndbcluster option.',
2603
'name': 'ndb-log-apply-status',
2604
'values': [ { 'default': 'on',
2607
'type': 'boolean'}],
2608
'versions': [((5, 1, 51),), ((5, 1),), ()]},
2609
{ 'caption': 'ndb_log_updated_only',
2610
'description': 'Log complete rows (ON) or updates only (OFF)',
2611
'name': 'ndb_log_updated_only',
2612
'values': [ { 'default': 'on',
2615
'type': 'boolean'}],
2616
'versions': [((5, 1, 19),), ((5, 1),), ()]},
2617
{ 'caption': 'ndb-log-update-as-write',
2618
'description': 'Toggles logging of updates on the master between updates (OFF) and writes (ON)',
2619
'name': 'ndb-log-update-as-write',
2620
'values': [ { 'default': 'on',
2623
'type': 'boolean'}],
2624
'versions': [((5, 1, 19),), ((5, 1),), ()]},
2625
{ 'caption': 'ndb_log_empty_epochs',
2626
'description': 'When used, causes epochs in which there were no changes to be written to the ndb_apply_status and ndb_binlog_index tables even when --log-slave-updates is enabled.',
2627
'name': 'ndb_log_empty_epochs',
2628
'values': [ { 'default': 'off',
2631
'type': 'boolean'}],
2632
'versions': [((5, 1, 31),), ((5, 1),), ()]},
2633
{ 'caption': 'ndb-nodeid',
2634
'description': 'MySQL Cluster node ID for this MySQL server',
2635
'name': 'ndb-nodeid',
2636
'values': [ { 'inversion': (5, 0, 45),
2640
{ 'inversion': (5, 1, 5),
2643
'type': 'numeric'}],
2644
'versions': [((5, 0, 45), (5, 1, 15)), ((5, 0), (5, 1)), ()]},
2645
{ 'caption': 'ndb-mgmd-host',
2646
'description': 'Set the host (and port, if desired) for connecting to the management server',
2647
'name': 'ndb-mgmd-host',
2648
'values': [{ 'default': 'localhost:1186', 'type': 'string'}],
2649
'versions': [(), ((5, 0), (5, 1)), ()]},
2650
{ 'caption': 'ndb-wait-connected',
2651
'description': 'Time (in seconds) for the MySQL server to wait for connection to cluster management and data nodes before accepting MySQL client connections.',
2652
'name': 'ndb-wait-connected',
2653
'values': [ { 'default': '0',
2654
'maximum': '31536000',
2656
'type': 'numeric'}],
2657
'versions': [((5, 1, 16),), ((5, 1),), ()]},
2658
{ 'caption': 'ndb-wait-setup',
2659
'description': 'Time (in seconds) for the MySQL server to wait for NDB engine setup to complete.',
2660
'name': 'ndb-wait-setup',
2661
'values': [ { 'default': '15',
2662
'maximum': '31536000',
2664
'type': 'numeric'}],
2665
'versions': [((5, 1, 39),), ((5, 1),), ()]},
2666
{ 'caption': 'ndbcluster',
2667
'description': 'Enable NDB Cluster (if this version of MySQL supports it)',
2668
'disabledby': 'skip-ndbcluster',
2669
'name': 'ndbcluster',
2670
'values': [ { 'default': 'false',
2671
'off': 'disabledby',
2673
'type': 'boolean'}],
2674
'versions': [(), ((4, 1), (5, 0), (5, 1)), ()]},
2675
{ 'caption': 'net_buffer_length',
2676
'description': 'Buffer length for TCP/IP and socket communication',
2677
'name': 'net_buffer_length',
2678
'values': [ { 'default': '16384',
2679
'maximum': '1048576',
2681
'type': 'numeric'}],
2683
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2685
{ 'caption': 'net_read_timeout',
2686
'description': 'Number of seconds to wait for more data from a connection before aborting the read',
2687
'name': 'net_read_timeout',
2688
'values': [{ 'default': '30', 'minimum': '1', 'type': 'numeric'}],
2690
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2692
{ 'caption': 'net_retry_count',
2693
'description': 'If a read on a communication port is interrupted, retry this many times before giving up',
2694
'name': 'net_retry_count',
2695
'values': [ { 'bitsize': '32',
2697
'maximum': '4294967295',
2702
'maximum': '18446744073709547520',
2704
'type': 'numeric'}],
2706
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2708
{ 'caption': 'net_write_timeout',
2709
'description': 'Number of seconds to wait for a block to be written to a connection before aborting the write',
2710
'name': 'net_write_timeout',
2711
'values': [{ 'default': '60', 'minimum': '1', 'type': 'numeric'}],
2713
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2716
'description': "Use very new, possibly 'unsafe' functions",
2717
'disabledby': 'skip-new',
2719
'values': [ { 'default': 'false',
2720
'off': 'disabledby',
2722
'type': 'boolean'}],
2724
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2726
{ 'caption': 'old-protocol',
2727
'description': 'Use old server behaviors',
2728
'name': 'old-protocol',
2729
'values': [ { 'default': 'false',
2732
'type': 'boolean'}],
2733
'versions': [(), ((4, 1),), ((4, 1, 1),)]},
2734
{ 'caption': 'old-alter-table',
2735
'description': 'Use old, nonoptimized alter table',
2736
'name': 'old-alter-table',
2737
'values': [ { 'default': 'off',
2740
'type': 'boolean'}],
2741
'versions': [(), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
2742
{ 'caption': 'old-passwords',
2743
'description': 'Use old password encryption method (needed for 4.0 and older clients)',
2744
'name': 'old-passwords',
2745
'values': [ { 'default': 'false',
2748
'type': 'boolean'}],
2750
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2752
{ 'caption': 'old-style-user-limits',
2753
'description': 'Enable old-style user limits (before 5.0.3, user resources were counted per each user+host vs. per account)',
2754
'name': 'old-style-user-limits',
2755
'values': [ { 'default': 'false',
2758
'type': 'boolean'}],
2759
'versions': [ ((5, 0, 3),),
2760
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2762
{ 'caption': 'open-files-limit',
2763
'description': 'If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit()',
2764
'name': 'open-files-limit',
2765
'values': [ { 'default': '0',
2768
'type': 'numeric'}],
2770
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2772
{ 'caption': 'optimizer_join_cache_level',
2773
'description': 'How join buffers are used',
2774
'name': 'optimizer_join_cache_level',
2775
'values': [ { 'default': '4',
2780
'inversion': (6, 0, 14),
2783
'type': 'numeric'}],
2784
'versions': [((5, 6, 1), (6, 0, 14)), ((5, 6), (6, 0)), ()]},
2785
{ 'caption': 'optimizer_prune_level',
2786
'description': 'Controls the heuristic(s) applied during query optimization to prune less-promising partial plans from the optimizer search space',
2787
'name': 'optimizer_prune_level',
2788
'values': [{ 'default': '1', 'off': '0', 'on': '1', 'type': 'boolean'}],
2789
'versions': [ ((5, 0, 1),),
2790
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2792
{ 'caption': 'optimizer_search_depth',
2793
'description': 'Maximum depth of search performed by the query optimizer',
2794
'name': 'optimizer_search_depth',
2795
'values': [ { 'default': '62', 'type': 'numeric'},
2799
'outversion': (5, 5, 99),
2802
'inversion': (5, 6),
2807
'inversion': (6, 0, 0),
2810
'outversion': (6, 0, 13),
2813
'inversion': (6, 0, 14),
2816
'type': 'numeric'}],
2817
'versions': [ ((5, 0, 1),),
2818
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
2820
{ 'caption': 'optimizer_switch',
2821
'description': 'Enable control over which optimizations to use',
2822
'name': 'optimizer_switch',
2823
'optype': { 'inversion': '5.1.34'},
2824
'values': [ { 'choice': [ 'index_merge={on|off}',
2825
'index_merge_intersection={on|off}',
2826
'index_merge_sort_union={on|off}',
2827
'index_merge_union={on|off}'],
2828
'outversion': (5, 2, 3),
2830
{ 'choice': ['no_semijoin', 'no_materialization'],
2832
'inversion': (5, 2, 4),
2834
{ 'choice': [ 'index_merge={on|off}',
2835
'index_merge_intersection={on|off}',
2836
'index_merge_sort_union={on|off}',
2837
'index_merge_union={on|off}'],
2838
'inversion': (5, 4, 2),
2839
'outversion': (5, 5, 2),
2841
{ 'choice': [ 'engine_condition_pushdown={on|off}',
2842
'index_merge={on|off}',
2843
'index_merge_intersection={on|off}',
2844
'index_merge_sort_union={on|off}',
2845
'index_merge_union={on|off}'],
2846
'inversion': (5, 5, 3),
2848
{ 'choice': [ 'no_firstmatch',
2850
'no_materialization',
2853
'inversion': (6, 0, 0),
2854
'outversion': (6, 0, 10),
2856
{ 'choice': [ 'index_merge={on|off}',
2857
'index_merge_intersection={on|off}',
2858
'index_merge_sort_union={on|off}',
2859
'index_merge_union={on|off}',
2860
'semijoin={on|off}',
2861
'firstmatch={on|off}',
2862
'loosescan={on|off}',
2863
'materialization={on|off}'],
2864
'inversion': (6, 0, 11),
2865
'outversion': (6, 0, 13),
2867
{ 'choice': [ 'index_merge={on|off}',
2868
'index_merge_intersection={on|off}',
2869
'index_merge_sort_union={on|off}',
2870
'index_merge_union={on|off}',
2871
'semijoin={on|off}',
2872
'firstmatch={on|off}',
2873
'loosescan={on|off}',
2874
'materialization={on|off}',
2875
'engine_condition_pushdown={on|off}',
2876
'index_condition_pushdown={on|off}',
2878
'mrr_cost_based={on|off}'],
2879
'inversion': (6, 0, 14),
2881
'versions': [ ((5, 1, 34), (5, 2, 4), (5, 4, 2)),
2882
((5, 1), (5, 2), (5, 4), (5, 5), (5, 6), (6, 0)),
2884
{ 'caption': 'partition',
2885
'description': 'Enable (or disable) partitioning support',
2886
'disabledby': 'skip-partition',
2887
'name': 'partition',
2888
'values': [ { 'default': 'on',
2889
'off': 'disabledby',
2891
'type': 'boolean'}],
2892
'versions': [(), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
2893
{ 'caption': 'performance_schema',
2894
'description': 'Whether Performance Schema is enabled',
2895
'name': 'performance_schema',
2896
'optype': { 'format': 'performance_schema=#'},
2897
'values': [ { 'default': 'on',
2900
'type': 'boolean'}],
2901
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2902
{ 'caption': 'performance_schema_events_waits_history_long_size',
2903
'description': 'The number of rows in events_waits_history_long',
2904
'name': 'performance_schema_events_waits_history_long_size',
2905
'optype': { 'format': 'performance_schema_events_waits_history_long_size=#'},
2906
'values': [{ 'default': '10000', 'type': 'numeric'}],
2907
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2908
{ 'caption': 'performance_schema_events_waits_history_size',
2909
'description': 'The number of rows in events_waits_history',
2910
'name': 'performance_schema_events_waits_history_size',
2911
'optype': { 'format': 'performance_schema_events_waits_history_size=#'},
2912
'values': [{ 'default': '10', 'type': 'numeric'}],
2913
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2914
{ 'caption': 'performance_schema_max_cond_classes',
2915
'description': 'The maximum number of condition instruments',
2916
'name': 'performance_schema_max_cond_classes',
2917
'optype': { 'format': 'performance_schema_max_cond_classes=#'},
2918
'values': [{ 'default': '80', 'type': 'numeric'}],
2919
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2920
{ 'caption': 'performance_schema_max_cond_instances',
2921
'description': 'The maximum number of instrumented condition objects',
2922
'name': 'performance_schema_max_cond_instances',
2923
'optype': { 'format': 'performance_schema_max_cond_instances=#'},
2924
'values': [{ 'default': '1000', 'type': 'numeric'}],
2925
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2926
{ 'caption': 'performance_schema_max_file_classes',
2927
'description': 'The maximum number of file instruments',
2928
'name': 'performance_schema_max_file_classes',
2929
'optype': { 'format': 'performance_schema_max_file_classes=#'},
2930
'values': [{ 'default': '50', 'type': 'numeric'}],
2931
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2932
{ 'caption': 'performance_schema_max_file_handles',
2933
'description': 'The maximum number of opened file objects',
2934
'name': 'performance_schema_max_file_handles',
2935
'optype': { 'format': 'performance_schema_max_file_handles=#'},
2936
'values': [{ 'default': '32768', 'type': 'numeric'}],
2937
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2938
{ 'caption': 'performance_schema_max_file_instances',
2939
'description': 'The maximum number of instrumented file objects',
2940
'name': 'performance_schema_max_file_instances',
2941
'optype': { 'format': 'performance_schema_max_file_instances=#'},
2942
'values': [{ 'default': '10000', 'type': 'numeric'}],
2943
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2944
{ 'caption': 'performance_schema_max_mutex_classes',
2945
'description': 'The maximum number of mutex instruments',
2946
'name': 'performance_schema_max_mutex_classes',
2947
'optype': { 'format': 'performance_schema_max_mutex_classes=#'},
2948
'values': [{ 'default': '200', 'type': 'numeric'}],
2949
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2950
{ 'caption': 'performance_schema_max_mutex_instances',
2951
'description': 'The maximum number of instrumented mutex objects',
2952
'name': 'performance_schema_max_mutex_instances',
2953
'optype': { 'format': 'performance_schema_max_mutex_instances=#'},
2954
'values': [{ 'default': '1000', 'type': 'numeric'}],
2955
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2956
{ 'caption': 'performance_schema_max_rwlock_classes',
2957
'description': 'The maximum number of rwlock instruments',
2958
'name': 'performance_schema_max_rwlock_classes',
2959
'optype': { 'format': 'performance_schema_max_rwlock_classes=#'},
2960
'values': [{ 'default': '20', 'type': 'numeric'}],
2961
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2962
{ 'caption': 'performance_schema_max_rwlock_instances',
2963
'description': 'The maximum number of instrumented rwlock objects',
2964
'name': 'performance_schema_max_rwlock_instances',
2965
'optype': { 'format': 'performance_schema_max_rwlock_instances=#'},
2966
'values': [{ 'default': '1000', 'type': 'numeric'}],
2967
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2968
{ 'caption': 'performance_schema_max_table_handles',
2969
'description': 'The maximum number of opened table objects',
2970
'name': 'performance_schema_max_table_handles',
2971
'optype': { 'format': 'performance_schema_max_table_handles=#'},
2972
'values': [{ 'default': '100000', 'type': 'numeric'}],
2973
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2974
{ 'caption': 'performance_schema_max_table_instances',
2975
'description': 'The maximum number of instrumented table objects',
2976
'name': 'performance_schema_max_table_instances',
2977
'optype': { 'format': 'performance_schema_max_table_instances=#'},
2978
'values': [{ 'default': '50000', 'type': 'numeric'}],
2979
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2980
{ 'caption': 'performance_schema_max_thread_classes',
2981
'description': 'The maximum number of thread instruments',
2982
'name': 'performance_schema_max_thread_classes',
2983
'optype': { 'format': 'performance_schema_max_thread_classes=#'},
2984
'values': [{ 'default': '50', 'type': 'numeric'}],
2985
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2986
{ 'caption': 'performance_schema_max_thread_instances',
2987
'description': 'The maximum number of instrumented thread objects',
2988
'name': 'performance_schema_max_thread_instances',
2989
'optype': { 'format': 'performance_schema_max_thread_instances=#'},
2990
'values': [{ 'default': '1000', 'type': 'numeric'}],
2991
'versions': [((5, 5, 3), (6, 0, 14)), ((5, 5), (5, 6), (6, 0)), ()]},
2992
{ 'caption': 'performance_schema_setup_actors_size',
2993
'description': 'The number of rows in setup_actors',
2994
'name': 'performance_schema_setup_actors_size',
2995
'optype': { 'format': 'performance_schema_setup_actors_size=#'},
2996
'values': [{ 'default': '100', 'type': 'numeric'}],
2997
'versions': [((5, 6, 1),), ((5, 6),), ()]},
2998
{ 'caption': 'performance_schema_setup_objects_size',
2999
'description': 'The number of rows in setup_objects',
3000
'name': 'performance_schema_setup_objects_size',
3001
'optype': { 'format': 'performance_schema_setup_objects_size=#'},
3002
'values': [{ 'default': '100', 'type': 'numeric'}],
3003
'versions': [((5, 6, 1),), ((5, 6),), ()]},
3004
{ 'caption': 'pid-file',
3005
'description': 'Process ID file used by mysqld_safe',
3007
'optype': { 'format': 'pid-file=file_name'},
3008
'values': [{ 'type': 'filename'}],
3010
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3012
{ 'caption': 'plugin',
3013
'description': 'Prefix for specifying plugin-specific options.',
3015
'values': [{ 'type': 'string'}],
3016
'versions': [(), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3017
{ 'caption': 'plugin_dir',
3018
'description': 'Directory for plugins',
3019
'name': 'plugin_dir',
3020
'values': [ { 'default': 'BASEDIR/lib/plugin',
3021
'inversion': (5, 1, 2),
3022
'platform': 'windows',
3024
{ 'default': 'BASEDIR/lib/mysql/plugin',
3025
'inversion': (5, 1, 2),
3026
'platform': 'other',
3028
{ 'default': 'BASEDIR/lib/plugin',
3029
'inversion': (5, 5, 0),
3030
'outversion': (5, 5, 4),
3031
'platform': 'windows',
3033
{ 'default': 'BASEDIR/lib/mysql/plugin',
3034
'inversion': (5, 5, 0),
3035
'outversion': (5, 5, 4),
3036
'platform': 'other',
3038
{ 'default': 'BASEDIR/lib/plugin',
3039
'inversion': (5, 5, 5),
3040
'type': 'dirname'}],
3041
'versions': [ ((4, 1, 25), (5, 0, 67), (5, 1, 2)),
3042
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3044
{ 'caption': 'plugin-load',
3045
'description': 'List of plugins to load at startup',
3046
'name': 'plugin-load',
3047
'values': [{ 'type': 'string'}],
3048
'versions': [((5, 1, 18),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3049
{ 'caption': 'port',
3050
'description': 'Port number to use for connection',
3052
'values': [{ 'default': '3306', 'type': 'numeric'}],
3054
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3056
{ 'caption': 'port-open-timeout',
3057
'description': 'Maximum time in seconds to wait for the port to become free (Default: no wait)',
3058
'name': 'port-open-timeout',
3059
'values': [{ 'default': '0', 'type': 'numeric'}],
3060
'versions': [ ((5, 0, 19), (5, 1, 5)),
3061
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3063
{ 'caption': 'preload_buffer_size',
3064
'description': 'The size of the buffer that is allocated when preloading indexes',
3065
'name': 'preload_buffer_size',
3066
'values': [ { 'default': '32768',
3067
'maximum': '1073741824',
3069
'type': 'numeric'}],
3070
'versions': [ ((4, 1, 1),),
3071
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3073
{ 'caption': 'query_alloc_block_size',
3074
'description': 'Allocation block size for query parsing and execution',
3075
'name': 'query_alloc_block_size',
3076
'values': [ { 'bitsize': '32',
3077
'blocksize': '1024',
3079
'maximum': '4294967295',
3083
'blocksize': '1024',
3085
'maximum': '18446744073709547520',
3087
'type': 'numeric'}],
3089
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3091
{ 'caption': 'query_cache_limit',
3092
'description': "Don't cache results that are bigger than this",
3093
'name': 'query_cache_limit',
3094
'values': [ { 'bitsize': '32',
3095
'default': '1048576',
3096
'maximum': '4294967295',
3100
'default': '1048576',
3101
'maximum': '18446744073709547520',
3103
'type': 'numeric'}],
3105
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3107
{ 'caption': 'query_cache_min_res_unit',
3108
'description': 'Minimal size of unit in which space for results is allocated (last unit will be trimmed after writing all result data)',
3109
'name': 'query_cache_min_res_unit',
3110
'values': [ { 'bitsize': '32',
3112
'maximum': '4294967295',
3117
'maximum': '18446744073709547520',
3119
'type': 'numeric'}],
3121
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3123
{ 'caption': 'query_cache_size',
3124
'description': 'The memory allocated to store results from old queries',
3125
'name': 'query_cache_size',
3126
'values': [ { 'bitsize': '32',
3128
'maximum': '4294967295',
3133
'maximum': '18446744073709547520',
3135
'type': 'numeric'}],
3137
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3139
{ 'caption': 'query_cache_type',
3140
'description': 'Query cache type',
3141
'name': 'query_cache_type',
3142
'values': [{ 'choice': ['0', '1', '2'], 'default': '1', 'type': 'enum'}],
3144
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3146
{ 'caption': 'query_cache_wlock_invalidate',
3147
'description': 'Invalidate queries in query cache on LOCK for write',
3148
'name': 'query_cache_wlock_invalidate',
3149
'values': [ { 'default': 'false',
3152
'type': 'boolean'}],
3154
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3156
{ 'caption': 'query_prealloc_size',
3157
'description': 'Persistent buffer for query parsing and execution',
3158
'name': 'query_prealloc_size',
3159
'values': [ { 'bitsize': '32',
3160
'blocksize': '1024',
3162
'maximum': '4294967295',
3166
'blocksize': '1024',
3168
'maximum': '18446744073709547520',
3170
'type': 'numeric'}],
3172
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3174
{ 'caption': 'range_alloc_block_size',
3175
'description': 'Allocation block size for storing ranges during optimization',
3176
'name': 'range_alloc_block_size',
3177
'values': [ { 'bitsize': '32',
3178
'blocksize': '1024',
3180
'maximum': '4294967295',
3184
'blocksize': '1024',
3186
'inversion': (5, 0, 54),
3187
'maximum': '4294967295',
3191
'blocksize': '1024',
3193
'maximum': '18446744073709547520',
3197
'blocksize': '1024',
3199
'inversion': (5, 0, 54),
3200
'maximum': '18446744073709547520',
3202
'type': 'numeric'}],
3204
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3206
{ 'caption': 'read_buffer_size',
3207
'description': 'Each thread that does a sequential scan allocates a buffer of this size for each table it scans',
3208
'name': 'read_buffer_size',
3209
'values': [ { 'default': '131072',
3210
'maximum': '2147479552',
3212
'type': 'numeric'}],
3214
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3216
{ 'caption': 'read_only',
3217
'description': 'Make all nontemporary tables read only',
3218
'name': 'read_only',
3219
'values': [{ 'default': '0', 'type': 'numeric'}],
3221
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3223
{ 'caption': 'read_rnd_buffer_size',
3224
'description': 'When reading rows in sorted order after a sort, the rows are read through this buffer to avoid a disk seeks. If not set, then it is set to the value of record_buffer.',
3225
'name': 'read_rnd_buffer_size',
3226
'values': [ { 'default': '262144',
3227
'maximum': '4294967295',
3229
'type': 'numeric'}],
3231
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3233
{ 'caption': 'record_buffer',
3234
'deprecated': (4, 0, 3),
3235
'description': 'Alias for read_buffer_size',
3236
'name': 'record_buffer',
3237
'optype': { 'outversion': '4.0.3'},
3238
'values': [ { 'default': '131072',
3239
'maximum': '4294967295',
3241
'type': 'numeric'}],
3242
'versions': [(), (), ()]},
3243
{ 'caption': 'relay-log',
3244
'description': 'The location and base name to use for relay logs',
3245
'name': 'relay-log',
3246
'values': [{ 'type': 'filename'}],
3248
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3250
{ 'caption': 'relay-log-index',
3251
'description': 'The location and name to use for the file that keeps a list of the last relay logs',
3252
'name': 'relay-log-index',
3253
'values': [{ 'type': 'filename'}],
3255
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3257
{ 'caption': 'relay-log-info-file',
3258
'description': 'The location and name of the file that remembers where the SQL replication thread is in the relay logs',
3259
'name': 'relay-log-info-file',
3260
'optype': { 'format': 'relay-log-info-file=file_name'},
3261
'values': [{ 'default': 'relay-log.info', 'type': 'filename'}],
3263
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3265
{ 'caption': 'relay_log_purge',
3266
'description': 'Determines whether relay logs are purged',
3267
'name': 'relay_log_purge',
3268
'values': [ { 'default': 'true',
3271
'type': 'boolean'}],
3272
'versions': [ ((4, 1, 1),),
3273
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3275
{ 'caption': 'relay_log_info_file',
3276
'description': 'The name of the file in which the slave records information about the relay logs.',
3277
'name': 'relay_log_info_file',
3278
'values': [{ 'default': 'relay-log.info', 'type': 'string'}],
3279
'versions': [ ((4, 1, 1),),
3280
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3282
{ 'caption': 'relay_log_index',
3283
'description': 'The name of the relay log index file.',
3284
'name': 'relay_log_index',
3285
'values': [{ 'default': '*host_name*-relay-bin.index', 'type': 'string'}],
3286
'versions': [ ((4, 1, 1),),
3287
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3289
{ 'caption': 'relay_log_recovery',
3290
'description': 'Enables automatic recovery of relay log files from master at startup',
3291
'name': 'relay_log_recovery',
3292
'values': [ { 'default': 'false',
3295
'type': 'boolean'}],
3296
'versions': [((6, 0, 11),), ((5, 5), (5, 6), (6, 0)), ()]},
3297
{ 'caption': 'relay_log_space_limit',
3298
'description': 'Maximum space to use for all relay logs',
3299
'name': 'relay_log_space_limit',
3300
'values': [ { 'bitsize': '32',
3302
'maximum': '4294967295',
3307
'maximum': '18446744073709547520',
3309
'type': 'numeric'}],
3311
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3313
{ 'caption': 'replicate-do-db',
3314
'description': 'Tells the slave SQL thread to restrict replication to the specified database',
3315
'name': 'replicate-do-db',
3316
'values': [{ 'type': 'string'}],
3318
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3320
{ 'caption': 'replicate-do-table',
3321
'description': 'Tells the slave SQL thread to restrict replication to the specified table',
3322
'name': 'replicate-do-table',
3323
'values': [{ 'type': 'string'}],
3325
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3327
{ 'caption': 'replicate-ignore-db',
3328
'description': 'Tells the slave SQL thread not to replicate to the specified database',
3329
'name': 'replicate-ignore-db',
3330
'values': [{ 'type': 'string'}],
3332
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3334
{ 'caption': 'replicate-ignore-table',
3335
'description': 'Tells the slave SQL thread not to replicate to the specified table',
3336
'name': 'replicate-ignore-table',
3337
'values': [{ 'type': 'string'}],
3339
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3341
{ 'caption': 'replicate-rewrite-db',
3342
'description': 'Updates to a database with a different name than the original',
3343
'name': 'replicate-rewrite-db',
3344
'values': [{ 'type': 'string'}],
3346
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3348
{ 'caption': 'replicate-same-server-id',
3349
'description': 'In replication, if set to 1, do not skip events having our server id',
3350
'name': 'replicate-same-server-id',
3351
'values': [ { 'default': 'false',
3354
'type': 'boolean'}],
3355
'versions': [ ((5, 0, 1),),
3356
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3358
{ 'caption': 'replicate-wild-do-table',
3359
'description': 'Tells the slave thread to restrict replication to the tables that match the specified wildcard pattern',
3360
'name': 'replicate-wild-do-table',
3361
'values': [{ 'type': 'string'}],
3363
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3365
{ 'caption': 'replicate-wild-ignore-table',
3366
'description': 'Tells the slave thread not to replicate to the tables that match the given wildcard pattern',
3367
'name': 'replicate-wild-ignore-table',
3368
'values': [{ 'type': 'string'}],
3370
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3372
{ 'caption': 'report-host',
3373
'description': 'Host name or IP of the slave to be reported to the master during slave registration',
3374
'name': 'report-host',
3375
'values': [{ 'type': 'string'}],
3377
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3379
{ 'caption': 'report-password',
3380
'description': 'The account password that a slave server should report to the master server',
3381
'name': 'report-password',
3382
'values': [{ 'type': 'string'}],
3384
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3386
{ 'caption': 'report-port',
3387
'description': 'Port for connecting to slave reported to the master during slave registration',
3388
'name': 'report-port',
3389
'values': [{ 'default': '3306', 'type': 'numeric'}],
3391
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3393
{ 'caption': 'report-user',
3394
'description': 'The account name that a slave server should report to the master server',
3395
'name': 'report-user',
3396
'values': [{ 'type': 'string'}],
3398
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3400
{ 'caption': 'restore_disables_events',
3401
'description': 'Whether RESTORE disables restored events',
3402
'name': 'restore_disables_events',
3403
'values': [ { 'default': 'on',
3406
'type': 'boolean'}],
3407
'versions': [((6, 0, 14),), ((5, 6), (6, 0)), ()]},
3408
{ 'caption': 'restore_elevation',
3409
'description': 'Enable or disable RESTORE privilege elevation',
3410
'name': 'restore_elevation',
3411
'values': [ { 'default': 'on',
3414
'type': 'boolean'}],
3415
'versions': [((6, 0, 14),), ((5, 6), (6, 0)), ()]},
3416
{ 'caption': 'restore_precheck',
3417
'description': 'Whether RESTORE performs privilege checking before restoring',
3418
'name': 'restore_precheck',
3419
'values': [ { 'default': 'on',
3422
'type': 'boolean'}],
3423
'versions': [((6, 0, 14),), ((5, 6), (6, 0)), ()]},
3424
{ 'caption': 'safe-mode',
3425
'deprecated': (5, 0),
3426
'description': 'Skip some optimization stages (for testing)',
3427
'name': 'safe-mode',
3428
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
3430
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3432
{ 'caption': 'safe-show-database',
3433
'deprecated': (4, 0, 2),
3434
'description': 'Deprecated option; use GRANT SHOW DATABASES instead',
3435
'name': 'safe-show-database',
3436
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
3438
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3440
{ 'caption': 'safe-user-create',
3441
'description': "Don't allow new user creation by the user who has no write privileges to the mysql.user table",
3442
'name': 'safe-user-create',
3443
'values': [ { 'default': 'false',
3446
'type': 'boolean'}],
3448
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3450
{ 'caption': 'safemalloc-mem-limit',
3451
'description': 'Simulate memory shortage',
3452
'name': 'safemalloc-mem-limit',
3453
'values': [{ 'type': 'numeric'}],
3455
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)),
3457
{ 'caption': 'secure-auth',
3458
'description': 'Disallow authentication for accounts that have old (pre-4.1) passwords',
3459
'name': 'secure-auth',
3460
'values': [ { 'default': 'false',
3463
'type': 'boolean'}],
3464
'versions': [ ((4, 1, 1),),
3465
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3467
{ 'caption': 'secure-backup-file-priv',
3468
'description': 'Limit BACKUP DATABASE and RESTORE to files in a single directory',
3469
'name': 'secure-backup-file-priv',
3470
'values': [{ 'type': 'string'}],
3471
'versions': [((6, 1, 11),), ((5, 6), (6, 0)), ()]},
3472
{ 'caption': 'secure-file-priv',
3473
'description': 'Limit LOAD_FILE(), LOAD DATA, and SELECT ... INTO OUTFILE to files in specified directory',
3474
'name': 'secure-file-priv',
3475
'optype': { 'format': 'secure-file-priv=path'},
3476
'values': [{ 'type': 'string'}],
3477
'versions': [ ((5, 0, 38), (5, 1, 17)),
3478
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3480
{ 'caption': 'server-id',
3481
'description': 'Uniquely identifies the server instance in the community of replication partners. Must be set to a value greater than 0 to enable replication.',
3482
'name': 'server-id',
3483
'values': [ { 'default': '0',
3484
'maximum': '4294967295',
3486
'type': 'numeric'}],
3488
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3490
{ 'caption': 'server-id-bits',
3491
'description': 'Sets the number of least significant bits in the server_id actually used for identifying the server, permitting NDB API applications to store application data in the most significant bits. server_id must be less than 2 to the power of this value.',
3492
'name': 'server-id-bits',
3493
'values': [ { 'default': '32',
3496
'type': 'numeric'}],
3497
'versions': [((5, 1, 47),), ((5, 1),), ()]},
3498
{ 'caption': 'set-variable',
3499
'deprecated': (5, 0),
3500
'description': 'Change the value of a variable; please note that this option is deprecated',
3501
'name': 'set-variable',
3502
'values': [{ 'type': 'string'}],
3503
'versions': [(), ((4, 1), (5, 0)), ()]},
3504
{ 'caption': 'show-slave-auth-info',
3505
'description': 'Show user name and password in SHOW SLAVE HOSTS on this master',
3506
'name': 'show-slave-auth-info',
3507
'values': [ { 'default': 'false',
3510
'type': 'boolean'}],
3512
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3514
{ 'caption': 'skip-bdb',
3515
'description': 'Disable Berkeley DB (if this version of MySQL supports it)',
3517
'values': [ { 'default': 'false',
3520
'type': 'boolean'}],
3521
'versions': [(), ((4, 1), (5, 0)), ()]},
3522
{ 'caption': 'skip-character-set-client-handshake',
3523
'description': 'Ignore client side character set value sent during handshake',
3524
'name': 'skip-character-set-client-handshake',
3525
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3526
'versions': [ ((4, 1, 15), (5, 0, 13)),
3527
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3529
{ 'caption': 'skip-concurrent-insert',
3530
'description': 'Turn off the ability to select and insert at the same time on MyISAM tables',
3531
'name': 'skip-concurrent-insert',
3532
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3534
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3536
{ 'caption': 'skip-event-scheduler',
3537
'description': 'Sets the Event Scheduler to OFF.',
3538
'name': 'skip-event-scheduler',
3539
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3540
'versions': [(), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3541
{ 'caption': 'skip-external-locking',
3542
'description': 'Skip system (external) locking',
3543
'name': 'skip-external-locking',
3544
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3546
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3548
{ 'caption': 'skip-grant-tables',
3549
'description': 'Start without grant tables. This gives all users FULL ACCESS to all tables',
3550
'name': 'skip-grant-tables',
3551
'values': [ { 'default': 'false',
3554
'type': 'boolean'}],
3556
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3558
{ 'caption': 'skip-host-cache',
3559
'description': "Don't cache host names",
3560
'name': 'skip-host-cache',
3561
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3563
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3565
{ 'caption': 'skip-locking',
3567
'description': 'Deprecated option',
3568
'name': 'skip-locking',
3569
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3571
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3573
{ 'caption': 'skip-merge',
3574
'description': 'Disable Merge storage engine',
3575
'name': 'skip-merge',
3576
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3577
'versions': [((5, 0, 24), (5, 1, 12)), ((5, 0), (5, 1)), ((5, 1, 14),)]},
3578
{ 'caption': 'skip-name-resolve',
3579
'description': "Don't resolve host names. All host names are IPs or 'localhost'",
3580
'name': 'skip-name-resolve',
3581
'values': [ { 'default': 'off',
3584
'type': 'boolean'}],
3586
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3588
{ 'caption': 'skip-networking',
3589
'description': "Don't allow connection with TCP/IP",
3590
'name': 'skip-networking',
3591
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3593
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3595
{ 'caption': 'skip-new',
3596
'description': "Don't use new, possibly wrong routines",
3598
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3600
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3602
{ 'caption': 'skip-partition',
3603
'description': 'Do not enable user-defined partitioning',
3604
'name': 'skip-partition',
3605
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3606
'versions': [(), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3607
{ 'caption': 'skip-show-database',
3608
'description': 'Do not allow SHOW DATABASE statements',
3609
'name': 'skip-show-database',
3610
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3612
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3614
{ 'caption': 'skip-slave-start',
3615
'description': 'If set, slave is not autostarted',
3616
'name': 'skip-slave-start',
3617
'values': [ { 'default': 'false',
3620
'type': 'boolean'}],
3622
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3624
{ 'caption': 'skip-stack-trace',
3625
'description': "Don't print a stack trace on failure",
3626
'name': 'skip-stack-trace',
3627
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3629
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3631
{ 'caption': 'skip-symlink',
3632
'description': "Don't allow symlinking of tables. Deprecated option. Use --skip-symbolic-links.",
3633
'name': 'skip-symlink',
3634
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3636
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3638
{ 'caption': 'skip-sync-bdb-logs',
3640
'description': 'Disables synchronous BDB log flushes',
3641
'name': 'skip-sync-bdb-logs',
3642
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3643
'versions': [(), ((4, 1), (5, 0)), ()]},
3644
{ 'caption': 'skip-thread-priority',
3645
'deprecated': (5, 1, 29),
3646
'description': "Don't give threads different priorities",
3647
'name': 'skip-thread-priority',
3648
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
3650
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3652
{ 'caption': 'slave_allow_batching',
3653
'description': 'Turns update batching on and off for a replication slave',
3654
'name': 'slave_allow_batching',
3655
'values': [ { 'default': 'off',
3658
'type': 'boolean'}],
3659
'versions': [((5, 1, 19),), ((5, 1),), ()]},
3660
{ 'caption': 'slave-load-tmpdir',
3661
'description': 'The location where the slave should put its temporary files when replicating a LOAD DATA INFILE statement',
3662
'name': 'slave-load-tmpdir',
3663
'values': [{ 'default': '/tmp', 'type': 'filename'}],
3665
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3667
{ 'caption': 'slave-skip-errors',
3668
'description': 'Tells the slave thread to continue replication when a query returns an error from the provided list',
3669
'name': 'slave-skip-errors',
3672
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3674
{ 'caption': 'slave_compressed_protocol',
3675
'description': 'Use compression on master/slave protocol',
3676
'name': 'slave_compressed_protocol',
3677
'values': [ { 'default': 'off',
3680
'type': 'boolean'}],
3682
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3684
{ 'caption': 'slave-net-timeout',
3685
'description': 'Number of seconds to wait for more data from a master/slave connection before aborting the read',
3686
'name': 'slave-net-timeout',
3687
'values': [{ 'default': '3600', 'minimum': '1', 'type': 'numeric'}],
3689
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3691
{ 'caption': 'slave_transaction_retries',
3692
'description': 'Number of times the slave SQL thread will retry a transaction in case it failed with a deadlock or elapsed lock wait timeout, before giving up and stopping',
3693
'name': 'slave_transaction_retries',
3694
'values': [ { 'bitsize': '32',
3696
'maximum': '4294967295',
3701
'maximum': '18446744073709547520',
3703
'type': 'numeric'}],
3704
'versions': [ ((4, 1, 11), (5, 0, 3)),
3705
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3707
{ 'caption': 'slave_type_conversions',
3708
'description': 'Controls type conversion mode on replication slave. Value is a list of zero or more elements from the list: ALL_LOSSY, ALL_NON_LOSSY. Set to an empty string to disallow type conversions between master and slave.',
3709
'name': 'slave_type_conversions',
3710
'values': [ { 'choice': [ 'ALL_LOSSY',
3712
'ALL_LOSSY,ALL_NON_LOSSY'],
3715
'versions': [ ((5, 1, 44), (5, 5, 3), (6, 0, 14)),
3716
((5, 1), (5, 5), (5, 6), (6, 0)),
3718
{ 'caption': 'slow-query-log',
3719
'description': 'Enable|disable slow query log',
3720
'name': 'slow-query-log',
3721
'optype': { 'inversion': '5.1.29'},
3722
'values': [ { 'default': 'off',
3725
'type': 'boolean'}],
3726
'versions': [((5, 1, 12),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3727
{ 'caption': 'slow_query_log_file',
3728
'description': 'Name of the slow query log file',
3729
'name': 'slow_query_log_file',
3730
'values': [{ 'type': 'filename'}],
3731
'versions': [((5, 1, 12),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3732
{ 'caption': 'slow_launch_time',
3733
'description': 'If creating the thread takes longer than this value (in seconds), the Slow_launch_threads counter will be incremented',
3734
'name': 'slow_launch_time',
3735
'values': [{ 'default': '2', 'type': 'numeric'}],
3737
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3739
{ 'caption': 'socket',
3740
'description': 'Socket file to use for connection',
3742
'values': [{ 'default': '/tmp/mysql.sock', 'type': 'filename'}],
3744
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3746
{ 'caption': 'sort_buffer_size',
3747
'description': 'Each thread that needs to do a sort allocates a buffer of this size',
3748
'name': 'sort_buffer_size',
3749
'values': [ { 'bitsize': '32',
3750
'default': '2097144',
3751
'maximum': '4294967295',
3754
'default': '2097144',
3755
'maximum': '18446744073709547520',
3756
'type': 'numeric'}],
3758
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3760
{ 'caption': 'sporadic-binlog-dump-fail',
3761
'description': 'Option used by mysql-test for debugging and testing of replication',
3762
'name': 'sporadic-binlog-dump-fail',
3763
'values': [ { 'default': 'false',
3766
'type': 'boolean'}],
3768
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3770
{ 'caption': 'sql-bin-update-same',
3771
'description': 'The update log is deprecated since version 5.0, is replaced by the binary log and this option does nothing anymore',
3772
'name': 'sql-bin-update-same',
3773
'values': [ { 'default': 'false',
3776
'type': 'boolean'}],
3777
'versions': [(), ((4, 1),), ()]},
3778
{ 'caption': 'sql-mode',
3779
'description': 'Set the SQL server mode',
3781
'values': [ { 'choice': [ 'ALLOW_INVALID_DATES',
3783
'ERROR_FOR_DIVISION_BY_ZERO',
3784
'HIGH_NOT_PRECEDENCE',
3786
'NO_AUTO_CREATE_USER',
3787
'NO_AUTO_VALUE_ON_ZERO',
3788
'NO_BACKSLASH_ESCAPES',
3790
'NO_ENGINE_SUBSTITUTION',
3794
'NO_UNSIGNED_SUBTRACTION',
3797
'ONLY_FULL_GROUP_BY',
3798
'PAD_CHAR_TO_FULL_LENGTH',
3801
'STRICT_ALL_TABLES',
3802
'STRICT_TRANS_TABLES'],
3806
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3809
'description': 'Enable SSL for connection (automatically enabled with other flags)',
3810
'disabledby': 'skip-ssl',
3812
'values': [ { 'default': 'false',
3813
'off': 'disabledby',
3815
'type': 'boolean'}],
3817
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3819
{ 'caption': 'ssl-ca',
3820
'description': 'CA file in PEM format (check OpenSSL docs, implies --ssl)',
3822
'values': [{ 'type': 'filename'}],
3823
'versions': [ ((5, 0, 23), (5, 1, 11)),
3833
{ 'caption': 'ssl-capath',
3834
'description': 'CA directory (check OpenSSL docs, implies --ssl)',
3835
'name': 'ssl-capath',
3836
'values': [{ 'type': 'filename'}],
3837
'versions': [ ((5, 0, 23), (5, 1, 11)),
3847
{ 'caption': 'ssl-cert',
3848
'description': 'X509 cert in PEM format (implies --ssl)',
3850
'values': [{ 'type': 'filename'}],
3851
'versions': [ ((5, 0, 23), (5, 1, 11)),
3861
{ 'caption': 'ssl-cipher',
3862
'description': 'SSL cipher to use (implies --ssl)',
3863
'name': 'ssl-cipher',
3864
'values': [{ 'type': 'filename'}],
3865
'versions': [ ((5, 0, 23), (5, 1, 11)),
3875
{ 'caption': 'ssl-key',
3876
'description': 'X509 key in PEM format (implies --ssl)',
3878
'values': [{ 'type': 'string'}],
3879
'versions': [ ((5, 0, 23), (5, 1, 11)),
3889
{ 'caption': 'ssl-verify-server-cert',
3890
'description': 'For clients, verify server host name against Common Name in server certificate',
3891
'name': 'ssl-verify-server-cert',
3892
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
3893
'versions': [((5, 1, 11),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
3894
{ 'caption': 'symbolic-links',
3895
'description': 'Use symbolic links',
3896
'disabledby': 'skip-symbolic-links',
3897
'name': 'symbolic-links',
3898
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
3900
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3902
{ 'caption': 'sync-bdb-logs',
3904
'description': 'Synchronously flush Berkeley DB logs. Enabled by default',
3905
'disabledby': 'skip-sync-bdb-logs',
3906
'name': 'sync-bdb-logs',
3907
'values': [ { 'default': 'true',
3908
'off': 'disabledby',
3910
'type': 'boolean'}],
3911
'versions': [(), ((4, 1), (5, 0)), ()]},
3912
{ 'caption': 'sync_binlog',
3913
'description': 'Synchronously flush binary log to disk after every #th event',
3914
'name': 'sync_binlog',
3915
'values': [ { 'bitsize': '32',
3917
'maximum': '4294967295',
3922
'maximum': '18446744073709547520',
3924
'type': 'numeric'}],
3925
'versions': [ ((4, 1, 3), (5, 0, 1)),
3926
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3928
{ 'caption': 'sync_frm',
3929
'description': 'Sync .frm to disk on create. Enabled by default',
3931
'values': [ { 'default': 'true',
3934
'type': 'boolean'}],
3936
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3938
{ 'caption': 'sync_master_info',
3939
'description': 'Synchronize master.info to disk after every #th event.',
3940
'name': 'sync_master_info',
3941
'values': [ { 'bitsize': '32',
3943
'maximum': '4294967295',
3948
'maximum': '18446744073709547520',
3950
'type': 'numeric'}],
3951
'versions': [((6, 0, 11),), ((5, 5), (5, 6), (6, 0)), ()]},
3952
{ 'caption': 'sync_relay_log',
3953
'description': 'Synchronize relay log to disk after every #th event.',
3954
'name': 'sync_relay_log',
3955
'values': [ { 'bitsize': '32',
3957
'maximum': '4294967295',
3962
'maximum': '18446744073709547520',
3964
'type': 'numeric'}],
3965
'versions': [((6, 0, 10),), ((5, 5), (5, 6), (6, 0)), ()]},
3966
{ 'caption': 'sync_relay_log_info',
3967
'description': 'Synchronize relay.info file to disk after every #th event.',
3968
'name': 'sync_relay_log_info',
3969
'values': [ { 'bitsize': '32',
3971
'maximum': '4294967295',
3976
'maximum': '18446744073709547520',
3978
'type': 'numeric'}],
3979
'versions': [((6, 0, 11),), ((5, 5), (5, 6), (6, 0)), ()]},
3980
{ 'caption': 'sysdate-is-now',
3981
'description': 'Nondefault option to alias SYSDATE() to NOW() to make it safe-replicable',
3982
'name': 'sysdate-is-now',
3983
'values': [ { 'default': 'false',
3986
'type': 'boolean'}],
3987
'versions': [ ((5, 0, 20), (5, 1, 8)),
3988
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
3990
{ 'caption': 'table_cache',
3991
'deprecated': (5, 1, 3),
3992
'description': 'The number of open tables for all threads',
3993
'name': 'table_cache',
3994
'values': [ { 'default': '64',
3995
'maximum': '524288',
3997
'type': 'numeric'}],
3998
'versions': [(), ((4, 1), (5, 0), (5, 1)), ((5, 1, 3),)]},
3999
{ 'caption': 'table_definition_cache',
4000
'description': 'The number of table definitions that can be stored in the definition cache.',
4001
'name': 'table_definition_cache',
4002
'values': [ { 'default': '128',
4003
'maximum': '524288',
4005
'outversion': (5, 1, 24),
4008
'inversion': (5, 1, 25),
4009
'maximum': '524288',
4013
'inversion': (5, 4, 0),
4014
'maximum': '524288',
4018
'inversion': (6, 0, 0),
4019
'maximum': '524288',
4021
'outversion': (6, 0, 5),
4024
'inversion': (6, 0, 6),
4025
'maximum': '524288',
4027
'type': 'numeric'}],
4028
'versions': [((5, 1, 3),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4029
{ 'caption': 'table_lock_wait_timeout',
4030
'description': 'Currently unused',
4031
'name': 'table_lock_wait_timeout',
4032
'values': [ { 'default': '50',
4033
'maximum': '1073741824',
4035
'type': 'numeric'}],
4036
'versions': [ ((5, 0, 10),),
4037
((5, 0), (5, 1), (5, 4), (5, 5), (6, 0)),
4038
((5, 5, 3), (6, 0, 14))]},
4039
{ 'caption': 'table_open_cache',
4040
'description': 'The number of open tables for all threads',
4041
'name': 'table_open_cache',
4042
'values': [ { 'default': '64',
4043
'maximum': '524288',
4047
'inversion': (5, 4, 0),
4048
'maximum': '524288',
4050
'outversion': (5, 4, 1),
4053
'inversion': (5, 4, 2),
4054
'maximum': '524288',
4058
'inversion': (6, 0, 0),
4059
'maximum': '524288',
4061
'type': 'numeric'}],
4062
'versions': [((5, 1, 3),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4063
{ 'caption': 'tc-heuristic-recover',
4064
'description': 'Decision to use in heuristic recover process. Possible values are COMMIT or ROLLBACK',
4065
'name': 'tc-heuristic-recover',
4066
'values': [{ 'choice': ['COMMIT', 'RECOVER'], 'type': 'enum'}],
4067
'versions': [ ((5, 0, 3),),
4068
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4070
{ 'caption': 'temp-pool',
4071
'description': 'Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file',
4072
'name': 'temp-pool',
4073
'values': [ { 'default': 'true',
4076
'type': 'boolean'}],
4078
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4080
{ 'caption': 'thread_cache_size',
4081
'description': 'How many threads we should keep in a cache for reuse',
4082
'name': 'thread_cache_size',
4083
'values': [ { 'default': '0',
4086
'type': 'numeric'}],
4088
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4090
{ 'caption': 'thread_concurrency',
4091
'description': 'Permits the application to give the threads system a hint for the desired number of threads that should be run at the same time',
4092
'name': 'thread_concurrency',
4093
'values': [ { 'default': '10',
4096
'type': 'numeric'}],
4098
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4100
{ 'caption': 'thread_handling',
4101
'description': 'The thread-handling model',
4102
'name': 'thread_handling',
4103
'values': [ { 'choice': ['no-threads', 'one-thread-per-connection'],
4104
'outversion': (6, 0, 3),
4106
{ 'choice': [ 'no-threads',
4107
'one-thread-per-connection',
4109
'inversion': (6, 0, 4),
4111
'versions': [((5, 1, 17),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4112
{ 'caption': 'thread_pool_size',
4113
'description': 'The size of the thread pool',
4114
'name': 'thread_pool_size',
4115
'values': [ { 'default': '20',
4118
'type': 'numeric'}],
4119
'versions': [((6, 0, 4),), ((6, 0),), ((6, 0, 14),)]},
4120
{ 'caption': 'thread_stack',
4121
'description': 'The stack size for each thread',
4122
'name': 'thread_stack',
4123
'values': [ { 'bitsize': '32',
4124
'blocksize': '1024',
4125
'default': '196608',
4126
'maximum': '4294967295',
4127
'minimum': '131072',
4130
'blocksize': '1024',
4131
'default': '262144',
4132
'maximum': '18446744073709547520',
4133
'minimum': '131072',
4134
'type': 'numeric'}],
4136
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4138
{ 'caption': 'timed_mutexes',
4139
'description': 'Specify whether to time mutexes (only InnoDB mutexes are currently supported)',
4140
'name': 'timed_mutexes',
4141
'values': [ { 'default': 'off',
4144
'type': 'boolean'}],
4145
'versions': [ ((5, 0, 3),),
4146
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4148
{ 'caption': 'tmp_table_size',
4149
'description': 'If an in-memory temporary table exceeds this size, MySQL will automatically convert it to an on-disk MyISAM table',
4150
'name': 'tmp_table_size',
4151
'values': [ { 'default': 'system dependent',
4152
'maximum': '4294967295',
4154
'type': 'numeric'}],
4156
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4158
{ 'caption': 'tmpdir',
4159
'description': 'Path for temporary files',
4161
'values': [{ 'type': 'filename'}],
4163
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4165
{ 'caption': 'transaction-isolation',
4166
'description': 'Default transaction isolation level',
4167
'name': 'transaction-isolation',
4168
'values': [ { 'choice': [ 'READ-UNCOMMITTED',
4174
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4176
{ 'caption': 'transaction_alloc_block_size',
4177
'description': 'Allocation block size for transactions to be stored in binary log',
4178
'name': 'transaction_alloc_block_size',
4179
'values': [ { 'bitsize': '32',
4180
'blocksize': '1024',
4182
'maximum': '4294967295',
4186
'blocksize': '1024',
4188
'maximum': '18446744073709547520',
4190
'type': 'numeric'}],
4192
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4194
{ 'caption': 'transaction_prealloc_size',
4195
'description': 'Persistent buffer for transactions to be stored in binary log',
4196
'name': 'transaction_prealloc_size',
4197
'values': [ { 'bitsize': '32',
4198
'blocksize': '1024',
4200
'maximum': '4294967295',
4204
'blocksize': '1024',
4206
'maximum': '18446744073709547520',
4208
'type': 'numeric'}],
4210
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4212
{ 'caption': 'updatable_views_with_limit',
4213
'description': 'This variable controls whether updates to a view can be made when the view does not contain all columns of the primary key',
4214
'name': 'updatable_views_with_limit',
4215
'values': [{ 'default': '1', 'off': '0', 'on': '1', 'type': 'boolean'}],
4216
'versions': [ ((5, 0, 2),),
4217
((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4219
{ 'caption': 'use-symbolic-links',
4220
'deprecated': (5, 0),
4221
'description': 'Enable symbolic link support. Deprecated option. Use --symbolic-links.',
4222
'name': 'use-symbolic-links',
4223
'values': [ { 'default': 'true',
4226
'type': 'boolean'}],
4227
'versions': [(), ((5, 1), (5, 4), (6, 0)), ()]},
4228
{ 'caption': 'user',
4229
'description': 'Run mysqld daemon as user',
4231
'values': [{ 'type': 'string'}],
4233
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4235
{ 'caption': 'verbose',
4236
'description': 'Used with --help option for detailed help',
4238
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4240
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4242
{ 'caption': 'wait_timeout',
4243
'description': 'The number of seconds the server waits for activity on a connection before closing it',
4244
'name': 'wait_timeout',
4245
'values': [ { 'default': '28800',
4246
'maximum': '31536000',
4249
{ 'default': '28800',
4250
'maximum': '2147483',
4252
'platform': 'windows',
4253
'type': 'numeric'}],
4255
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4257
{ 'caption': 'warnings',
4258
'deprecated': (5, 0),
4259
'description': 'Deprecated; use --log-warnings instead',
4261
'values': [ { 'bitsize': '32',
4263
'maximum': '4294967295',
4268
'maximum': '18446744073709547520',
4270
'type': 'numeric'}],
4271
'versions': [(), ((4, 1), (5, 0)), ()]},
4272
{ 'caption': 'debug',
4273
'description': 'Output debug log',
4275
'values': [{ 'default': "'d:t:o,/tmp/mysqld.trace'", 'type': 'string'}],
4277
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4279
{ 'caption': 'skip-safemalloc',
4280
'description': "Don't check for memory overruns during each memory allocation",
4281
'name': 'skip-safemalloc',
4282
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4284
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (6, 0)),
4286
{ 'caption': 'skip-ssl',
4287
'description': "Don't use ssl",
4289
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4291
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4293
{ 'caption': 'standalone',
4294
'description': 'Instructs the MySQL server not to run as a service',
4295
'name': 'standalone',
4296
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4298
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4300
{ 'caption': 'enable-named-pipe',
4301
'description': 'Enable support for named pipes.',
4302
'name': 'enable-named-pipe',
4303
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4304
'versions': [(), ((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4305
{ 'caption': 'ndb_index_stat_cache_entries',
4306
'description': 'Sets the granularity of the statistics by determining the number of starting and ending keys',
4307
'name': 'ndb_index_stat_cache_entries',
4308
'values': [ { 'default': '32',
4309
'maximum': '4294967295',
4311
'type': 'numeric'}],
4312
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ((5, 1, 14),)]},
4313
{ 'caption': 'ndb_index_stat_enable',
4314
'description': 'Use NDB index statistics in query optimization',
4315
'name': 'ndb_index_stat_enable',
4316
'values': [ { 'default': 'off',
4319
'type': 'boolean'}],
4320
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ((5, 1, 19),)]},
4321
{ 'caption': 'ndb_index_stat_update_freq',
4322
'description': 'How often to query data nodes instead of the statistics cache',
4323
'name': 'ndb_index_stat_update_freq',
4324
'values': [ { 'default': '20',
4325
'maximum': '4294967295',
4327
'type': 'numeric'}],
4328
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ((5, 1, 14),)]},
4329
{ 'caption': 'ndb_optimized_node_selection',
4330
'description': 'Determines how an SQL node chooses a cluster data node to use as transaction coordinator',
4331
'name': 'ndb_optimized_node_selection',
4332
'values': [ { 'default': 'on',
4333
'inversion': (4, 1, 9),
4336
'outversion': (5, 1, 22),
4339
'inversion': (5, 1, 22),
4342
'type': 'numeric'}],
4343
'versions': [((4, 1, 9),), ((4, 1), (5, 0), (5, 1)), ()]},
4344
{ 'caption': 'ndb_report_thresh_binlog_epoch_slip',
4345
'description': 'This is a threshold on the number of epochs to be behind before reporting binlog status',
4346
'name': 'ndb_report_thresh_binlog_epoch_slip',
4347
'values': [ { 'default': '3',
4350
'type': 'numeric'}],
4351
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ()]},
4352
{ 'caption': 'ndb_report_thresh_binlog_mem_usage',
4353
'description': 'This is a threshold on the percentage of free memory remaining before reporting binlog status',
4354
'name': 'ndb_report_thresh_binlog_mem_usage',
4355
'values': [ { 'default': '10',
4358
'type': 'numeric'}],
4359
'versions': [(), ((4, 1), (5, 0), (5, 1), (6, 0)), ()]},
4360
{ 'caption': 'ndb_use_transactions',
4361
'description': 'Forces NDB to use a count of records during SELECT COUNT(*) query planning to speed up this type of query',
4362
'name': 'ndb_use_transactions',
4363
'values': [ { 'default': 'on',
4366
'type': 'boolean'}],
4367
'versions': [((4, 1, 18),), ((4, 1), (5, 0), (5, 1), (6, 0)), ()]},
4369
'description': 'Cause the server to revert to certain behaviors present in older versions',
4371
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4372
'versions': [((5, 1, 18),), ((5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4373
{ 'caption': 'lower_case_file_system',
4374
'description': 'This variable describes the case sensitivity of file names on the file system',
4375
'name': 'lower_case_file_system',
4376
'values': [{ 'off': '0', 'on': '1', 'type': 'boolean'}],
4378
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4380
{ 'caption': 'time_zone',
4381
'description': 'The current time zone.',
4382
'name': 'time_zone',
4383
'optype': { 'format': 'default_time_zone'},
4384
'values': [{ 'type': 'string'}],
4386
((4, 1), (5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)),
4388
{ 'caption': 'skip-falcon',
4389
'description': 'Disable the Falcon storage engine',
4390
'name': 'skip-falcon',
4391
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4392
'versions': [(), ((6, 0),), ()]},
4393
{ 'caption': 'skip-ndbcluster',
4394
'description': 'Disable the NDB Cluster storage engine',
4395
'name': 'skip-ndbcluster',
4396
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4397
'versions': [(), ((5, 1), (6, 0)), ()]},
4398
{ 'caption': 'one-thread',
4399
'description': 'Only use one thread (for debugging under Linux)',
4400
'name': 'one-thread',
4401
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4402
'versions': [(), ((5, 0), (5, 1), (5, 4), (5, 5), (5, 6), (6, 0)), ()]},
4403
{ 'caption': 'skip-innodb',
4404
'description': 'Disable InnoDB',
4405
'name': 'skip-innodb',
4406
'values': [{ 'off': 'del', 'on': 'name', 'type': 'boolean'}],
4407
'versions': ((), ((5, 1),), ())}]
added
removed
plugins/wb.admin/backend/config/raw_opts.py
