MySQL 慢查询日报（线上 prod8591）2026-09-08

统计概览

Top10 明细（按单条耗时）

高频慢查询模式（指纹聚合，取样 23,116 条）

按条数 Top5

按累计耗时 Top5

备份模式全天 65 条 / 1.55h，未触发深度分析（如条数环比异常翻倍再人工介入）。

触发深度分析的模式（条数>100 或 累计>30min，非备份，最多 8 个）

1. select sum(searched_times) as total, keyword from t8_keyword_statistics where date between ? and —— 402 次 × 35.62s = 3.98h

• 代表性 SQL：select sum(searched_times) as total, keyword from t8_keyword_statistics where date between '2026-08-08' and '2026-09-08' group by keyword order by total desc limit 5;
• 库表：?.t8_keyword_statistics；实例 alias：prod-8591/8591-b
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

2. SELECT c.* FROM t8_user_id_card_number_list AS c WHERE c.img_type = ? AND c.status = ? AND c.image ! —— 3,235 次 × 3.50s = 3.14h

• 代表性 SQL：SELECT c.* FROM t8_user_id_card_number_list AS c WHERE c.img_type = 2 AND c.status = 2 AND c.image != '' AND (c.ocr_result = '' or c.ocr_result is null) ORDER BY c.id ASC,c.id LIMIT 1;
• 库表：?.t8_user_id_card_number_list；实例 alias：prod-8591/8591-a
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

3. select wallet, sum(if(type = ?, amount, ?)) - sum(if(type = ?, amount, ?)) as balance from a8591.` —— 153 次 × 50.52s = 2.15h

• 代表性 SQL：select wallet, sum(if(type = 2, amount, 0)) - sum(if(type = 1, amount, 0)) as balance from a8591.t8_money_trade_log where account = 'A0100' and created_at <= '2026-09-08 00:03:50' group by wallet;
• 库表：a8591.t8_money_trade_log；实例 alias：prod-8591/8591-a
• explain SQL：select wallet, sum(if(type = 2, amount, 0)) - sum(if(type = 1, amount, 0)) as balance from a8591.t8_money_trade_log where account = 'A0100' and created_at <= '2026-09-08 00:03:50' group by wa`
• 执行计划：[]
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

4. SELECT * FROM t8_mall_stat ORDER BY created_at DESC; —— 2 次 × 3799.32s = 2.11h

• 代表性 SQL：SELECT * FROM t8_mall_stat ORDER BY created_at DESC;
• 库表：?.t8_mall_stat；实例 alias：prod-8591/8591-b
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

5. SELECT a.buyUser AS buyerId, a.sellUser AS sellerId, c.order_number AS orderNo, a.id AS txNo, c.orde —— 2 次 × 2217.36s = 1.23h

• 代表性 SQL：SELECT a.buyUser AS buyerId, a.sellUser AS sellerId, c.order_number AS orderNo, a.id AS txNo, c.order_status AS orderStatus, a.status AS txStatus, d.type AS gameType, CONVERT ( CAST( d.NAME AS BINARY ) USING utf8 ) AS gameName, CONVERT ( CAST( e.type_name AS BINARY ) USING utf8 ) AS goodsType, CONVERT ( CAST( a.title AS BINARY ) USING utf8 ) AS goodsTitle, c.pay_by AS payMethod, c.user
• 库表：?.ware_item；实例 alias：prod-8591/8591-b
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

6. select session, from, body from chat_messages where from = ? and time > ? and type = ? —— 2,752 次 × 1.31s = 1.00h

• 代表性 SQL：select session, from, body from chat_messages where from = 1787879 and time > '2026-09-07 06:00:07' and type = 'msg:txt';
• 库表：?.chat_messages；实例 alias：prod-8591/8591-b
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

7. select t1_design_img.id, t1_design_img.views, t1_design_img.collection, t1_design_img. —— 2,572 次 × 1.33s = 57.0min

• 代表性 SQL：select t1_design_img.id, t1_design_img.views, t1_design_img.collection, t1_design_img.favor_count, t1_design_img.comment_count, t1_design_img.pin_share_count + t1_design_img.fb_share_count + t1_design_img.line_share_count as share_count, t1_design_img.downs + t1_design_img.save_count + t1_design_img.screenshot_count as download_count from t1_design_img inner join t1_design_w`
• 库表：?.t1_design_img；实例 alias：prod-8591/100
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

8. SELECT id, user_id, money, ware_id, type, ware_type_limit, amount_limit, client_limit, active_id, co —— 2 次 × 1538.55s = 51.3min

• 代表性 SQL：SELECT id, user_id, money, ware_id, type, ware_type_limit, amount_limit, client_limit, active_id, coupon_id, get_client, use_client, IF(create_time NOT LIKE '0000-00-00 00:00:00', create_time, NULL) AS create_time, IF(used_time NOT LIKE '0000-00-00 00:00:00', used_time, NULL) AS used_time, IF(can_use_time NOT LIKE '0000-00-00 00:00:00', can
• 库表：?.t8_user_voucher；实例 alias：prod-8591/8591-b
• explain：未执行（Error calling tool 'explain': (1046, 'No database selected')）
• 慢因：其他(需结合 SQL 与执行计划人工判断)
• 建议：结合 SQL 文本与执行计划人工复核; 考虑降频/缓存

逐条优化建议汇总

*采集脚本 .agents/scripts/mysql_slow_prod_report.py，中间数据 outputs/slow_report_prod8591_20260908.json；全程只读。*