List:General Discussion« Previous MessageNext Message »
From:Hannes Rohde Date:July 7 2005 7:12am
Subject:Locks on Heap tables
View as plain text  
Hello everyone,

	We are using MySQL as the database backend on quite a big portal
page with about 50.000 users and 3 mio. PIs per day. MySQL is as well the
backend for the (php) session management. We are using a heap for that case
as well as for instance phpbb does. 
Lately we are experiencing long lasting table locks due to deletes or
updates on the session table. I know that heap tables only support table
wide locking, but shouldn't those locks be gone quite fast? I have already
checked the obvious reasons for this kind of behaviour like swapping but I
couldn't find anything. Even googling didn't bring anything useful up.
Hopefully someone got some ideas to solve this problem :-)

Thank you in advance
Hannes Rohde

¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ - agentur für neue medien
Stapenhorststr. 10
D-45329 Essen

hr@stripped <mailto:hr@stripped>

Phone & Fax 0700-0-4626932

Diese E-Mail enthält vertrauliche Informationen, die nur für den o.g.
Empfänger bestimmt sind! Jede Kenntnisnahme, Verteilung oder
Vervielfältigung durch andere Personen ist nicht zulässig. Sollten Sie diese
E-Mail irrtümlich erhalten haben, melden Sie uns dies bitte unverzüglich.

This email, its content and any files transmitted with it are intended
solely for the addressee(s). Access, distribution or copying by any other
party is not permitted. If you are not the intended recipient, then please
notify us immediately by returning it to the originator. 

Locks on Heap tablesHannes Rohde7 Jul
  • Re: Locks on Heap tablesGleb Paharenko7 Jul
    • AW: Locks on Heap tablesHannes Rohde7 Jul