Uncategorized

CRON: Repeat on Specific Numbers Format

Posted on

For Ex:   1-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan0.sh 5-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan1.sh 7-59/10 * * * * root /usr/bin/nice -n20 /root/interfase-tester/renew_wan2.sh Line 1: 01/11/21/31/41/51 Line 2: 05/15/25/35/45/55 Line 3: 07/17/27/37/47/57

Uncategorized

MySQL: Table Sizes

Posted on

Based on Row Size SELECT TABLE_SCHEMA, table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘**Table NAME**’ ORDER BY table_rows DESC; Based on Table Size (MB) SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC

Uncategorized

Plex: Installation and Media repository using Synology NAS

Posted on

URL Format: http://192.168.5.229:32400/web/   Create Shared Folder with NAS # Mounting Network Directory for Plex //192.168.5.201/volume1/Plex /var/plex/media cifs uid=999,gid=999,credentials=/var/lib/plexmediaserver/.mountaccess,iocharset=utf8 0 0 sudo mount 192.168.1.214:/volume1/Downloads /media/NAS/Downloads $sudo mount -t nfs 192.168.1.254:/volume1/system76 /mnt/system76 \ sudo mount -t nfs 192.168.5.201:/volume1/Plex /var/plex/media