Hi!
I was playing around with indexes after we faced problems with
mariadb choosing the wrong index because of high average value group size.
So I created a table with 4 text columns and indexed the 4th column with
a prefix length of 1.
Following are the stats in brief --
The index has 35 unique values
There are around 1040000 rows in total.
this will give an average value group size of 29714
Cardinality is calculated as <no. of records in the index>/<average size
of value groups>, thus it's value must be 35
BUT from show indexes, it's value is shown as 72
(innodb_stats_persistent_sample_pages = 9999999).
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
