RDS 慢日志查询 做得太过简单
最少 应该 支持 按数据库分类 查询, 和按数据库 导出 等必要的功能
除了有
Query abstract, 还应该
Query sample
Count : 858 (7.03%)
Time : 1239.056762 s total, 1.444122 s avg, 50.557 ms to 12.825837 s max (5.05%)
95% of Time : 951.24246 s total, 1.167169 s avg, 50.557 ms to 4.982805 s max
Lock Time (s) : 0 total, 0 avg, 0 to 0 max (0.00%)
95% of Lock : 0 total, 0 avg, 0 to 0 max
Rows sent : 0 avg, 0 to 0 max (0.00%)
Rows examined : 0 avg, 0 to 0 max (0.00%)
Query abstract:
SELECT a.usr_id,a.active,a.netname,p.
gender,p.membership,p.
birthday, p.is_cut_img,p.height,ad.r_
state_id,ad.r_city_id, substring(ft.about,N,N) AS about, duf.email_verify,duf.mobile_
verify,duf.cid_verify,duf.
quick_cid_verify,duf.video_
verify, (SELECT COUNT(N) FROM de_user_picture WHERE usr_id=a.usr_id AND active=N) AS active_pics FROM de_user_account a,de_user_profile p, de_user_profile_address ad,de_user_profile_fulltext ft,de_user_flags duf WHERE a.usr_id=p.usr_id AND a.usr_id=ad.usr_id AND a.usr_id=ft.usr_id AND a.usr_id=duf.usr_id AND a.usr_id='S' LIMIT N;
Query sample:
select a.usr_id,a.active,a.netname,p.
gender,p.membership,p.
birthday,
p.is_cut_img,p.height,ad.r_
state_id,ad.r_city_id,
SUBSTRING(ft.about,1,90) as about,
duf.email_verify,duf.mobile_
verify,duf.cid_verify,duf.
quick_cid_verify,duf.video_
verify,
(select count(1) from de_user_picture where usr_id=a.usr_id and active=1) as active_pics
from de_user_account a,de_user_profile p,
de_user_profile_address ad,de_user_profile_fulltext ft,de_user_flags duf
where a.usr_id=p.usr_id and a.usr_id=ad.usr_id
and a.usr_id=ft.usr_id and a.usr_id=duf.usr_id
and a.usr_id='11336225' limit 1;
引用第1楼yzpc2003于2012-08-21 15:53发表的 ReRDS慢日志查询做得太过简单 :
感谢您的反馈,您说的需求已经在规划中了,我们目前慢查询功能新上线,后续会陆续丰富更多的功能。
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。