Debian Ubuntu: Delete Packages which are marked as „rc“

Problem: If you up/downgrade a Debian most of unneeded files are always on your disk

Solution:
To check:

$sudo dpkg -l | more

To cleanup:
dpkg --list |grep "^rc" | cut -d " " -f 3 | xargs sudo dpkg --purge

If you like run the command twice cause sometimes deps are new taken
or install deporphan to:
$sudo deborphan | xargs sudo apt-get -y remove --purge

If you like run the command twice cause sometimes deps are new taken

WordPress MySQL: Cleanup old revisions old posts old entrys

Problem: If you use wordpress and edit often your posts a high count of old revisions are backuped inside the mysql database:

Solution:
Login mysql

$mysql -u root -p [Enter root password]

at mysql command line select wordpress your database
mysql>use wordpressdb; [Enter]
System echo=Database changed..

delete old backups of posts
mysql>DELETE FROM wp_posts WHERE post_type = "revision"; [Enter]
System echo=..Entry affected time..

logout database and revisit pages, if you have made a database backup with mysqldump before and after cleanup you see how much size the database lost (du -h wordpress.sql)
often 80% of the size.

SME Server Centos Red Hat speedup disable unneeded services sound pcmcia cpuspeed

Problem: The default installation setup some unneeded services like pcmcia or sound or cpuspeed

Solution:

  1. log into your server as root
  2. run
    /sbin/chkconfig --list 
    to see active services
  3. run
    /sbin/chkconfig --level 2345 pcmcia off 
    to disable pcmcia cause a server does not have pcmcia
  4. edit the /etc/modprobe.conf and switch off sound-modules with
    alias "name-module" off
  5. run after reboot
    #/sbin/lsmod
    to control the disabled sound modules if they are not seen they are not active
  6. NOW you have reduced memory load and processes at cpu can speed up your CPU and save energy (at my Epia 533Mhz may be 3Watts at hour)