Status: Closed (View Workflow)
Linux Debian 9 (Stretch)
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 ...