My Oracle Support Banner

MySQL Performance Schema: Conditional Variables (Doc ID 1464623.1)

Last updated on MAY 25, 2021

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Purpose

 

Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened.

This document explains conditional wait variables and how they are used in the PERFORMANCE_SCHEMA of MySQL Server.

Scope

This document is aimed at anyone who is responsible for performance management, fine tuning and development related to the internal workings of MySQL. Details are based around an understanding of multithreading programming so some knowledge would be helpful although not required.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
  Overview
 Description
 Examples
 Performance_Schema Details
 How to Use
 Related Instruments
 wait/synch/cond/sql/PAGE::cond
 wait/synch/cond/sql/TC_LOG_MMAP::COND_active
 wait/synch/cond/sql/TC_LOG_MMAP::COND_pool
 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_prep_xids
 wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond
 wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond
 wait/synch/cond/sql/Query_cache::COND_cache_status_changed
 wait/synch/cond/sql/COND_manager
 wait/synch/cond/sql/COND_server_started
 wait/synch/cond/sql/Delayed_insert::cond
 wait/synch/cond/sql/Delayed_insert::cond_client
 wait/synch/cond/sql/Item_func_sleep::cond
 wait/synch/cond/sql/Master_info::data_cond
 wait/synch/cond/sql/Master_info::start_cond
 wait/synch/cond/sql/Master_info::stop_cond
 wait/synch/cond/sql/Master_info::sleep_cond
 wait/synch/cond/sql/Relay_log_info::data_cond
 wait/synch/cond/sql/Relay_log_info::log_space_cond
 wait/synch/cond/sql/Relay_log_info::start_cond
 wait/synch/cond/sql/Relay_log_info::stop_cond
 wait/synch/cond/sql/Relay_log_info::sleep_cond
 wait/synch/cond/sql/Relay_log_info::pending_jobs_cond
 wait/synch/cond/sql/Worker_info::jobs_cond
 wait/synch/cond/sql/TABLE_SHARE::cond
 wait/synch/cond/sql/User_level_lock::cond
 wait/synch/cond/sql/COND_thread_count
 wait/synch/cond/sql/COND_thread_cache
 wait/synch/cond/sql/COND_flush_thread_cache
 wait/synch/cond/mysys/COND_alarm
 wait/synch/cond/mysys/IO_CACHE_SHARE::cond
wait/synch/cond/mysys/IO_CACHE_SHARE::cond_writer
 wait/synch/cond/mysys/my_thread_var::suspend
 wait/synch/cond/mysys/THR_COND_threads
 wait/synch/cond/sql/Event_scheduler::COND_state
 wait/synch/cond/sql/COND_queue_state
 wait/synch/cond/sql/MDL_context::COND_wait_status
 wait/synch/cond/myisam/MI_SORT_INFO::cond
 wait/synch/cond/innodb/commit_cond
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.