Am 29.08.2011 23:48, schrieb Simon: > > On 30/08/2011, at 9:42 AM, Reindl Harald wrote: > >> your innodb-settings sucks >> >> this should not be so slow >> on our 15 GB dbmail-database "dbmail-util" needs only 5 minutes >> and there is normal access to anything while it tuns >> >> how much mameory has your box and what are your mysql-settings > > Thanks for the quick reply... i had thought it might be something like this. > 2GB RAM on the MySQL box with the > following: > > http://www.nzlocal.com/simon/mysqlconf.txt
2 GB RAM is way too small for a 70 GB InnoDB in a perfect world innodb_buffer_pool is as large as the database in your case there is nothing left to play because the mailservices needs memory too beside the operating system - our 15 GB dbmail-server has 10.500 MB memory in a virtual machine, our small one has 1 GB buffer-pool sorry, i do not know how to deal with so few memory
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
