Control device, control method, and recording medium
AssigneeNippon Telegraph and Telephone Corporation
InventorTakaaki KOYAMA
Life of this patent
Estimating the term…
Abstract
A control device according to the present invention includes: a memory; and processing circuitry coupled to the memory and configured to: detect a state of access to table data stored in a first logical disk of a physical disk and to which first data is written and a state of access to a write ahead log (WAL) stored in a second logical disk of the physical disk and to which second data is written or to a WAL stored in a second storage medium different from the physical disk and to which the second data is written, and acquire an I/O use ratio of the WAL and an I/O use ratio of the table data, and set a writing destination of the second data to one of the WAL stored in the second logical disk and the WAL stored in the second storage medium.
Claims7
A control device comprising:
- a memory;
- and
- processing circuitry coupled to the memory and configured to:
- detect a state of access to table data stored in a first logical disk of a physical disk and to which first data is written and a state of access to a write ahead log (WAL) stored in a second logical disk of the physical disk and to which second data is written or to a WAL stored in a second storage medium different from the physical disk and to which the second data is written, and acquire an I/O use ratio of the WAL and an I/O use ratio of the table data, and
- set a writing destination of the second data to one of the WAL stored in the second logical disk and the WAL stored in the second storage medium based on an average of the I/O use ratio of the WAL and the I/O use ratio of the table data acquired at the acquiring.
A control method comprising:
- detecting a state of access to table data stored in a first logical disk of a physical disk and to which first data is written and a state of access to a WAL stored in a second logical disk of the physical disk and to which second data is written or to a WAL stored in a second storage medium different from the physical disk and to which a small amount of high-frequency data is written, and acquiring an I/O use ratio of the WAL and an I/O use ratio of the table data, by a processor;
- and
- setting a writing destination of the second data to one of the WAL stored in the second logical disk and the WAL stored in the second storage medium based on an average of the I/O use ratio of the WAL and the I/O use ratio of the table data acquired at the acquiring.
A non-transitory computer-readable recording medium storing therein a control program that causes a computer to execute a process comprising:
- detecting a state of access to table data stored in a first logical disk of a physical disk and to which first data is written and a state of access to a WAL stored in a second logical disk of the physical disk and to which second data is written or to a WAL stored in a second storage medium different from the physical disk and to which a small amount of high-frequency data is written, and acquiring an I/O use ratio of the WAL and an I/O use ratio of the table data;
- and
- setting a writing destination of the second data to one of the WAL stored in the second logical disk and the WAL stored in the second storage medium based on an average of the I/O use ratio of the WAL and the I/O use ratio of the table data acquired at the acquiring.
Dependencies are inferred from the claim text.