From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <bga@altlinux.org>
Date: Tue, 1 Sep 2009 23:20:53 +0400
From: "Grigory Batalov" <bga@altlinux.org>
To: devel@lists.altlinux.org
Message-ID: <20090901232053.02980844@bga>
In-Reply-To: <240e377b0909010803p309ef97dxcb8ad8bf31b1d453@mail.gmail.com>
References: <20090901170806.69ad6bdd@bga>
	<20090901171159.493b7715@satellite.immomsk.ru>
	<20090901173225.79f37891@bga>
	<20090901174018.7f06c9f2@satellite.immomsk.ru>
	<20090901184953.710824a4@bga>
	<240e377b0909010803p309ef97dxcb8ad8bf31b1d453@mail.gmail.com>
Organization: ALT Linux Team
X-Mailer: Claws Mail 3.6.1cvs5 (GTK+ 2.16.1; i586-alt-linux-gnu)
X-Face: ")Qu!$R3ym>`zI`H#Scijb6gliZ{v(u-Y6muu{*\y^\%Chb}{eEo4=L^jB]/>jhI]yW._DV')>_Yj#L`{-(%kaIt76Smg&jk>R>@!QO(p{:dr},@;
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: [devel] Mysqld CPU usage at www.sisyphus.ru
X-BeenThere: devel@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: ALT Linux Team development discussions <devel@lists.altlinux.org>
List-Id: ALT Linux Team development discussions <devel.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/devel>,
	<mailto:devel-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/devel>
List-Post: <mailto:devel@lists.altlinux.org>
List-Help: <mailto:devel-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/devel>,
	<mailto:devel-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Tue, 01 Sep 2009 19:20:54 -0000
Archived-At: <http://lore.altlinux.org/devel/20090901232053.02980844@bga/>
List-Archive: <http://lore.altlinux.org/devel/>
List-Post: <mailto:devel@altlinux.org>

On Tue, 1 Sep 2009 19:03:00 +0400
Mikhail Yakshin wrote:

> > SELECT DISTINCT s.name, s.version, s.rel, m.packager, s.summary, s.repo
> > FROM srpm as s, maintainers as m, rpm as r WHERE =C2=A0r.srpm =3D s.nam=
e AND
> > m.mail=3Ds.packager AND ( s.name RLIKE 'unichrome' =C2=A0OR =C2=A0s.sum=
mary RLIKE
> > 'unichrome' =C2=A0OR =C2=A0s.description RLIKE 'unichrome' =C2=A0OR =C2=
=A0r.namen RLIKE
> > 'unichrome' ) AND s.repo=3D'Sisyphus' AND r.repo=3D'Sisyphus' ORDER BY 1
> > ASC LIMIT 0,20;
> >
> > =D0=9C=D0=BE=D0=B6=D0=B5=D1=82 =D0=B1=D1=8B=D1=82=D1=8C, =D0=B7=D0=B0=
=D0=BC=D0=B5=D0=BD=D0=B8=D1=82=D1=8C RLIKE =D0=BD=D0=B0 MATCH AGAINST ? =D0=
=91=D1=83=D0=B4=D0=B5=D1=82 =D0=B1=D1=8B=D1=81=D1=82=D1=80=D0=B5=D0=B5?
>=20
> =D0=92=D0=BE-=D0=BF=D0=B5=D1=80=D0=B2=D1=8B=D1=85, =D0=BF=D1=80=D0=BE=D0=
=B2=D0=B5=D1=80=D0=B8=D1=82=D1=8C =D0=B8=D0=BD=D0=B4=D0=B5=D0=BA=D1=81=D1=
=8B, =D0=BF=D0=BE =D0=BA=D0=BE=D1=82=D0=BE=D1=80=D1=8B=D0=BC =D0=BF=D1=80=
=D0=BE=D0=B8=D0=B7=D0=B2=D0=BE=D0=B4=D0=B8=D1=82=D1=81=D1=8F JOIN. =D0=98=
=D0=BC=D0=B5=D0=B5=D1=82
> =D1=81=D0=BC=D1=8B=D1=81=D0=BB =D0=B2=D1=8B=D0=BF=D0=B8=D1=81=D0=B0=D1=82=
=D1=8C =D1=8D=D1=82=D0=BE =D0=B2 =D1=8F=D0=B2=D0=BD=D1=8B=D0=B9 "INNER JOIN=
 ON =D1=87=D1=82=D0=BE-=D1=82=D0=BE":
