Search results

  1. S

    ZFS Defrag

    Hi All, root@db1:~# zpool list NAME SIZE ALLOC FREE CKPOINT EXPANDSZ FRAG CAP DEDUP HEALTH ALTROOT pool 1.04T 579G 485G - - 67% 54% 1.00x ONLINE - root@db1:~# A couple of questions please: 1) This is a NVME datacenter SSD. Is fragmentation...
  2. S

    Mysql tuning. Recordsize / Volblocksize, VM or LXC?

    I am referring to the block size box when you add the zfs dataset in the gui. I set the recordsize of the dataset on the cli, then add the dataset onto storage on the gui. I assumed this was the vol block size used in vms that add hdd's from that storage
  3. S

    Mysql tuning. Recordsize / Volblocksize, VM or LXC?

    I've done some testing. AMD Ryzen 9 5900X - 12c/24t - 3.7 GHz/4.8 GHz 128 GB ECC 2666 MHz 2×1.92TB Samsung PM9A3 U.2 NVMe Server SSD in ZFS mirror Very basic test with fio 16K blocks, not sure if this is representative of mysql load but anyhow...... fio --randrepeat=1 --ioengine=libaio...
  4. S

    [SoYouStart] rEFInd/Grub Boot Error (Upgrading Proxmox 6 to 7)

    Ah ok, so I'll need to revert to reinstall / rescue ok. Proxmox 7 has been out ages, OVH really need to make it available as a template it would save them and us a lot of hassle.
  5. S

    [SoYouStart] rEFInd/Grub Boot Error (Upgrading Proxmox 6 to 7)

    This also worked for me, go into BIOS change first boot device to OS. It also renamed my network devices. Use ip -c link to see the dev names and edit your /etc/network/interfaces accordingly.
  6. S

    Mysql tuning. Recordsize / Volblocksize, VM or LXC?

    Ok - great, so basically separate pool and set the recordsize on the pool to 16K (underlying raid structure depending....) Thank you! So lets say I have 2 NVME ssd and create a raidz1 pool across them, I would set record size to 32K? or still 16Kb? Sorry if its a dumb question, I'm not sure...
  7. S

    Mysql tuning. Recordsize / Volblocksize, VM or LXC?

    Thanks! - I see no option to do this in the GUI when added a HDD to the VM, so I guess I do this on the CLI on the host?
  8. S

    Mysql tuning. Recordsize / Volblocksize, VM or LXC?

    Hi All, I'm trying to run MariaDB with the correct blocksizes to get best performance, either in a VM or LXC. With an LXC, I can set the recordsize on particular datasets on the host so that the container uses them. I guess this is one layer less of abstraction for the filesystem compared to...
  9. S

    Cannot add backup server on non standard port

    I am running two pbs servers inside my home network. I can forward port 8007 -> 8007 for the first and 8107 -> 8007 for the second on my router so I can connect to them from outside. But I cannot add a PBS server on the gui with a port number on the external server. Is this possible some...
  10. S

    Feature Request - show vm/ct name with id

    Sorry if this is the wrong place to post, but I have a feature request. I have a backup server that has backups of usually around 10 machines per host so when browsing backups its hard to know which backup is which without cross referencing the ID numbers back to the pve host, just wondering if...
  11. S

    New feature - hourly backups

    I'd like to backup my database on the hour, the backup server has retention policies for this but in pve you have to make 24 jobs as far as I can see, could pve benefit from the same date system used in pbs ?
  12. S

    Backup speed

    Wow. This is quite a thing, will mean for me anything that has large hdd volumes an a low percentage of data changing each day that I want to backup quickly they will now have to be vm's. Thanks very much for the info.
  13. S

    Backup speed

    Will this always be the case? will containers ever have the dirty-bitmap functionality?
  14. S

    Backup speed

    Is running a 1Tb database better in a vm or a container in terms of if I want to take a backup every hour? I'm thinking maybe the vm backup is faster because it can use the dirty_bitmap but containers have to check all the files? Thanks, Jack
  15. S

    Restore does not create zvols with correct metadata

    Hi All, Sorry I wasn't sure if this was a bug or where to report it so I'll just ask. I've got a container : NAME PROPERTY VALUE SOURCE bigpool/subvol-100-disk-2 compression on inherited from bigpool bigpool/subvol-100-disk-2 recordsize...
  16. S

    Most efficient sync / prune / garbage collect strategy

    Thanks a lot it means a great deal to get quality support and replies when you're relying on something for a backup, I'm glad I switched from restic to the pbs, which of course makes sense if you use proxmox and I'm glad it's good. Good work! thanks again.
  17. S

    Most efficient sync / prune / garbage collect strategy

    Hola, I have a production server. I do nightly backups which take about 6 hours. I want local backups to restore as fast as possible so I have proxmox backup installed locally. In case the whole server is lost, I remote sync the backups to another proxmox backup server remotely. Backup data...
  18. S

    How fast is your backup datastore? Benchmark tool

    I'm not that savvy but...... I get similar numbers to a remote machine, the worse the ping, the lower TLS speed I get, but if you're getting that locally I think it's your hardware, on a Ryzen 3600 with 4x raid 5 HDD's I get : ┌───────────────────────────────────┬─────────────────────┐ │ Name...
  19. S

    How fast is your backup datastore? Benchmark tool

    Much better.... at least with the benchmark tool. Good work. This is over a link with 30ms latency, but before I got 2.5Mbps. root@wopr:~# proxmox-backup-client benchmark --repository root@pam@xxxxxxxx:xxxxxxxxx Uploaded 101 chunks in 5 seconds. Time per request: 53192 microseconds. TLS...
  20. S

    Missing SSL certificate for Proxmox backup server

    Hi All, I'm no expert, this isn't official advice, but if like me you have installed backup and PVE on the same box and are annoyed it's not sharing the same ssl as the PVE install read on... By default proxmox backup server doesn't use the same cert as your PVE when installed on the same box...