Contents:
debug.txt - contains debugging information; opened in overwrite mode ('>') per request
debug.log - contains debugging information; opened in append mode ('>>'); rotated using log_rotate.pl (count => 3)
sql.txt - contains SELECT query statements from application in production mode; opened in append mode; rotated using log_rotate.pl (count => 3)
dev_sql.txt - contains SELECT query statements from application in development mode; rotated using log_rotate.pl (count => 3)
{yyyy_MMdd}_sql.log - contains UPDATE/INSERT/DELETE statements from application in production mode; archived in /old daily using log_rotate.pl
dev_sql.log - contains UPDATE/INSERT/DELETE statements from application in development mode; rotated using log_rotate.pl (count => 3)