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

On Tue, 1 Sep 2009 17:11:59 +0400
Alex Gorbachenko wrote:

> >=D0=95=D1=81=D1=82=D1=8C =D0=BB=D0=B8 =D1=81=D0=BE=D0=BE=D0=B1=D1=80=D0=
=B0=D0=B6=D0=B5=D0=BD=D0=B8=D1=8F, =D1=81=D0=BE=D0=B2=D0=B5=D1=82=D1=8B?
>=20
> innodb ? =D0=B5=D1=81=D0=BB=D0=B8 =D0=B4=D0=B0, =D1=82=D0=BE OPTIMIZE TAB=
LE =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.

mysql> optimize table srpm;
+---------------+----------+----------+----------+
| Table         | Op       | Msg_type | Msg_text |
+---------------+----------+----------+----------+
| alt_stat.srpm | optimize | status   | OK       |=20
+---------------+----------+----------+----------+
1 row in set (0.15 sec)

mysql> optimize table rpm;
+--------------+----------+----------+----------+
| Table        | Op       | Msg_type | Msg_text |
+--------------+----------+----------+----------+
| alt_stat.rpm | optimize | status   | OK       |=20
+--------------+----------+----------+----------+
1 row in set (2.16 sec)

mysql> optimize table maintainers;
+----------------------+----------+----------+----------+
| Table                | Op       | Msg_type | Msg_text |
+----------------------+----------+----------+----------+
| alt_stat.maintainers | optimize | status   | OK       |=20
+----------------------+----------+----------+----------+
1 row in set (0.03 sec)