send signal from mysql server through mysql connection to client
Given the following problem:
There is a mysql table with jobs description in it.
There are a lot of clients that take jobs from this table and procces them and return the results to the DB as soon as the proccessing has finsished.
I would like to be able to delete jobs from the table an to notify the clients through their connection that the job was deleted.
If jobs are deleted from the table the clients can not be aware of that. They could, if they would querie the table lets say every 5 sec. to see if the job that they are proccessing is still valid. But I think this is not a good idea. Having lets say 1000 clients doing every 5sec a querie only to see if they still have to work is producing a lot of overhead on the server.
Ideally the Mysql server would send a signal through the open connection and the client would catch it.
Is there a way to send signal to the clients?
How could I catch this signals in C?
Subject
Views
Written By
Posted
send signal from mysql server through mysql connection to client
3576
March 18, 2011 08:11AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.