mirror of
https://github.com/MariaDB/server.git
synced 2026-01-24 04:14:49 +01:00
21518ab2e4
This fixes MDEV-7742 and MDEV-8305 (Allow user to specify if stored
procedures should be logged in the slow and general log)
New functionality:
- Added new variables log_slow_disable_statements and log_disable_statements
that can be used to disable logging of certain queries to slow and
general log. Currently supported options are 'admin', 'call', 'slave'
and 'sp'.
Defaults are as before. Only 'sp' (stored procedure statements) is
disabled for slow and general_log.
- Slow log to files now includes the following new information:
- When logging stored procedure statements the name of stored
procedure is logged.
- Number of created tmp_tables, tmp_disk_tables and the space used
by temporary tables.
- When logging 'call', the logged status now contains the sum of all
included statements. Before only 'time' was correct.
- Added filsort_priority_queue as an option for log_slow_filter (this
variable existed before, but was not exposed)
- Added support for BIT types in my_getopt()
Mapped some old variables to bitmaps (old variables can still be used)
- Variable 'log_queries_not_using_indexes' is mapped to
log_slow_filter='not_using_index'
- Variable 'log_slow_slave_statements' is mapped to
log_slow_disabled_statements='slave'
- Variable 'log_slow_admin_statements' is mapped to
log_slow_disabled_statements='admin'
- All the above variables are changed to session variables from global
variables
Other things:
- Simplified LOGGER::log_command. We don't need to check for super if
OPTION_LOG_OFF is set as this flag can only be set if one is a super
user.
- Removed some setting of enable_slow_log as it's guaranteed to be set by
mysql_parse()
- mysql_admin_table() now sets thd->enable_slow_log
- Added prepare_logs_for_admin_command() to reset thd->enable_slow_log if
needed.
- Added new functions to store, restore and add slow query status
- Added new functions to store and restore query start time
- Reorganized Sub_statement_state according to types
- Added code in dispatch_command() to ensure that
thd->reset_for_next_command() is always called for a query.
- Added thd->last_sql_command to simplify checking of what was the type
of the last command. Needed when logging to slow log as lex->sql_command
may have changed before slow logging is called.
- Moved QPLAN_TMP_... to where status for tmp tables are updated
- Added new THD variable, affected_rows, to be able to correctly log
number of affected rows to slow log.
79 lines
2.7 KiB
Text
79 lines
2.7 KiB
Text
select @@log_slow_filter;
|
|
@@log_slow_filter
|
|
admin,filesort,filesort_on_disk,filsort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
|
|
select @@log_slow_rate_limit;
|
|
@@log_slow_rate_limit
|
|
1
|
|
select @@log_slow_verbosity;
|
|
@@log_slow_verbosity
|
|
|
|
show variables like "log_slow%";
|
|
Variable_name Value
|
|
log_slow_admin_statements ON
|
|
log_slow_disabled_statements sp
|
|
log_slow_filter admin,filesort,filesort_on_disk,filsort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
|
|
log_slow_rate_limit 1
|
|
log_slow_slave_statements ON
|
|
log_slow_verbosity
|
|
set @org_slow_query_log= @@global.slow_query_log;
|
|
set @@log_slow_filter= "filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk,admin";
|
|
select @@log_slow_filter;
|
|
@@log_slow_filter
|
|
admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
|
|
set @@log_slow_filter="admin,admin";
|
|
select @@log_slow_filter;
|
|
@@log_slow_filter
|
|
admin
|
|
set @@log_slow_filter=7;
|
|
select @@log_slow_filter;
|
|
@@log_slow_filter
|
|
admin,filesort,filesort_on_disk
|
|
set @@log_slow_filter= "filesort,impossible,impossible2,admin";
|
|
ERROR 42000: Variable 'log_slow_filter' can't be set to the value of 'impossible'
|
|
set @@log_slow_filter= "filesort, admin";
|
|
ERROR 42000: Variable 'log_slow_filter' can't be set to the value of ' admin'
|
|
set @@log_slow_filter= 1<<31;
|
|
ERROR 42000: Variable 'log_slow_filter' can't be set to the value of '2147483648'
|
|
select @@log_slow_filter;
|
|
@@log_slow_filter
|
|
admin,filesort,filesort_on_disk
|
|
set @@log_slow_verbosity= "query_plan,innodb";
|
|
select @@log_slow_verbosity;
|
|
@@log_slow_verbosity
|
|
innodb,query_plan
|
|
set @@log_slow_verbosity=1;
|
|
select @@log_slow_verbosity;
|
|
@@log_slow_verbosity
|
|
innodb
|
|
show fields from mysql.slow_log;
|
|
Field Type Null Key Default Extra
|
|
start_time timestamp(6) NO current_timestamp(6) on update current_timestamp(6)
|
|
user_host mediumtext NO NULL
|
|
query_time time(6) NO NULL
|
|
lock_time time(6) NO NULL
|
|
rows_sent int(11) NO NULL
|
|
rows_examined int(11) NO NULL
|
|
db varchar(512) NO NULL
|
|
last_insert_id int(11) NO NULL
|
|
insert_id int(11) NO NULL
|
|
server_id int(10) unsigned NO NULL
|
|
sql_text mediumtext NO NULL
|
|
thread_id bigint(21) unsigned NO NULL
|
|
rows_affected int(11) NO NULL
|
|
flush slow logs;
|
|
set long_query_time=0.1;
|
|
set log_slow_filter='';
|
|
set global slow_query_log=1;
|
|
set global log_output='TABLE';
|
|
select sleep(0.5);
|
|
sleep(0.5)
|
|
0
|
|
select count(*) FROM mysql.slow_log;
|
|
count(*)
|
|
1
|
|
set @@long_query_time=default;
|
|
set global slow_query_log= @org_slow_query_log;
|
|
set @@log_slow_filter=default;
|
|
set @@log_slow_verbosity=default;
|
|
set global log_output= default;
|
|
truncate mysql.slow_log;
|