Bug #22746 | MySQL memory grows, runs out of memory and process crashes | ||
---|---|---|---|
Submitted: | 27 Sep 2006 17:54 | Modified: | 28 Sep 2006 9:29 |
Reporter: | Stefan Burwitz | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.24a | OS: | Windows (Windows Server 2003) |
Assigned to: | CPU Architecture: | Any |
[27 Sep 2006 17:54]
Stefan Burwitz
[28 Sep 2006 7:09]
Stefan Burwitz
The MySQL server error log contains many log entries of the type below. 060928 8:53:31 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space It also appears as if the memory issues are reported on selects rather than inserts. My application inserts 200-300k rows per minute. The same table is pruned once per minute to remove stale entries. The same table is queried at a much lower rate to produce aggregate values for specified time periods.
[27 Jan 2007 19:06]
Chad Catlett
I'm curious.. did you resolve this? If so what were your steps?