This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/sh | |
#Check the Drive Space Used by Cached Files | |
du -sh /var/cache/apt/archives | |
#Clean all the log file | |
#for logs in `find /var/log -type f`; do > $logs; done | |
logs=`find /var/log -type f` | |
for i in $logs |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Para saber o tamanho de todas as bases de dados: | |
SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# RESCAN FOR NEWLY ADDED HDS | |
echo "- - -" > /sys/class/scsi_host/host#/scan | |
fdisk -l | |
# NEW LOGICAL VOLUME | |
sudo fdisk /dev/sdb | |
# then create a new partition of type 8e (Linux LVM) | |
# create a phisical volume | |
sudo pvcreate /dev/sdb1 | |
# create new volume group |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# my.cnf for TAKIS Server | |
# BEGIN CONFIG INFO | |
# DESCR: 8 GB RAM, InnoDB only, ACID, few connections, heavy queries | |
# TYPE: SYSTEM | |
# END CONFIG INFO | |
[client] | |
port = 7000 | |
socket = /var/lib/mysql/mysql.sock |