send signal from mysql server through mysql connection to client
Posted by: Adrian Balint
Date: March 18, 2011 08:11AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
send signal from mysql server through mysql connection to client
3491
March 18, 2011 08:11AM


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.