Hi, On Sat, 2003-08-30 at 10:56, Marcin Soltysiak wrote: > Can you give me a hint on optimising mysql for midgard? What could be > possible bottlenecks that cause high load on my box? I got some 200 > cocurrent connections to midgard sites and it's a bit irritating that quite > a good server has problems.
As a first, run mysql >= 4.0.13 and configure the query cache. Second, check that the indexes in your database are up to date with what is in CVS. Older midgard databases may have suboptimal indexes. Third, read up on the MySQL manual on optimizing performance. wkr, -- Envida http://www.envida.net/ Armand A. Verstappen Graadt van Roggenweg 328 [EMAIL PROTECTED] 3531 AH Utrecht tel: +31 (0)30 298 2255 Postbus 19127 fax: +31 (0)30 298 2111 3501 DC Utrecht
signature.asc
Description: This is a digitally signed message part
