From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <bga@altlinux.org>
Date: Tue, 1 Sep 2009 18:49:53 +0400
From: "Grigory Batalov" <bga@altlinux.org>
To: devel@lists.altlinux.org
Message-ID: <20090901184953.710824a4@bga>
In-Reply-To: <20090901174018.7f06c9f2@satellite.immomsk.ru>
References: <20090901170806.69ad6bdd@bga>
	<20090901171159.493b7715@satellite.immomsk.ru>
	<20090901173225.79f37891@bga>
	<20090901174018.7f06c9f2@satellite.immomsk.ru>
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 14:49:54 -0000
Archived-At: <http://lore.altlinux.org/devel/20090901184953.710824a4@bga/>
List-Archive: <http://lore.altlinux.org/devel/>
List-Post: <mailto:devel@altlinux.org>

On Tue, 1 Sep 2009 17:40:18 +0400
Alex Gorbachenko wrote:

> >> innodb ? =D0=B5=D1=81=D0=BB=D0=B8 =D0=B4=D0=B0, =D1=82=D0=BE OPTIMIZE =
TABLE =D0=BA=D0=B0=D0=BA =D0=B4=D0=B0=D0=B2=D0=BD=D0=BE =D0=B4=D0=B5=D0=BB=
=D0=B0=D0=BB=D1=81=D1=8F ?
> >
> >=D0=A1=D0=B4=D0=B5=D0=BB=D0=B0=D0=BB =D1=81=D0=B5=D0=B9=D1=87=D0=B0=D1=
=81, =D0=BD=D0=BE =D1=87=D1=82=D0=BE-=D1=82=D0=BE =D1=80=D0=B0=D0=B7=D0=BD=
=D0=B8=D1=86=D1=8B =D0=BD=D0=B5 =D0=B7=D0=B0=D0=BC=D0=B5=D1=82=D0=BD=D0=BE.
>=20
> =D1=82=D0=BE=D0=B3=D0=B4=D0=B0 =D0=B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81 =D0=
=B8 explain =D0=BE=D1=82 =D0=BD=D0=B5=D0=B3=D0=BE - =D0=B2 =D1=81=D1=82=D1=
=83=D0=B4=D0=B8=D1=8E.

=D0=92=D0=BE=D1=82 =D1=82=D0=B0=D0=BA=D0=B8=D0=B5 =D0=B7=D0=B0=D0=BF=D1=80=
=D0=BE=D1=81=D1=8B =D1=82=D0=BE=D1=80=D0=BC=D0=BE=D0=B7=D1=8F=D1=82:

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  r.srpm =3D s.name AND
m.mail=3Ds.packager AND ( s.name RLIKE 'unichrome'  OR  s.summary RLIKE
'unichrome'  OR  s.description RLIKE 'unichrome'  OR  r.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?

=D0=A2=D0=B0=D0=B1=D0=BB=D0=B8=D1=86=D1=8B =D0=BD=D0=B5=D0=B2=D0=B5=D0=BB=
=D0=B8=D0=BA=D0=B8:

mysql> select count(*) from srpm;
+----------+
| count(*) |
+----------+
|    38240 |=20
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from rpm;
+----------+
| count(*) |
+----------+
|   109232 |=20
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from maintainers;
+----------+
| count(*) |
+----------+
|      250 |=20
+----------+
1 row in set (0.01 sec)