If you would need to set up your displays once every week or less using the GUI is just fine. I had to do it every morning and after a while it became really annoying. Turn off the HDMI display: Turn on the HDMI display and set it as primary display:
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! If we want to remove all indices from February 2015:
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. If you can/want to … Continue reading Kill all mysql queries having query time greater than 1 minute
The data: select id, name from Object where name like “dbrferrari%”; +—–+————–+ | id | name | +—–+————–+ | 8 | dbrferrari5 | | 9 | dbrferrari6 | | 25 | dbrferrari1 | | 26 | dbrferrari2 | | 35 | dbrferrari3 | | 64 | dbrferrari4 | | 80 | dbrferrari7 | | 99 … Continue reading Natural Sorting in MySQL
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. Note: Here is the patch.txt
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
Load modules List of helpful ipmitool commands Check BMC Firmware Revision Check SEL log List SEL log Check which node you are in [For Dell Cloud edge] Reset BMC/DRAC to default Note: this will also fix No more sessions are available for this type of connection! error while trying to connect to DRAC Configure DRAC … Continue reading Configuring DRAC with ipmitool
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