Help:Configuration parameter "$smwgQTemporaryTablesAutoCommitMode"

From semantic-mediawiki.org
Jump to: navigation, search
Title $smwgQTemporaryTablesAutoCommitMode
Description Sets whether certain types of transactions may be performed that cannot be safely logged using global transaction identifiers (GTIDs).
Default setting
false
Software Semantic MediaWiki
First version supported 2.5.0
Last version supported still available
Configuration Store settings · Miscellaneous
Keyword SQLStore · Store

$smwgQTemporaryTablesAutoCommitMode is a configuration parameter that sets whether certain types of transactions may be performed that cannot be safely logged using global transaction identifiers (GTIDs). This parameter is specific to a relational data store and was introduced in Semantic MediaWiki 2.5.0.1. It was backported to the 2.4.x branch of Semantic MediaWiki.2

The default setting "false" enforces transactions to be GTID consistent. This requirement can be disabled by changing the setting to "true".

Rationale

MySQL's Global transaction identifier is a unique transaction ID assigned to every transaction that happens in a MySQL database. Using it will create issues when executing queries that rely on temporary tables. According to the documentation "... the operations listed cannot be used ... CREATE TEMPORARY TABLE statements inside transactions".

This configuration parameter helps mitigate issues encountered when the MySQL variable @@GLOBAL.ENFORCE_GTID_CONSISTENCY is set to enforce GTIDs to be consistent.


This documentation page applies to all SMW versions from 2.5.0 to the most current version.
     

Help:$smwgQTemporaryTablesAutoCommitMode en 2.5.0