Home » Performance » MySQL » Queries locking the database
Queries locking the database [message #139] Wed, 06 September 2006 06:42 Go to previous message
geelwortel  is currently offline geelwortel
Messages: 25
Registered: September 2006
Junior Member
After a HUGE performance loss on MySQL version 5 we moved back to version 3. The main problem we have now is that one of the queries are locking the database every time it is running. The query is:
Select count(*) as NoRec from gen_Main Left Join con_History ON (gen_Main.WKey = con_History.WKey) Where con_History.RecActive = 'y' And con_History.MOID = 1 And con_History.DepId =14

Can someone please help

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:performance of query for normalized DB
Next Topic:Order of columns in indexes
Goto Forum:

  


Current Time: Mon Jul 6 21:55:38 EDT 2009

Total time taken to generate the page: 0.02160 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.