Bug #19597 listen, unlisten, notify
Submitted: 7 May 2006 21:42 Modified: 14 Jun 2013 19:12
Reporter: ladimir Kolpakov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: Assigned Account CPU Architecture:Any

[7 May 2006 21:42] ladimir Kolpakov 
Description:
PostgreSQL's event-driven interface to UNIX client process
is the feature absolutely necessary for distributed transaction processing.
Distributed transaction is not a single DBMS-controlled matter,
but rather network-distributed set of asynchronous processess
interacting via messaging. DB servers are functioning there
just as I/O device sending packet to unix process waiting on I/O.

I've discussed this feature several times with MySQL developers,
and even submit feature request on bugs.mysql once,
however it disappeared somehow from there.

All mysql.com team need to implement to show it's maturity is
LISTEN, UNLISTEN and NOTIFY functions.
If you don't have unix man pages about these clauses
on your linux box, please, install PostgreSQL documentation .rpm
to read it.

How to repeat:
see above

Suggested fix:
see above
[7 May 2006 21:45] ladimir Kolpakov 
Typo: "again oracle" must read as "against oracle".
[11 Jul 2007 17:25] Frank Illenberger 
I also want to emphasize the importance of LISTEN, UNLISTEN, NOTIFY for application development. Polling is not always a feasible alternative. Please consider implementing these features in the client API.