Hi Jeremy, here is the value when I typed 'ulimit -a'.
core file size (blocks) unlimited data seg size (kbytes) 524288 file size (blocks) unlimited max locked memory (kbytes) unlimited max memory size (kbytes) unlimited open files 32768 pipe size (512 bytes) 1 stack size (kbytes) 65536 cpu time (seconds) unlimited max user processes 8211 virtual memory (kbytes) 589824 Thanks a lot for your help. Kaming. 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? > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 7 days, processed 223,310,311 queries (351/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]