Recently I've found these two MySQL functions compress and uncompress and I'm planning to use it in my database to compress some xml files (around 40 million ~ 600GB+) to reduce my database size. Unfortunately, I didn't found anything about performance and ram/hardware usage from those functions.
How would it be in terms of performance and server ram usage performing hundred/thousands of queries like these per minute?
SELECT cast(uncompress(document) AS char(10000))
FROM documents;