MySQL5.6，64位，RHEL5.8使用ORDERBY和LIMIT'row_count'(或LIMIT0,'row_count')对大表进行查询。如果“row_count”大于结果集的实际计数，将会非常非常慢。情况1:下面的查询非常快(没有“LIMIT”):mysql>SELECT*FROMsyslogWHERE(ReportedTimeBETWEEN'2013-11-04'AND'2013-11-05')ANDPriority情况2:下面的查询也很快('LIMIT5'):mysql>SELECT*FROMsyslogWHERE(ReportedTimeBETWEEN'2013-1