Re: [Maria-developers] innodb holepunch compression vs the filesystem

2015-10-21 Thread Jan Lindström
Hi, Firstly, thank you for detailed blogs that I have personally followed but naturally with some delay. Personally, I have not yet tested latest MySQL 5.7 performance using punch hole. My testing have been done mainly using MariaDB and NVMFS in FusionIO NVM devices. MariaDB 10.1 does not use by d

[Maria-developers] innodb holepunch compression vs the filesystem

2015-10-17 Thread MARK CALLAGHAN
InnoDB punch-hole compression is very bad for a filesystem when done on every (or most) page writes. That feature was not designed to be used in that manner and generates far too much in-memory metadata in the filesystem. If nothing else it leads to multi-minute unlink() system calls. Yet both Mari