- 论坛徽章:
- 0
|
本帖最后由 lxxpsp2007 于 2013-03-12 09:52 编辑
我们公司的一台 slave mysql 服务器,提供只读服务。 MYISAM 引擎
每天都有 150MB左右的 慢查询日志。
我单独拿出这些被记录到慢日志的 语句 执行,发现速度很快的。
慢查询设置超过1秒被记录。
我很迷惑,明明语句不变态也有索引,手动单独执行也很快。 不知道为什么被记录近了慢查询日志。
请大家指点迷津,或者给个思路,谢谢大家。
比如下面经过 mysqlsla 处理后的排名第一慢的- Count : 4.58k (2.68%)
- Time : 4617 s total, 1.008739 s avg, 1 s to 4 s max (6.20%)
- 95% of Time : 4348 s total, 1 s avg, 1 s to 1 s max
- Lock Time (s) : 1 s total, 218 祍 avg, 0 to 1 s max (3.85%)
- 95% of Lock : 0 total, 0 avg, 0 to 0 max
- Rows sent : 16 avg, 15 to 16 max (0.75%)
- Rows examined : 46 avg, 32 to 48 max (0.09%)
- Database : xxpp_data
- Users :
- xxppx@ 192.168.0.101 : 42.30% (1936) of query, 41.27% (70379) of all users
- xxppx@ 192.168.0.102 : 33.71% (1543) of query, 32.70% (55761) of all users
- xxppx@ 192.168.0.103 : 23.99% (1098) of query, 24.35% (41533) of all users
- Query abstract:
- SELECT m.id, m.title, from_unixtime( m.cdate, 'S') AS cdate, from_unixtime( m.udate, 'S') AS udate, m.image, m.spec, m.product_area, m.shop_id, m.gcid, s.rid, m.price, m.stat, s.company, s.level AS shop_level, b.title AS brand, b.id AS brand_id, N AS type, unit FROM xxpp_goods.goods AS m LEFT JOIN xxpp.shop AS s ON m.shop_id = s.id LEFT JOIN xxpp.brand AS b ON m.brand_id = b.id WHERE m.id IN (N16);
- Query sample:
- SELECT
- m.id,
- m.title,
- FROM_UNIXTIME( m.cdate, '%Y-%m-%d %H:%i') AS cdate,
- FROM_UNIXTIME( m.udate, '%Y-%m-%d %H:%i') AS udate,
- m.image,
- m.spec,
- m.product_area,
- m.shop_id,
- m.gcid,
- s.rid,
- m.price,
- m.stat,
- s.company,
- s.level AS shop_level,
- b.title AS brand,
- b.id AS brand_id,
- 1 AS type,
- unit
- FROM xxpp_goods.goods AS m
- LEFT JOIN xxpp.shop as s ON m.shop_id = s.id
- LEFT JOIN xxpp.brand AS b ON m.brand_id = b.id
- WHERE m.id IN (2676271,2667626,2769278,2915621,2542843,1635917,1788116,2662136,2505980,1201328,2493089,1995808,2490642,2125146,2042179,2068516);
复制代码 |
|