Is it possible to query a tmp table that mysql creates automatically when dealing with large queries?
When I do a 'show processlist' and it gives a state of 'Copying to tmp table' , is there a way to query or access this tmp table to see the status of the query? Im thinking this would give me an idea of how long to expect the query to take based on its progress... Thanks- __________________________________________________