1. 12 Mar, 2018 2 commits
  2. 09 Mar, 2018 2 commits
  3. 07 Mar, 2018 1 commit
    • Marko Mäkelä's avatar
      MDEV-14904 Backport innodb_default_row_format · 8ef727b3
      Marko Mäkelä authored
      InnoDB in Debian uses utf8mb4 as default character set since
      version 10.0.20-2. This leads to major pain due to keys longer
      than 767 bytes.
      
      MariaDB 10.2 (and MySQL 5.7) introduced the setting
      innodb_default_row_format that is DYNAMIC by default. These
      versions also changed the default values of the parameters
      innodb_large_prefix=ON and innodb_file_format=Barracuda.
      This would allow longer column index prefixes to be created.
      The original purpose of these parameters was to allow InnoDB
      to be downgraded to MySQL 5.1, which is long out of support.
      
      Every InnoDB version since MySQL 5.5 does support operation
      with the relaxed limits.
      
      We backport the parameter innodb_default_row_format to
      MariaDB 10.1, but we will keep its default value at COMPACT.
      This allows MariaDB 10.1 to be configured so that CREATE TABLE
      is less likely to encounter a problem with the limitation:
      
      	loose_innodb_large_prefix=ON
      	loose_innodb_default_row_format=DYNAMIC
      
      (Note that the setting innodb_large_prefix was deprecated in
      MariaDB 10.2 and removed in MariaDB 10.3.)
      
      The only observable difference in the behaviour with the default
      settings should be that ROW_FORMAT=DYNAMIC tables can be created
      both in the system tablespace and in .ibd files, no matter what
      innodb_file_format has been assigned to. Unlike MariaDB 10.2,
      we are not changing the default value of innodb_file_format,
      so ROW_FORMAT=COMPRESSED tables cannot be created without
      changing the parameter.
      8ef727b3
  4. 04 Mar, 2018 1 commit
  5. 24 Feb, 2018 1 commit
  6. 22 Feb, 2018 3 commits
  7. 21 Feb, 2018 5 commits
  8. 20 Feb, 2018 3 commits
  9. 19 Feb, 2018 2 commits
  10. 18 Feb, 2018 1 commit
  11. 17 Feb, 2018 5 commits
    • Jan Lindström's avatar
    • Monty's avatar
      Fixed performance problem with Aria in find_head() · 55bc3f1d
      Monty authored
      For some simple benchmarks, a majority of time was
      spend in find_head() which tries to find the best
      place to put the record.
      
      The result of this patch is a 2x or more speedup for
      inserts without keys for format PAGE. All changes
      are only related to how rows are stored
      
      Should fix some of the problems mentioned in:
      MDEV-8132 Temporary tables using Aria with very poor performance
      MDEV-9079 Aria very slow for internal temporary tables
      MDEV-5841 Mariadb very poor temporary performance
      
      The following changes where done:
      - For rows with a small row length that fits into
        a page (818 bytes with 8192 pages), stop as soon as we
        hit a match.
      - Added markers full_head_size and full_tail_size that tells
        us where to start searching on the bitmap page
      - Ensure that page->used_size is correctly updated when
        bitmap grows. This allows us to stop searching at used_size
      - Added code to check that the bitmap variables are correct.
      - Fixed a wrong test where we set "first_bitmap_with_space".
        This shouldn't have caused any notable problems.
      55bc3f1d
    • Monty's avatar
      TokuDB didn't compile with valgrind · 965e1637
      Monty authored
      TokuDB uses USE_VALGRIND while MariaDB uses HAVE_valgrind
      
      Fixed by defining USE_VALGRIND in TokuDB if HAVE_valgrind is used
      965e1637
    • Monty's avatar
      f853b8ed
    • Marko Mäkelä's avatar
      MDEV-15333 MariaDB (still) slow start · 9a46d971
      Marko Mäkelä authored
      This performance regression was introduced in the MariaDB 10.1
      file format incompatibility bug fix MDEV-11623 (MariaDB 10.1.21
      and MariaDB 10.2.4) and partially fixed in MariaDB 10.1.25 in
      MDEV-12610 without adding a regression test case.
      
      On a normal startup (without crash recovery), InnoDB should not read
      every .ibd data file, because this is slow. Like in MySQL, for now,
      InnoDB will still open every data file (without reading), and it
      will read every .ibd file for which an .isl file exists, or the
      DATA DIRECTORY attribute has been specified for the table.
      
      The test case shuts down InnoDB, moves data files, replaces them
      with garbage, and then restarts InnoDB, expecting no messages to
      be issued for the garbage files. (Some messages will for now be
      issued for the table that uses the DATA DIRECTORY attribute.)
      Finally, the test shuts down the server, restores the old data files,
      and restarts again to drop the tables.
      
      fil_open_single_table_tablespace(): Remove the condition on flags,
      and only call fsp_flags_try_adjust() if validate==true
      (reading the first page has been requested). The only caller with
      validate==false is at server startup when we are processing all
      records from SYS_TABLES. The flags passed to this function are
      actually derived from SYS_TABLES.TYPE and SYS_TABLES.N_COLS,
      and there never was any problem with SYS_TABLES in MariaDB 10.1.
      The problem that MDEV-11623 was that incorrect tablespace flags
      were computed and written to FSP_SPACE_FLAGS.
      9a46d971
  12. 16 Feb, 2018 3 commits
  13. 15 Feb, 2018 1 commit
  14. 14 Feb, 2018 3 commits
  15. 13 Feb, 2018 2 commits
  16. 11 Feb, 2018 2 commits
  17. 10 Feb, 2018 2 commits
  18. 09 Feb, 2018 1 commit