Showing entries 1 to 1
Displaying posts with tag: LearningQuery Optimizationinternalsoptimizationtriggers (reset)
One TRIGGER Fact, Optimizer Rewriting Stuff

internals, optimization triggers One thing about TRIGGERs is that you can have 6 triggers per table:

BEFORE
AFTER
    INSERT
UPDATE
DELETE

That was brought up at the User Group meeting.

In other news, I have been reading the MySQL Internals Manual. The most interesting chapter yet is Chapter 3, the optimizer. This can be read out of order, and actually contains lots of information …

[Read more]
Showing entries 1 to 1