Archive for February, 2015
PL/SQL: I wouldn’t recommend to use the following construction: IF EXISTS (SELECT 1 FROM `table_a` WHERE `id` = `_ID`) THEN UPDATE `table_a` SET `value` = 1 WHERE `id` = `_ID`; ELSE INSERT INTO `table_a` […]; END IF; In my case there was a trigger (on table_a) who additionaly modifed “table_b”. When I changed the engine […]
yum install install i8kutils yum install lm_sensors.x86_64 echo “i8k” > /etc/modules-load.d/i8k.conf # Now, one can manage fan speed. i8kfan 1 1 I run this script into console (as watch command parameter) every 900s. #!/bin/bash SCRIPT_NAME=`basename $0` FILE_TMP=”/tmp/sensors-$SCRIPT_NAME” sensors > $FILE_TMP TEMP4=`grep temp4 $FILE_TMP | sed ‘s/\s//g’ | awk -F “:” ‘{print $2}’ | sed ‘s/[^0-9.]//g’` […]