MySQL stored procedure activation on import

Question

Is there a way of having a mysql stored procedure automatically execute following a mysql workbench data import, e.g. after an import of a recordset from a csv file?

The aim is to update a separate table that tracks activity.

Answer 1

Triggers, that's what you are looking for. But be warned that mysql triggers operate at row level and it will fire the trigger once for each row. Which means bulk imports will be very very slow.

Answer 2

Why don't you schedule your stored procedure with MySQL event scheduler which will run your stored proc in every 5 minutes of interval to track the activity.

First thing I want to confirm that scheduled events only works with MySQL version 5.6 .

Here is the links which may help you in scheduling procs:

http://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/

How to schedule a stored procedure in MySQL