mariadb/mysql-test/suite/plugins/t/server_audit_buffering.test
Sergei Golubchik 27ce95f3a4 MDEV-34680 post-fixes
* clarify the help text for --server-audit-file-rotate-size
* initialize cn->sync_statement, otherwise new connection randomly syncs
* and DON'T SPAM syslog
2025-07-31 16:59:53 +02:00

101 lines
1.9 KiB
Text

--source include/not_embedded.inc
if (!$SERVER_AUDIT_SO) {
skip No SERVER_AUDIT plugin;
}
--disable_ps2_protocol
# An unfortunate wait for check-testcase.inc to complete disconnect.
let count_sessions= 1;
source include/wait_until_count_sessions.inc;
let $MYSQLD_DATADIR= `SELECT @@datadir`;
let SEARCH_FILE= $MYSQLD_DATADIR/server_audit.log;
install plugin server_audit soname 'server_audit';
set global server_audit_file_buffer_size=8192;
show variables like 'server_audit%';
set global server_audit_logging=on;
let $counter=50;
--disable_query_log
--disable_result_log
while ($counter)
{
eval select $counter;
dec $counter;
}
--enable_result_log
--enable_query_log
--source include/print_file_line_count.inc
set global server_audit_sync_log_file=on;
--source include/print_file_line_count.inc
set global server_audit_file_buffer_size= 16384;
let $counter=50;
--disable_query_log
--disable_result_log
while ($counter)
{
eval select $counter;
dec $counter;
}
--enable_result_log
--enable_query_log
--source include/print_file_line_count.inc
set global server_audit_sync_log_file=on;
--source include/print_file_line_count.inc
let $counter=1000;
--disable_query_log
--disable_result_log
while ($counter)
{
eval select $counter;
dec $counter;
}
--enable_result_log
--enable_query_log
set global server_audit_sync_log_file=on;
--source include/print_file_line_count.inc
set global server_audit_file_buffer_size=0;
let $counter=100;
--disable_query_log
--disable_result_log
while ($counter)
{
eval select $counter;
dec $counter;
}
--enable_result_log
--enable_query_log
--source include/print_file_line_count.inc
set global server_audit_sync_log_file=on;
--source include/print_file_line_count.inc
SET GLOBAL server_audit_file_buffer_size=0;
set global server_audit_logging=off;
uninstall plugin server_audit;
remove_file $MYSQLD_DATADIR/server_audit.log;
--enable_ps2_protocol