Store & Forward statu shows that the Local cache is bigger than the Memory Buffer Size, but zero quarantined. This results in a large amount of data not being stored in the database in time. What caused this? The exception occurred after the server was restarted. We can’t find the reason.
Looking forward to your reply!
I need help, please~
This results in a large amount of data not being stored in the database in time.The amount of data prompted to be discarded. The Memory Buffer is used up, and the local cache is out of limit, but “no item to display”.
How to restore storage? Reply Online.
Production system? Call support. This forum is not support. That said, your database is likely the problem–not powerful enough to keep up, or has run out of space, or crashed. The count of items dropped suggests the DB is just underpowered.
You could try increasing the cache size
The maximum number of records that can be cached.
I used ignition platform in the industrial energy management system. The DB version is MySQL 5.7.21 community. We created 10 databases in the DB. Only this database has storage problems.There are more than 40,000 data storage points in this problem database, most of which are minute level storage granularity. Do I need distributed storage in different DB？