Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 1 of 1 « Previous | Next »
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]