I am currently using MySQLAdapter as my primary historian and found that in the system console it displays "
[PPA_Name] there are xxxxxx unprocessed measurements in the output queue" and eventually shows "[PPA_Name] system exercised evasive action to converse memory and
dumped 500000 unprocessed measurements from the output queue :( " I believe it may have something to do with the server optimization. My server spec is Xeon dual core 3ghz with 4gb ram and presently only 3 PMUs are reporting to the PDC.
I am pretty new to MySQL and wonder if anyone can advise how to optimize the server in the configuration so that it will not lose any data being archived.
Also in the forum I found a lot of people are using AdoAdapter to archvie data to MySQL server, is it a more effective way to use MySQL server as historian? Please advise?
Any suggestion/comment would be greatly appreciated!