On 01.01.2014 20:52, Reindl Harald wrote: > Am 01.01.2014 17:42, schrieb Aleksandr Dezhin: >> As you mentioned earlier, max_db_connections can be a source of problems, I >> tried to use the default value, but it >> did not change the situation. Maybe our database is too slow, but there's >> nothing we can do about it. It is quite >> big, it is about 100 GB > RAM, RAM and again RAM > > you need at least the summary of all indexes + 50% on InnoDB > > perfect would be the whole database size, but in case of dbmail > that's not entirely true because there are many many old messages > which are not loaded that much > > rule of thumbs is the innodb_buffer_pool should hold all regulary > accessed data and have enough free space for regular operations > _____________________________________________ > > what version of MySQL? It's pretty sad, but we'll use mysql 5.1 without much performance tuning (Debian 6). We have already planned to fix it, but it will take some time. So while working with what is.
At the moment, we choose what we use to provide fault tolerance at database level. DRBD or MariaDB Galera? Somebody uses dbmail together with galera? _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
