We have Debian Wheezy running on all our production machines. Debian Jessie is out there for a while and I wanted to give it a try… An upgrade like this should be painless and without any major problems. I installed a machine with Debian Jessie and made it ready for production by playing some ansible … Continue reading nagios-nrpe-server: Ignores dont_blame_nrpe=1
Could happen to have a mysql database with a lot of tables and we want dump all of them, but we also want to make the logical dump process faster. Some of you could say that mydumper is the solution. It could be. But what if we don’t have the permission to install it or whatever? … Continue reading Dumping multiple mysql tables at once
At this point there are two approaches to achieve this. One is using pt-kill from Percona Toolkit, and the other one is to use a bash script with a lot of pipes :) Why would someone use the second approach? I don’t know, perhaps because there is no Percona Toolkit available. [codesyntax lang=”bash”] for i … Continue reading Kill all mysql queries having query time greater than 1 minute