Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How Long a connection Object is valid before time out ?

 
Chandra A Sekhar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We have a strange problem, we have 9 different threads accessing one table (ofcourse thro a synchrnized DBClass method) , each time each thread needs around 2-3 mins and thread will come back in 30 mins. In other words this is more of a continuous process.
Once in a week we need to clean up the complete table during that process our clean up procedure will archive all previous weeks data on to archive data base.
My question here is the archivel process takes some time (about 30 mins) during that process my 9 threads will try to write on to that table and they will keep waiting for clean up procedure to leave the lock , so here can anybody tell me how much time will that connection be valid and how much time it waits or keeps polling for a write access on to that table ?
Some times all 9 threads die at this very particular time so we are suspecting that some thing is going wrong during thar process.!!
Any input will be greatly appreciated

Thanks in advance,
Chandu
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
...so here can anybody tell me how much time will that connection be valid and how much time it waits or keeps polling for a write access on to that table ? ...

You tell us! each statement has a method to
find what the timeout setting is and a method to change the length before timeout

Jamie
[ March 01, 2002: Message edited by: Jamie Robertson ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic