September 11th, 2008
SHOW STATUS considered harmful
First of all, I know this is a known problem, but it struck me so hard, I just had to write about it! As Peter Zaitev points out calling SHOW STATUS might have a huge performance impact. We recently replaced one of our servers with a DELL R900 with 96GB RAM. Having a disk-bound workload [...]