MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: mysql run slow
Posted by: Phillip Ward
Date: March 27, 2015 06:42AM

Agreed; it would probably be optimised out, but a plenty of other things run the gambit of spinning up one of these in-memory, temporary tables:

From: http://dev.mysql.com/doc/refman/5.5/en/internal-temporary-tables.html
* UNION
* ORDER BY + DISTINCT
* ORDER BY + GROUP BY (where the two don't match up)
* GROUP_CONCAT
* COUNT( DISTINCT )
and many more ...

Basically, we need to see the O.P.'s query.

Regards, Phill W.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
mysql run slow
eric tang
March 26, 2015 02:06AM
Re: mysql run slow
Phillip Ward
March 26, 2015 06:05AM
Re: mysql run slow
Rick James
March 27, 2015 12:16AM
Re: mysql run slow
Phillip Ward
March 27, 2015 06:42AM


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.