I have an application that works with facebook activity log, I have 150 pages under monitoring, and I do the daily insertion of these lines:
- Post
- Comment
- Reply
- Likes
- Shares
It has reached 500 thousand records in 2 hours at most, but here comes the problem, before I worked regulating the time on the bot, hence I took this limitation, the database receives up to a certain point and remains functional but not inserts, only after restarting vps it inserts a large amount of records even without the bot active.
I put events to clean the internal log (even if you do not request the same thing from api), and to clean the mysql logs (flush logs & binary purge) Use PHP 5.4 + mariadb
Thanks in advance for any input