Comment 7 for bug 1444541

Revision history for this message
苏信东 (webmaster-wavecn) wrote :

I'm using MariaDB 5.5.45 and this version of MariaDB does not support FLUSH CHANGED_PAGE_BITMAPS too. According to https://mariadb.atlassian.net/browse/MDEV-7472, MariaDB supports it since version 10.1.6 (but just a workaround).

So I suggest to change the version checking sql to:

SELECT COUNT(*) FROM information_schema.plugins WHERE plugin_name LIKE "innodb_changed_pages" AND
IF (VERSION() NOT LIKE "%MariaDB%", TRUE,
(
SUBSTRING_INDEX(SUBSTRING_INDEX(VERSION(), '-', 1), '.', 1) * 10000 +
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(VERSION(), '-', 2), '.', 1), '.', -1) * 100 +
SUBSTRING_INDEX(SUBSTRING_INDEX(VERSION(), '-', 1), '.', -1)
) >= 100116
)

This version checking method comes from http://stackoverflow.com/questions/32104142/sql-compare-version-string-w-x-y-z-in-mysql