Skip to main content

2020 | OriginalPaper | Buchkapitel

Quantitative Contention Generation for Performance Evaluation on OLTP Databases

verfasst von : Chunxi Zhang, Rong Zhang, Weining Qian, Ke Shu, Aoying Zhou

Erschienen in: Web and Big Data

Verlag: Springer International Publishing

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Although we have achieved significant progress in improving the scalability of transactional database systems (OLTP), the presence of contention operations in workloads is still the fundamental limitation in improving throughput. The reason is that the overhead of managing conflict transactions with concurrency control mechanism is proportional to the amount of contentions. As a consequence, contention workload generation is urgent to evaluate performance of modern OLTP database systems. Though we have kinds of standard benchmarks which provide some ways in simulating resource contention, e.g. skew distribution control of transactions, they can not control the generation of contention quantitatively; even worse, the simulation effectiveness of these methods is affected by the scale of data. So in this paper we design a scalable quantitative contention generation method with fine contention granularity control, which is expected to generate resource contention specified by contention ratio and contention intensity.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Aditya, G., Dheren, G., Fei, Z., Amit, P., Zhan, F.M.: Btrim: hybrid in-memory database architecture for extreme transaction processing in VLDBS. In: VLDB, pp. 1889–1901 (2018) Aditya, G., Dheren, G., Fei, Z., Amit, P., Zhan, F.M.: Btrim: hybrid in-memory database architecture for extreme transaction processing in VLDBS. In: VLDB, pp. 1889–1901 (2018)
2.
Zurück zum Zitat Appuswamy, R., Anadiotis, A.C., Porobic, D., Iman, M.K., Ailamaki, A.: Analyzing the impact of system architecture on the scalability of oltp engines for high-contention workloads. VLDB 11(2), 121–134 (2017) Appuswamy, R., Anadiotis, A.C., Porobic, D., Iman, M.K., Ailamaki, A.: Analyzing the impact of system architecture on the scalability of oltp engines for high-contention workloads. VLDB 11(2), 121–134 (2017)
3.
Zurück zum Zitat Cahill, M.J., Röhm, U., Fekete, A.D.: Serializable isolation for snapshot databases. TODS 34(4), 20 (2009)CrossRef Cahill, M.J., Röhm, U., Fekete, A.D.: Serializable isolation for snapshot databases. TODS 34(4), 20 (2009)CrossRef
4.
Zurück zum Zitat Chen, S., Ailamaki, A., Athanassoulis, M., et al.: TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study. SIGMOD 39(3), 5–10 (2011)CrossRef Chen, S., Ailamaki, A., Athanassoulis, M., et al.: TPC-C: characterizing the new TPC-E benchmark via an I/O comparison study. SIGMOD 39(3), 5–10 (2011)CrossRef
5.
Zurück zum Zitat Chunxi, Z., Yuming, L., Rong, Z., et al.: Benchmarking on intensive transaction processing. Front. J. Higher Educ. Press, 14, 145–204 (2019) Chunxi, Z., Yuming, L., Rong, Z., et al.: Benchmarking on intensive transaction processing. Front. J. Higher Educ. Press, 14, 145–204 (2019)
6.
Zurück zum Zitat Cooper, B.F., Silberstein, A., Tam, E., Ramakrishnan, R., Sears, R.: Benchmarking cloud serving systems with YCSB. In: Proceedings of the 1st ACM Symposium on Cloud Computing, pp. 143–154. ACM (2010) Cooper, B.F., Silberstein, A., Tam, E., Ramakrishnan, R., Sears, R.: Benchmarking cloud serving systems with YCSB. In: Proceedings of the 1st ACM Symposium on Cloud Computing, pp. 143–154. ACM (2010)
7.
Zurück zum Zitat Harding, R., Aken, D.V., Pavlo, A., Stonebraker, M.: An evaluation of distributed concurrency control. VLDB 10(5), 553–564 (2017) Harding, R., Aken, D.V., Pavlo, A., Stonebraker, M.: An evaluation of distributed concurrency control. VLDB 10(5), 553–564 (2017)
8.
Zurück zum Zitat Huang, G., et al.: X-engine: an optimized storage engine for large-scale e-commerce transaction processing. In: SIGMOD, pp. 651–665. ACM (2019) Huang, G., et al.: X-engine: an optimized storage engine for large-scale e-commerce transaction processing. In: SIGMOD, pp. 651–665. ACM (2019)
10.
Zurück zum Zitat Ren, K., Faleiro, J.M., Abadi, D.J.: Design principles for scaling multi-core OLTP under high contention. In: SIGMOD, pp. 1583–1598. ACM (2016) Ren, K., Faleiro, J.M., Abadi, D.J.: Design principles for scaling multi-core OLTP under high contention. In: SIGMOD, pp. 1583–1598. ACM (2016)
11.
Zurück zum Zitat Ronstrom, M., Thalmann, L.: Mysql cluster architecture overview. MySQL Technical White Paper (2004) Ronstrom, M., Thalmann, L.: Mysql cluster architecture overview. MySQL Technical White Paper (2004)
12.
Zurück zum Zitat Stonebraker, M.: A measure of transaction processing power. In: Readings in Database Systems, pp. 442–454 (1994) Stonebraker, M.: A measure of transaction processing power. In: Readings in Database Systems, pp. 442–454 (1994)
13.
Zurück zum Zitat Wolski, A.: TATP benchmark description (version 1.0) (2009) Wolski, A.: TATP benchmark description (version 1.0) (2009)
14.
Zurück zum Zitat Zhou, N., Zhou, X., Zhang, X., Du, X., Wang, S.: Reordering transaction execution to boost high-frequency trading applications. Data Sci. Eng. 2(4), 301–315 (2017)CrossRef Zhou, N., Zhou, X., Zhang, X., Du, X., Wang, S.: Reordering transaction execution to boost high-frequency trading applications. Data Sci. Eng. 2(4), 301–315 (2017)CrossRef
Metadaten
Titel
Quantitative Contention Generation for Performance Evaluation on OLTP Databases
verfasst von
Chunxi Zhang
Rong Zhang
Weining Qian
Ke Shu
Aoying Zhou
Copyright-Jahr
2020
DOI
https://doi.org/10.1007/978-3-030-60290-1_34

Neuer Inhalt