I know I can use "show processlist" to see what is running when I'm in the office. How can I see what is running when I'm not there.
Something is running on my server at 3am every morning that is generating a IO Rate Alert and a CPU Usage Alert, but I don't know what it is. Is there a logging system that I should be using or a script I can write that will report what is currently running against the database at that time.
The alerts come in within the same rough time-frame every night, about 0300 - 0330.
I'm not even sure if this is a DBA question or more a Sys Admin question?
I appreciate any help.