phpmyadmin Question posted in
The official documentation can be found here.

Syslog-NG with mysql phpmyamdin not storing data real time? – Phpmyadmin

I have installed syslog-ng on an ubuntu 18.04.4lts. but it looks like mysql is missing some logs. when I run syslog-ng -d I can see logs are coming in real time. But in phpmyadmin they are at least 25-30min behind. Furthermore, it is happening everyday. I have also made the changes so that there is no limit of mysql to store data. Any idea what can be wrong?

Tags:

2

Answers


  1. 0

    Please adjust spelling, reading this in all caps sounds like you’re screaming.

    Login or Signup to reply.
  2. 0

    In phpMyAdmin, as long as you refresh the page, you’re seeing data as MySQL/MariaDB stores it; there’s no delay or caching on the MySQL <–> phpMyAdmin connection. Any delay you’re seeing as described here would have to be explained by syslog-ng; is there some sort of cache involved where it delays writing events to the database? That would make the most sense about why syslog-ng -d shows you the relevant logs but it takes some time to propagate to MySQL.

    Really, I don’t know much about using syslog-ng in this way, but based on your explanation of events, the answer has to lie there somewhere.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search