Matches in SemOpenAlex for { <https://semopenalex.org/work/W4241097186> ?p ?o ?g. }
- W4241097186 endingPage "29" @default.
- W4241097186 startingPage "1" @default.
- W4241097186 abstract "Modern implementations of DBMS software are intended to take advantage of high core counts that are becoming common in high-end servers. However, we have observed that several database platforms, including MySQL, Shore-MT, and a commercial system, exhibit throughput collapse as load increases into oversaturation (where there are more request threads than cores), even for a workload with little or no logical contention for locks, such as a read-only workload. Our analysis of MySQL identifies latch contention within the lock manager as the bottleneck responsible for this collapse. We design a lock manager with reduced latching, implement it in MySQL, and show that it avoids the collapse and generally improves performance. Our efficient implementation of a lock manager is enabled by a staged allocation and deallocation of locks. Locks are preallocated in bulk, so that the lock manager only has to perform simple list manipulation operations during the acquire and release phases of a transaction. Deallocation of the lock data structures is also performed in bulk, which enables the use of fast implementations of lock acquisition and release as well as concurrent deadlock checking." @default.
- W4241097186 created "2022-05-12" @default.
- W4241097186 creator A5025255598 @default.
- W4241097186 creator A5025750562 @default.
- W4241097186 creator A5034858357 @default.
- W4241097186 creator A5062887839 @default.
- W4241097186 creator A5086519205 @default.
- W4241097186 date "2014-12-30" @default.
- W4241097186 modified "2023-09-27" @default.
- W4241097186 title "A Scalable Lock Manager for Multicores" @default.
- W4241097186 cites W1785356562 @default.
- W4241097186 cites W1814601622 @default.
- W4241097186 cites W1976716006 @default.
- W4241097186 cites W1998663979 @default.
- W4241097186 cites W2001738739 @default.
- W4241097186 cites W2038572501 @default.
- W4241097186 cites W2040057776 @default.
- W4241097186 cites W2048408594 @default.
- W4241097186 cites W2075372521 @default.
- W4241097186 cites W2091076568 @default.
- W4241097186 cites W2101995353 @default.
- W4241097186 cites W2128841495 @default.
- W4241097186 cites W2144430183 @default.
- W4241097186 cites W2152211001 @default.
- W4241097186 cites W2165772200 @default.
- W4241097186 cites W2172197636 @default.
- W4241097186 cites W2185655604 @default.
- W4241097186 cites W3022040810 @default.
- W4241097186 cites W4213428324 @default.
- W4241097186 cites W4240506541 @default.
- W4241097186 cites W4244624509 @default.
- W4241097186 doi "https://doi.org/10.1145/2691190.2691192" @default.
- W4241097186 hasPublicationYear "2014" @default.
- W4241097186 type Work @default.
- W4241097186 citedByCount "12" @default.
- W4241097186 countsByYear W42410971862018 @default.
- W4241097186 countsByYear W42410971862019 @default.
- W4241097186 countsByYear W42410971862020 @default.
- W4241097186 countsByYear W42410971862021 @default.
- W4241097186 countsByYear W42410971862022 @default.
- W4241097186 crossrefType "journal-article" @default.
- W4241097186 hasAuthorship W4241097186A5025255598 @default.
- W4241097186 hasAuthorship W4241097186A5025750562 @default.
- W4241097186 hasAuthorship W4241097186A5034858357 @default.
- W4241097186 hasAuthorship W4241097186A5062887839 @default.
- W4241097186 hasAuthorship W4241097186A5086519205 @default.
- W4241097186 hasConcept C111919701 @default.
- W4241097186 hasConcept C120314980 @default.
- W4241097186 hasConcept C127413603 @default.
- W4241097186 hasConcept C149635348 @default.
- W4241097186 hasConcept C157764524 @default.
- W4241097186 hasConcept C159023740 @default.
- W4241097186 hasConcept C173608175 @default.
- W4241097186 hasConcept C174839445 @default.
- W4241097186 hasConcept C199360897 @default.
- W4241097186 hasConcept C26713055 @default.
- W4241097186 hasConcept C2778476105 @default.
- W4241097186 hasConcept C2780513914 @default.
- W4241097186 hasConcept C41008148 @default.
- W4241097186 hasConcept C48044578 @default.
- W4241097186 hasConcept C555944384 @default.
- W4241097186 hasConcept C72108876 @default.
- W4241097186 hasConcept C75949130 @default.
- W4241097186 hasConcept C77088390 @default.
- W4241097186 hasConcept C78519656 @default.
- W4241097186 hasConcept C78766204 @default.
- W4241097186 hasConcept C93996380 @default.
- W4241097186 hasConceptScore W4241097186C111919701 @default.
- W4241097186 hasConceptScore W4241097186C120314980 @default.
- W4241097186 hasConceptScore W4241097186C127413603 @default.
- W4241097186 hasConceptScore W4241097186C149635348 @default.
- W4241097186 hasConceptScore W4241097186C157764524 @default.
- W4241097186 hasConceptScore W4241097186C159023740 @default.
- W4241097186 hasConceptScore W4241097186C173608175 @default.
- W4241097186 hasConceptScore W4241097186C174839445 @default.
- W4241097186 hasConceptScore W4241097186C199360897 @default.
- W4241097186 hasConceptScore W4241097186C26713055 @default.
- W4241097186 hasConceptScore W4241097186C2778476105 @default.
- W4241097186 hasConceptScore W4241097186C2780513914 @default.
- W4241097186 hasConceptScore W4241097186C41008148 @default.
- W4241097186 hasConceptScore W4241097186C48044578 @default.
- W4241097186 hasConceptScore W4241097186C555944384 @default.
- W4241097186 hasConceptScore W4241097186C72108876 @default.
- W4241097186 hasConceptScore W4241097186C75949130 @default.
- W4241097186 hasConceptScore W4241097186C77088390 @default.
- W4241097186 hasConceptScore W4241097186C78519656 @default.
- W4241097186 hasConceptScore W4241097186C78766204 @default.
- W4241097186 hasConceptScore W4241097186C93996380 @default.
- W4241097186 hasIssue "4" @default.
- W4241097186 hasLocation W42410971861 @default.
- W4241097186 hasOpenAccess W4241097186 @default.
- W4241097186 hasPrimaryLocation W42410971861 @default.
- W4241097186 hasRelatedWork W1597592026 @default.
- W4241097186 hasRelatedWork W181753131 @default.
- W4241097186 hasRelatedWork W2011430815 @default.
- W4241097186 hasRelatedWork W2065002364 @default.
- W4241097186 hasRelatedWork W2125082339 @default.
- W4241097186 hasRelatedWork W2129789076 @default.