| Presentation | 2015-09-25 DBMS Performance Improvement based on Dynamic VM Memory Allocation Masaki Sakamoto, Saneyasu Yamaguchi, |
|---|---|
| PDF Download Page |  PDF download Page Link |
| Abstract(in Japanese) | (See Japanese page) |
| Abstract(in English) | In virtualized environment, several computers run on a physical computer. Many of virtualization systems have a ballooning function with which memory allocation size for a virtual machine can be dynamically changed without restarting the virtual machine. Thus, it is expected that performance of an applications in a virtual machine can be improved by dynamic optimization of the virtual machine memory size. Xen also has a ballooning function, which is called xenballoon. It takes account of only memories consumed by processes and does not consider page cache memory size. Therefore, I/O performance improvement cannot be expected with this ballooning fiction. In this paper, we focus on Xen virtualized environment and DBMS, and discuss a method for improving I/O performance by dynamic optimization of memory allocation size of virtual machines. First, we investigate relation among virtual machine memory size, page cache hit ratio in the guest OS, and DBMS performance. Then, we show that leading cache hit ratio to a target ratio, which is not 100%, is effective in DBMS performance improvement. Second, we propose a method for improving DBMS performance based on cache hit ratio. Third, we evaluate our prosed method with TPC-C, which is a popular DBMS benchmark specification, and demonstrate that our method can improve DBMS performance by dynamic tuning of virtual machine memory size. |
| Keyword(in Japanese) | (See Japanese page) |
| Keyword(in English) | balloon / virtual machine / Xen |
| Paper # | DE2015-27 |
| Date of Issue | 2015-09-17 (DE) |
| Conference Information | |
| Committee | DE |
|---|---|
| Conference Date | 2015/9/24(2days) |
| Place (in Japanese) | (See Japanese page) |
| Place (in English) | |
| Topics (in Japanese) | (See Japanese page) |
| Topics (in English) | Data Engineering and Food Media |
| Chair | Masato Oguchi(Ochanomizu Univ.) |
| Vice Chair | Makoto Onizuka(Osaka Univ.) / Masashi Toyoda(Univ. of Tokyo) |
| Secretary | Makoto Onizuka(Univ. of Electro-Comm.) / Masashi Toyoda(Kyushu Univ.) |
| Assistant | Mayuki Ueda(Univ. of Marketing and Distrbution Science) / Daisuke Kitayama(Kogakuin Univ.) |
| Paper Information | |
| Registration To | Technical Committee on Data Engineering |
|---|---|
| Language | JPN |
| Title (in Japanese) | (See Japanese page) |
| Sub Title (in Japanese) | (See Japanese page) |
| Title (in English) | DBMS Performance Improvement based on Dynamic VM Memory Allocation |
| Sub Title (in English) | |
| Keyword(1) | balloon |
| Keyword(2) | virtual machine |
| Keyword(3) | Xen |
| 1st Author's Name | Masaki Sakamoto |
| 1st Author's Affiliation | Kogakuin University(Kogakuin Univ.) |
| 2nd Author's Name | Saneyasu Yamaguchi |
| 2nd Author's Affiliation | Kogakuin University(Kogakuin Univ.) |
| Date | 2015-09-25 |
| Paper # | DE2015-27 |
| Volume (vol) | vol.115 |
| Number (no) | DE-230 |
| Page | pp.pp.41-46(DE), |
| #Pages | 6 |
| Date of Issue | 2015-09-17 (DE) |