'Hibernate's default-update-timestamps-region.data causes 90% disk I/0
There was a huge disk I/O on our servers when we were doing some batch email processing (Spring Thread Pool Executor) by retrieving/updating data in DB. When I did a "sudo iotop" command I noticed this thread from hibernate (default-update-timestamps-region.data) was the root cause for it.
From hibernate's documentation I get to know the thread will update cache in the memory
default-update-timestamps-region Holding timestamps of the most recent updates to queryable tables. These are used to validate the results as they are served from the query cache.
My question is what does cache update has to do with disk I/O and how can I optimize on this part?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|