[MDEV-19554] data directory with page compressed tables is slow to copy Created: 2019-05-22 Updated: 2019-05-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.2 |
| Fix Version/s: | 10.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Tomas Mozes | Assignee: | Marko Mäkelä |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Environment: |
Linux Gentoo, MariaDB 10.2.23, ext4 filesystem, 10k/15k rotating enterprise disks |
||
| Description |
|
I'm trying to migrate my mariadb data directory with several tables with page compression from 10k to 15k disks (both ext4 filesystem). I've tried stopping the mariadb process, then do a regular cp, but it's very slow. The data directory is just 100GB large, it starts very well, comes to 60GB, then it's become very slow, copying just a few hunder KB per second, taking forever to complete. I also tried using mariabackup to copy from one disk to another, but it came to 78GB, 4 cores running on 100% (mariabackup --parallel=4) but very slow progress. Found this: https://www.percona.com/blog/2017/11/20/innodb-page-compression/ Is there anything that can be done to have some reasonable speeds? The tables are partitioned page compressed tables like: Thanks |