MySQL Forums
Forum List  »  Newbie

Unwanted cache
Posted by: Muhammad Ali
Date: May 08, 2014 10:13AM

Dear Gurus,

I am using 5.6.16-log MySQL Community Server (GPL) on CentOS release 5.7 (64 bit). I have having a strange issue in which it seems that MySQL is cache result of stored procedure even if the procedure arguments are changed. For example

CALL proc_getName(1,@v_Name );
select @v_Name;

CALL proc_getName(2,@v_Name );
select @v_Name;

CALL proc_getName(3,@v_Name );
select @v_Name;


All of above are giving same results even if the base table truncated. This issue resolved when MySQL restarted.

Your help is required to fix this issue.

Options: ReplyQuote


Subject
Written By
Posted
Unwanted cache
May 08, 2014 10:13AM
May 09, 2014 03:17PM
May 09, 2014 11:51PM
May 13, 2014 09:25AM


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.