On 08/29/2011 11:48 PM, Simon wrote:
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
You can safely increase your innodb_buffer_pool_size to 1GB and
innodb_log_file_size to 256MB. Just don't forget to check in MySQL
documentation how it should be done once you already created a database.
--
Igor Živković
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
