Anybody know this error message :/usr/local/mysql/bin/mysqld: Out of memory (Needed 16777224 bytes)?
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