7
4
The Drizzle Transaction Log contains a sequence of
8
5
`Google Protocol Buffer <http://code.google.com/p/protobuf/>`_
9
6
messages that describe the transactions which have been run.
11
This plugin is loaded by default, but it may need to be configured. See
12
the plugin's :ref:`transaction_log_configuration` and
13
:ref:`transaction_log_variables`.
15
To stop the plugin from loading by default, start :program:`drizzled`
18
--plugin-remove=transaction_log
20
.. seealso:: :doc:`/options` for more information about adding and removing plugins.
22
.. _transaction_log_configuration:
15
Several server variables control the transaction log.
27
These command line options configure the plugin when :program:`drizzled`
28
is started. See :doc:`/configuration` for more information about specifying
17
31
.. program:: drizzled
19
33
.. option:: --transaction-log.enable
36
:Variable: :ref:`transaction_log_enable <transaction_log_enable>`
21
38
Enable transaction log.
23
.. option:: --transaction-log.enable-checksum
40
.. option:: --transaction-log.enable-checksum
43
:Variable: :ref:`transaction_log_enable_checksum <transaction_log_enable_checksum>`
25
45
Enable CRC32 Checksumming of each written transaction log entry
27
.. option:: --transaction-log.file=arg
29
Path to the file to use for transaction log. The default will be
30
:file:`transaction.log`.
32
.. option:: --transaction-log.use-replicator
34
Name of the replicator plugin to use (default='default_replicator')
47
.. option:: --transaction-log.file ARG
49
:Default: :file:`transaction.log`
50
:Variable: :ref:`transaction_log_file <transaction_log_file>`
52
Path to the file to use for transaction log.
36
54
.. option:: --transaction-log.flush-frequency=arg
57
:Variable: :ref:`transaction_log_flush_frequency <transaction_log_flush_frequency>`
38
59
* 0 : rely on operating system to sync log file (default)
39
60
* 1 : sync file at each transaction write
40
61
* 2 : sync log file once per second
42
.. option:: --transaction-log.num-write-buffers=arg
63
.. option:: --transaction-log.num-write-buffers ARG
66
:Variable: :ref:`transaction_log_num_write_buffers <transaction_log_num_write_buffers>`
68
Number of slots for in-memory write buffers.
70
.. option:: --transaction-log.truncate-debug
73
:Variable: :ref:`transaction_log_truncate_debug <transaction_log_truncate_debug>`
75
DEBUGGING - Truncate transaction log.
77
.. option:: --transaction-log.use-replicator ARG
79
:Default: ``default_replicator``
80
:Variable: :ref:`transaction_log_use_replicator <transaction_log_use_replicator>`
82
Name of the replicator plugin to use.
84
.. _transaction_log_variables:
89
These variables show the running configuration of the plugin.
90
See `variables` for more information about querying and setting variables.
92
.. _transaction_log_enable:
94
* ``transaction_log_enable``
98
:Option: :option:`--transaction-log.enable`
100
If the transaction log is enabled or not.
102
.. _transaction_log_enable_checksum:
104
* ``transaction_log_enable_checksum``
108
:Option: :option:`--transaction-log.enable-checksum`
110
Enable CRC32 Checksumming of each written transaction log entry
112
.. _transaction_log_file:
114
* ``transaction_log_file``
118
:Option: :option:`--transaction-log.file`
120
Path to the file to use for transaction log
122
.. _transaction_log_flush_frequency:
124
* ``transaction_log_flush_frequency``
128
:Option: :option:`--transaction-log.flush-frequency`
132
.. _transaction_log_num_write_buffers:
134
* ``transaction_log_num_write_buffers``
138
:Option: :option:`--transaction-log.num-write-buffers`
44
140
Number of slots for in-memory write buffers (default=8).
142
.. _transaction_log_truncate_debug:
144
* ``transaction_log_truncate_debug``
148
:Option: :option:`--transaction-log.truncate-debug`
150
DEBUGGING - Truncate transaction log
152
.. _transaction_log_use_replicator:
154
* ``transaction_log_use_replicator``
158
:Option: :option:`--transaction-log.use-replicator`
160
Name of the replicator plugin to use (default='default_replicator')
47
162
Transaction Log Messages
48
163
------------------------
69
183
this is always a Transaction GPB message.
70
184
* **Length** - The length, in bytes, of the serialized message.
71
185
* **Serialized Message** - The actual message data.
187
.. _transaction_log_examples:
192
Sorry, there are no examples for this plugin.
194
.. _transaction_log_authors:
201
.. _transaction_log_version:
206
This documentation applies to **transaction_log 0.1.1**.
208
To see which version of the plugin a Drizzle server is running, execute:
210
.. code-block:: mysql
212
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='transaction_log'