High system load

[GFisher]

Hi,

I have a meteobridge pro receiving from a Davis pro2 that only logs data to a mysql db. It frequently (and now permanently) has a system load over 100%. As a result, it seems to 'miss' rainfall and other data. RF reception is -61 (though don't know if this is good or bad!)

I have tried a daily reboot, but that doesn't seem to help for long.

What should I do? Am happy to move the db to a usb, do full rebuild on reboot or even factory reset (if someone can tell me how )

Questions, suggestions and solutions very much appreciated!

Graham

[admin]

RF -61db is very good. Please set threshold to -80db or so.
Internal SLC USB is best to go for, external will not improve anything.

Does system load decrease when you stop feeding your mysql?

Did you consider the send HTTP requests to your database server and to initiate the database inserts from that on the database server itself?

[GFisher]

Thanks for the reply!

Once the systemload has peaked it sometimes doesn't recover until a reboot.

I log into mysql each minute most of the available variables, including CPU load. I've (this week) switched off logging to all other external weather nets (was using cwop and met office) to try and ease memory use (it sits between 70% and 90%). It also reboots each day, picking up the latest software.

From (now) looking at the logs, it seem the trigger point is just after midnight when there is a spike in CPU load that is sometimes it doesn't recover from.

This week, it occured 5th -> 6th and 6 -> 7th, though during the day on the 7th it also picked up a new update (build 13422) and it was fine 7th into 8th (today).

If it re-occurs then I'll look into sending the data over http - thanks for the suggestion!