Date: Mon, 16 Oct 2000 22:14:55 -0200 (EDT) From: Antonio Carlos Venancio Junior <antonio@inf.ufsc.br> To: freebsd-stable@freebsd.org Subject: MySQL with Big Tables Message-ID: <Pine.GSO.4.10.10010162208410.5203-100000@venus>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.10.10010162208410.5203-100000>