[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    mysql: big tables
From:       Michael Widenius <monty () monty ! pp ! sci ! fi>
Date:       1998-08-31 20:20:25
[Download RAW message or body]

>>>>> "Drew" == Drew M Hahn <amh7@acf2.nyu.edu> writes:

Drew> i am getting a table 'SQL4_0' is full error.  i know i can set
Drew> SQL_BIG_TABLES = 1 and do it on disk instead, but i would rather adjust
Drew> the ulimits to allow it to do it in memory.  right now, mysql is running
Drew> on a sun enterprise 3500 with 2 processors and 1GB of ram.  any
Drew> recommendations on rlimit settings to accommodate mysql?

Hi!

This isn't a rlimit issue.

Just increase the tmp_table_size parameter:

safe_mysqld --O tmp_table_size=8M

Yours,
Monty

*************** Warning commercial signature follows **********
If you like TCX's concept of a 'mostly free' database and free
advice, you should at least CONSIDER supporting us that we can
afford to keep this service up.   http://www.tcx.se/
-----------------------------------------------------------
Send a mail to mdomo@tcx.se with
unsubscribe mysql your@subscription.address
in the body of the message to unsubscribe from this list.

[prev in list] [next in list] [prev in thread] [next in thread]