Optimal strategies for spinning and blocking
Journal of Parallel and Distributed Computing
Performance measurements for multithreaded programs
SIGMETRICS '98/PERFORMANCE '98 Proceedings of the 1998 ACM SIGMETRICS joint international conference on Measurement and modeling of computer systems
Characteristics of scalability and their impact on performance
Proceedings of the 2nd international workshop on Software and performance
The Performance of Spin Lock Alternatives for Shared-Memory Multiprocessors
IEEE Transactions on Parallel and Distributed Systems
ACM SIGOPS Operating Systems Review
Critical sections: re-emerging scalability concerns for database storage engines
Proceedings of the 4th international workshop on Data management on new hardware
Shore-MT: a scalable storage manager for the multicore era
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
A new look at the roles of spinning and blocking
Proceedings of the Fifth International Workshop on Data Management on New Hardware
Static data race detection for concurrent programs with asynchronous calls
Proceedings of the the 7th joint meeting of the European software engineering conference and the ACM SIGSOFT symposium on The foundations of software engineering
A method for analysis and solution of scalability bottleneck in DBMS
Proceedings of the 2010 Symposium on Information and Communication Technology
Trace-Based symbolic analysis for atomicity violations
TACAS'10 Proceedings of the 16th international conference on Tools and Algorithms for the Construction and Analysis of Systems
Towards software performance engineering for multicore and manycore systems
ACM SIGMETRICS Performance Evaluation Review
| Hi-index | 0.00 |
ACID-compliant DBMSs are said to be difficult to scale their performance by using many more processors, which means that they are difficult to enjoy the benefits of recent many-core systems that widespread use of multi-core processors has made practicable. Since DBMSs are indispensable in most of IT systems, scalability issues should be addressed to fulfill the demand of handling large quantity of data. This paper proposes a viable approach for solving scalability issue, in which lock-related bottleneck will be identified from event trace based measurements and scalability will be improved by replacing the bottleneck-lock with fine-grained locks. This paper also describes a case study on the application of the proposed method, in which the scalability of a many-core system in executing DBT-1 transactions with MySQL adopting the InnoDB storage engine has been successfully improved. Since applying the proposed method produced the increase in maximum throughput of the 16-CPU system by 1.6 times, the method is promising, as long as lock-related bottlenecks are of concern.