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