Date: Mon, 16 Oct 2000 21:11:28 -0400 From: "Otter" <otterr@telocity.com> To: "Jonel Rienton" <jmr@freebsduser.org>, "Antonio Carlos Venancio Junior" <antonio@inf.ufsc.br>, <freebsd-stable@FreeBSD.ORG> Subject: RE: MySQL with Big Tables Message-ID: <HLEDJBJKDDPDJBMGCLPPKEPFCFAA.otterr@telocity.com> In-Reply-To: <01c401c037d0$3d6469d0$17161d0a@jonelrienton.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <antonio@inf.ufsc.br> }To: <freebsd-stable@freebsd.org> }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 <http://www.pgp.com>; 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?HLEDJBJKDDPDJBMGCLPPKEPFCFAA.otterr>