MySQL – Tail -f Equivalent for MySQL Logging Database

loggingMySQL

It was decided that we should move to using a (MySQL) database for our application logs (it is a Java app using the logback lib). I am hoping to find something like tail -f that I can use with a specific table in that database that will show me new rows as they are added (similar to how tail -f worked on log files).

Best Answer

Turn on MySQL binary logging. Then you can use the mysqlbinlog command to see all data-modifying statements.

Related Solutions

Mysql – Tomcat does not recognize the MySQL .jar library

Tomcat does not use the CLASSPATH in the webapp's classloader. You can add paths and files to the common.loader line in conf/catalina.properties. The classloader should have found the class when the jar was in WEB-INF/lib. I can't explain why it hasn't. If you are using 5.5, you can place the jar in common/lib or lib/ if you're using tomcat6. This path is loaded by a higher level classloader and should be picked up first.

What’s the best strategy for log rotation with apache+passenger+ruby-on-rails+thesql

Instead of 'copytruncate', these lines worked for me in the logrotate file for my rails app:

  postrotate
    touch /your-rails-directory/tmp/restart.txt
  endscript

Best Answer

Related Solutions

Mysql – Tomcat does not recognize the MySQL .jar library

What’s the best strategy for log rotation with apache+passenger+ruby-on-rails+thesql

Related Topic