Drupal and watching MySQL logs
Posted by gregster on 17 Sep 2009 in Servers, Activity log
Drupal's fantastically complete logging caused me to check on it once again in order to respond to an associated request. I did this:
tail -f /m1/mysql/logs/mysql.log
to watch stuff go by (you can pipe out to grep <db_name> to limit the spew that comes out).
Just for the sake of interest, loading a Drupal page generates ~5MB of log, and 2 minutes on the site generates a total of ~17MB - including the initial 5MB load. So, after loading the page, the CMS seems to create approximately 6MB of logs/minute.