Bug #58596 Disable Trigger At Session Level Feature Request
Submitted: 30 Nov 2010 16:13 Modified: 30 Nov 2010 16:20
Reporter: Larry D. Wilson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[30 Nov 2010 16:13] Larry D. Wilson 
Description:
While there are some work-arounds to suppress execution of a trigger, it would be great if we could have a DISABLE TRIGGER SQL command. 

Ideally, this would disable a trigger only during the session where it's executed, so that if a DBA needed to perform a major change during production hours, it would not disable triggers for all other connections. 

Example for potential usage:

DELIMITER $$
DISABLE TRIGGER <triggername>;
$$
<mass update/import statement>;
$$
ENABLE TRIGGER <triggername>;
$$

How to repeat:
Feature request

Suggested fix:
Implement session-level DISABLE TRIGGER support.
[30 Nov 2010 16:20] MySQL Verification Team 
Thank you for the bug report.
[30 Nov 2010 18:52] Peter Gulutzan 
Looks like a duplicate of
Bug#14661 ALTER TRIGGER trigger_name DISABLE or ALTER TABLE table_name DISABLE TRIGGERS;