Hint for a future me - before backuping Friendica (and other software) instance to migrate to another server: purge blocked domains and subdomains - the backup will be much smaller and restore will happen much faster. #sysadmin #mysqldump

#MariaDB backup:
During backing up of databases daily, via "#mysqldump" and/or "#mariabackup" (need to see what recording the process overs ~10 days brought), INSERT queries are delayed due to table locks. That causes a swell in number of open connections, from ~5 to ~70.

One way to avoid locks with "mysqldump", is to divide backing up in 2 main steps:
- when all the tables have #InnoDB engine, dump that database via "--single-transaction" option;
- rest with normal table locks.
1/2 ...

@f2k1de Ich nutze dazu immer #mysqldump
Exportiert den gesamten Inhalt inkl. der Tabellenbeschreibung. Kommt halt immer auf die Größe der DB an.