Unwanted cache
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.
Subject
Written By
Posted
Unwanted cache
May 08, 2014 10:13AM
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.