I have a big problem using insert/update queries in mySQL 5.0.24
Sometimes it happens that an insert or update query is not written to the table (or the disc) at once. it seems that it hangs in some cache.
for example: i make an insert on a table (via the website), refresh the website and i can see the changes, but the row is not visible in phpmyadmin. i am also not possible to update the row via the website. it says, that the row does not exist.
after a server restart or a “flush tables” the row appears in phpmyadmin and every update via the website works fine.
where is the row? lost in a cache?
does the setting “flush tables after each SQL command” or “flush time” help?
any help will be fine.