On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote: > > Jeremy Zawodny wrote: > > > On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote: > > > > > > Then after the checking, the table seems being fixed and then I start > > > the MySQL again. I can run query in that table after that. Then suddenly > > > I saw this error message keeps coming in the mysqld.log > > > > > > Error Message: > > > 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 > > > > So, what does `ulimit' tell you? > > Hi Jeremy, > > here is the value when I typed 'ulimit -a'. > > core file size (blocks) unlimited > data seg size (kbytes) 524288
It looks like processes are limited to 512MB. What's your my.cnf file look like? Is it likely that MySQL wants more RAM than that? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 7 days, processed 235,612,406 queries (345/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]