4
The Innobase plugin provides the InnoDB storage engine. It is almost identical
5
to the innodb_plugin, but adapted to Drizzle. We plan to move to having InnoDB
6
provided by the HailDB plugin, which will allow for easier maintenance and
9
InnoDB is the default storage engine for Drizzle. It is a fully transactional
15
We maintain the Innobase plugin in Drizzle as a downstream project of the
16
innodb_plugin for MySQL. We try and keep it up to date with innodb_plugin
19
Differences from innodb_plugin
20
------------------------------
22
* AUTO_INCREMENT behaves the standard way (as in MyISAM)
23
* Supports four byte UTF-8 with the same index size
4
The :program:`innodb` plugin provides the InnoDB storage engine,
5
a fully transactional MVCC storage engine developed by
6
`Innobase Oy <http://www.innodb.com/>`_. InnoDB is the default
7
storage engine for Drizzle.
10
.. _innodb_compatibility_with_mysql:
12
Compatibility with MySQL
13
------------------------
15
The :program:`innodb` plugin is maintained in Drizzle as a downstream
16
project of the :program:`innodb_plugin` for MySQL. The two are nearly
17
identical, and the Drizzle plugin is usually kept up-to-date with the MySQL
18
plugin, but there are some notable differences:
20
* The on disk formats are slightly incompatible (to allow for the same
21
index length for the four byte UTF-8 that Drizzle supports)
22
* The table definitions (.from for MySQL, .dfe for Drizzle) are completely
23
different. This means that you cannot directly share InnoDB tablespaces
24
between MySQL and Drizzle. Use the drizzledump tool to migrate data from
27
There are also some notable compatibilies:
29
* AUTO_INCREMENT behaves the standard way (as in MyISAM)
30
* Supports four byte UTF-8 with the same index size
32
.. _innodb_native_aio_support:
28
37
InnoDB supports Linux native AIO when compiled on platforms that have the
29
38
libaio development files installed (typically a package called libaio-dev or
30
39
libaio-devel). For more information on the advantages of this please see
31
40
http://blogs.innodb.com/wp/2010/04/innodb-performance-aio-linux/
33
To confirm that Linux native AIO is enabled execute this command:
42
To confirm that Linux native AIO is enabled, execute:
35
44
.. code-block:: mysql
37
show global variables like 'innodb_use_native_aio';
39
Compatibility with MySQL
40
------------------------
42
Although the innobase plugin is near identical to the innodb_plugin in MySQL,
43
the on disk formats are slightly incompatible (to allow for the same index
44
length for the four byte UTF-8 that Drizzle supports) and the table definitions
45
(FRM for MySQL, .dfe for Drizzle) are completely different. This means that you
46
cannot directly share InnoDB tablespaces between MySQL and Drizzle. Use the
47
drizzledump tool to migrate data from MySQL to Drizzle.
46
SHOW GLOBAL VARIABLES LIKE 'innodb_use_native_aio';
49
48
.. _innodb_transaction_log:
51
50
InnoDB Transaction Log
52
51
----------------------
54
The Innobase plugin provides a mechanism to store replication events in an
55
InnoDB table. When enabled, this transaction log can be accessed through
56
the SYS_REPLICATION_LOG and INNODB_REPLICATION_LOG tables in the DATA_DICTIONARY
59
To enable this transaction log, you must start the server with:
53
The :program:`innodb` plugin provides a mechanism to store replication
54
events in an InnoDB table. When enabled, this transaction log can be accessed
55
through the SYS_REPLICATION_LOG and INNODB_REPLICATION_LOG tables in the
56
DATA_DICTIONARY schema.
58
To enable this transaction log, start the server with the
59
:option:`--innodb.replication-log`.
64
This plugin is loaded by default, but it may need to be configured. See
65
the plugin's :ref:`innodb_configuration` and
66
:ref:`innodb_variables`.
68
To stop the plugin from loading by default, start :program:`drizzled`
71
--plugin-remove=innodb
73
.. seealso:: :doc:`/options` for more information about adding and removing plugins.
75
.. _innodb_configuration:
80
These command line options configure the plugin when :program:`drizzled`
81
is started. See :doc:`/configuration` for more information about specifying
61
84
.. program:: drizzled
63
.. option:: --innodb.replication-log
65
It is not enabled by default.
86
.. option:: --innodb.adaptive-flushing-method ARG
89
:Variable: :ref:`innodb_adaptive_flushing_method <innodb_adaptive_flushing_method>`
91
Adaptive flushing method. Possible values are:
97
.. option:: --innodb.additional-mem-pool-size ARG
99
:Default: 8388608 (8M)
100
:Variable: :ref:`innodb_additional_mem_pool_size <innodb_additional_mem_pool_size>`
102
Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures.
104
.. option:: --innodb.auto-lru-dump
107
:Variable: :ref:`innodb_auto_lru_dump <innodb_auto_lru_dump>`
109
Time in seconds between automatic buffer pool dumps.
111
.. option:: --innodb.autoextend-increment ARG
114
:Variable: :ref:`innodb_autoextend_increment <innodb_autoextend_increment>`
116
Data file autoextend increment in megabytes.
118
.. option:: --innodb.buffer-pool-instances ARG
123
Number of buffer pool instances.
125
.. option:: --innodb.buffer-pool-size ARG
127
:Default: 134217728 (128M)
128
:Variable: :ref:`innodb_buffer_pool_size <innodb_buffer_pool_size>`
130
The size of the memory buffer InnoDB uses to cache data and indexes of its tables.
132
.. option:: --innodb.change-buffering
135
:Variable: :ref:`innodb_change_buffering <innodb_change_buffering>`
137
Buffer changes to reduce random access. Possible values:
146
.. option:: --innodb.checkpoint-age-target
149
:Variable: :ref:`innodb_checkpoint_age_target <innodb_checkpoint_age_target>`
151
Control soft limit of checkpoint age. (0 = no control)
153
.. option:: --innodb.commit-concurrency
156
:Variable: :ref:`innodb_commit_concurrency <innodb_commit_concurrency>`
158
Helps in performance tuning in heavily concurrent environments.
160
.. option:: --innodb.concurrency-tickets ARG
163
:Variable: :ref:`innodb_concurrency_tickets <innodb_concurrency_tickets>`
165
Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket.
167
.. option:: --innodb.data-file-path
169
:Default: ibdata1:10M:autoextend
170
:Variable: :ref:`innodb_data_file_path <innodb_data_file_path>`
172
Path to individual files and their sizes.
174
.. option:: --innodb.data-home-dir
177
:Variable: :ref:`innodb_data_home_dir <innodb_data_home_dir>`
179
Directory for InnoDB data.
181
.. option:: --innodb.disable-adaptive-flushing
184
:Variable: :ref:`innodb_adaptive_flushing <innodb_adaptive_flushing>`
186
Do not attempt flushing dirty pages to avoid IO bursts at checkpoints.
188
.. option:: --innodb.disable-adaptive-hash-index
191
:Variable: :ref:`innodb_adaptive_hash_index <innodb_adaptive_hash_index>`
193
Enable InnoDB adaptive hash index (enabled by default)
195
.. option:: --innodb.disable-checksums
198
:Variable: :ref:`innodb_checksums <innodb_checksums>`
200
Disable InnoDB checksums validation.
202
.. option:: --innodb.disable-doublewrite
205
:Variable: :ref:`innodb_doublewrite <innodb_doublewrite>`
207
Disable InnoDB doublewrite buffer.
209
.. option:: --innodb.disable-native-aio
214
Do not use Native AIO library for IO, even if available.
215
See :ref:`innodb_native_aio_support`.
217
.. option:: --innodb.disable-stats-on-metadata
222
Disable statistics gathering for metadata commands such as SHOW TABLE STATUS (on by default).
224
.. option:: --innodb.disable-table-locks
229
Disable InnoDB locking in LOCK TABLES.
231
.. option:: --innodb.disable-xa
234
:Variable: :ref:`innodb_support_xa <innodb_support_xa>`
236
Disable InnoDB support for the XA two-phase commit.
238
.. option:: --innodb.fast-shutdown ARG
241
:Variable: :ref:`innodb_fast_shutdown <innodb_fast_shutdown>`
243
Speeds up the shutdown process of the InnoDB storage engine. Possible values are:
247
* 2 (fastest, crash-like)
249
.. option:: --innodb.file-format ARG
252
:Variable: :ref:`innodb_file_format <innodb_file_format>`
254
File format to use for new tables in .ibd files.
256
.. option:: --innodb.file-format-check
259
:Variable: :ref:`innodb_file_format_check <innodb_file_format_check>`
261
Whether to perform system file format check.
263
.. option:: --innodb.file-format-max ARG
266
:Variable: :ref:`innodb_file_format_max <innodb_file_format_max>`
268
The highest file format in the tablespace.
270
.. option:: --innodb.file-per-table
273
:Variable: :ref:`innodb_file_per_table <innodb_file_per_table>`
275
Stores each InnoDB table to an .ibd file in the database dir.
277
.. option:: --innodb.flush-log-at-trx-commit ARG
280
:Variable: :ref:`innodb_flush_log_at_trx_commit <innodb_flush_log_at_trx_commit>`
282
Flush lot at transaction commit. Possible values are:
284
* 0 (write and flush once per second)
285
* 1 (write and flush at each commit)
286
* 2 (write at commit, flush once per second)
288
.. option:: --innodb.flush-method
291
:Variable: :ref:`innodb_flush_method <innodb_flush_method>`
295
.. option:: --innodb.flush-neighbor-pages ARG
298
:Variable: :ref:`innodb_flush_neighbor_pages <innodb_flush_neighbor_pages>`
300
Enable/Disable flushing also neighbor pages. 0:disable 1:enable
302
.. option:: --innodb.force-recovery
305
:Variable: :ref:`innodb_force_recovery <innodb_force_recovery>`
307
Helps to save your data in case the disk image of the database becomes corrupt.
309
.. option:: --innodb.ibuf-accel-rate ARG
312
:Variable: :ref:`innodb_ibuf_accel_rate <innodb_ibuf_accel_rate>`
314
Tunes amount of insert buffer processing of background, in addition to innodb_io_capacity. (in percentage)
316
.. option:: --innodb.ibuf-active-contract ARG
319
:Variable: :ref:`innodb_ibuf_active_contract <innodb_ibuf_active_contract>`
321
Enable/Disable active_contract of insert buffer. 0:disable 1:enable
323
.. option:: --innodb.ibuf-max-size ARG
326
:Variable: :ref:`innodb_ibuf_max_size <innodb_ibuf_max_size>`
328
The maximum size of the insert buffer (in bytes).
330
.. option:: --innodb.io-capacity ARG
333
:Variable: :ref:`innodb_io_capacity <innodb_io_capacity>`
335
Number of IOPs the server can do. Tunes the background IO rate.
337
.. option:: --innodb.lock-wait-timeout ARG
340
:Variable: :ref:`innodb_lock_wait_timeout <innodb_lock_wait_timeout>`
342
Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. Values above 100000000 disable the timeout.
344
.. option:: --innodb.log-buffer-size ARG
346
:Default: 8,388,608 (8M)
347
:Variable: :ref:`innodb_log_buffer_size <innodb_log_buffer_size>`
349
The size of the buffer which InnoDB uses to write log to the log files on disk.
351
.. option:: --innodb.log-file-size ARG
353
:Default: 20971520 (20M)
354
:Variable: :ref:`innodb_log_file_size <innodb_log_file_size>`
356
The size of the buffer which InnoDB uses to write log to the log files on disk.
358
.. option:: --innodb.log-files-in-group ARG
361
:Variable: :ref:`innodb_log_files_in_group <innodb_log_files_in_group>`
363
Number of log files in the log group. InnoDB writes to the files in a circular fashion.
365
.. option:: --innodb.log-group-home-dir
368
:Variable: :ref:`innodb_log_group_home_dir <innodb_log_group_home_dir>`
370
Path to InnoDB log files.
372
.. option:: --innodb.max-dirty-pages-pct ARG
375
:Variable: :ref:`innodb_max_dirty_pages_pct <innodb_max_dirty_pages_pct>`
377
Percentage of dirty pages allowed in bufferpool.
379
.. option:: --innodb.max-purge-lag
382
:Variable: :ref:`innodb_max_purge_lag <innodb_max_purge_lag>`
384
Desired maximum length of the purge queue (0 = no limit)
386
.. option:: --innodb.mirrored-log-groups ARG
389
:Variable: :ref:`innodb_mirrored_log_groups <innodb_mirrored_log_groups>`
391
Number of identical copies of log groups we keep for the database. Currently this should be set to 1.
393
.. option:: --innodb.old-blocks-pct ARG
396
:Variable: :ref:`innodb_old_blocks_pct <innodb_old_blocks_pct>`
398
Percentage of the buffer pool to reserve for 'old' blocks.
400
.. option:: --innodb.old-blocks-time
403
:Variable: :ref:`innodb_old_blocks_time <innodb_old_blocks_time>`
405
Move blocks to the 'new' end of the buffer pool if the first access
406
was at least this many milliseconds ago.
408
.. option:: --innodb.open-files ARG
411
:Variable: :ref:`innodb_open_files <innodb_open_files>`
413
How many files at the maximum InnoDB keeps open at the same time.
415
.. option:: --innodb.purge-batch-size ARG
418
:Variable: :ref:`innodb_purge_batch_size <innodb_purge_batch_size>`
420
Number of UNDO logs to purge in one batch from the history list.
422
.. option:: --innodb.purge-threads ARG
425
:Variable: :ref:`innodb_purge_threads <innodb_purge_threads>`
427
Purge threads can be either 0 or 1.
429
.. option:: --innodb.read-ahead ARG
432
:Variable: :ref:`innodb_read_ahead <innodb_read_ahead>`
434
Control read ahead activity. Possible values are:
441
.. option:: --innodb.read-ahead-threshold ARG
444
:Variable: :ref:`innodb_read_ahead_threshold <innodb_read_ahead_threshold>`
446
Number of pages that must be accessed sequentially for InnoDB to trigger a readahead.
448
.. option:: --innodb.read-io-threads ARG
451
:Variable: :ref:`innodb_read_io_threads <innodb_read_io_threads>`
453
Number of background read I/O threads in InnoDB.
455
.. option:: --innodb.replication-delay
458
:Variable: :ref:`innodb_replication_delay <innodb_replication_delay>`
460
Replication thread delay (ms) on the slave server if innodb_thread_concurrency is reached (0 by default)
462
.. option:: --innodb.replication-log
465
:Variable: :ref:`innodb_replication_log <innodb_replication_log>`
467
Enable :ref:`innodb_transaction_log`.
469
.. option:: --innodb.spin-wait-delay ARG
472
:Variable: :ref:`innodb_spin_wait_delay <innodb_spin_wait_delay>`
474
Maximum delay between polling for a spin lock.
476
.. option:: --innodb.stats-sample-pages ARG
479
:Variable: :ref:`innodb_stats_sample_pages <innodb_stats_sample_pages>`
481
The number of index pages to sample when calculating statistics.
483
.. option:: --innodb.status-file
486
:Variable: :ref:`innodb_status_file <innodb_status_file>`
488
Enable SHOW INNODB STATUS output in the innodb_status.<pid> file.
490
.. option:: --innodb.strict-mode
493
:Variable: :ref:`innodb_strict_mode <innodb_strict_mode>`
495
Use strict mode when evaluating create options.
497
.. option:: --innodb.sync-spin-loops ARG
500
:Variable: :ref:`innodb_sync_spin_loops <innodb_sync_spin_loops>`
502
Count of spin-loop rounds in InnoDB mutexes.
504
.. option:: --innodb.thread-concurrency
507
:Variable: :ref:`innodb_thread_concurrency <innodb_thread_concurrency>`
509
Helps in performance tuning in heavily concurrent environments. Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling.
511
.. option:: --innodb.thread-sleep-delay ARG
514
:Variable: :ref:`innodb_thread_sleep_delay <innodb_thread_sleep_delay>`
516
Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep.
518
.. option:: --innodb.use-internal-malloc
521
:Variable: `innodb_use_sys_malloc <innodb_use_sys_malloc>`
523
Use InnoDB's internal memory allocator instead of the system's malloc.
525
.. option:: --innodb.version ARG
528
:Variable: :ref:`innodb_version_var <innodb_version_var>`
532
.. option:: --innodb.write-io-threads ARG
535
:Variable: :ref:`innodb_write_io_threads <innodb_write_io_threads>`
537
Number of background write I/O threads in InnoDB.
539
.. _innodb_variables:
544
These variables show the running configuration of the plugin.
545
See `variables` for more information about querying and setting variables.
547
.. _innodb_adaptive_flushing:
549
* ``innodb_adaptive_flushing``
553
:Option: :option:`--innodb.disable-adaptive-flushing`
555
If adaptive flushing is enabled or not.
557
.. _innodb_adaptive_flushing_method:
559
* ``innodb_adaptive_flushing_method``
563
:Option: :option:`--innodb.adaptive-flushing-method`
565
Adaptive flushing method. Possible values are:
571
.. _innodb_adaptive_hash_index:
573
* ``innodb_adaptive_hash_index``
577
:Option: :option:`--innodb.disable-adaptive-hash-index`
579
If the adapative hash index is enabled or not.
581
.. _innodb_additional_mem_pool_size:
583
* ``innodb_additional_mem_pool_size``
587
:Option: :option:`--innodb.additional-mem-pool-size`
589
Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures.
591
.. _innodb_auto_lru_dump:
593
* ``innodb_auto_lru_dump``
597
:Option: :option:`--innodb.auto-lru-dump`
599
Time in seconds between automatic buffer pool dumps.
601
.. _innodb_autoextend_increment:
603
* ``innodb_autoextend_increment``
607
:Option: :option:`--innodb.autoextend-increment`
609
Data file autoextend increment in megabytes
611
.. _innodb_buffer_pool_size:
613
* ``innodb_buffer_pool_size``
617
:Option: :option:`--innodb.buffer-pool-size`
619
The size of the memory buffer InnoDB uses to cache data and indexes of its tables.
621
.. _innodb_change_buffering:
623
* ``innodb_change_buffering``
627
:Option: :option:`--innodb.change-buffering`
629
Buffer changes to reduce random access: OFF
631
.. _innodb_checkpoint_age_target:
633
* ``innodb_checkpoint_age_target``
637
:Option: :option:`--innodb.checkpoint-age-target`
639
Control soft limit of checkpoint age. (0 : not control)
641
.. _innodb_checksums:
643
* ``innodb_checksums``
647
:Option: :option:`--innodb.disable-checksums`
649
If checksums are enabled or not.
651
.. _innodb_commit_concurrency:
653
* ``innodb_commit_concurrency``
657
:Option: :option:`--innodb.commit-concurrency`
659
Helps in performance tuning in heavily concurrent environments.
661
.. _innodb_concurrency_tickets:
663
* ``innodb_concurrency_tickets``
667
:Option: :option:`--innodb.concurrency-tickets`
669
Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket
671
.. _innodb_data_file_path:
673
* ``innodb_data_file_path``
677
:Option: :option:`--innodb.data-file-path`
679
Path to individual files and their sizes.
681
.. _innodb_data_home_dir:
683
* ``innodb_data_home_dir``
687
:Option: :option:`--innodb.data-home-dir`
689
Directory for InnoDB data.
691
.. _innodb_doublewrite:
693
* ``innodb_doublewrite``
697
:Option: :option:`--innodb.disable-doublewrite`
699
If doublewrite buffer is enabled or not.
701
.. _innodb_fast_shutdown:
703
* ``innodb_fast_shutdown``
707
:Option: :option:`--innodb.fast-shutdown`
709
Fast shutdown method.
711
.. _innodb_file_format_check:
713
* ``innodb_file_format_check``
717
:Option: :option:`--innodb.file-format-check`
719
Whether to perform system file format check.
721
.. _innodb_file_per_table:
723
* ``innodb_file_per_table``
727
:Option: :option:`--innodb.file-per-table`
729
Stores each InnoDB table to an .ibd file in the database dir.
731
.. _innodb_file_format:
733
* ``innodb_file_format``
737
:Option: :option:`--innodb.file-format`
739
File format to use for new tables in .ibd files.
741
.. _innodb_file_format_max:
743
* ``innodb_file_format_max``
747
:Option: :option:`--innodb.file-format-max`
749
The highest file format in the tablespace.
751
.. _innodb_flush_method:
753
* ``innodb_flush_method``
757
:Option: :option:`--innodb.flush-method`
761
.. _innodb_flush_log_at_trx_commit:
763
* ``innodb_flush_log_at_trx_commit``
767
:Option: :option:`--innodb.flush-log-at-trx-commit`
769
Set to 0 (write and flush once per second)
771
.. _innodb_flush_neighbor_pages:
773
* ``innodb_flush_neighbor_pages``
777
:Option: :option:`--innodb.flush-neighbor-pages`
779
Enable/Disable flushing also neighbor pages. 0:disable 1:enable
781
.. _innodb_force_recovery:
783
* ``innodb_force_recovery``
787
:Option: :option:`--innodb.force-recovery`
789
Helps to save your data in case the disk image of the database becomes corrupt.
791
.. _innodb_ibuf_accel_rate:
793
* ``innodb_ibuf_accel_rate``
797
:Option: :option:`--innodb.ibuf-accel-rate`
799
Tunes amount of insert buffer processing of background
801
.. _innodb_ibuf_active_contract:
803
* ``innodb_ibuf_active_contract``
807
:Option: :option:`--innodb.ibuf-active-contract`
809
Enable/Disable active_contract of insert buffer. 0:disable 1:enable
811
.. _innodb_ibuf_max_size:
813
* ``innodb_ibuf_max_size``
817
:Option: :option:`--innodb.ibuf-max-size`
819
The maximum size of the insert buffer (in bytes).
821
.. _innodb_io_capacity:
823
* ``innodb_io_capacity``
827
:Option: :option:`--innodb.io-capacity`
829
Number of IOPs the server can do. Tunes the background IO rate
831
.. _innodb_lock_wait_timeout:
833
* ``innodb_lock_wait_timeout``
837
:Option: :option:`--innodb.lock-wait-timeout`
839
Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. Values above 100000000 disable the timeout.
841
.. _innodb_log_group_home_dir:
843
* ``innodb_log_group_home_dir``
847
:Option: :option:`--innodb.log-group-home-dir`
849
Path to InnoDB log files.
851
.. _innodb_log_buffer_size:
853
* ``innodb_log_buffer_size``
857
:Option: :option:`--innodb.log-buffer-size`
859
The size of the buffer which InnoDB uses to write log to the log files on disk.
861
.. _innodb_log_file_size:
863
* ``innodb_log_file_size``
867
:Option: :option:`--innodb.log-file-size`
869
The size of the buffer which InnoDB uses to write log to the log files on disk.
871
.. _innodb_log_files_in_group:
873
* ``innodb_log_files_in_group``
877
:Option: :option:`--innodb.log-files-in-group`
879
Number of log files in the log group. InnoDB writes to the files in a circular fashion.
881
.. _innodb_max_dirty_pages_pct:
883
* ``innodb_max_dirty_pages_pct``
887
:Option: :option:`--innodb.max-dirty-pages-pct`
889
Percentage of dirty pages allowed in bufferpool.
891
.. _innodb_max_purge_lag:
893
* ``innodb_max_purge_lag``
897
:Option: :option:`--innodb.max-purge-lag`
899
Desired maximum length of the purge queue (0 = no limit)
901
.. _innodb_mirrored_log_groups:
903
* ``innodb_mirrored_log_groups``
907
:Option: :option:`--innodb.mirrored-log-groups`
909
Number of identical copies of log groups we keep for the database. Currently this should be set to 1.
911
.. _innodb_old_blocks_pct:
913
* ``innodb_old_blocks_pct``
917
:Option: :option:`--innodb.old-blocks-pct`
919
Percentage of the buffer pool to reserve for 'old' blocks.
921
.. _innodb_old_blocks_time:
923
* ``innodb_old_blocks_time``
927
:Option: :option:`--innodb.old-blocks-time`
929
ove blocks to the 'new' end of the buffer pool if the first access
931
.. _innodb_open_files:
933
* ``innodb_open_files``
937
:Option: :option:`--innodb.open-files`
939
How many files at the maximum InnoDB keeps open at the same time.
941
.. _innodb_purge_batch_size:
943
* ``innodb_purge_batch_size``
947
:Option: :option:`--innodb.purge-batch-size`
949
Number of UNDO logs to purge in one batch from the history list.
951
.. _innodb_purge_threads:
953
* ``innodb_purge_threads``
957
:Option: :option:`--innodb.purge-threads`
959
Purge threads can be either 0 or 1. Default is 1.
961
.. _innodb_read_ahead:
963
* ``innodb_read_ahead``
967
:Option: :option:`--innodb.read-ahead`
971
.. _innodb_read_ahead_threshold:
973
* ``innodb_read_ahead_threshold``
977
:Option: :option:`--innodb.read-ahead-threshold`
979
Number of pages that must be accessed sequentially for InnoDB to trigger a readahead.
981
.. _innodb_read_io_threads:
983
* ``innodb_read_io_threads``
987
:Option: :option:`--innodb.read-io-threads`
989
Number of background read I/O threads in InnoDB.
991
.. _innodb_replication_delay:
993
* ``innodb_replication_delay``
997
:Option: :option:`--innodb.replication-delay`
999
Replication thread delay (ms) on the slave server if innodb_thread_concurrency is reached (0 by default)
1001
.. _innodb_replication_log:
1003
* ``innodb_replication_log``
1007
:Option: :option:`--innodb.replication-log`
1009
If the :ref:`innodb_transaction_log` is enabled or not.
1011
.. _innodb_spin_wait_delay:
1013
* ``innodb_spin_wait_delay``
1017
:Option: :option:`--innodb.spin-wait-delay`
1019
Maximum delay between polling for a spin lock (6 by default)
1021
.. _innodb_stats_sample_pages:
1023
* ``innodb_stats_sample_pages``
1027
:Option: :option:`--innodb.stats-sample-pages`
1029
The number of index pages to sample when calculating statistics (default 8)
1031
.. _innodb_status_file:
1033
* ``innodb_status_file``
1037
:Option: :option:`--innodb.status-file`
1039
Enable SHOW INNODB STATUS output in the innodb_status.<pid> file
1041
.. _innodb_strict_mode:
1043
* ``innodb_strict_mode``
1047
:Option: :option:`--innodb.strict-mode`
1049
Use strict mode when evaluating create options.
1051
.. _innodb_support_xa:
1053
* ``innodb_support_xa``
1057
:Option: :option:`--innodb.disable-xa`
1059
If two-phase XA commit it enabled or not.
1061
.. _innodb_sync_spin_loops:
1063
* ``innodb_sync_spin_loops``
1067
:Option: :option:`--innodb.sync-spin-loops`
1069
Count of spin-loop rounds in InnoDB mutexes (30 by default)
1071
.. _innodb_thread_concurrency:
1073
* ``innodb_thread_concurrency``
1077
:Option: :option:`--innodb.thread-concurrency`
1079
Helps in performance tuning in heavily concurrent environments. Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling.
1081
.. _innodb_thread_sleep_delay:
1083
* ``innodb_thread_sleep_delay``
1087
:Option: :option:`--innodb.thread-sleep-delay`
1089
Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep
1091
.. _innodb_use_native_aio:
1093
* ``innodb_use_native_aio``
1097
:Option: :option:`--innodb.diable-native-aio`
1099
If :ref:`innodb_native_aio_support` enabled or not.
1101
.. _innodb_use_sys_malloc:
1103
* ``innodb_use_sys_malloc``
1107
:Option: :option:`--innodb.use-interal-malloc`
1109
If system or internal malloc() is being used.
1111
.. _innodb_version_var:
1113
* ``innodb_version``
1117
:Option: :option:`--innodb.version`
1121
.. _innodb_write_io_threads:
1123
* ``innodb_write_io_threads``
1127
:Option: :option:`--innodb.write-io-threads`
1129
Number of background write I/O threads in InnoDB.
1136
`Innobase Oy <http://www.innodb.com/>`_
1143
This documentation applies to **innodb 1.1.4**.
1145
To see which version of the plugin a Drizzle server is running, execute:
1147
.. code-block:: mysql
1149
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='innodb'
1156
* First Drizzle version.