Stefan Seidel

Asked: 2019-10-15 00:23:04 +0800 CST2019-10-15 00:23:04 +0800 CST 2019-10-15 00:23:04 +0800 CST

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on MariaDB 10.3 because they changed (back) from XtraDB to InnoDB.

What is the alternative? Does MariaDB 10.3 offer anything similar? Is it not needed anymore because there is some other optimization?

Or is it best to switch to Percona Server for MySQL to keep using that feature, and would that "cross-grade" work seamlessly?

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

Can you pass user/pass for HTTP Basic Authentication in URL parameters?

Ping a Specific Port

Check if port is open or closed on a Linux server?

How to automate SSH login with password?

How do I tell Git for Windows where to find my private RSA key?

What's the default superuser username/password for postgres after a new install?

What port does SFTP use?

Command line to list users in a Windows Active Directory group?

What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?

How to determine if a bash variable is empty?

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

0 Answers