# MySQL High Disk Usage

**URL:** <https://forum.inductiveautomation.com/t/mysql-high-disk-usage/17905>\
**Category:** Ignition\
**Created:** [May 2, 2018, 7:02pm UTC](https://forum.inductiveautomation.com/t/mysql-high-disk-usage/17905 "2018-05-02T19:02:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shaunstewart](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@shaunstewart](https://forum.inductiveautomation.com/u/shaunstewart)\
**Post date:** [May 2, 2018, 7:02pm UTC](https://forum.inductiveautomation.com/t/mysql-high-disk-usage/17905/1 "2018-05-02T19:02:36Z")

</div>

Setup:  
Running Redundant Gateways and running my historian on the Backup Gateway  
Windows 10 Pro  
Intel(R) Xeon(R) CPU E3-1240 v6 @ 3.70GHz  
32GB Ram  
Have 2 Hard Drives:  
Samsung MZVKW512HMJP-000L7  
ST1000DM003-1SB102 -Use this one for my data

Java Version -1.8.0\_161-b12  
Ignition: 7.9.5

The problem im having is using mysql for my historian. Whenever Ignition pushes the data to mysql every 10 seconds it almost pegs out my disk usage. (Shown in picture below). The issue is that a few times its hit 100% disk usage and drops the connection to mysql and never establishes itself even tho my instance of mysql says everything is good. So i end up having to make a new schema for it to start logging again. I dont know why the disk usage is so high using mysql. Dont know if its a hardware issue or the configuration of mysql is wrong. Any help would be greatly appreciated.

P.S. : I have two systems setup the same way(hardware/software) and they are both doing the same thing.

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a0bd089d10f106310f99b387f3495126d12fc8b1.png)