mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
775cba4d0f
- FLUSH GLOBAL STATUS now resets most global_status_vars.
At this stage, this is mainly to be used for testing.
- FLUSH SESSION STATUS added as an alias for FLUSH STATUS.
- FLUSH STATUS does not require any privilege (before required RELOAD).
- FLUSH GLOBAL STATUS requires RELOAD privilege.
- All global status reset moved to FLUSH GLOBAL STATUS.
- Replication semisync status variables are now reset by
FLUSH GLOBAL STATUS.
- In test cases, the only changes are:
- Replace FLUSH STATUS with FLUSH GLOBAL STATUS
- Replace FLUSH STATUS with FLUSH STATUS; FLUSH GLOBAL STATUS.
This was only done in a few tests where the test was using SHOW STATUS
for both local and global variables.
- Uptime_since_flush_status is now always provided, independent if
ENABLED_PROFILING is enabled when compiling MariaDB.
- @@global.Uptime_since_flush_status is reset on FLUSH GLOBAL STATUS
and @@session.Uptime_since_flush_status is reset on FLUSH SESSION STATUS.
- When connected, @@session.Uptime_since_flush_status is set to 0.
57 lines
1.6 KiB
Text
57 lines
1.6 KiB
Text
mysqld is alive
|
|
mariadb-admin: unknown variable 'database=db1'
|
|
Warning: mariadb-admin: unknown variable 'loose-database=db2'
|
|
mysqld is alive
|
|
#
|
|
# Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
|
|
#
|
|
# Executing mysqladmin with --sleep=1 and --count=2.
|
|
# Done.
|
|
# Displaying the output :
|
|
mysqld is alive
|
|
mysqld is alive
|
|
#
|
|
# BUG#11766184 - 59234: cmdline clients crash --defaults-extra-file
|
|
# with no .cnf or .ini extension.
|
|
#
|
|
# Creating an empty file 'cnf_file'
|
|
# Using --defaults-extra-file option with 'cnf_file'.
|
|
mysqld is alive
|
|
#
|
|
# MDEV-33992 mariadb-admin flush-status command should do
|
|
# FLUSH GLOBAL STATUS
|
|
#
|
|
flush session status;
|
|
flush global status;
|
|
connect con1,localhost,root,;
|
|
connect con2,localhost,root,;
|
|
connect con3,localhost,root,;
|
|
disconnect con1;
|
|
disconnect con2;
|
|
disconnect con3;
|
|
connection default;
|
|
show status like 'Max_used_connections';
|
|
Variable_name Value
|
|
Max_used_connections 4
|
|
show global status like 'Max_used_connections';
|
|
Variable_name Value
|
|
Max_used_connections 4
|
|
#
|
|
# Running mariadb-admin flush-status
|
|
#
|
|
show status like 'Max_used_connections';
|
|
Variable_name Value
|
|
Max_used_connections 2
|
|
show global status like 'Max_used_connections';
|
|
Variable_name Value
|
|
Max_used_connections 2
|
|
# restart: --ssl-key=MYSQLTEST_VARDIR/tmp/ssl_key.pem --ssl-cert=MYSQLTEST_VARDIR/tmp/ssl_cert.pem
|
|
connect ssl_con,localhost,root,,,,,SSL;
|
|
SELECT VARIABLE_VALUE INTO @ssl_not_after FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_server_not_after';
|
|
# Use a different certificate ("Not after" certificate field changed)
|
|
# Check new certificate used by new connection
|
|
Result
|
|
OK
|
|
# Cleanup
|
|
# restart
|
|
# End of 11.5
|