mariadb/mysql-test/suite/plugins/t/server_audit_buffering.test
Sergei Golubchik 1563988ae6 MDEV-37160 When >=2 clients are in use, the server_audit_file_buffer_size setting is not honored
initialize cn->sync_statement everywhere where cn->thread_id is

followup for ef3c843c17 and 7251cbca51
2025-08-02 15:24:34 +02:00

105 lines
2 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
set global server_audit_sync_log_file=on;
let SEARCH_COUNT=52;
--source include/wait_for_line_count_in_file.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
let SEARCH_COUNT=52;
--source include/wait_for_line_count_in_file.inc
set global server_audit_sync_log_file=on;
let SEARCH_COUNT=104;
--source include/wait_for_line_count_in_file.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;
let SEARCH_COUNT=1105;
--source include/wait_for_line_count_in_file.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
let SEARCH_COUNT=1206;
--source include/wait_for_line_count_in_file.inc
set global server_audit_sync_log_file=on;
let SEARCH_COUNT=1207;
--source include/wait_for_line_count_in_file.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