|
楼主 |
发表于 2015-10-9 17:08:50
|
显示全部楼层
回复 qrx12340
1.使用centos 类linux系统
2.打开mysql的slow日志,通过执行时长看瓶颈出现在哪,有针 ...
ismtlee 发表于 2015-10-9 15:47
linux等实在没办法才考虑了,那个需要请人维护,不太现实
慢查询日志里查询时间最长的应该是“只看该作者”功能,在一些回复超级多的帖子里耗时30多秒,索引怎么优化我就不懂了,据说在千万级的表里加索引也是非常麻烦的事情,麻烦帮忙看看这个怎么优化,如果没办法我考虑去掉这个功能- Query_time: 38.078125 Lock_time: 0.000000 Rows_sent: 5 Rows_examined: 12721270
- use gaoloumi;
- SET timestamp=1444363782;
- SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, m.digestposts, m.oltime,
- m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
- m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, mf.nickname, mf.site,
- mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.medals,
- mf.sightml AS signature, mf.customstatus, mf.spacename , mf.field_1, mf.field_2
- FROM cdb_posts p
- LEFT JOIN cdb_members m ON m.uid=p.authorid
- LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
- WHERE p.tid='9714' AND p.invisible='0' AND p.authorid='507839' ORDER BY dateline LIMIT 0, 11;
复制代码 |
|