I'm looking at the stats on one of our servers and trying to understand why Handler_read_rnd_next is so high. It's 256.5M right now, which is about 10x the total number of reported queries.
The machine is being used, almost entirely, for queries of the form: select * from crumb where link_id is null and latitude > 39 and longitude > -98 limit 10000; link_id is indexed. There are about 8 million rows in the table, and most of them have link_id = null right now. latitude and longitude are not indexed - but my understanding is that mySQL will only use one index, and link_id is the interesting one for us. Are the latitude and longitude qualifiers the cause of the table scans? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
