SUM_TIMER_WAIT:等待事件的总计时器等待时间。 MIN_TIMER_WAIT:等待事件的最小计时器等待时间。 AVG_TIMER_WAIT:等待事件的平均计时器等待时间。 MAX_TIMER_WAIT:等待事件的最大计时器等待时间。 3.11 events_waits_summary_global_by_event_name 提供了按事件名称分类的全局等待事件的汇总信息。 代码语言:javascript...
Date: December 26, 2014 02:08AM Hi, SELECT THREAD_ID, threads.NAME, SUM (COUNT_STAR) AS Tcount, SUM (SUM_TIMER_WAIT) AS Ttime FROM performance_schema.events_waits_summary_by_thread_by_event_name INNER JOIN performance_schema,threads USING (THREAD_ID) ...
SELECTEVENT_NAME,SUM_TIMER_WAITFROMperformance_schema.events_waits_summary_global_by_event_nameWHERESUM_TIMER_WAIT>0ORDERBYSUM_TIMER_WAITDESC; 1. 2. 3. 4. 这条SQL语句会列出各种等待事件及其总等待时间。可以根据SUM_TIMER_WAIT字段的值来找出等待时间最长的事件,从而定位到导致等待的原因。 关系图示例 ...
SUM_TIMER_WAIT FROM events_waits_summary_global_by_event_name where event_name like "wait/sync%" ORDER BY SUM_TIMER_WAIT DESC LIMIT 10; select * from information_schema.global_status where variable_name = "Uptime"' mysql> select * from setup_timers; +---+---+ | NAME | TIMER_NAME ...
SELECTEVENT_NAME,SUM(TIMER_WAIT)AStotal_wait_time,COUNT(*)ASwait_countFROMperformance_schema.events_waits_summary_global_by_event_nameWHEREEVENT_NAMELIKE'wait/%'GROUPBYEVENT_NAMEORDERBYtotal_wait_timeDESC; 1. 2. 3. 4. 5. 6. 7.
, SUM(count_star) count , ROUND( (SUM(sum_timer_wait) / SUM(count_star)) / 1000000) AS avg_microsec FROM performance_schema.events_statements_summary_by_digest WHERE schema_name IS NOT NULL GROUP BY schema_name; +---+---+---+ | schema_name | count | avg_microsec | +---...
TIMER_START, TIMER_END, TIMER_WAIT:事件开始/结束和等待的时间,单位为皮秒(picoseconds) OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE视情况而定 对于同步对象(cond, mutex, rwlock),这个3个值均为NULL 对于文件IO对象,OBJECT_SCHEMA为NULL,OBJECT_NAME为文件名,OBJECT_TYPE为FILE ...
SELECT file_name,event_name,SUM_NUMBER_OF_BYTES_READ,SUM_NUMBER_OF_BYTES_WRITE FROM file_summary_by_instance ORDER BY SUM_NUMBER_OF_BYTES_READ + SUM_NUMBER_OF_BYTES_WRITE DESC; 哪个表逻辑 IO 最多? SELECT object_name,COUNT_READ,COUNT_WRITE,COUNT_FETCH,SUM_TIMER_WAIT FROM table_io_waits...
SUM_TIMER_WAIT: 650358383000 MIN_TIMER_WAIT: 292045159000 AVG_TIMER_WAIT: 325179191000 MAX_TIMER_WAIT: 358313224000 SUM_LOCK_TIME: 520000000 SUM_ERRORS: 0 SUM_WARNINGS: 0 SUM_ROWS_AFFECTED: 0 SUM_ROWS_SENT: 520048 SUM_ROWS_EXAMINED: 520048 ...
Date: December 26, 2014 02:08AM Hi, SELECT THREAD_ID, threads.NAME, SUM (COUNT_STAR) AS Tcount, SUM (SUM_TIMER_WAIT) AS Ttime FROM performance_schema.events_waits_summary_by_thread_by_event_name INNER JOIN performance_schema,threads USING (THREAD_ID) ...