Hi Axel, RootShare means that a task wants to lock a btree in share mode but has to wait because another task holds a RootExcl lock on the same btree root. The RootShare lock is needed for reading in leaves or for updating one leaf. The RootExcl lock is set if a task needs to add or remove another leaf to the btree.
regards, Uwe >-----Original Message----- >From: Axel Busch [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 07, 2004 11:34 AM >To: [EMAIL PROTECTED] >Subject: Task State "RootShare" > > >Hi, > >I was dumping the task state of our database instance during a >sudden increase in database connections (from 2 to 150 in 10 >seconds) with x_cons, and ran across the state "RootShare". >This state is not documented, but since most of the tasks are in >this state, I would be _very_ interested in what it says. > >Can somebody please sketch quickly what it says? Actually I need >this rather urgently, since we have some serious freezing problem. > >kind regards and thanks in advance, > >Axel > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
