MySQL Forums
Forum List  »  MyISAM

Re: Query/connection state getting locked
Posted by: Ingo Strüwing
Date: January 23, 2006 04:20AM

Well, I wrote "In some cases a SHOW CREATE TABLE can also be useful." The word "also" was there intentionally. :)

The table layout _alone_ does not help. As Jay said, please add the output of EXPLAIN SELECT for your query. And the command itself should be useful too. This is because I doubt that _any_ select on this table takes 3 to 5 min. For example a statement like "SELECT ID FROM article WHERE ID=4711" should take less than a tenth of a second even if your table is > 500 GB.

While a SELECT is running on a table, it should be locked against changes, but other selects should still be possible.

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query/connection state getting locked
5318
January 23, 2006 04:20AM


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.