Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.22, 10.3.13
    • Fix Version/s: 10.2.23, 10.3.14, 10.4.4
    • Component/s: Galera
    • Labels:
      None
    • Environment:
      Linux Debian 9 (Stretch)

      Description

      Hi,

      I tested importing dump on MariaDB + Galera (2 nodes Master-Master) as follow :

      • Create a db
      • import dump sql (table in INNODB) on Node 1

      When I check some index cardinalities, I have on node 1 the right value and on node 2 null value (0) e.g :

      Node 1 : index on column username (varchar 255 utf-8) : cardinality =38250
      Node 2 : index username : cardinality = 0

      Indexes are not updated on node 2 and SQL queries on MariaDB Node 2 are too slow !

      I tested different versions :

      MariaDB 10.1.37 (Debian Stretch version) : cardinality is OK : no problem (but not same cardinality ...) !
      MariaDB 10.2.22 (Debian MariaDB repository) : cardinality is NOT ok : problem
      MariaDB 10.3.12 (Debian MariaDB repository) : cardinality is NOT ok : problem

      I run OPTIMIZE Table on Node 2 for build indexes and then indexes are managed on Node 2. Strange things too : the cardinalities are always differentes on the 2 nodes ...

      Hope, you will be able to take a look ...

      Thank's

      Eric

        Attachments

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              erbru Eric Brun
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: