원문정보
초록
영어
This study analyzed the ad-hoc query processing capability according to changes of parameter values by performing TPC-H benchmark with 1GB database targeting HDD to find out optimized parameters of INNODB storage engine type parameters of MYSQL in accordance with data storage device. As a result of performing test for three parameters(innodb_buffer_pool_size, inndb_additional_mem_pool_size, innodb_log_buffer_size) among INNODB storage engine type parameters that are known to affect performance, as innodb_buffer_pool_size got bigger, QphH(Query- per-Hour) got better but the rest two parameters couldn’t affect QphH. Therefore, more researches about the case that the types of data storage device of servers are different from one another and bigger database capacity.
목차
1. Introduction
2. Related Study
2.1. TPC-H
2.2. Storage Engine Type
3. Performance Analysis Environment and Conditions
3.1. Performance Test Environment
3.2. Test Procedure and Condition
4. Test Results
5. Conclusion
References