MySQL Forums :: Performance :: Long execution time despite LIMIT 3


Advanced Search

Re: Long execution time despite LIMIT 3
Posted by: Rick James ()
Date: June 20, 2011 06:33PM

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';

Options: ReplyQuote


Subject Views Written By Posted
Long execution time despite LIMIT 3 1686 Joachim Berger 06/19/2011 12:47PM
Re: Long execution time despite LIMIT 3 700 Joachim Berger 06/19/2011 12:54PM
Re: Long execution time despite LIMIT 3 651 Rick James 06/20/2011 06:33PM
Re: Long execution time despite LIMIT 3 665 Joachim Berger 06/20/2011 11:44PM
Re: Long execution time despite LIMIT 3 727 Joachim Berger 06/21/2011 02:06AM
Re: Long execution time despite LIMIT 3 718 Rick James 06/21/2011 07:23AM
Re: Long execution time despite LIMIT 3 615 Joachim Berger 06/21/2011 07:28AM
Re: Long execution time despite LIMIT 3 748 Joachim Berger 06/21/2011 10:33AM
Re: Long execution time despite LIMIT 3 765 Rick James 06/21/2011 10:08PM
Re: Long execution time despite LIMIT 3 1047 Joachim Berger 06/22/2011 12:33AM
Re: Long execution time despite LIMIT 3 654 Rick James 06/22/2011 07:26PM
Re: Long execution time despite LIMIT 3 671 Joachim Berger 06/22/2011 11:45PM
Re: Long execution time despite LIMIT 3 656 Rick James 06/23/2011 08:53AM
Re: Long execution time despite LIMIT 3 741 Joachim Berger 06/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.