PHP Stopping Insert in Table

0

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

    
asked by anonymous 11.04.2016 / 19:48

0 answers