[slurm-users] Database Compression

[Baer, Troy]

My site has just updated to Slurm 21.08 and we are looking at moving to the built-in job script capture capability, so I'm curious about this as well.

	--Troy

-----Original Message-----
From: slurm-users <slurm-users-bounces at lists.schedmd.com> On Behalf Of Paul Edmon
Sent: Thursday, December 2, 2021 10:30 AM
To: slurm-users at lists.schedmd.com
Subject: [slurm-users] Database Compression

With the advent of the ability to store jobscripts in the slurmdb, our 
db is growing at a fairly impressive rate (which is expected).  That 
said I've noticed that our database backups are highly compressible 
(factor of 24).  Not being a mysql expert I hunted around to see if it 
could do native compression and it can: 
https://urldefense.com/v3/__https://mariadb.com/kb/en/innodb-page-compression/__;!!KGKeukY!jgWBQWFG0eUgbghBOl8d4w1h4_lBv5VNloBkfgr5pOYVq0V1xjV-hToRXTQZ$ 

My question is if anyone has had any experience with using page 
compression for mariadb and if there are any hitches I should be aware of?

-Paul Edmon-