[slurm-users] Extreme long db upgrade 16.05.6 -> 17.11.3

[Chris Samuel]

On Friday, 23 February 2018 8:04:50 PM AEDT Miguel Gila wrote:

> Interestingly enough, a poor vmare VM (2CPUs, 3GB/RAM) with MariaDB 5.5.56
> outperformed our central MySQL 5.5.59 (128GB, 14core, SAN) by a factor of
> at least 3 on every table conversion.

Wild idea completely out of left field..

Does the production system have the updates for Meltdown and Spectre applied, 
whereas the VM setup does not?

There are meant to be large impacts from those fixes for syscall heavy 
applications and databases are one of those nightmare cases...

cheers,
Chris
-- 
 Chris Samuel  :  http://www.csamuel.org/  :  Melbourne, VIC