Re: [devel] Mysqld CPU usage at www.sisyphus.ru

["Grigory Batalov" <bga@altlinux.org>]

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

> >Есть ли соображения, советы?
> 
> innodb ? если да, то OPTIMIZE TABLE как давно делался ?

Сделал сейчас, но что-то разницы не заметно.

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

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

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