By default @Mail uses the InnoDB database format via mySQL for the most frequently used database tables.

This increases performance for the application, however uses more memory and disk resources via MySQL.

If you experience problems using the InnoDB format you can switch to the default table format of MySQL ( MyISAM )

For technical details on the different database formats of MySQL see:

http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html

To change the table types:

#!/usr/bin/perl
# Switch DB to MyISM
foreach('UserSession', 'Users', 'Groups', 'Log_Error', 'Log_Login', 'Log_RecvMail', 'Log_SMS', 'Log_SendMail', 'Log_Spam', 'Log_Virus', 'awl')  {
my $table = $_;
print("alter table $table TYPE=myisam;n");
}

Usage:

perl /tmp/switchdb.pl | mysql -u root -p atmail

Q: do you have an E-Mail Push Service solution like Blackberry or funambol.com for your Mail Server ? Or do you have an idear how we can deliver this Service with your Mail Server ?

(more...)