I'm facing the following situation. There is periodic procedure calling by event (CREATE EVENT) that modifies record and commits. There are two additional sessions (one by HeidiSQL, one by mysql command line tool) that issue select on view based on the table involved. I noticed outdated values, returned by mysql session while another session return accurate new value of datetime column.
Then (in mysql session) I issue "flush tables" command. Then on next execution I get new value.
This upsets me. I was expecting to get the latest column value regardless "flush tables". Is that designed behavior? Are there some system settings that affect the logic? Should I issue "flush tables" every time before issuing select?
My environment:
11.4.2-MariaDB
Win64
my.ini: autocommit=0 sql_mode=ORACLE