MySQL Forums
Forum List  »  Connector/Python

Monitor a Query then retrieve data using process ID
Posted by: Paul Benson
Date: June 22, 2016 02:33PM

Is there a way to monitor a query to see when it is complete and then retrieve data using the process ID. I have an application that is executing some pretty large queries. What I would like to do is run query, retrieve ID, and monitor the query. When the query is complete I can then use the process ID to request the response back from mySQL. I would like to do this because some queries cause the application to time out as there is no response for several minutes. If I could monitor the query, I could bounce back and forth so the front end does not time out. Thanks

Options: ReplyQuote

Written By
Monitor a Query then retrieve data using process ID
June 22, 2016 02:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.