From owner-freebsd-stable Mon Oct 16 18: 8:40 2000 Delivered-To: freebsd-stable@freebsd.org Received: from mail-4.sjc.telocity.net (mail-4.sjc.telocity.net [216.227.56.44]) by hub.freebsd.org (Postfix) with ESMTP id DAB9337B503 for ; Mon, 16 Oct 2000 18:08:36 -0700 (PDT) Received: from zoso (dsl-216-227-91-85.telocity.com [216.227.91.85]) by mail-4.sjc.telocity.net (8.9.3/8.9.3) with SMTP id SAA16459; Mon, 16 Oct 2000 18:03:51 -0700 (PDT) From: "Otter" To: "Jonel Rienton" , "Antonio Carlos Venancio Junior" , Subject: RE: MySQL with Big Tables Date: Mon, 16 Oct 2000 21:11:28 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <01c401c037d0$3d6469d0$17161d0a@jonelrienton.org> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG as is its microsloth cousin. i know in nt, you can adjust how much ram sql is devouring. from what i've seen, it'll take as much as you allow it to take. if not set at a reasonable limit, it can cripple a system... but now that's why some of choose to run a different os when our ms-enamoured employers can't see it. -Otter }-----Original Message----- }From: owner-freebsd-stable@FreeBSD.ORG }[mailto:owner-freebsd-stable@FreeBSD.ORG]On Behalf Of Jonel Rienton }Sent: Monday, October 16, 2000 8:22 PM }To: Antonio Carlos Venancio Junior; freebsd-stable@FreeBSD.ORG }Subject: Re: MySQL with Big Tables } } }-----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 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message