Here are the ones I tried. Hope the comments aren’t too confusing

1. Simple Rails Log Query Analyzer
   • Ran ruby bin/query_log_analyzer.rb ../log/production.log
     • production.log.1 (small log file ~25MB) Just printed the “Totals” heading with no results
     • production.log (large log file ~400MB) Ran for a long time and nothing happened

Read the rest of this entry »

Tags: log analyzers, logger, logs, production.log, query, rails, railscast.com, rawk.rb, ruby on rails

081004  2:35:11 [ERROR] Could not use /var/log/mysql-err.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.

The above error displayed in the mysqld.log file fter adding the below line to /etc/my.cnf under [mysqld].

log=/var/log/mysql.log

Before restarting mysql I created the file and applied the proper permissions by entering the commands below from the console.

Read the rest of this entry »