A method for analysis and solution of scalability bottleneck in DBMS

Takashi Horikawa, Akira Fukuda

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Many-core systems differ from traditional multi-processor systems in performance characteristics and sometimes behave in unfamiliar ways for us. This can lead us facing performance troubles from unknown causes, requiring long time to fix them. To address those situations it is important for us to accumulate technology and know-how on performance of multi-core systems through a plenty of case studies. This paper describes a case study on unusual phenomena of a many-core based system in executing DBT-1 transactions with MySQL; where system throughput was decreased with the increase of the number of cores, an appearance of a scalability bottleneck. The root-cause analysis based on several measurements of the system has succeeded to reveal that the problem was caused from an interaction between two bottlenecks at the different layers, hardware and software, which is hardly found in traditional systems. The bottleneck at the hardware layer has been alleviated by introducing a newly developed lock mechanism that the analysis results suggested. Although the problem may be particular to the system, we, however, believe that the method and process to identify the root cause are of wide use for various scalability bottlenecks.

Original languageEnglish
Title of host publicationProceedings of Symposium on Information and Communication Technology, SoICT2010
Pages139-146
Number of pages8
DOIs
Publication statusPublished - Nov 22 2010
EventSymposium on Information and Communication Technology, SoICT 2010 - Hanoi, Viet Nam
Duration: Aug 27 2010Aug 28 2010

Publication series

NameACM International Conference Proceeding Series

Other

OtherSymposium on Information and Communication Technology, SoICT 2010
CountryViet Nam
CityHanoi
Period8/27/108/28/10

All Science Journal Classification (ASJC) codes

  • Software
  • Human-Computer Interaction
  • Computer Vision and Pattern Recognition
  • Computer Networks and Communications

Fingerprint Dive into the research topics of 'A method for analysis and solution of scalability bottleneck in DBMS'. Together they form a unique fingerprint.

Cite this