MySQL Forums
Forum List  »  Memory Storage Engine

Anybody know this error message :/usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)?
Posted by: david yeung
Date: January 11, 2008 03:21AM

My mysql version is 5.1.21 and my application all use porcedure to interact with mysql.Sometimes this error occurs:

Version: '5.1.21-beta' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
080110 16:47:46 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 16:59:28 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 16:59:31 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 16:59:39 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 16:59:42 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:01:55 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:01:58 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:02:02 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:02:52 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:03:00 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 5592440 bytes)
080110 17:03:18 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:03:25 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:03:29 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 5592432 bytes)
080110 17:04:12 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 5592440 bytes)
080110 17:05:27 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:06:05 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:06:09 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)
080110 17:06:12 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)

Anbybody tell me why is it?
Thanks very much.

Now I can post my procedure here.

My procedure is almost as follows:


DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`sp_get_article_content`$$

CREATE DEFINER=`webuser`@`%` PROCEDURE `sp_get_article_content`(IN f_cid int,
IN f_aid int, IN f_page_no int)
BEGIN

set @sqltext = 'select cid, aid, page_no, content, page_title from article_content where 1 = 1';

if f_cid != 0 then
set @sqltext = concat(@sqltext,' and cid = ',f_cid);
end if;
if f_aid != 0 then
set @sqltext = concat(@sqltext,' and aid = ',f_aid);
end if;
if f_page_no != 0 then
set @sqltext = concat(@sqltext,' and page_no = ',f_page_no);
set @sqltext = concat(@sqltext,' order by page_no asc');
end if;


prepare s1 from @sqltext;
execute s1;
deallocate prepare s1;
set @sqltext = '';
END$$

DELIMITER ;

I'm a mysql DBA in china.
To know more details about me can visit:http://yueliangdao0608.cublog.cn

Options: ReplyQuote


Subject
Views
Written By
Posted
Anybody know this error message :/usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)?
8780
January 11, 2008 03:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.