memory errors / crashes
Chris Knipe
savage at savage.za.org
Mon May 9 04:46:28 PDT 2005
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=536870912
read_buffer_size=2093056
max_used_connections=418
max_connections=2048
threads_connected=404
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
516080 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Righty. Now, the system has 4 x 3.2GHz Intel processors... It has 4GB of
ram... systat shows that all 4 processors are definately used... NO swap
space is used at all (4GB allocated), and yes, it uses the entire 4GB of ram
under heavy load... I am aware of the POSSIBILITY of the 2GB limit...
However, I highly doubt that this is related as the system has no problem to
use the 4GB of RAM (According to top in any case).
1) Why does the system not swap, and
2) Why is Mysql complaining that it needs at least 512MB ram, whilst there
are 4GB available to it??????
I've been battling for over 3 weeks to get this right, I have made multiple
posts on the list about this... can someone please just give me some
answers....
We're running FBSD 5.4-STABLE.
--
Chris.
More information about the freebsd-questions
mailing list