mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +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.
85 lines
2.4 KiB
Text
85 lines
2.4 KiB
Text
call mtr.add_suppression("192.0.2.4");
|
|
flush global status;
|
|
flush hosts;
|
|
flush user_resources;
|
|
flush privileges;
|
|
select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like '192.%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like '2001:%';
|
|
User Host
|
|
select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
|
|
User Host
|
|
connect con1,"127.0.0.1",root,,test,$MASTER_MYPORT,;
|
|
select "Con1 is alive";
|
|
Con1 is alive
|
|
Con1 is alive
|
|
select current_user();
|
|
current_user()
|
|
root@localhost
|
|
disconnect con1;
|
|
connection default;
|
|
SET @saved_dbug = @@GLOBAL.debug_dbug;
|
|
set global debug_dbug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_format_ipv4";
|
|
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MariaDB server
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 192.0.2.4
|
|
HOST NULL
|
|
HOST_VALIDATED NO
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 1
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 1
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 0
|
|
COUNT_AUTH_PLUGIN_ERRORS 0
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 0
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
ERROR HY000: Host '192.0.2.4' is not allowed to connect to this MariaDB server
|
|
connection default;
|
|
# Dumping performance_schema.host_cache
|
|
IP 192.0.2.4
|
|
HOST NULL
|
|
HOST_VALIDATED NO
|
|
SUM_CONNECT_ERRORS 0
|
|
COUNT_HOST_BLOCKED_ERRORS 0
|
|
COUNT_NAMEINFO_TRANSIENT_ERRORS 0
|
|
COUNT_NAMEINFO_PERMANENT_ERRORS 0
|
|
COUNT_FORMAT_ERRORS 2
|
|
COUNT_ADDRINFO_TRANSIENT_ERRORS 0
|
|
COUNT_ADDRINFO_PERMANENT_ERRORS 0
|
|
COUNT_FCRDNS_ERRORS 0
|
|
COUNT_HOST_ACL_ERRORS 2
|
|
COUNT_NO_AUTH_PLUGIN_ERRORS 0
|
|
COUNT_AUTH_PLUGIN_ERRORS 0
|
|
COUNT_HANDSHAKE_ERRORS 0
|
|
COUNT_PROXY_USER_ERRORS 0
|
|
COUNT_PROXY_USER_ACL_ERRORS 0
|
|
COUNT_AUTHENTICATION_ERRORS 0
|
|
COUNT_SSL_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_ERRORS 0
|
|
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
|
|
COUNT_DEFAULT_DATABASE_ERRORS 0
|
|
COUNT_INIT_CONNECT_ERRORS 0
|
|
COUNT_LOCAL_ERRORS 0
|
|
COUNT_UNKNOWN_ERRORS 0
|
|
FIRST_ERROR_SEEN set
|
|
LAST_ERROR_SEEN set
|
|
SET @@GLOBAL.debug_dbug = @saved_dbug;
|