Re: count distinct for more than 500,000 rows?
Posted by:
Rick James
Date: October 17, 2013 09:45PM
Looks like a serious bug. But first let's check some things...
What is the datatype of id?
Is `id` the PRIMARY KEY?
Also run EXPLAIN against each. Better yet, do EXPLAIN FORMAT=JSON.
If `id` is INT and PRIMARY KEY, then file a bug at
http://bugs.mysql.com
Subject
Views
Written By
Posted
1495
October 16, 2013 02:59PM
Re: count distinct for more than 500,000 rows?
709
October 17, 2013 09:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.