From owner-freebsd-stable Mon Oct 16 16:11:32 2000 Delivered-To: freebsd-stable@freebsd.org Received: from inf.ufsc.br (euryale.inf.ufsc.br [150.162.60.23]) by hub.freebsd.org (Postfix) with ESMTP id E914F37B66D for ; Mon, 16 Oct 2000 16:11:25 -0700 (PDT) Received: from venus (venus [150.162.60.1]) by inf.ufsc.br (8.9.3/8.9.3) with ESMTP id VAA80800 for ; Mon, 16 Oct 2000 21:14:57 -0300 Date: Mon, 16 Oct 2000 22:14:55 -0200 (EDT) From: Antonio Carlos Venancio Junior X-Sender: antonio@venus To: freebsd-stable@freebsd.org Subject: MySQL with Big Tables Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG People, I run a MySQL server and I`m ahving a little problem. When I enabled my server to handle big-tables, mysqld goes crazy and take all system resources. Any clue? Here is top output: ---------- last pid: 95971; load averages: 0.97, 0.72, 0.74 up 61+08:08:27 21:12:59 41 processes: 2 running, 39 sleeping CPU states: 51.0% user, 0.0% nice, 49.0% system, 0.0% interrupt, 0.0% idle Mem: 82M Active, 102M Inact, 30M Wired, 7884K Cache, 8341K Buf, 28M Free Swap: 100M Total, 14M Used, 86M Free, 14% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 95582 mysql 105 0 28312K 14580K RUN 127:51 98.73% 98.73% mysqld ---------- If I turn big-tables off mysqld runs fine. :// Cya Antonio .-===================================================================-. | Can't buy what I want because its FREE! - Pearl Jam | |-===================================================================-| | antonio@inf.ufsc.br | floripa@zoing.net | antonio@musicramp.com | |-===================================================================-| | ICQ# 9253680 | Floripa | MySQL | PHP | FreeBSD - The Power to Serve | `-===================================================================-' To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message