#The following loop will print the status included current timestamps of any mysqldump queries being ran on the server. while true; do mysql -NBe ' SELECT NOW(),ID,USER,HOST,DB,COMMAND,TIME,STATE,INFO,TIME_MS,STAGE,MAX_STAGE,PROGRESS,MEMORY_USED,MAX_MEMORY_USED,EXAMINED_ROWS,QUERY_ID,INFO_BINARY,TID FROM information_schema.processlist WHERE info LIKE "SELECT /*!% SQL_NO_CACHE */%"; '; done