Hello.
See: http://dev.mysql.com/doc/mysql/en/crashing.html "Chris Knipe" <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]