Re: Query/connection state getting locked
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
Subject
Views
Written By
Posted
13748
January 10, 2006 05:25AM
6502
January 10, 2006 05:07PM
6110
January 11, 2006 05:54AM
6108
January 23, 2006 02:07AM
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.