Monthly Archives: September 2010

optimize XFS for a RAID array

This script helps you to find the right mkfs.xfs command. Source: http://www.mythtv.org/wiki/Optimizing_Performance#Further_Information

Posted in IT, Linux | Leave a comment

MySQL: binary search without index

This is a flash of a genius: http://linxtrix.com/2007/09/19/tricking-mysql-to-use-index-on-binary-search/ Problem: you can’t search case insensitive words. This trick will “do” it for you. Make a test between this two ways: SELECT * FROM test WHERE binary login = ‘SomeCaseSensitiveLogin’ is million … Continue reading

Posted in IT | Leave a comment

Import Ingo (Horde) sieve rules into Roundcube

1. Replace the default managesieve plugin by sieverules 2. Copy the old ruleset to the place, where dovecot is looks for it. In case of cyrus-imapd it’s here by default: /var/spool/sieve/ 3. Rename it from ingo.script to ingo.sieve 4. Go … Continue reading

Posted in IT | Leave a comment