mysql 多表连接查询优化 ,并发量大时速度超慢
1.先丢查询语句
-- 业务:查询某个学校[学校id为120082]的某一节课[大学英语]有多少学生选
SELECT COUNT(DISTINCT _choosemate.studentId)
FROM _choosemate LEFT JOIN _course ON _course.id = _choosemate.courseId
LEFT JOIN _student ON _choosemate.studentId = _student.id
WHERE _course.schoolId = 120082 AND _course.`name` = '大学英语'
AND _course.beginYear = 2013 AND term = 1 AND LENGTH(_student.nickName) > 0
2.问题
单独执行时速度挺快的,但当并发量大时速度变得很慢,
被这个问题困扰很久了,急求大虾们指教!!!