Skip site navigation (1)Skip section navigation (2)
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>