ksoftirqd/3 Linux high cpu usage solution
This is often related to your network traffic and that most of the time Ifind the kernel just uses a single core to send or receive via your NIC.
This can be adjusted like this so that multiple cores are used to send and receive data via your NIC (eth0).
multicore eth0 RX
#enable multicore
echo f > /sys/class/net/eth0/queues/rx-0/rps_cpus
# enable flow and entries cou........
MySQL Out of Range Solution for DATETIME field
Affected rows: 0
Warning: #1264 Out of range value adjusted for column 'deleteon' at row 1
SQL query:
UPDATE `custtable`.`custinfo` SET `deleteon` = '2011-02-29 00:00:00' WHERE `custinfo`.`custid` =105 LIMIT 1 ;
This happened after a migration to a new SQL database due to user error. The old database server MySQL 3.23 or 4 allowed an impossible date to be entered by a user. As we know February 29th DOESNOT exist but the database al........