samedi 28 février 2015

MYSQL Thread Historical Data


We had to force a restart on our database server today and we're now trying to find out what the server was doing at the time of the shutdown. In our error logs we have found 5 instances where the query that was executing had to be forced out.



[Warning] /usr/sbin/mysqld: Forcing close of thread ####### user: 'username'


Is there a place that the thread number is stored with the action is what executing? Searching around I've only been able to find results where the process is still running. Also is this message indicative of an issue or potentially a query could have just been executed when I executed the shutdown?





Aucun commentaire:

Enregistrer un commentaire