Fedora 31 : rsyncd.log logrotate Hint

  vi /etc/logrotate.d/syslog   or vi /etc/logrotate.d/rsyslog    /var/log/cron /var/log/maillog /var/log/messages /var/log/secure /var/log/spooler /var/log/rsyncd.log {        missingok     sharedscripts     postrotate         /usr/bin/systemctl kill -s HUP rsyslog.service >/dev/null 2>&1 || true     endscript }     logrotate --force --verbose /etc/logrotate.conf       vi /etc/cron.daily/logrotate #!/bin/sh   /usr/sbin/logrotate […]

Read More

ERROR 1118 (42000) at line 25: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.   vi /etc/my.cnf.d/server.cnf innodb_strict_mode = OFF   or    > SET GLOBAL innodb_default_row_format='dynamic'; > SET SESSION innodb_strict_mode=OFF; > ALTER TABLE `tablename` ENGINE=InnoDB […]

Read More

Linux : ps memory size human readable Hint!

ps -eo pmem,comm,pid,maj_flt,min_flt,rss,size,vsize,pcpu,time --sort -rss | numfmt --header --to=iec --field 4-5 | numfmt --header --from-unit=1024 --to=iec --field 6-8 | column -t | head -n 20   vi psmem.sh #!/bin/bash ps -eo pmem,comm,pid,maj_flt,min_flt,rss,size,vsize,pcpu,time --sort -rss | numfmt --header --to=iec --field 4-5 | numfmt --header --from-unit=1024 --to=iec --field 6-8 | column -t $@     # psmem.sh […]

Read More

mariadb : dblink Hint

-- 1. create database for dblink create database IF NOT EXISTS dblink1;   -- 2. check dblink for FEDERATED plugin support. show engines; -- FEDERATED -- install plugin federated soname 'ha_federated.so';   -- 3. create server for dblink drop server IF EXISTS dblink1; CREATE SERVER IF NOT EXISTS dblink1  FOREIGN DATA WRAPPER mysql  OPTIONS (USER […]

Read More