diff options
| author | unknown <andrey@lmy004.> | 2006-03-01 02:34:22 +0100 |
|---|---|---|
| committer | unknown <andrey@lmy004.> | 2006-03-01 02:34:22 +0100 |
| commit | d576ca18154392c64b53ff2ed2ab14be3a71d55c (patch) | |
| tree | 08e923bfbb7001fee0cc29eb19d1f0c315dc87a7 /sql/sp_head.h | |
| parent | 11c7dbd3a5956c3ea4b7262389f40f278796a1a3 (diff) | |
| download | mariadb-git-d576ca18154392c64b53ff2ed2ab14be3a71d55c.tar.gz | |
fix for bug #16426
Events: Event-caused statements don't appear in the slow query log
WL#1034
sql/event_executor.cc:
enable slow logging
sql/event_timed.cc:
enable slow logging for the anonymous SP
sql/sp_head.cc:
allow thd->enable_slow_log to be TRUE if only
m_flags & sp_head::LOG_SLOW_STATEMENTS
Because usually enable_slow_log is 1 in user mode, this second
check is needed backup the mode otherwise.
sql/sp_head.h:
add a new constant for slow queries. SP by default does not log slow queries in the
body just the whole CALL could be considered as slow if taking too much time and
called directly from the user
sql/sql_parse.cc:
let us see in the the trace log
Diffstat (limited to 'sql/sp_head.h')
| -rw-r--r-- | sql/sp_head.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/sp_head.h b/sql/sp_head.h index a637c466041..83228147430 100644 --- a/sql/sp_head.h +++ b/sql/sp_head.h @@ -124,7 +124,8 @@ public: IS_INVOKED= 32, // Is set if this sp_head is being used HAS_SET_AUTOCOMMIT_STMT= 64,// Is set if a procedure with 'set autocommit' /* Is set if a procedure with COMMIT (implicit or explicit) | ROLLBACK */ - HAS_COMMIT_OR_ROLLBACK= 128 + HAS_COMMIT_OR_ROLLBACK= 128, + LOG_SLOW_STATEMENTS= 256 }; /* TYPE_ENUM_FUNCTION, TYPE_ENUM_PROCEDURE or TYPE_ENUM_TRIGGER */ |