Henning Schroeder wrote:
> i also tried logging the queries that appear often with "copying to temp
> table" status and now have a nice set of them, though i donīt quite
> understand *why* the are copying. below are two:
> (the rows count is *way* to high, probably because the timestamps are
> ancient by the time i ran explain select)
It is copying ALL of the results into the temp table. If you can (e.g. you know you
will
never want more than N records), add a LIMIT 0,N to the end of the SELECT so that when
you
have an old timestamp it will not hang the database.
--Bill
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
