Comments - mysqldump restore with poor performance
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
What is the Azure MariaDB version is running? innodb_flush_log_at_trx_commit=0 temporary during import and increasing the innodb_log_fie_size to 8G or so.
thanks for your help !
Azure version is mariadb 10.3.23, it looks like innodb_log_file_size is not tunable in mariadb managed azure database parameters but is 256 MB. It looks like innodb_flush_log_at_trx_commit is not tunable too :(
See https://learn.microsoft.com/en-us/azure/mariadb/concepts-server-parameters at "Non-configurable server parameters" section