I am doing the production full database export with consistent=Y option 2:00 am everyday and It only takes about 15 minutes. the size of file is after gzipping only less than 15 M.
Our system administrator asked me to change backup time to 11:00 pm.
I wonder what kind of overhead is related to export process in the database level?
I prefer 2:00 am to 11:00pm, since less people is connected to the database.
Could anybody can answer this for me?