From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- .../williamdes/mariadb-mysql-kbs/test/DataTest.php | 74 -- .../mariadb-mysql-kbs/test/RefProvider.php | 50 - .../mariadb-mysql-kbs/test/SearchTest.php | 178 --- .../mariadb-mysql-kbs/test/SlimDataTest.php | 59 - .../williamdes/mariadb-mysql-kbs/test/cleaner.js | 193 ---- .../test/data/mysql_test_case_1.html | 235 ---- .../test/data/mysql_test_case_2.html | 1211 -------------------- .../test/data/mysql_test_case_3.html | 339 ------ .../test/data/ultraSlimDataTestWithVariables.json | 51 - .../williamdes/mariadb-mysql-kbs/test/index.js | 12 - .../williamdes/mariadb-mysql-kbs/test/parser.js | 129 --- .../williamdes/mariadb-mysql-kbs/test/phpunit.xml | 27 - .../williamdes/mariadb-mysql-kbs/test/templates.js | 218 ---- 13 files changed, 2776 deletions(-) delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/DataTest.php delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/RefProvider.php delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SearchTest.php delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SlimDataTest.php delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/cleaner.js delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_1.html delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_2.html delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_3.html delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/ultraSlimDataTestWithVariables.json delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/index.js delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/parser.js delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/phpunit.xml delete mode 100644 srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/templates.js (limited to 'srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test') diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/DataTest.php b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/DataTest.php deleted file mode 100644 index c12f576..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/DataTest.php +++ /dev/null @@ -1,74 +0,0 @@ -setRemoteRefProvider(new RefProvider()); - $schema = Schema::import($id, $options); - $schema->in($contents); - return true;// No exception occured - } - - /** - * test files - * - * @return void - */ - public function testFileSample(): void - { - $slimDataTestData = json_decode((string) file_get_contents(__DIR__."/data/ultraSlimDataTestWithVariables.json")); - $this->assertTrue(self::validate($slimDataTestData, "urn:williamdes:mariadb-mysql-kbs:ultraslimdata")); - } - - /** - * test slim data - * - * @return void - */ - public function testFileSlim(): void - { - $slimData = json_decode((string) file_get_contents(__DIR__."/../dist/merged-slim.json")); - $this->assertTrue(self::validate($slimData, "urn:williamdes:mariadb-mysql-kbs:slimdata")); - } - - /** - * test ultra slim data - * - * @return void - */ - public function testFileUltraSlim(): void - { - $slimData = json_decode((string) file_get_contents(__DIR__."/../dist/merged-ultraslim.json")); - $this->assertTrue(self::validate($slimData, "urn:williamdes:mariadb-mysql-kbs:ultraslimdata")); - } - - /** - * test ultra slim data - * - * @return void - */ - public function testFileRaw(): void - { - $slimData = json_decode((string) file_get_contents(__DIR__."/../dist/merged-raw.json")); - $this->assertTrue(self::validate($slimData, "urn:williamdes:mariadb-mysql-kbs:rawdata")); - } - -} diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/RefProvider.php b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/RefProvider.php deleted file mode 100644 index 50b25cc..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/RefProvider.php +++ /dev/null @@ -1,50 +0,0 @@ -{'$id'}) && $schema !== null) { - $this->urnSchemas[$schema->{'$id'}] = $schema; - } - } - } - } - - /** - * @param string $url The file url - * @return \stdClass|false json_decode of $url resource content - */ - public function getSchemaData($url) - { - if (isset($this->urnSchemas[$url])) {// Handle urn: urls - return $this->urnSchemas[$url]; - } elseif (is_file($url)) {// Handle file - return json_decode((string) file_get_contents($url)); - } else {// Handle URL - return json_decode((string) file_get_contents(rawurldecode($url))); - } - } - -} diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SearchTest.php b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SearchTest.php deleted file mode 100644 index cc15ac9..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SearchTest.php +++ /dev/null @@ -1,178 +0,0 @@ -addVariable("variable-1", "boolean", true); - $sd->addVariable("variable-2", null, null); - $sd->addVariable("variable-3", null, true); - $variable4 = $sd->addVariable("variable-4", null, false); - $variable4->addDocumentation("https://mariadb.com/testurl/for/variable/4", "myanchor"); - $variable4->addDocumentation("https://dev.mysql.com/testurl_for-variable/4", "my_anchor"); - Search::loadTestData($sd); - } - - /** - * test get by name - * - * @return void - */ - public function testGetByName(): void - { - $found = Search::getByName("variable-4"); - $this->assertEquals("https://mariadb.com/testurl/for/variable/4#myanchor", $found); - } - - /** - * test get by name for MySQL - * - * @return void - */ - public function testGetByNameMYSQL(): void - { - $found = Search::getByName("variable-4", Search::MYSQL); - $this->assertEquals("https://dev.mysql.com/testurl_for-variable/4#my_anchor", $found); - } - - /** - * test get by name for MARIADB - * - * @return void - */ - public function testGetByNameMARIADB(): void - { - $found = Search::getByName("variable-4", Search::MARIADB); - $this->assertEquals("https://mariadb.com/testurl/for/variable/4#myanchor", $found); - } - - /** - * test get by name - * - * - * @return void - */ - public function testException(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does not exist for this type of documentation !/'); - Search::getByName("variable-3", Search::MARIADB); - } - - /** - * test get by name not found variable - * - * - * @return void - */ - public function testExceptionNoFoundGetVariableType(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does not exist !/'); - Search::getVariableType("acbdefghi0202"); - } - - /** - * test get by name not found variable - * - * - * @return void - */ - public function testExceptionNoFound(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does not exist !/'); - Search::getByName("acbdefghi0202", Search::MARIADB); - } - - /** - * test get by name not found variable - * - * - * @return void - */ - public function testExceptionNoFoundGetVariable(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does not exist !/'); - Search::getVariable("acbdefghi0202"); - } - - /** - * test load data fail - * - * @runInSeparateProcess - * - * @return void - */ - public function testExceptionLoadData(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does not exist !/'); - Search::$DATA_DIR = "."; - Search::$loaded = false; - Search::loadData(); - } - - /** - * test get variables with dynamic status - * - * @return void - */ - public function testGetVariablesWithDynamic(): void - { - $dynamic = Search::getVariablesWithDynamic(true); - $this->assertEquals($dynamic, Search::getDynamicVariables()); - $static = Search::getVariablesWithDynamic(false); - $this->assertEquals($static, Search::getStaticVariables()); - $this->assertEquals(2, count($dynamic)); - $this->assertEquals(1, count($static)); - $common = \array_intersect($dynamic, $static); - $this->assertEquals(0, count($common));// Impossible to be dynamic and not - } - - /** - * test Exception get variable type has no type - * - * - * @return void - */ - public function testExceptionGetVariableType(): void - { - $this->expectException(KBException::class); - $this->expectExceptionCode(0); - $this->expectExceptionMessageRegExp('/(.+) does have a known type !/'); - Search::getVariableType("variable-2"); - } - - /** - * test get variable type - * - * @return void - */ - public function testGetVariableType(): void - { - $type = Search::getVariableType("variable-1"); - $this->assertEquals("boolean", $type); - } - -} diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SlimDataTest.php b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SlimDataTest.php deleted file mode 100644 index 30a1d18..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/SlimDataTest.php +++ /dev/null @@ -1,59 +0,0 @@ -assertInstanceOf(SlimData::class, $slimData); - return $slimData; - } - - /** - * Test json_encode empty object - * - * @param SlimData $slimData SlimData instance - * @depends testCreateInstance - * @return void - */ - public function testToJsonEmpty(SlimData $slimData): void - { - $this->assertEquals('{"version":1}', json_encode($slimData)); - } - - /** - * Test json_encode with variables - * - * @param SlimData $slimData SlimData instance - * @depends testCreateInstance - * @return void - */ - public function testToJsonWithVariables(SlimData $slimData): void - { - $slimData->addVariable("Test_var", "boolean", true); - $slimData->addVariable("another-variable", "string", false); - $kbe = $slimData->addVariable("doc-variable_ok", "integer", true); - $kbe->addDocumentation("https://example.org/williamdes/mariadb-mysql-kbs", "a_doc-variable_ok"); - $kbe->addDocumentation("https://example.org/williamdes/mariadb-mysql-kbs", "a_href_ok"); - $kbe->addDocumentation("https://example.org/williamdes/mariadb-mysql-kbs/_doc-variable_ok"); - $kbe->addDocumentation("https://dev.mysql.com/"); - $kbe->addDocumentation("https://mariadb.com/"); - $kbe->addDocumentation("https://mariadb.com/", "anchorname"); - $this->assertEquals( - file_get_contents(__DIR__."/data/ultraSlimDataTestWithVariables.json"), - json_encode($slimData, JSON_UNESCAPED_SLASHES | JSON_PRETTY_PRINT) - ); - } - -} diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/cleaner.js b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/cleaner.js deleted file mode 100644 index 007207e..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/cleaner.js +++ /dev/null @@ -1,193 +0,0 @@ -'use strict'; - -const expect = require('chai').expect; -const cleaner = require(__dirname + '/../src/cleaner'); - -module.exports = function() { - suite('cleaner', function() { - test('clean cli html code', function(done) { - const cli = cleaner.cleanCli('--test-argument'); - expect(cli).to.equal('--test-argument'); - done(); - }); - test('clean cli html code not closed', function(done) { - const cli = cleaner.cleanCli('--test-argument'); - expect(cli).to.equal('--test-argument'); - done(); - }); - test('clean cli nothing to clean', function(done) { - const cli = cleaner.cleanCli('--test-argument'); - expect(cli).to.equal('--test-argument'); - done(); - }); - test('clean cli undefined', function(done) { - const cli = cleaner.cleanCli(undefined); - expect(cli).to.equal(undefined); - done(); - }); - test('clean range undefined', function(done) { - const range = cleaner.cleanRange(undefined); - expect(range).to.deep.equal(undefined); - done(); - }); - test('clean range.from typeof object (dataset-1)', function(done) { - const range = cleaner.cleanRange({ - from: null, - to: null, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-2)', function(done) { - const range = cleaner.cleanRange({ - to: null, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-3)', function(done) { - const range = cleaner.cleanRange({ - from: null, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-4)', function(done) { - const range = cleaner.cleanRange({ - from: undefined, - to: undefined, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-5)', function(done) { - const range = cleaner.cleanRange({ - to: undefined, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-6)', function(done) { - const range = cleaner.cleanRange({ - from: undefined, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof object (dataset-7)', function(done) { - const range = cleaner.cleanRange({ - from: NaN, - to: NaN, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.from typeof int', function(done) { - const range = cleaner.cleanRange({ - from: 1024, - }); - expect(range).to.deep.equal({ - from: 1024, - }); - done(); - }); - test('clean range.from typeof string', function(done) { - const range = cleaner.cleanRange({ - from: '1024', - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.to typeof int', function(done) { - const range = cleaner.cleanRange({ - to: 1024, - }); - expect(range).to.deep.equal({ - to: 1024, - }); - done(); - }); - test('clean range.to typeof string', function(done) { - const range = cleaner.cleanRange({ - to: '1024', - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range.to typeof object', function(done) { - const range = cleaner.cleanRange({ - to: {}, - }); - expect(range).to.deep.equal({}); - done(); - }); - test('clean range to upwards', function(done) { - const range = cleaner.cleanRange({ - to: 'upwards', - }); - expect(range).to.deep.equal({ - to: 'upwards', - }); - done(); - }); - test('clean range to upwards match', function(done) { - const range = cleaner.cleanRange({ - to: '(128KB) upwards', - }); - expect(range).to.deep.equal({ - to: 'upwards', - }); - done(); - }); - test('clean binary types in bytes', function(done) { - const type = cleaner.cleanType('in bytes'); - expect(type).to.deep.equal('byte'); - done(); - }); - test('clean binary types size in mb', function(done) { - const type = cleaner.cleanType('size in mb'); - expect(type).to.deep.equal('byte'); - done(); - }); - test('clean binary types number of bytes', function(done) { - const type = cleaner.cleanType('number of bytes'); - expect(type).to.deep.equal('byte'); - done(); - }); - test('clean binary types number of', function(done) { - const type = cleaner.cleanType('number of'); - expect(type).to.deep.equal('integer'); - done(); - }); - test('clean binary types size of', function(done) { - const type = cleaner.cleanType('size of'); - expect(type).to.deep.equal('integer'); - done(); - }); - test('clean binary types in microseconds', function(done) { - const type = cleaner.cleanType('in microseconds'); - expect(type).to.deep.equal('integer'); - done(); - }); - test('clean binary types in seconds', function(done) { - const type = cleaner.cleanType('in seconds'); - expect(type).to.deep.equal('integer'); - done(); - }); - test('clean wtf type', function(done) { - const type = cleaner.cleanType('wtf'); - expect(type).to.deep.equal(undefined); - done(); - }); - test('clean enumeration type', function(done) { - const type = cleaner.cleanType('enumeration'); - expect(type).to.deep.equal('enumeration'); - done(); - }); - test('clean undefined type', function(done) { - const type = cleaner.cleanType(undefined); - expect(type).to.deep.equal(undefined); - done(); - }); - }); -}; diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_1.html b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_1.html deleted file mode 100644 index 5855c10..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_1.html +++ /dev/null @@ -1,235 +0,0 @@ - - -
-
    -
  • -

    - - - - - --ndbcluster -

    -
    - -

    Table 21.207 - Type and value information for ndbcluster

    -
    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    PropertyValue
    Namendbcluster -
    Command LineYes
    System VariableNo
    Status VariableNo
    Option FileYes
    Scope
    DynamicNo
    Type
    Default, RangeFALSE (Version: NDB 7.5-7.6)
    Notes -

    - DESCRIPTION: Enable NDB Cluster (if this version - of MySQL supports it) -

    -

    - Disabled by - --skip-ndbcluster. -

    -
    -
    -
    - - - - - - - -
    PropertyValue
    -
    - -
    -
    -

    - The NDBCLUSTER storage engine - is necessary for using NDB Cluster. If a - mysqld binary includes support for the - NDBCLUSTER storage engine, - the engine is disabled by default. Use the - --ndbcluster option to - enable it. Use --skip-ndbcluster to - explicitly disable the engine. -

    -

    - It is not necessary or desirable to use this option - together with --initialize. - Beginning with NDB 7.5.4, --ndbcluster is - ignored (and the NDB storage engine is - not enabled) if - --initialize is also used. (Bug #81689, - Bug #23518923) -

    -
    • -
  • -

    - - - - - --ndb-allow-copying-alter-table=[ON|OFF] -

    -
    - -

    Table 21.208 - Type and value information for ndb-allow-copying-alter-table

    -
    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    PropertyValue
    Namendb-allow-copying-alter-table -
    Command LineYes
    System VariableYes
    Status VariableNo
    Option FileYes
    ScopeBoth
    DynamicYes
    Type
    Default, RangeON (Version: NDB 7.5-7.6)
    Notes -

    - DESCRIPTION: Set to OFF to keep ALTER TABLE from - using copying operations on NDB tables -

    -
    -
    -
    - - - - - - - -
    PropertyValue
    -
    - -
    -
    -

    - Let ALTER TABLE and other - DDL statements use copying operations on - NDB tables. Set to - OFF to keep this from happening; doing - so may improve performance of critical applications. -

    -
    • -
  • -

    - - - - - --ndb-batch-size=# -

    - - diff --git a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_2.html b/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_2.html deleted file mode 100644 index 2c3c1c5..0000000 --- a/srcs/phpmyadmin/vendor/williamdes/mariadb-mysql-kbs/test/data/mysql_test_case_2.html +++ /dev/null @@ -1,1211 +0,0 @@ - -
    -
      -
    • -

      - - - - - binlog_gtid_simple_recovery -

      -
      - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
      PropertyValue
      Command-Line Format--binlog-gtid-simple-recovery[={OFF|ON}]
      System Variablebinlog_gtid_simple_recovery -
      ScopeGlobal
      DynamicNo
      SET_VAR Hint AppliesNo
      TypeBoolean
      Default ValueON
      -
      -

      - This variable controls how binary log files are iterated - during the search for GTIDs when MySQL starts or restarts. -

      -

      - When - binlog_gtid_simple_recovery=TRUE, - which is the default in MySQL 8.0, the values of - gtid_executed and - gtid_purged are computed at - startup based on the values of - Previous_gtids_log_event in the most recent - and oldest binary log files. For a description of the - computation, see - The gtid_purged System - Variable. This setting - accesses only two binary log files during server restart. If - all binary logs on the server were generated using MySQL 5.7.8 - or later, - binlog_gtid_simple_recovery=TRUE - can always safely be used. - - -

      -

      - If any binary logs from MySQL 5.7.7 or older are present on - the server (for example, following an upgrade of an older - server to MySQL 8.0), with - binlog_gtid_simple_recovery=TRUE, - gtid_executed and - gtid_purged might be - initialized incorrectly in the following two situations: -

      -
      -
        -
      • -

        - The newest binary log was generated by MySQL 5.7.5 or - earlier, and gtid_mode - was ON for some binary logs but - OFF for the newest binary log. -

        -
        • -
      • -

        - A SET @@GLOBAL.gtid_purged statement - was issued on MySQL 5.7.7 or earlier, and the binary log - that was active at the time of the SET - @@GLOBAL.gtid_purged statement has not yet been - purged. - - -

        -
        • -
      -
      -

      - If an incorrect GTID set is computed in either situation, it - will remain incorrect even if the server is later restarted - with - binlog_gtid_simple_recovery=FALSE. - If either of these situations apply or might apply on the - server, set - binlog_gtid_simple_recovery=FALSE - before starting or restarting the server. -

      -

      - When - binlog_gtid_simple_recovery=FALSE - is set, the method of computing - gtid_executed and - gtid_purged as described in - The gtid_purged System - Variable is changed to - iterate the binary log files as follows: -

      -
      -
        -
      • -

        - Instead of using the value of - Previous_gtids_log_event and GTID log - events from the newest binary log file, the computation - for gtid_executed - iterates from the newest binary log file, and uses the - value of Previous_gtids_log_event and - any GTID log events from the first binary log file where - it finds a Previous_gtids_log_event - value. If the server's most recent binary log files do not - have GTID log events, for example if - gtid_mode=ON was used but - the server was later changed to - gtid_mode=OFF, this - process can take a long time. -

        -
        • -
      • -

        - Instead of using the value of - Previous_gtids_log_event from the - oldest binary log file, the computation for - gtid_purged iterates from - the oldest binary log file, and uses the value of - Previous_gtids_log_event from the first - binary log file where it finds either a nonempty - Previous_gtids_log_event value, or at - least one GTID log event (indicating that the use of GTIDs - starts at that point). If the server's older binary log - files do not have GTID log events, for example if - gtid_mode=ON was only set - recently on the server, this process can take a long time. -

        -
        • -
      -
      -
      • -
    • -

      - enforce_gtid_consistency -

      -
      - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
      PropertyValue
      Command-Line Format--enforce-gtid-consistency[=value]
      System Variableenforce_gtid_consistency -
      ScopeGlobal
      DynamicYes
      SET_VAR Hint AppliesNo
      TypeEnumeration
      Default ValueOFF
      Valid Values -

      OFF

      -

      ON

      -

      WARN

      -
      -
      -

      - Depending on the value of this variable, the server enforces - GTID consistency by allowing execution of only statements that - can be safely logged using a GTID. You - must set this variable to - ON before enabling GTID based replication. -

      -

      - The values that - enforce_gtid_consistency can - be configured to are: -

      -
      -
        -
      • -

        - OFF: all transactions are allowed to - violate GTID consistency. -

        -
        • -
      • -

        - ON: no transaction is allowed to - violate GTID consistency. -

        -
        • -
      • -

        - WARN: all transactions are allowed to - violate GTID consistency, but a warning is generated in - this case. -

        -
        • -
      -
      -

      - Only statements that can be logged using GTID safe statements - can be logged when - enforce_gtid_consistency is - set to ON, so the operations listed here - cannot be used with this option: -

      -
      -
        -
      • -

        - CREATE - TABLE ... SELECT statements -

        -
        • -
      • -

        - CREATE - TEMPORARY TABLE or - DROP TEMPORARY - TABLE statements inside transactions -

        -
        • -
      • -

        - Transactions or statements that update both transactional - and nontransactional tables. There is an exception that - nontransactional DML is allowed in the same transaction or - in the same statement as transactional DML, if all - nontransactional tables are - temporary. -

        -
        • -
      -
      -

      - --enforce-gtid-consistency only - takes effect if binary logging takes place for a statement. If - binary logging is disabled on the server, or if statements are - not written to the binary log because they are removed by a - filter, GTID consistency is not checked or enforced for the - statements that are not logged. -

      -

      - For more information, see - Section 17.1.3.6, “Restrictions on - Replication with GTIDs”. -

      -

      - Prior to MySQL 5.7 and in early releases in that release - series, the boolean - enforce_gtid_consistency - defaulted to OFF. To maintain compatibility - with these earlier releases, the enumeration defaults to - OFF, and setting - --enforce-gtid-consistency - without a value is interpreted as setting the value to - ON. The variable also has multiple textual - aliases for the values: 0=OFF=FALSE, - 1=ON=TRUE,2=WARN. This - differs from other enumeration types but maintains - compatibility with the boolean type used in previous releases. - These changes impact on what is returned by the variable. - Using SELECT @@ENFORCE_GTID_CONSISTENCY, - SHOW VARIABLES LIKE - 'ENFORCE_GTID_CONSISTENCY', and SELECT * - FROM INFORMATION_SCHEMA.VARIABLES WHERE 'VARIABLE_NAME' = - 'ENFORCE_GTID_CONSISTENCY', all return the textual - form, not the numeric form. This is an incompatible change, - since @@ENFORCE_GTID_CONSISTENCY returns - the numeric form for booleans but returns the textual form for - SHOW and the Information Schema. -

      -
      • -
    • -

      - - - - - gtid_executed -

      -
      - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
      PropertyValue
      System Variablegtid_executed -
      System Variablegtid_executed -
      ScopeGlobal
      ScopeGlobal, Session
      DynamicNo
      DynamicNo
      SET_VAR Hint AppliesNo
      SET_VAR Hint AppliesNo
      TypeString
      -
      -

      - When used with global scope, this variable contains a - representation of the set of all transactions executed on the - server and GTIDs that have been set by a - SET - gtid_purged statement. This - is the same as the value of the - Executed_Gtid_Set column in the output of - SHOW MASTER STATUS and - SHOW SLAVE STATUS. The value of - this variable is a GTID set, see - GTID Sets for - more information. -

      -

      - When the server starts, - @@GLOBAL.gtid_executed is initialized. See - binlog_gtid_simple_recovery - for more information on how binary logs are iterated to - populate gtid_executed. GTIDs - are then added to the set as transactions are executed, or if - any - SET - gtid_purged statement is - executed. -

      -

      - The set of transactions that can be found in the binary logs - at any given time is equal to - GTID_SUBTRACT(@@GLOBAL.gtid_executed, - @@GLOBAL.gtid_purged); that is, to all transactions - in the binary log that have not yet been purged. -

      -

      - Issuing RESET MASTER causes the - global value (but not the session value) of this variable to - be reset to an empty string. GTIDs are not otherwise removed - from this set other than when the set is cleared due to - RESET MASTER. -

      -

      - In some older releases, this variable could also be used with - session scope, where it contained a representation of the set - of transactions that are written to the cache in the current - session. The session scope is now deprecated. -

      -
      • -
    • -

      - gtid_executed_compression_period -

      -
      - - - - - - - - - - - -
      PropertyValue