I have partitioned a table on the basis of a column. This column can either have 0 or 1. So, only two partitions (p0, p1) have been created internally. On this table there are 3 triggers which execute on insert, delete and update event.
Insert trigger - inserting a new record including ID of inserted row in another table.
Update trigger - Manipulate 2 other tables.
Delete trigger - Delete entries from associated tables.
Now, my concerns are below:
- Do these triggers affect the performance negatively or have no effect?
- In case of negative affect, what alternate approach I should take?
- How does MySQL manage these 3 triggers on partitioned tables internally?
- What measure changes happened in the trigger execution before and after table partition?