# delayed insert/update queries

**URL:** <https://forums.percona.com/t/delayed-insert-update-queries/933>\
**Category:** Other MySQL® Questions\
**Created:** [September 19, 2008, 2:51am UTC](https://forums.percona.com/t/delayed-insert-update-queries/933 "2008-09-19T02:51:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Timeout](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/timeout/32/791_2.png) [@Timeout](https://forums.percona.com/u/Timeout)\
**Post date:** [September 19, 2008, 2:51am UTC](https://forums.percona.com/t/delayed-insert-update-queries/933/1 "2008-09-19T02:51:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [September 19, 2008, 3:15am UTC](https://forums.percona.com/t/delayed-insert-update-queries/933/2 "2008-09-19T03:15:24Z")

</div>

Can’t it be some cache on webserver side or maybe phpmyadmin cached in browser? Can you see this new row using console MySQL client?

---

<div class="post-metadata">

**Author:** ![Timeout](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/timeout/32/791_2.png) [@Timeout](https://forums.percona.com/u/Timeout)\
**Post date:** [September 19, 2008, 7:10am UTC](https://forums.percona.com/t/delayed-insert-update-queries/933/3 "2008-09-19T07:10:03Z")

</div>

| [B]debug wrote on Fri, 19 September 2008 04:45[/B] |
| Can't it be some cache on webserver side or maybe phpmyadmin cached in browser? Can you see this new row using console MySQL client? |

no it can´t as i try to update the inserted row with the same webpage and it says that the row is not existent.

in detail  
it is a picture gallery. i add a picture using the website. the picture is displayed. then i open a page to update the data (like category, etc.) and the main data like pictureID and anything else is shown properly (which means that the select statement works and the row of the picture exists) but then i send up the form which sets an update-statement on this picture and i got an error, that the key (pictureID) does not exist. i look inside phpmyadmin and the row of the picture does not exist.

after i “flush tables” the row appears in phpmyadmin and the update of the picture works fine.

strange behaviour isn´t it.