I think the trigger activates before any row is inserted, based on the "BEFORE INSERT" clause in the trigger definition. The trigger body also seems to be updating a variable called @subtotal, so that's a good clue.
I'm feeling pretty confident about this one. The key settings that control global buffers are `key_buffer_size`, `innodb_buffer_pool_size`, and `tmp_table_size`. I'll select those three.
Okay, I think I've got this. The key is to minimize latency for all customers globally, so a Multi-Regional Cloud Storage bucket is probably the way to go.
upvoted 0 times
...
Log in to Pass4Success
Sign in:
Report Comment
Is the comment made by USERNAME spam or abusive?
Commenting
In order to participate in the comments you need to be logged-in.
You can sign-up or
login
Amie
4 months agoRozella
4 months agoAshleigh
4 months agoLuz
4 months agoFrancesco
5 months agoGeorgene
5 months agoAleta
5 months agoMelda
5 months ago