search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
254 stars 26 forks source link

Issue with using xtrabackup/mariadbbackup error while setting value '70.000000' to 'innodb_max_dirty_pages_pct' #180

Closed drupaladmin closed 11 months ago

drupaladmin commented 1 year ago

I have an issue with using xtrabackup/mariadbbackup with the latest Releem config recommendations. Specifically, the Releem engine set a float where xtrabackup was expecting an integer. See the following error: Job execution error: Unknown suffix '.' used for variable 'innodb_max_dirty_pages_pct' (value '70.000000') /usr/bin/xtrabackup: Error while setting value '70.000000' to 'innodb_max_dirty_pages_pct'

kochetovd commented 1 year ago

This problem is related to bug in the software used https://jira.percona.com/browse/PXB-1807 - fixed a problem in the version 2.4.15, 8.0.7 https://jira.mariadb.org/browse/MDEV-20286 - The problem has not been fixed yet