Try putting the following before the mysqld call but before your ulimit calls -
export LDR_CNTRL='MAXDATA=0x8000'
Also try setting ulimit -m unlimited and ulimit -s unlimited.
Hopefully this helps.
Scott Pippin
[EMAIL PROTECTED]
On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote:
>
> Jeremy Zawodny wrote:
>
> > On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
> > >
> > > Then after the checking, the table seems being fixed and then I start
> > > the MySQL again. I can run query in that table after that. Then s
Hi Jeremy,
here is the value when I typed 'ulimit -a'.
core file size (blocks) unlimited
data seg size (kbytes) 524288
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 32768
pipe size (512 bytes)
On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
>
> Then after the checking, the table seems being fixed and then I start
> the MySQL again. I can run query in that table after that. Then suddenly
> I saw this error message keeps coming in the mysqld.log
>
> Error Message:
> Out of memory
Hi.
Have a look at your my.cnf (and the according manual entries). There
you can specify how much memory MySQL is allowed to use.
MySQL doesn't release memory it's allowed to use for caching.
Bye,
Benjamin.
PS: There is nothing such as "linux 7.1". Linux (the kernel) exists in
versio
