Am 01.01.2014 18:19, schrieb Aleksandr Dezhin: > 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
uhm with default settings most server software is designed to run everywhere but mostly not with best performance and/or with questionable security settings > (Debian 6). We have already planned to fix it, but it will take some > time. So while working with what is http://forums.debian.net/viewtopic.php?t=38976 for mission critical packages (dbmail, mysql, apache, postfix, trafficserver..) i build my own packages since i started to take over resposibility of the infrastructure and i did not regret it for a single second - a mysql-upgrade is a no-brainer because it works without dumping and restoring databases, at least the last 12 years both cases are greatly improved: * a newer package than the distribution ships * maintain a older one like PHP 5.3 for Fedora 17/18 because PHP 5.4 had some bad incompatible changes we needed to prepare until last summer the only thing you should always avoid is install software bypassing your package managment because the question is not if it will break things badly only when it will happen
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
