Hello.
See:
http://dev.mysql.com/doc/mysql/en/crashing.html
"Chris Knipe" <savage@stripped> wrote:
> 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.
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
