When I start mysql 3.23.38 on our Solaris 2.8 machine, with or without
the /etc/my.cnf file read (i.e., I can move it out of the way or not), I
get the following messages:
/etc/rc2.d/S99mysql: @HOSTNAME@: not found
S99mysql is the script that starts up MySQL when I reboot the machine (I
believe it points to a script in init.d).
This is especially confusing because the script is set to run in the
Bourne shell, and my limited knowledge of same doesn't know of a
variable called @HOSTNAME@. There is a HOST, accessed, presumably, by
$host, but substituting that into the script doesn't appear to work,
either.
Ideas?
Kyle Hayes wrote:
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
--
Ari Davidow
Applications Administrator, Web Central
Tufts University
617-627-4291
[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