Deleting migrate module tables post migration
So, I deleted the tables (actually truncated them) on my dev server and there have been no side effects that I have noticed, so will try deleting the tables in their entirely. The migrate tables made up around 600mb in a dump.