A Study on the Analysis of the Effectiveness according to Buffer Size of Storage

Most of the present DMBSs have parameters to set the size of data buffer caching in a memory, and disc I/O can be reduced, as the buffer size is greatly reduced, because data pages caching in a buffer increase. Whereas greatly setting this parameter value makes a memory occupy a system excessively, and the buffer pool may be swapped by system's operating system.This article compared and analyzed efficiency of each storage medium, by changing the size of data buffer caching in a memory, after connecting DBMS with a storage medium. According to the result of the test, both performances of storage media increased, as the buffer size was greatly reduced. Seeing that D-SSD's performance and HDD's performance changed from above 1GB and 2GB, respectively, it is supposed that there is no need to cut down the buffer size infinitely, because performance doesn't change from a certain section, although it improves, as the buffer size highly decreases. It isn't necessary to expand the buffer size greatly under the small load, since there was no change of performance, even when the buffer size was greatly increased under the small load. While DSSD also can maintain its performance without any big change, if it exceeds the scope of capacity that the buffer can process, HDD shows a considerable reduction of performance. Therefore, it is likely that unlike HDD, for D-SSD, tuning the buffer size isn't needed. However, there is a need of conducting a test in an actual service environment in future, because these results came from the test in a single server.