Re: Sending data in processlist
> peocesslist status 'sending data' and no result still 4/5 hours runnl
Often that signals a very long table scan.
In a mysql client, run EXPLAIN EXTENDED on the query and post the result here along with SHOW CREATE TABLE results for tables referenced in the query.
Subject
Written By
Posted
December 19, 2014 07:55AM
Re: Sending data in processlist
December 19, 2014 03:07PM
December 20, 2014 12:03AM
December 20, 2014 05:33AM
December 20, 2014 10:18AM
December 26, 2014 02:23AM
December 26, 2014 11:56AM
December 29, 2014 02:59AM
December 29, 2014 01:16PM
December 30, 2014 07:02AM
December 30, 2014 02:55PM
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.