Add asynchronous functions to mysql
===

I want to be able to update my search index in real time. This would be easiest done with triggers in MySQL. Adding code to the application, to update in each place the DB gets updated is very painful. The problem with triggers is that they slow down all updates/inserts/deletions to the DB. 

Is there any way in which I can call a function that will run the update on the index (or just call a php script and that will then handle the updates) but do this asynchronously. It should not hold up the trigger from completing. 

I am using MySQL for the DB and [sphinx][1] for the search server 


  [1]: http://sphinxsearch.com/