Does MySQL invalidate or amend a cached table when rows are added, updated or deleted?

0 votes

1 answer

34 views

                          What does MySQL (InnoDB) do when it has cached an entire table into memory and one or more rows in that table changes?

Does MySQL in this instance amend the cache in memory, or would it consider the cache dirty, dump the cached table data, and then re-cache the table the next time it is queried?

Asked by TheLegendaryCopyCoder (105 rep)

Apr 25, 2024, 08:17 AM
Last activity: Apr 25, 2024, 03:02 PM

Does MySQL invalidate or amend a cached table when rows are added, updated or deleted?

Related Questions