I faced some real issues regarding the execution of some stored procedures using Mysql server. Sometimes, one of my procedures is not executed (or maybe stopped) during an external call (from app) so I'm wondering :
- Is it possible that Mysql could stop automatically the and kill the process?
- if is it true, what are the indicators and factors that make Mysql chose its victim?
- Is there an alternative to set up a list of priority of running queries?