On 08/26/15 11:39, Andrew Elwell wrote: >> Copying to tmp table | SELECT parent_id, COUNT(*) as dirattr_sort FROM >> NAMES GROUP BY parent_id ORDER BY dirattr_sort DESC > Ah, I see this too for large queries that need sorting. If you have > space on an SSD drive, it's possible to speed this up by using that > for SQL temp tables - ie > > ie I have in my [server] section of the mysql config > tmpdir = /var/lib/mysql/tmp Good to know. Thank you for the tip, Andrew.
> > (path can be anywhere, but for us, /var/lib/mysql is all on SSD) > which makes it a bit faster... > > ------------------------------------------------------------------------------ > _______________________________________________ > robinhood-support mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/robinhood-support ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
