# Tag History module has interrupted data storage **URL:** \ **Category:** Ignition\ **Created:** [March 27, 2020, 3:08am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471 "2020-03-27T03:08:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![1264034959](https://avatars.discourse-cdn.com/v4/letter/1/bcef8e/32.png) [@1264034959](https://forum.inductiveautomation.com/u/1264034959)\ **Post date:** [March 27, 2020, 3:08am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/1 "2020-03-27T03:08:08Z")
Hi, My project ran well for servral months. Nowdays Tag History module has interrupted data storage. I found that CPU utilization of database server reaches 40%. Now I restart the database server. It dropped below 10%。Besides, Partition Units changed from 1 month to 1 week. Max Active connections in the database has been expanded. And database server property follows:Processor Interl(R) Xeon(R) silver 4114 CPU @ 2.2GHz 2.19GHz /4 core /16GB RAM. ![1%20database%20connection%20error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c48c278990bd24300dd96e476fe136906a995594.png) ![2%20database%20connection%20error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/32339671f7f96953818d1a4b7c50ec332a3c1f62.png) ![3%20database%20connection%20error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/767ed53e3f2d128ad5f502fa1e2ef6b210896506.png) ![4%20database%20connection%20error](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d28673a452cdd794db179fe6ee012b02f3d9d139.png) ![server%20configuration](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/707b766a0a213d3a1298d0b95b4a03b9cc9ceeee.png) The total Tag Provider number is nearly 200,000. Different Historical Provider uses different store metricx. Someone store metricxs average time is 38.6 per second. Aggregate Throughput is bettween 17.8 and about 100 per second. At present, the problem of database has been temporarily solved. I would like to know whether there is a better solution for my case or not. Do I need to buy another tag history module for store data? Looking forward your reply! Respectly ---
**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Post date:** [March 27, 2020, 3:20am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/2 "2020-03-27T03:20:14Z")
What is your inndb buffer pool size? ---
**Author:** ![1264034959](https://avatars.discourse-cdn.com/v4/letter/1/bcef8e/32.png) [@1264034959](https://forum.inductiveautomation.com/u/1264034959)\ **Post date:** [March 27, 2020, 4:27am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/3 "2020-03-27T04:27:58Z")
Memory buffer size is 250,000. ---
**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Post date:** [March 27, 2020, 2:50pm UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/4 "2020-03-27T14:50:06Z")
Run this: `show variables like 'innodb_buffer_pool_size';` ---
**Author:** ![1264034959](https://avatars.discourse-cdn.com/v4/letter/1/bcef8e/32.png) [@1264034959](https://forum.inductiveautomation.com/u/1264034959)\ **Post date:** [March 27, 2020, 3:29pm UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/5 "2020-03-27T15:29:36Z")
![innodb_buffer_pool_size](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/41e1cbc1358a929d3e13b5b0f9014091f1aeb025.png) the innodb\_buffer\_pool\_size of mysql is 8388608. ---
**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\ **Post date:** [March 27, 2020, 3:31pm UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/6 "2020-03-27T15:31:48Z")
You need to increase that. That is the default value. ---
**Author:** ![1264034959](https://avatars.discourse-cdn.com/v4/letter/1/bcef8e/32.png) [@1264034959](https://forum.inductiveautomation.com/u/1264034959)\ **Post date:** [March 30, 2020, 1:45am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/7 "2020-03-30T01:45:30Z")
May I ask that which size is suitable for my case? ---
**Author:** ![1264034959](https://avatars.discourse-cdn.com/v4/letter/1/bcef8e/32.png) [@1264034959](https://forum.inductiveautomation.com/u/1264034959)\ **Post date:** [March 30, 2020, 10:16am UTC](https://forum.inductiveautomation.com/t/tag-history-module-has-interrupted-data-storage/33471/8 "2020-03-30T10:16:21Z")
I’ve optimized and expanded the innodb\_buffer\_pool\_size to 128MB. Then how to see it works well? ![mysql%20parameter](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/28c3cac5b5ff60d3cf3aa484e1744e844e603ea5.png)