On Mon, Aug 13, 2001 at 06:16:10AM +0100, Corin Hartland-Swann wrote:
>
> I have also set tmp_table_size to 1024M, which according to the
> manual should mean that temporary tables will be created in RAM
> unless they're going to be bigger than that. When I do the following
> query:
>
> SELECT
Hi,
On Thu, 9 Aug 2001, Fournier Jocelyn [Presence-PC] wrote:
> > set-variable = join_buffer=2048M
> > set-variable = key_buffer=2048M
> > set-variable = table_cache=1024
> > set-variable = record_buffer=2048M
> > set-variable = sort_buffer=2048M
> > set-variable = tmp_table_size=2048M
>
> Your
Corin Hartland-Swann wrote:
>
> Hi there,
>
> I am trying to optimise MySQL for use on a machine with:
>
> Linux 2.4.7-ac9 (only kernel to work with the disk controller)
> Dual Pentium III 1000 MHz
> 4096 MB memory
> RAID-1 Mirror over two 76GB 7200 RPM UDMA disks
> Reiserfs partition
You might want to look into what your ulimit settings are for the process
starting mysql... usually this can be done with 'ulimit -a' but check your
shells man page for more info. You could have a memory limit set for the
process and mysql is not able to use the amount of memory you specify.
Keep
