mysql cache issue-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

mysql cache issue

巴扎黑 2017-05-24 11:34:40

681

1. The database mysql, the persistence layer uses mybatis
2. Now I have configured two data sources A and B, but there are two data sources, but in fact the two data sources are configured with the same database
3. Now I write a record through data source A, but it cannot be queried through data source B. I have to wait for a long time before it can be queried.
I guess it may be a cache problem. The query_cache of msyql has also been removed, and it still remains. It doesn't work. What else may cause this problem? Can anyone give me some solutions?

巴扎黑

reply all (1)

曾经蜡笔没有小新2017-05-24 11:36:40 1 floor

First confirm whether mysql has this data after writing. Because of this architecture, it is not only a problem of mysql cache, but also cache in the mybatis layer.