Re: Long execution time despite LIMIT 3
Something unobvious is going on, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
Also, please do
SELECT COUNT(*) FROM table WHERE thread='foo';
Subject
Views
Written By
Posted
2544
June 19, 2011 12:47PM
901
June 19, 2011 12:54PM
Re: Long execution time despite LIMIT 3
1042
June 20, 2011 06:33PM
1058
June 20, 2011 11:44PM
999
June 21, 2011 02:06AM
1070
June 21, 2011 07:23AM
857
June 21, 2011 07:28AM
1002
June 21, 2011 10:33AM
1053
June 21, 2011 10:08PM
1425
June 22, 2011 12:33AM
981
June 22, 2011 07:26PM
879
June 22, 2011 11:45PM
988
June 23, 2011 08:53AM
1000
June 24, 2011 02:51AM
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.