`
cocos
  • 浏览: 395326 次
  • 性别: Icon_minigender_1
  • 来自: 福州
社区版块
存档分类
最新评论

mysql BENCHMARK

阅读更多

EXPLAIN 
SELECT COUNT(*) FROM ol_answerresult_1 INNER JOIN ol_question ON ol_answerresult_1.QuestionId = ol_question.QuestionId   AND PaperId='00000000-0000-0000-0000-000000000000' AND ol_question.IsConfirmed=1 AND QuestionCategory=1  AND ol_question.SimilarType<>2 AND (GKYear!=0 OR GKArea!=0) WHERE ol_answerresult_1.userid=39176 AND ol_answerresult_1.SUBJECT=10

EXPLAIN
SELECT SQL_NO_CACHE questionid,AllTagCatalogId 
FROM ol_question WHERE MATCH(AllTagCatalogId)AGAINST (7117,7116);

EXPLAIN

MATCH() AGAINST

SELECT SQL_NO_CACHE questionid
FROM ol_question WHERE AllTagCatalogId LIKE '%7116%';

SELECT BENCHMARK(1000000,(SELECT SQL_NO_CACHE questionid FROM ol_question WHERE MATCH(AllTagCatalogId)AGAINST ('7116') LIMIT 1))

SELECT BENCHMARK(1000000,(SELECT SQL_NO_CACHE questionid FROM ol_question WHERE AllTagCatalogId LIKE '%7116%' LIMIT 1))

SELECT BENCHMARK(10000000,CURRENT_DATE())
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics