Problemas de escritura continua en Earthworm 7.10 con Winston 1.6.2 y MySQL 8

[Moises Contreras]

Hello everyone,

I am implementing Earthworm 7.10 along with Winston 1.6.2 on the same system and machine (although we have sometimes used different machines), both on Windows and CentOS. I am facing writing issues when receiving 370 traces, with between 100 and 200 samples per second. The data is written continuously to MySQL 8 with InnoDB. After a couple of weeks, the hard drive where the data is written becomes slower, resulting in continuous trace losses, and on one occasion, a solid-state drive was physically damaged.

My questions are:

1. Is there any way to modify the buffer to write all signals without losses?
2. Is there any limit in Winston for continuous data writing?
3. What is the optimal MySQL configuration to continuously write up to 800 traces?

Thank you in advance for any advice or experiences you can share