mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
13 lines
503 B
Text
13 lines
503 B
Text
#
|
|
# Dirty reads from INFORMATION_SCHEMA tables.
|
|
#
|
|
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
--disable_info
|
|
USE information_schema;
|
|
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";
|
|
SET GLOBAL wsrep_reject_queries=ALL;
|
|
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";
|
|
SET GLOBAL wsrep_reject_queries=NONE;
|
|
SET SESSION wsrep_dirty_reads=TRUE;
|
|
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";
|