Marvel indices taking lot of space? Delete indices older than 7 days!

It looks like Marvel is generating some data everyday. Is there a way to reduce the amount of data generated by marvel? The short answer to the above question is Yes! [codesyntax lang=”bash”] curator –host 127.0.0.1 show indices –older-than 30 –time-unit days –timestring ‘%Y.%m.%d’ –prefix .marvel curator –host 127.0.0.1 close indices –older-than 30 –time-unit days … Continue reading Marvel indices taking lot of space? Delete indices older than 7 days!

nagios-nrpe-server: Ignores dont_blame_nrpe=1

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

Kill all mysql queries having query time greater than 1 minute

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

How to add debug symbols for MariaDB Debian/Ubuntu packages

I don’t know about other distributions, but I know that the debug symbols were stripped from Debian/Ubuntu packages. If there are some crashes reported I won’t be able to fully analyze them. The only way to fix this problem is to build the packages again. [codesyntax lang=”bash”] git clone https://github.com/MariaDB/server.git cd server/ git branch -a … Continue reading How to add debug symbols for MariaDB Debian/Ubuntu packages

mysql hot backup with xtrabackup

I want to backup my databases without downtime… Well, there are couple approaches to this. One of them is to add a standby slave and use LVM snapshot approach. The second approach is to use percona xtrabackup. My problem is that I have some huge databases here, so taking local backups is out of the question. … Continue reading mysql hot backup with xtrabackup

Configuring DRAC with ipmitool

Load modules [codesyntax lang=”bash”] modprobe ipmi_devintf modprobe ipmi_si [/codesyntax] List of helpful ipmitool commands Check BMC Firmware Revision [codesyntax lang=”bash”] ipmitool -I open bmc info | grep -A3 “Firmware Revision” [/codesyntax] Check SEL log [codesyntax lang=”bash”] ipmitool sel [/codesyntax] List SEL log [codesyntax lang=”bash”] ipmitool sel list [/codesyntax] Check which node you are in [For … Continue reading Configuring DRAC with ipmitool

How to recover the space used by UNDO_LOG in InnoDB tablespaces

The panic started when the monitoring server sent an alert about the storage of one of our MySQL servers – saying that the disk is about to get filled. I realized that a a lot of the disk space was used by the InnoDB’s shared tablespace ibdata1. But wait… I have innodb_file_per_table enabled. So, what … Continue reading How to recover the space used by UNDO_LOG in InnoDB tablespaces

I can't memorize much, so I take notes!