Seriously, this one weird trick reduced insert time by a tonne. I really have to benchmark this at some point as it's a lifesaver.
Explain/ Execution Plans
Speaking of poor performing queries...
Running MySQL in the background
With a 6Gig database there's a lot of things I need to kick off in the background for long run while the GoCode does other things. Building function+logic into a Procedure sounds sensible, and then when Go's prepped some databases calling a once-off-background procedure run makes sense.
1CREATE EVENT run_info_now 2ON SCHEDULE AT CURRENT_TIMESTAMP 3DO CALL simbakda_sensus.info;
Good MySQL cursor refresher.
... and how to disable them. Short version, you can't. Long version, make a variable and do it yourself.