maria-discuss team mailing list archive

[John Pace <johnpace95@xxxxxxx>]

Hi,   I am using mariabackup to backup a database.   On day 1 a full backup with
mariabackup --backup --user=Backup --password=my-password --target-dir=path-to-full 
and on day 2-7 a incremental backup with
mariabackup --backup --user=Backup --password=my-password --target-dir=path-to-inc --incremental-basedir=path-to-full 
Then follows again a new backup for day 1 and so on. The database can be used while the backup is running. A web application for Apache Tomcat uses the database.   This worked very well for a couple of weeks, the backup was finished within 20 minutes. But recently I noticed that the incremental backup took much longer than before. I checked the output of mariabackup and it was spammed several hours with lines like these
[00] 2022-04-20 00:48:00 >> log scanned up to (1747989580536)
[00] 2022-04-20 00:48:01 >> log scanned up to (1747989580536)
[00] 2022-04-20 00:48:02 >> log scanned up to (1747989580536)
2022-04-20 0:48:03 0 [Note] InnoDB: Read redo log up to LSN=1747989580800
[00] 2022-04-20 00:48:03 >> log scanned up to (1747989580536)
[00] 2022-04-20 00:48:04 >> log scanned up to (1747989580536)
[00] 2022-04-20 00:48:05 >> log scanned up to (1747989580536)
[00] 2022-04-20 00:48:06 >> log scanned up to (1747989580536)   Yesterday the incremental backup took 7 hours so I wonder if there is something wrong.   MariaDB shows no error in the log:
2022-03-15 8:35:48 0 [Note] InnoDB: Using Linux native AIO
2022-03-15 8:35:48 0 [Note] InnoDB: Uses event mutexes
2022-03-15 8:35:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-15 8:35:48 0 [Note] InnoDB: Number of pools: 1
2022-03-15 8:35:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-15 8:35:48 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2022-03-15 8:35:48 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-15 8:35:48 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-03-15 8:35:49 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-15 8:35:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-15 8:35:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-15 8:35:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-03-15 8:35:49 0 [Note] InnoDB: 10.5.8 started; log sequence number 1741176510061; transaction id 38228169
2022-03-15 8:35:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-15 8:35:49 0 [Note] InnoDB: Loading buffer pool(s) from /path-to-database/ib_buffer_pool
2022-03-15 8:35:49 0 [Note] Server socket created on IP: '::'.
2022-03-15 8:35:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220315 8:35:50
2022-03-15 8:35:50 0 [Note] /path-to-mariadb/bin/mariadbd: ready for connections.
Version: '10.5.8-MariaDB' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server   PS: Sorry for my test-post. 

-------------------------------------------------------------------------------------------------
FreeMail powered by mail.de - MEHR SICHERHEIT, SERIOSITÄT UND KOMFORT