db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From T K <sanokist...@yahoo.com>
Subject Re: Running stats while online
Date Fri, 21 Aug 2009 16:50:05 GMT
Also, would an explicit LOCK TABLE before running stats help in preventing these deadlocks?




________________________________
From: T K <sanokistoka@yahoo.com>
To: Derby Discussion <derby-user@db.apache.org>
Sent: Friday, August 21, 2009 11:27:56 AM
Subject: Re: Running stats while online


>  I have sometimes seen timeouts and deadlocks as a result of this when updating the statistics
while other threads are accessing the same table.

Have you seen this with 10.5 and its new approach as well? Or just prior versions?


Thanks


      
Mime
View raw message