0

I have a database in MySQL8. I am running MySQL8 server as a docker container. I have a table 'A' in the database to which I added some data earlier. Recently, I deleted all data in table 'A' and added new data. Over the past few days, I noticed that when I query data from 'A', I get previous data and not the latest data. But after a few times the select query is run, I get the new data. I am not sure what is happening here. Is it possible that MySQL is maintaining some kind of cache or versions of the table internally? How do I make sure that the old data is 'actually' deleted from the server?

  • Recently, I deleted all data in table 'A' and added new data. How do you do this? precisely, including code, please. I am not sure what is happening here. Is it possible that MySQL is maintaining some kind of cache or versions of the table internally? No. This may be an effect of 1) explicit COMMIT absence 2) intermediate third-party software caching. – Akina Jun 26 at 4:55
  • Or the docker image is somehow being initialized. Do you have other tables that would indicate this or refute it? – Rick James Jun 26 at 5:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.