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 in mind that mysql doesnt actually allocate all the memory you let it
until it needs it, so utilities like 'top' wont show the full amount of
memory mysql will use until its been up for a while and sufficiently 'used'.
Also, your computer has 4096MB or ram, you shouldnt let mysql use absolutly
all of it you should keep some of the OS + the other stuff that runs on the
computer (if any).
ryan
----- Original Message -----
From: "Corin Hartland-Swann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 1:41 PM
Subject: Optimising for 4096MB RAM
>
> 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 for MySQL
>
> As a reference point, I am running the benchmarking tests to measure the
> performance. I plan on measuring the performance with our particular
> queries after this.
>
> After reading the section of the manual dealing with performance tuning, I
> used the following in my.cnf:
>
> [mysqld]
> set-variable = join_buffer=2048M
> set-variable = key_buffer=2048M
> set-variable = table_cache=1024
> set-variable = max_allowed_packet=16M
> set-variable = max_connections=200
> set-variable = record_buffer=2048M
> set-variable = sort_buffer=2048M
> set-variable = tmp_table_size=2048M
>
> The problem is that these settings don't seem to have practically any
> effect on the amount of memory that MySQL uses when running the
> benchmarking suite - I expected it to chew up large amounts of memory with
> these settings. MySQL is currently only taking up 25MB of RAM - not the
> 512MB plus I was expecting.
>
> This machine is going to be a dedicated database server for a number of
> web servers - I expected MySQL to take up about half the memory, and disk
> caching the other half. I want it to run like a beast posessed :)
>
> Does anyone have any real world examples and/or suggestions for how to
> increase the performance? Any other variables I should be looking at?
>
> When the machine is operational, the biggest table I expect to be using
> has 55 million rows and takes up about 2G disk space (compressed, packed,
> everything).
>
> Please could you CC: any replies to me, since I am no longer on the list.
>
> Regards,
>
> Corin
>
> /------------------------+-------------------------------------\
> | Corin Hartland-Swann | Tel: +44 (0) 20 7491 2000 |
> | Commerce Internet Ltd | Fax: +44 (0) 20 7491 2010 |
> | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027 |
> | Gilbert Street | |
> | Mayfair | Web: http://www.commerce.uk.net/ |
> | London W1K 5HJ | E-Mail: [EMAIL PROTECTED] |
> \------------------------+-------------------------------------/
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
