Database corrupting with large volume firewall logs?

Hi,

I currently import large volumes of firewall logs into the Firewall Analyzer via the "remote files" option. We currently have several firewalls' worth of logs in the analyzer. The size of the database is currently at about 190GB.

My concern is that every now and then, when I import log files, and for whatever reason it corrupts the database because there is too much data to import in one batch, is that I suspect that the data for the other firewalls gets corrupted.

I say this because if I look at my "Live Reports" for each firewall, it doesn't show any data for the daily/weekly/monthly graph and only shows data for the yearly graph.

I don't know how you organize your data on the Firewall Analyzer, but to me it would make sense if you were to create separate databases within the MySQL server for each firewall? That way, if a database gets corrupted, it won't affect the other firewall's imported data?

Regards,
Nolan