1. 19 Feb, 2019 7 commits
    • Vicențiu Ciorbaru's avatar
      Introduce analyze_sample_percentage variable · f0773b78
      Vicențiu Ciorbaru authored
      The variable controls the amount of sampling analyze table performs.
      
      If ANALYZE table with histogram collection is too slow, one can reduce the
      time taken by setting analyze_sample_percentage to a lower value of the
      total number of rows.
      Setting it to 0 will use a formula to compute how many rows to sample:
      
      The number of rows collected is capped to a minimum of 50000 and
      increases logarithmically with a coffecient of 4096. The coffecient is
      chosen so that we expect an error of less than 3% in our estimations
      according to the paper:
      "Random Sampling for Histogram Construction: How much is enough?”
      – Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya, ACM SIGMOD, 1998.
      
      The drawback of sampling is that avg_frequency number is computed
      imprecisely and will yeild a smaller number than the real one.
      f0773b78
    • Vicențiu Ciorbaru's avatar
      Simplify column data adding method · 47f15ea7
      Vicențiu Ciorbaru authored
      The add method does not need to provide the row order number. It was
      only used to detect if the minimum/maximum value was populated once or not, so
      as to force an update for the first encounter of a value.
      47f15ea7
    • Vladislav Vaintroub's avatar
      MDEV-15693 Stop packaging data directory into ZIPs · 3dc6f041
      Vladislav Vaintroub authored
      Remove CMake INSTALL command for COMPONENT DataFiles.
      
      mysql_install_db.exe will calculate default datadir, so that it can be
      called without any parameters.
      3dc6f041
    • Varun Gupta's avatar
      MDEV-18551: New defaults for eq_range_index_dive_limit · 2e6d8fcc
      Varun Gupta authored
      The value for eq_range_index_dive_limit is increased to 200.
      2e6d8fcc
    • Varun Gupta's avatar
      MDEV-17903: New optimizer defaults: change optimize_join_buffer_size to be ON · d6db6df9
      Varun Gupta authored
      optimize_join_buffer_size is switched ON.
      d6db6df9
    • Vladislav Vaintroub's avatar
    • Teemu Ollakka's avatar
      MDEV-18587 Don't reject DDLs if streaming replication is on · 4baab869
      Teemu Ollakka authored
      The check for streaming replication logging format in
      THD::decide_logging_format() did the check also for DDLs running
      in TOI mode. This caused DROP DATABASE to fail if streaming
      replication was enabled.
      
      Added check for THD wsrep execution mode and perform the check
      only if the THD is in local processing mode (i.e. not TOI).
      
      Added galera_sr_create_drop test to verify that CREATE/DROP
      statements pass even if streaming replication is on.
      4baab869
  2. 18 Feb, 2019 17 commits
  3. 16 Feb, 2019 3 commits
    • Marko Mäkelä's avatar
      MDEV-18598: Wrong results after instant integer conversions · 790b6f5a
      Marko Mäkelä authored
      Field_str::is_equal(): Do not allow instant conversions between
      BIT (which is stored big-endian) and integer types (which can
      be stored big-endian or little-endian, depending on storage engine).
      
      row_sel_field_store_in_mysql_format_func(): Properly extend
      narrower integer and DATA_FIXBINARY values to the current format.
      DATA_FIXBINARY was incorrectly padded with 0x20 instead of 0.
      790b6f5a
    • Marko Mäkelä's avatar
      Merge 10.3 into 10.4 · e9e47889
      Marko Mäkelä authored
      e9e47889
    • Marko Mäkelä's avatar
      Fix tests for innodb_checksum_algorithm=strict_crc32 · df51dc28
      Marko Mäkelä authored
      In tests that directly write InnoDB data file pages,
      compute the innodb_checksum_algorithm=crc32 checksums,
      instead of writing the 0xdeadbeef value used by
      innodb_checksum_algorithm=none. In this way, these tests
      will not cause failures when executing
      ./mtr --mysqld=--loose-innodb-checksum-algorithm=strict_crc32
      df51dc28
  4. 15 Feb, 2019 11 commits
    • Sergei Golubchik's avatar
      28f18aa7
    • Igor Babaev's avatar
      Merge branch '10.4' into bb-10.4-mdev16188 · a44f2c3e
      Igor Babaev authored
      a44f2c3e
    • Alexander Barkov's avatar
      A cleanup for MDEV-13916 Enforce check constraint on JSON type · 62c0ac2d
      Alexander Barkov authored
      1. Renaming Type_handler_json to Type_handler_json_longtext
         There will be other JSON handlers soon, e.g. Type_handler_json_varchar.
      
      2. Making the code more symmetric for data types:
      
      - Adding a new virtual method
        Type_handler::Column_definition_validate_check_constraint()
      - Moving JSON-specific code from sql_yacc.yy to
        Type_handler_json_longtext::Column_definition_validate_check_constraint()
      
      3. Adding new files sql_type_json.cc and sql_type_json.h
         and moving Type_handler+JSON related code into these files.
      62c0ac2d
    • Vladislav Vaintroub's avatar
    • Marko Mäkelä's avatar
      MDEV-18579 Assertion !ctx->online || num_fts_index == 0 · e1af4601
      Marko Mäkelä authored
      instant_alter_column_possible(): Add the other MDEV-17459 work-around
      condition. The existence of fulltext indexes only prevents instant
      DROP COLUMN or changing the order of columns. Other forms of instant
      ALTER TABLE are no problem.
      
      Before commit 4e7ee166 that merged
      the MDEV-18295 fix from 10.3, the work-around of MDEV-17459 in
      instant_alter_column_possible() was categorically refusing any
      ALGORITHM=INSTANT if any FULLTEXT INDEX was present. After that commit,
      a related condition was only present in prepare_inplace_alter_table_dict()
      but not in the other callers of instant_alter_column_possible().
      e1af4601
    • Marko Mäkelä's avatar
      Merge 10.3 into 10.4 · 2b921845
      Marko Mäkelä authored
      2b921845
    • Jan Lindström's avatar
      MDEV-18109: Galera 4: run galera_sr test suite · dcaabf07
      Jan Lindström authored
      Fix some of the galera_sr suite test failures.
      Remove tests that are not going to be run because required
      feature is not supported.
      
      	modified:   mysql-test/suite/galera_sr/disabled.def
      	deleted:    mysql-test/suite/galera_sr/r/GCF-574.result
      	modified:   mysql-test/suite/galera_sr/r/galera_sr_cc_slave.result
      	modified:   mysql-test/suite/galera_sr/r/galera_sr_kill_all_norecovery.result
      	modified:   mysql-test/suite/galera_sr/r/galera_sr_load_data.result
      	deleted:    mysql-test/suite/galera_sr/r/galera_sr_sbr.result
      	modified:   mysql-test/suite/galera_sr/r/mysql-wsrep-features#148.result
      	deleted:    mysql-test/suite/galera_sr/r/mysql-wsrep-features#29.result
      	deleted:    mysql-test/suite/galera_sr/t/GCF-574.test
      	modified:   mysql-test/suite/galera_sr/t/galera_sr_cc_slave.test
      	modified:   mysql-test/suite/galera_sr/t/galera_sr_kill_all_norecovery.cnf
      	modified:   mysql-test/suite/galera_sr/t/galera_sr_kill_all_norecovery.test
      	modified:   mysql-test/suite/galera_sr/t/galera_sr_load_data.test
      	deleted:    mysql-test/suite/galera_sr/t/galera_sr_sbr.test
      	modified:   mysql-test/suite/galera_sr/t/mysql-wsrep-features#148.test
      	deleted:    mysql-test/suite/galera_sr/t/mysql-wsrep-features#29.test
      dcaabf07
    • Igor Babaev's avatar
      Merge branch '10.4' into bb-10.4-mdev16188 · 294b8c42
      Igor Babaev authored
      294b8c42
    • Marko Mäkelä's avatar
      MDEV-15564: Fix bool/ibool type mismatch · e17fc729
      Marko Mäkelä authored
      dtype_is_string_type(), dtype_is_binary_string_type(),
      dtype_is_non_binary_string_type(): Define as inline functions that
      return bool, not ibool.
      e17fc729
    • Marko Mäkelä's avatar
      MDEV-15564: Fix the non-debug build · 10c05d4a
      Marko Mäkelä authored
      10c05d4a
    • Igor Babaev's avatar
      Merge branch '10.4' into bb-10.4-mdev16188 · 98d55b13
      Igor Babaev authored
      98d55b13
  5. 14 Feb, 2019 2 commits
    • Igor Babaev's avatar
      MDEV-16188 Post review fixes · ccce4d3b
      Igor Babaev authored
      Also adjusted some test files.
      ccce4d3b
    • Vladislav Vaintroub's avatar
      MDEV-18549 Failing assertion: opt_no_lock during mariabackup --backup · 282ba973
      Vladislav Vaintroub authored
      The assertion happens under BACKUP STAGE BLOCK_COMMIT, when a DDL on a
      temporary table (#sql-xxx) is found.
      
      Apparently, assumption that all DDLs are blocked under FTWRL does not
      hold for BACKUP STAGE, and temporary tables can still have ALTERs
      
      The fix is to relax the assertion, and only check for opt_no_lock if
      backup is *really* inconsistent, i.e either optimized DDL or CREATE/RENAME
      are done on the tables that were not skipped during backup.
      282ba973