系统表介绍
cond_instances 表描记录了条件(conditions)列表。 条件或条件检测对象是指一个内部的代码机制,标志发生了一个特殊的事件,线程正在等待这个事件以恢复运行。 该表不允许truncate
列名 | 含义 |
---|---|
NAME | 监测器名称 |
OBJECT_INSTANCE_BEGIN | 监测器内存地址 |
实例
mysql> select *from cond_instances ;
+------------------------------------------------------------+-----------------------+
| NAME | OBJECT_INSTANCE_BEGIN |
+------------------------------------------------------------+-----------------------+
| wait/synch/cond/sql/COND_manager | 34053520 |
| wait/synch/cond/sql/COND_server_started | 33969072 |
| wait/synch/cond/sql/COND_compress_gtid_table | 33968896 |
| wait/synch/cond/sql/COND_socket_listener_active | 33968784 |
| wait/synch/cond/sql/COND_start_signal_handler | 33968672 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond | 34187040 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::prep_xids_cond | 34189528 |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_done | 34189808 |
| wait/synch/cond/sql/COND_thread_cache | 34180544 |
| wait/synch/cond/sql/COND_flush_thread_cache | 34180480 |
| wait/synch/cond/sql/COND_connection_count | 34028528 |
| wait/synch/cond/sql/COND_thd_list | 36691168 |
| wait/synch/cond/sql/COND_open | 34039280 |
| wait/synch/cond/sql/Query_cache::COND_cache_status_changed | 33967792 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390602639816 |
| wait/synch/cond/sql/COND_thr_lock | 140390602644352 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390535530888 |
| wait/synch/cond/sql/COND_thr_lock | 140390535535424 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390401313160 |
| wait/synch/cond/sql/COND_thr_lock | 140390401317696 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390468422024 |
| wait/synch/cond/sql/COND_thr_lock | 140390468426560 |
| wait/synch/cond/innodb/commit_cond | 34237856 |
| wait/synch/cond/myisam/keycache_thread_var::suspend | 34766912 |
| wait/synch/cond/sql/Gtid_state | 37095680 |
| wait/synch/cond/sql/Gtid_state | 37095824 |
| wait/synch/cond/sql/Master_info::data_cond | 44686904 |
| wait/synch/cond/sql/Master_info::start_cond | 44686960 |
| wait/synch/cond/sql/Master_info::stop_cond | 44687016 |
| wait/synch/cond/sql/Master_info::sleep_cond | 44687072 |
| wait/synch/cond/sql/Relay_log_info::data_cond | 45223368 |
| wait/synch/cond/sql/Relay_log_info::start_cond | 45223424 |
| wait/synch/cond/sql/Relay_log_info::stop_cond | 45223480 |
| wait/synch/cond/sql/Relay_log_info::sleep_cond | 45223536 |
| wait/synch/cond/sql/Relay_log_info::log_space_cond | 45231272 |
| wait/synch/cond/sql/Relay_log_info::pending_jobs_cond | 45233800 |
| wait/synch/cond/sql/Relay_log_info::mts_gaq_cond | 45223992 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond | 45225464 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::prep_xids_cond | 45227952 |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_done | 45228232 |
| wait/synch/cond/sql/COND_queue_state | 45452336 |
| wait/synch/cond/sql/Event_scheduler::COND_state | 45452560 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 45255496 |
| wait/synch/cond/sql/COND_thr_lock | 45260032 |
| wait/synch/cond/sql/MDL_context::COND_wait_status | 140390200222696 |
| wait/synch/cond/sql/COND_thr_lock | 140390200227232 |
+------------------------------------------------------------+-----------------------+
46 rows in set (0.00 sec)