in reply to using perl to lock tables without locking myself

I've been DBA'ing for quite a while now (12 years) on some very big systems (1000s of users, TBs of data) and I've never come across an situation where 'LOCK TABLE' was a 'good thing'. In fact in most situations it is the most significant obstacle to both performance and scalability.

rdfield

  • Comment on Re: using perl to lock tables without locking myself