Fix caching large snippet HTML content on MySQL databases

Closes #31647

See merge request !11024
Signed-off-by: Rémy Coutable <remy@rymai.me>