MySQL Forums
Forum List  »  Custom Storage Engines

mysql cache getting in the way of my realtime custome engine
Posted by: Colin MacKenzie
Date: July 11, 2011 03:43PM

I wrote a custom mysql engine that returns realtime data from one of our systems. The first time one of the "virtual" tables are queried I get the right results, but after that mysql caches this and it never changes. I am trying to figure out how to tell mysql optimizer that the data has changes and a rescan has to happen.

I figured it was part of the info() callback.

Can anyone point me in the right direction?

Thanks,
Colin

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql cache getting in the way of my realtime custome engine
6353
July 11, 2011 03:43PM


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.