MySQL Learnings

Batching inserts

• How do I batch sql statements with package database/sql

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

• 8.8 Understanding the Query Execution Plan

Speaking of poor performing queries...

Running MySQL in the background

• Stored procedure execution in background?
• Stored procedures

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;

Cursors

• MySQL Cursor

Good MySQL cursor refresher.

Triggers

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

• How to disable triggers in MySQL?