Date: Mon, 16 Oct 2000 19:21:48 -0500 From: "Jonel Rienton" <jmr@freebsduser.org> To: "Antonio Carlos Venancio Junior" <antonio@inf.ufsc.br>, <freebsd-stable@freebsd.org> Subject: Re: MySQL with Big Tables Message-ID: <01c401c037d0$3d6469d0$17161d0a@jonelrienton.org> References: <Pine.GSO.4.10.10010162208410.5203-100000@venus>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?01c401c037d0$3d6469d0$17161d0a>