Bug #13694 Support for asynchronous queries
Submitted: 3 Oct 2005 2:03 Modified: 30 Jun 2009 17:13
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.13 OS:Any
Assigned to: CPU Architecture:Any

[3 Oct 2005 2:03] [ name withheld ]
Description:
It would be very interesting to provide support for issuing non-blocking queries in the C/PHP API. I know nothing about the underlying C implementation but I would really like to be able to send a query to the MySQL server without blocking the execution of the program. By periodically checking the status of the connection I would know if the query completed and if a result set is available. As per PHP Manual, this feature exists in the PostgreSQL API, if I wasn't clear enough here is a direct link to it: http://www.php.net/manual/en/function.pg-send-query.php

How to repeat:
[13 Sep 2006 19:46] Peter Gulutzan
The new events feature in MySQL 5.1 allows creation of some statements which will run in the background, once or many times.
[4 Nov 2008 17:42] Roger Pack
somewhat possible -- see http://forums.mysql.com/read.php?45,183339,183339
[30 Jun 2009 17:13] Valeriy Kravchuk
Events in MySQL 5.1 (see http://dev.mysql.com/doc/refman/5.1/en/events-overview.html) allows to implement this functionality.