MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Query/connection state getting locked
Posted by: Black Bits (Neeraj)
Date: January 10, 2006 05:25AM

Hi all,

I am using MySql server 4.1.10a.
I am facing problem while firing big query
Like join with multiple tables multiple conditions

Whenever I fire this kind of query, all other requests from other connections got locked.

I am using MyISAM storage engine for storage. And database size near about 1.5 GB. It’s a linux on IBM server duel xeon processor 2GB ram

Please help me, what kind of changes I should do to stop locking..

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Query/connection state getting locked
13759
Black Bits (Neeraj)
January 10, 2006 05:25AM
Re: Query/connection state getting locked
6506
Jay Pipes
January 10, 2006 05:07PM
Re: Query/connection state getting locked
6114
Ingo Strüwing
January 11, 2006 05:54AM
Re: Query/connection state getting locked
6115
Black Bits (Neeraj)
January 23, 2006 02:07AM
Re: Query/connection state getting locked
5320
Ingo Strüwing
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.