From owner-freebsd-stable Tue Oct 17 8:30:18 2000 Delivered-To: freebsd-stable@freebsd.org Received: from apollo.retec.net (apollo.retec.net [207.99.22.10]) by hub.freebsd.org (Postfix) with ESMTP id 4B80837B4F9 for ; Tue, 17 Oct 2000 08:30:10 -0700 (PDT) Received: from newken (dhcp103.retec.net [207.99.22.103]) by apollo.retec.net (8.9.3/8.9.0) with SMTP id LAA04934; Tue, 17 Oct 2000 11:23:26 -0400 (EDT) Message-ID: <00bf01c0384f$1c3ceaa0$671663cf@icarz.com> From: "Ken Menzel" To: "Antonio Carlos Venancio Junior" , References: Subject: Re: MySQL with Big Tables Date: Tue, 17 Oct 2000 11:29:59 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Antonio, you will probably get better answers from http://www.mysql.com/documentation/lists.html Try the mailing list and the archives. I am running configured with --with-large-tables with no problems. But this is not the list for this discussion. Please e-mail me directly and I will try to help or try the MySQL mailing lists. MySQL works very well for us. Ken ----------------------------------------------------- Ken Menzel ICQ# 9325188 www.icarz.com kenm@icarz.com ----- Original Message ----- From: "Antonio Carlos Venancio Junior" To: Sent: Monday, October 16, 2000 8:14 PM Subject: MySQL with Big Tables > 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 > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message