>=20
> > WHERE  r.srpm =3D s.name AND m.mail=3Ds.packager
>=20
> =D0=92=D0=BE-=D0=B2=D1=82=D0=BE=D1=80=D1=8B=D1=85, =D1=82=D0=B0=D0=BA=D0=
=BE=D0=B9 RLIKE =D1=81=D0=BA=D0=BE=D1=80=D0=B5=D0=B5 =D0=B2=D1=81=D0=B5=D0=
=B3=D0=BE =D0=B2=D0=BE=D0=BE=D0=B1=D1=89=D0=B5 =D0=BD=D0=B5 =D0=B8=D1=81=D0=
=BF=D0=BE=D0=BB=D1=8C=D0=B7=D1=83=D0=B5=D1=82 =D0=B8=D0=BD=D0=B4=D0=B5=D0=
=BA=D1=81=D1=8B =D0=B8
> =D0=B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81 =D0=BF=D1=80=D0=B5=D0=B2=D1=80=D0=B0=
=D1=89=D0=B0=D0=B5=D1=82=D1=81=D1=8F =D0=B2 FULL SCAN. =D0=9F=D1=80=D0=BE=
=D0=B2=D0=B5=D1=80=D0=B8=D1=82=D1=8C =D0=B8=D0=BD=D0=B4=D0=B5=D0=BA=D1=81=
=D1=8B, =D0=BF=D0=BE =D0=BA=D0=BE=D1=82=D0=BE=D1=80=D1=8B=D0=BC
> =D0=B4=D0=B5=D0=BB=D0=B0=D0=B5=D1=82=D1=81=D1=8F RLIKE =D0=B8 =D0=B7=D0=
=B0=D0=BC=D0=B5=D0=BD=D0=B8=D1=82=D1=8C =D0=B5=D0=B3=D0=BE =D0=BB=D0=B8=D0=
=B1=D0=BE =D0=BD=D0=B0 LIKE '=D0=B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81%', =D0=BB=
=D0=B8=D0=B1=D0=BE =D0=BD=D0=B0
> =D1=80=D0=B0=D0=B2=D0=B5=D0=BD=D1=81=D1=82=D0=B2=D0=BE.
>=20
> MATCH AGAINST =D0=BF=D0=BE=D1=82=D1=80=D0=B5=D0=B1=D1=83=D0=B5=D1=82 =D0=
=BF=D0=BE=D0=BB=D0=BD=D0=BE=D1=82=D0=B5=D0=BA=D1=81=D1=82=D0=BE=D0=B2=D1=8B=
=D1=85 =D0=B8=D0=BD=D0=B4=D0=B5=D0=BA=D1=81=D0=BE=D0=B2, =D0=B4=D0=B0 =D0=
=B8 =D0=B1=D1=83=D0=B4=D0=B5=D1=82 =D0=B2=D0=BE=D0=B7=D0=B2=D1=80=D0=B0=D1=
=89=D0=B0=D1=82=D1=8C
> =D1=81=D0=BE=D0=B2=D1=81=D0=B5=D0=BC =D0=BD=D0=B5 =D1=82=D0=BE, =D1=87=D1=
=82=D0=BE =D1=85=D0=BE=D1=87=D0=B5=D1=82=D1=81=D1=8F, =D0=BA=D0=B0=D0=BA =
=D1=8F =D0=BF=D0=BE=D0=BD=D1=8F=D0=BB.

=D0=98=D0=BD=D0=B4=D0=B5=D0=BA=D1=81=D0=BE=D0=B2 =D0=BD=D0=B0 summary, desc=
ription =D1=81=D0=B5=D0=B9=D1=87=D0=B0=D1=81 =D0=B2=D0=BE=D0=BE=D0=B1=D1=89=
=D0=B5 =D0=BD=D0=B5=D1=82.

RLIKE =D0=B8=D1=81=D0=BF=D0=BE=D0=BB=D1=8C=D0=B7=D1=83=D0=B5=D1=82=D1=81=D1=
=8F =D0=B4=D0=BB=D1=8F =D0=BF=D0=BE=D0=B8=D1=81=D0=BA=D0=B0 =D0=BB=D1=8E=D0=
=B1=D0=BE=D0=B3=D0=BE =D1=81=D0=BE=D0=B2=D0=BF=D0=B0=D0=B4=D0=B5=D0=BD=D0=
=B8=D1=8F =D0=B2 name, summary,
description. '=D0=B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81%' =D1=81=D1=80=D0=B0=D0=
=B1=D0=BE=D1=82=D0=B0=D0=B5=D1=82 =D1=82=D0=BE=D0=BB=D1=8C=D0=BA=D0=BE =D0=
=BD=D0=B0 =D1=81=D0=BE=D0=B2=D0=BF=D0=B0=D0=B4=D0=B5=D0=BD=D0=B8=D0=B5 =D0=
=B2 =D0=BD=D0=B0=D1=87=D0=B0=D0=BB=D0=B5
=D1=81=D1=82=D1=80=D0=BE=D0=BA=D0=B8.