I need to set up some logging on my debian squeeze x64 mysql 5.1 Server:
1) logging when users logged in and logged off 2) logging only specific users commands
set up logging which will not slow down performance of mysql server or harddrives.
Is it possible to set logging only last month?
Is it possible to set up logging only in specific hours in a day?
I don't want gigabytes of useless logs, just logs of specific users in one file.