mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
6bd24deab4
XID cache is now based on lock-free hash. Also fixed lf_hash_destroy() to call alloc destructor. Note that previous implementation had race condition when thread was accessing XA owned by different thread. This new implementation doesn't fix it either.
63 lines
1.9 KiB
Text
63 lines
1.9 KiB
Text
#
|
|
# Verify that the configuration file defaults were processed correctly
|
|
#
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name IN (
|
|
'wait/synch/mutex/sql/LOCK_user_conn',
|
|
'wait/synch/mutex/sql/LOCK_uuid_generator',
|
|
'wait/synch/mutex/sql/LOCK_plugin',
|
|
'stage/sql/creating table')
|
|
AND enabled = 'yes' AND timed = 'no'
|
|
ORDER BY name;
|
|
NAME ENABLED TIMED
|
|
stage/sql/creating table YES NO
|
|
wait/synch/mutex/sql/LOCK_plugin YES NO
|
|
wait/synch/mutex/sql/LOCK_user_conn YES NO
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name = 'wait/synch/mutex/sql/LOCK_thread_count'
|
|
AND enabled = 'no' AND timed = 'no';
|
|
NAME ENABLED TIMED
|
|
wait/synch/mutex/sql/LOCK_thread_count NO NO
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name IN (
|
|
'wait/synch/mutex/sql/LOG_INFO::lock',
|
|
'wait/synch/mutex/sql/THD::LOCK_thd_data')
|
|
AND enabled = 'yes' AND timed = 'yes'
|
|
ORDER BY name;
|
|
NAME ENABLED TIMED
|
|
wait/synch/mutex/sql/LOG_INFO::lock YES YES
|
|
wait/synch/mutex/sql/THD::LOCK_thd_data YES YES
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name = 'wait/synch/mutex/sql/hash_filo::lock'
|
|
AND enabled = 'no' AND timed = 'no'
|
|
ORDER BY name;
|
|
NAME ENABLED TIMED
|
|
wait/synch/mutex/sql/hash_filo::lock NO NO
|
|
#
|
|
# Verify that the instrument startup settings are not not visible.
|
|
#
|
|
SHOW VARIABLES LIKE "%/wait/synch/mutex%";
|
|
Variable_name Value
|
|
#
|
|
# Verify command line options are processed correctly
|
|
#
|
|
#
|
|
# Verify that wait/io/table/sql/handler is enabled and timed
|
|
#
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name like "%wait/io/table/sql/handler%";
|
|
NAME ENABLED TIMED
|
|
wait/io/table/sql/handler YES YES
|
|
#
|
|
# Stop server
|
|
# Restart server with wait/io/table/sql/handler disabled
|
|
# Enable reconnect
|
|
# Wait until connected again
|
|
# Disable reconnect
|
|
#
|
|
# Verify that wait/io/table is disabled
|
|
#
|
|
SELECT * FROM performance_schema.setup_instruments
|
|
WHERE name like "%wait/io/table/sql/handler%";
|
|
NAME ENABLED TIMED
|
|
wait/io/table/sql/handler NO NO
|