From owner-freebsd-stable Mon Oct 16 17:10:53 2000 Delivered-To: freebsd-stable@freebsd.org Received: from ns1.jonelrienton.org (dsl-64-34-25-237.telocity.com [64.34.25.237]) by hub.freebsd.org (Postfix) with SMTP id C9EF437B66D for ; Mon, 16 Oct 2000 17:10:39 -0700 (PDT) Received: (qmail 23597 invoked from network); 17 Oct 2000 00:26:52 -0000 Received: from debian (10.29.22.23) by zeus with SMTP; 17 Oct 2000 00:26:52 -0000 Message-ID: <01c401c037d0$3d6469d0$17161d0a@jonelrienton.org> From: "Jonel Rienton" To: "Antonio Carlos Venancio Junior" , References: Subject: Re: MySQL with Big Tables Date: Mon, 16 Oct 2000 19:21:48 -0500 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 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 iirc, MySQL is known for that. Jonel Rienton http://qmail.freebsduser.org sent by qmail-1.03 on a FreeBSD 4.1-STABLE - ----- Original Message ----- From: "Antonio Carlos Venancio Junior" To: Sent: Monday, October 16, 2000 7: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 -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.8 for non-commercial use iQA/AwUBOeubm6Q0pAI9Fl/WEQIfggCdHTo+KHhdd9n8kApiyKoosqzfn3UAn3x3 6QOFRLFqo+2v7DDdvw68jefg =80P8 -----END PGP SIGNATURE----- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message