From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1G8kVs-00026e-5h for garchives@archives.gentoo.org; Thu, 03 Aug 2006 21:13:52 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.7/8.13.6) with SMTP id k73LCxCt031570; Thu, 3 Aug 2006 21:12:59 GMT Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by robin.gentoo.org (8.13.7/8.13.6) with ESMTP id k73LArJN013418 for ; Thu, 3 Aug 2006 21:10:53 GMT Received: from [129.130.0.165] (align.cns.ksu.edu [129.130.0.165]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTP id D6BE4642BF for ; Thu, 3 Aug 2006 21:10:52 +0000 (UTC) Message-ID: <44D26660.6080202@gentoo.org> Date: Thu, 03 Aug 2006 16:10:56 -0500 From: Lance Albertson User-Agent: Thunderbird 1.5.0.5 (Macintosh/20060719) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] Monthly Gentoo Council Reminder for August References: <20060801093001.C97C864465@smtp.gentoo.org> <1154607828.23292.5.camel@localhost> <44D1F4EF.3000209@gentoo.org> <1154612153.17538.26.camel@onyx> <44D20317.6030000@gentoo.org> <1154616531.28858.53.camel@onyx> <44D210C7.90902@gentoo.org> <44D1F809.5010801@gentoo.org> <1154628512.24984.70.camel@localhost> <44D244F2.8030602@gentoo.org> <623652d50608031255y54d2d773q269f16005070c1bf@mail.gmail.com> <44D262A3.2040607@badapple.net> In-Reply-To: <44D262A3.2040607@badapple.net> X-Enigmail-Version: 0.93.2.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigB7F06FF26D9955700B8F712C" X-Archives-Salt: 8a36e29a-6150-47b3-b2c9-e4b664b11da4 X-Archives-Hash: 63a97104e2efc1381fa9eff000424442 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigB7F06FF26D9955700B8F712C Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable kashani wrote: > Chris Bainbridge wrote: >> I'm curious what the problem is with bugzilla and it's db >> interactions? You're suggesting a specific issue rather than general >> db performance issues like fs, io scheduling, raid1, hyperthreads, >> etc.? >=20 > It's most likely related to Bugzilla using MyISAM tables by default= > which is fine in a small environment. However as concurrency grows alon= g > with table size those full table locks begin to cause issues. > Additionally most www-apps are not known for their well thought out db > schema. Performance of the underlying hardware plays a part, but can be= > overshadowed pretty quickly by query and table inefficiencies. >=20 > The usual fix without touching the internals of the software is > doing master/slave replication and allowing the selects to happen on th= e > slave and writes on the master. However you would need to change most o= f > the queries to point to the slave server which is usually not trivial. > It sounds like this is the path the Infra team is pursuing. 1++ You got it right :-) --=20 Lance Albertson Gentoo Infrastructure | Operations Manager --- GPG Public Key: Key fingerprint: 0423 92F3 544A 1282 5AB1 4D07 416F A15D 27F4 B742 ramereth/irc.freenode.net --------------enigB7F06FF26D9955700B8F712C Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (Darwin) iD8DBQFE0mZgQW+hXSf0t0IRAlayAJ49r4ZG0p0E8reV6Ey58/YI0sy4twCePBnl sE/I3pq7be5XRYC5EPvMv/k= =RPdV -----END PGP SIGNATURE----- --------------enigB7F06FF26D9955700B8F712C-- -- gentoo-dev@gentoo.org mailing list