Re: Server side cursors and locking



> Does the cache size really affect which records get locked? I messed with
> it
> and it seems to me that it always locks the entire result set.

Are you in a transaction?

Stephen Howe


.



Relevant Pages

  • Re: spinaphore conceptual draft
    ... >>I suspect any attempt to use time stamps in locks is a bad ... >>CPU will always snoop cache accesses for all cache lines ... > The idea behind these locks is for bigger systems for ... and a lock such as this should be able to send several CPUs to ...
    (Linux-Kernel)
  • Re: fcntl(F GETLEASE) semantics??
    ... > can't place a read lease, but can place a write lease! ... that screws with the ability to cache data. ... and nobody else holds locks on the file. ...
    (Linux-Kernel)
  • Re: FUSE merging?
    ... > plays nicely with the page cache. ... on the underlying file server. ... > talking about a virtual filesystem where all calls should be passed ... We have exclusive open semantics but not locks in the Posix ...
    (Linux-Kernel)
  • Re: [RFC][PATCH 1/7] Resource counters
    ... If I am not mistaken, you shouldn't loop in normal cases, which means ... If you care about optimization cache lines ... With spin locks you have to be a little more careful to put them ... With atomic ops you get that automatically. ...
    (Linux-Kernel)
  • Re: prepare_cached() unused in selectall_arrayref() et al
    ... In my case "prepare_cached" didn't scale up well, ... cache to be default and have an option to turn it off. ... Mark ... Prev by Date: ...
    (perl.dbi.users)