Date: Tue, 17 Oct 2000 11:29:59 -0400 From: "Ken Menzel" <kenm@icarz.com> To: "Antonio Carlos Venancio Junior" <antonio@inf.ufsc.br>, <freebsd-stable@FreeBSD.ORG> Subject: Re: MySQL with Big Tables Message-ID: <00bf01c0384f$1c3ceaa0$671663cf@icarz.com> References: <Pine.GSO.4.10.10010162208410.5203-100000@venus>
next in thread | previous in thread | raw e-mail | index | archive | help
Antonio, you will probably get better answers from http://www.mysql.com/documentation/lists.html Try the mailing list and the archives. I am running configured with --with-large-tables with no problems. But this is not the list for this discussion. Please e-mail me directly and I will try to help or try the MySQL mailing lists. MySQL works very well for us. Ken ----------------------------------------------------- Ken Menzel ICQ# 9325188 www.icarz.com kenm@icarz.com ----- Original Message ----- From: "Antonio Carlos Venancio Junior" <antonio@inf.ufsc.br> To: <freebsd-stable@FreeBSD.ORG> Sent: Monday, October 16, 2000 8: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 > 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?00bf01c0384f$1c3ceaa0$671663cf>