[horde] Horde 3.1: MySQL performance problem
jason at citydiesel.net
Mon Dec 11 08:43:29 PST 2006
If you are using mysql for session management you might want to try
switching to memcached instead, should reduce the load on mysql
significantly. The cvs versions of horde and imp use some caching that
should reduce the load on your database as well
Quoting Marco Pirovano <marco.pirovano at unibocconi.it>:
> last week I switched the webmail server of our university from Horde2/IMP3 to
> All seems to be good untill the number of contemporary users reached
> about 500.
> At that point the MySQL db response was VERY slow and we saw the message:
> "Fatal Error: can't connect to DB horde_uni".
> Our infrastructure is composed of:
> * 4 front-end (HP DL360 4 GB RAM, 2 CPU, FreeBSD 6.1) with:
> - Apache 2.0.59
> - PHP 4.4.4
> - eAccelerator 0.9.5
> * 1 MySQL server 5.0.27 (HP DL580, 4 GB RAM, 2 CPU, FreeBSD 6.1)
> * 1 IMAP server Cyrus 2.2.12 (HP DL580, 4 GB RAM, 2 CPU, FreeBSD 6.1)
> who was using the client (Outlook, Eudora or Thunderbird) had no problem.
> I tried to adjust MySQL parameter, but without success, so, afther three days
> of tentative, I had to rool back to Horde2/IMP3 :-[
> We run Horde2/IMP3 for more than 3 years without no problem and with only
> one server for both Apache and MYSQL.
> My boss told me that he want to use another system, but I'm sure tha Horde
> is the best and also the most used, especially in the academic world.
> But I have to sove the problem and than to persuade him !
> So, I'm asking who is using Horde 3.1 / IMP 4.1, on which infrastructure,
> how many contemporary users and if you had the same performance
> problem and how
> do you solved that problem.
> Please help me ...
> Thank you very much.
> * Marco Pirovano
> * Universita' Bocconi, Area Sistemi Informatici e Telematici
> * Piazza Sraffa 11 - 20136 Milano
> * Tel. +39 02 5836.3173 Fax. +39 02 5836.3160 VoIP. 02 5828.3173
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
More information about the horde