On Friday 26 October 2001 07:18, Wai Lee wrote:
> I dig through the manual and changed any possible settings
>
> set-variable = max_heap_table_size=2000M
> set-variable = key_buffer=2500M
> set-variable = max_allowed_packet=1M
> set-variable = table_cache=512
> set-variable = sort_buffer=2500M
> set-variable = join_buffer=2500M
> set-variable = record_buffer=2500M
> set-variable = myisam_sort_buffer_size=2500M
> set-variable = myisam_max_sort_file_size=2500M
> set-variable = myisam_max_extra_sort_file_size=2500M
> set-variable = thread_cache=8
I am not certain, but I think you told MySQL to use 2.5G x 5 or 12.5GB! That
is a little more than the 4GB you have in the machine :-)
In general, the advice I have seen it to make sure that all allocated buffers
take no more than about 50% of the memory in the machine. MySQL allocates
buffer space for indexes, but _NOT_ data. It lets the OS do that. Linux
does caching of disk data very well, but you need to leave it some room to do
this. When you leave at least 50% of the space for the OS, it has a chance
to cache disk data and accesses will be much faster.
If you have a lot of large indexes, I would drop these settings to something
like:
> set-variable = max_heap_table_size=200M
> set-variable = key_buffer=1000M
> set-variable = max_allowed_packet=1M
> set-variable = table_cache=512
> set-variable = sort_buffer=250M
> set-variable = join_buffer=250M
> set-variable = record_buffer=250M
> set-variable = myisam_sort_buffer_size=250M
> set-variable = myisam_max_sort_file_size=2500M
?? Not sure about this one. Check the manual.
> set-variable = myisam_max_extra_sort_file_size=2500M
?? Not sure about this one. Check the manual.
> set-variable = thread_cache=8
Best,
Kyle
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to PSTN based Fax (Up to 95% Savings)
- Fax Broadcasting: Send 100s of faxes to fax machines
and email addresses in the time it takes to send just one!
===========================================================
So send a fax today and let us know what you think!
For more info. visit: www.internetfaxjack.com
===========================================================
---------------------------------------------------------------------
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
