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
)
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 INDEX(SUBSTRING _INDEX( VERSION( ), '-', 1), '.', 1) * 10000 + INDEX(SUBSTRING _INDEX( SUBSTRING_ INDEX(VERSION( ), '-', 2), '.', 1), '.', -1) * 100 + INDEX(SUBSTRING _INDEX( VERSION( ), '-', 1), '.', -1)
IF (VERSION() NOT LIKE "%MariaDB%", TRUE,
(
SUBSTRING_
SUBSTRING_
SUBSTRING_
) >= 100116
)
This version checking method comes from http:// stackoverflow. com/questions/ 32104142/ sql-compare- version- string- w-x-y-z- in-mysql