XF 2.2 Query - Table size when moving MySQL5.7 to MariaDB 10.5

[ISPr_Winter]

Just a quick question. I've just tried moving my XenForo install on a MySQL 5.7 database to a new database that uses MariaDB 10.5. All went well, and it was a simple drop-in replacement, but I did notice one oddity with table sizes and I'm not sure if this is normal.

For example, under MySQL my xf_phrase table was 2.1 MiB in size, but the same table under MariaDB is listed as only being 48.0 KiB in size despite having the same 10,000+ rows. Is this normal?

 

[Paul B]

48K of data/storage doesn't sound right for 10K rows.

I use MariaDB 10.3 and with 10,683 rows it's 3.2MB.

Are you able to view all of the records in the table?

 

[bzcomputers]

MariaDB 10.6 xf_phrase table with 13,300 rows = 4.2mb ...which is about same ratio of row to size as @Brogan is seeing

 

[Masetrix]

MariaDB 10.5.13 xf_phrase table with 24,217 rows = 5.4mb...

Do you using: ?

InnoDB COMPRESSED Row Format

Similar to the COMPACT row format, but can store even more data on overflow pages.

mariadb.com

 

[Paul B]

Even compressed I can't see it getting down to 48K.

A blank table is 16K.