MySQL如何确定并行从属工作线程是否有效利用

数据运维 2023-09-16 穿过生命散发芬芳手机阅读

适用于:MySQL Server - Version 8.0 and later

使用slave_parallel_workers=N设置时，如何确定活动线程的数量？

可以使用以下查询在performance_schema中找到所需事件的线程信息:

SELECT performance_schema.events_transactions_summary_by_thread_by_event_name.THREAD_ID AS THREAD_ID, performance_schema.events_transactions_summary_by_thread_by_event_name.COUNT_STAR AS COUNT_STAR FROM performance_schema.events_transactions_summary_by_thread_by_event_name WHERE performance_schema.events_transactions_summary_by_thread_by_event_name.THREAD_ID IN (SELECT performance_schema.replication_applier_status_by_worker.THREAD_ID FROM performance_schema.replication_applier_status_by_worker);