-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 LALOT Dominique wrote: > > Also, you'll have to look at mysql. For big databases, you need special > tuning as default values are not good. We are in he way to put (for HA) > another mysql server and we will split the access to several servers. > (replica) > > As I reread your mail, look at your SQL setup..
That's exactly what helped us. After tuning the mysqld config the load dropped to a normal level. Here as an extract of our my.cnf: [...] skip-external-locking skip-thread-priority key_buffer = 64M max_connections = 1024 max_connect_errors = 1000 max_allowed_packet = 8M table_cache = 512 sort_buffer_size = 12M read_buffer_size = 1M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache_size = 64 query_cache_size = 128M tmp_table_size= 1024M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 12 wait_timeout = 75 interactive_timeout = 75 log_slow_queries [...] Try playing with the sort_buffer_size and tmp_table_size, increasing it helped in our case. We also configured Horde to not use persistent mysql connections. maybe it helps. Didi -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFJyKZ15UTx/TQx0LARAoHoAJ0WcGsktBb4w/mv6Sd/plztVlEUbwCgrm+j /RWVXxC3bwfa4gyiX5Qq4rQ= =vx74 -----END PGP SIGNATURE----- -- IMP mailing list - Join the hunt: http://horde.org/bounties/#imp Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]
