Method for testing performance of magnetic disc database

Abstract

The invention provides a method for testing a performance of a magnetic disc database. The method comprises the following steps: simulating a user database application, and using an iometer tool and scripts, such as sequential writing, random writing, sequential reading, random reading, and the like, to test the performance of a magnetic disc and the execution time of a database script when the magnetic disc does not adopt a data block for execution, thus basically grasping the holding capacity of the magnetic disc to a database, enabling a user to carry out corresponding database calling according to the data conveniently and also enabling a customer to replace different magnetic disc systems according to actual demands conveniently. By virtue of the test method, the performance of the magnetic disc of a tested machine and a relevance between the performance and an actual test of the database are confirmed, if the writing time of the database is long and simultaneously a test shows that the writing disc performance of the same data block is really low, the performance of the magnetic disc is determined as being unsuitable for carrying out the database application by the user, a new magnetic disc controller is required to be replaced or the database is required to be called, and a more appropriate size of a data block is selected.

Description

[0001] technical field [0002] The invention relates to a computer database technology, in particular to a method for testing the performance of a disk database. Background technique [0003] Users report that the disk performance of the machine configuration is poor and cannot meet the needs of the actual operation of the database. Generally, in this case, we need to re-test the performance of the user's hard disk and database performance. There is no relevant report and standard on the support of the disk to the database in advance. . Contents of the invention [0004] The purpose of this invention is to provide a kind of disk database performance test method [0005] The purpose of the present invention is realized in the following manner, simulate user database application, use the iometer tool and the script of database continuous writing, random writing, continuous reading, random reading, test the performance of the disk when the disk is not executed with data blo...

AI Technical Summary

Problems solved by technology

[0003] Users report that the disk performance of the machine configuration is poor and cannot meet the needs of the actual operation of the database. Generally, in this case, we need to re-test the performance of the user's hard disk and database performance. There is no relevant report and standard on the support of the disk to the database in advance.