Date: Mon, 9 May 2005 13:46:24 +0200 From: "Chris Knipe" <savage@savage.za.org> To: <mysql@lists.mysql.com>, <freebsd-questions@freebsd.org> Subject: memory errors / crashes Message-ID: <000d01c5548c$bbeec830$1e01a8c0@pc2xp>
next in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000d01c5548c$bbeec830$1e01a8c0>