Read "Signal Handling and cancelling operations" in the DBI manual carefully.

I'm not aware of any mysql-specific issues or techniques - for one, it seems DBD::mysql does not implement a working cancel() method.