MySQL Learnings

Batching inserts

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.

CREATE EVENT run_info_now
ON SCHEDULE AT CURRENT_TIMESTAMP
DO CALL simbakda_sensus.info;

Cursors

Good MySQL cursor refresher.

Triggers

... and how to disable them. Short version, you can't. Long version, make a variable and do it yourself.