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 [EMAIL PROTECTED] ----- Original Message ----- From: "Antonio Carlos Venancio Junior" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 | > |-===================================================================- | > | [EMAIL PROTECTED] | [EMAIL PROTECTED] | [EMAIL PROTECTED] | > |-===================================================================- | > | ICQ# 9253680 | Floripa | MySQL | PHP | FreeBSD - The Power to Serve | > `-===================================================================- ' > > > > To Unsubscribe: send mail to [EMAIL PROTECTED] > with "unsubscribe freebsd-stable" in the body of the message > To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-stable" in the body of the message