Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2.22, 10.3.13
-
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