pip install з параметрами

pip install mysqlclient --config-settings="build_options.c_options=-IC:\Program Files\MariaDB\MariaDB Connector C 64-bit\include 
-LC:\Program Files\MariaDB\MariaDB Connector C 64-bit\lib"

Запис завантажувальної флешки через DD

 

sudo dd bs=4M if=/path/to/iso/file of=/dev/sdb status=progress && sync

reset деяких залізяк Cisco

щоб надіслати break в Minicom, натискаємо Ctrl+a f

rommon 1 >confreg 0x2142
rommon 2 >reset

https://www.freeccnaworkbook.com/workbooks/ccna/cisco-2600-series-router-password-reset

reset pix: https://www.petenetlive.com/KB/Article/0000064

One more beautiful theme for Midnight Commander

https://draculatheme.com/midnight-commander

Clearing zabbix history via SQL

DELETE FROM history_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM history WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends_uint WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM trends WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM events WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));
DELETE FROM alerts WHERE clock < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 2 DAY));

Видалення листів з черги

mailq | awk '$7~/@/{print$1}' | while read qid; do postsuper -d $qid; done

Вирішення помилки в mysql "Row Size Too Large" з InnoDB

[mysqld]

innodb_log_file_size = 512M
innodb_strict_mode = 0