000177575 001__ 177575
000177575 005__ 20190416055810.0
000177575 037__ $$aCONF
000177575 245__ $$aOLTP on Hardware Islands
000177575 269__ $$a2012
000177575 260__ $$c2012
000177575 336__ $$aConference Papers
000177575 520__ $$aModern hardware is abundantly parallel and increasingly heterogeneous. The numerous processing cores have non-uniform access latencies to the main memory and to the processor caches, which causes variability in the communication costs. Unfortunately, database systems mostly assume that all processing cores are the same and that microarchitecture differences are not significant enough to appear in critical database execution paths. As we demonstrate in this paper, however, hardware heterogeneity does appear in the critical path and conventional database architectures achieve suboptimal and even worse, unpredictable performance. We perform a detailed performance analysis of OLTP deployments in servers with multiple cores per CPU (multicore) and multiple CPUs per server (multisocket). We compare different database deployment strategies where we vary the number and size of independent database instances running on a single server, from a single shared-everything instance to fine-grained shared-nothing configurations. We quantify the impact of non-uniform hardware on various deployments by (a) examining how efficiently each deployment uses the available hardware resources and (b) measuring the impact of distributed transactions and skewed requests on different workloads. Finally, we argue in favor of shared-nothing deployments that are topology- and workload-aware and take advantage of fast on-chip communication between islands of cores on the same socket.
000177575 700__ $$0244478$$g199720$$aPorobic, Danica
000177575 700__ $$aPandis, Ippokratis
000177575 700__ $$aBranco, Miguel
000177575 700__ $$0244143$$g190851$$aTözün, Pinar
000177575 700__ $$aAilamaki, Anastasia$$g177957$$0243527
000177575 7112_ $$dAugust 27 - 31, 2012$$cIstanbul, Turkey$$a38th International Conference on Very Large Databases
000177575 773__ $$j5$$tProceedings of the VLDB Endowment (PVLDB)$$k11$$q1447-1458
000177575 8564_ $$uhttps://infoscience.epfl.ch/record/177575/files/paper581-islands.pdf$$zPreprint$$s874396$$yPreprint
000177575 909C0 $$xU11836$$0252224$$pDIAS
000177575 909CO $$ooai:infoscience.tind.io:177575$$qGLOBAL_SET$$pconf$$pIC
000177575 917Z8 $$x199720
000177575 917Z8 $$x199720
000177575 917Z8 $$x199720
000177575 917Z8 $$x188175
000177575 917Z8 $$x199720
000177575 917Z8 $$x190851
000177575 937__ $$aEPFL-CONF-177575
000177575 973__ $$rREVIEWED$$sPUBLISHED$$aEPFL
000177575 980__ $$aCONF