Store & Forward Buffer cannot be emptied

Highly recommended. And peruse the MySQL docs for tuning. As for Ignition, you need to edit ignition.conf to use an appropriate amount of memory, and I also suggest using G1GC. See this thread.