Disk performance evaluating method based on database

A database and disk technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as comparing disks, and achieve the effect of clear data, simple test commands, and good ease of use

Inactive Publication Date: 2015-12-09
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0014] Because there are too many factors affecting disk performance, it is difficult to compare the differences between disks from the surface data, and it is necessary to find a reasonable means to compare the first-pass data;

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Disk performance evaluating method based on database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0080] Such as figure 1 Shown, a kind of disk performance evaluation method based on database, described method is based on the disk performance evaluation of database aspect, checks the performance status of disk in the server to the actual application of database, and concrete process is as follows:

[0081] 1. Install the system and configure system parameters: prepare the application server according to the actual application, install the operating system, and configure the system parameters;

[0082] 2. Install the database and configure the database parameters: install the database GP, and configure the relevant user and environment variable parameters;

[0083] 3. Debug the database environment: configure the database environment according to the system information, and establish relevant files for subsequent testing;

[0084] 4. Configure the disk and conduct a disk performance test: partition the disk to be tested and mount it to the system, execute the test command ...

Embodiment 2

[0088] On the basis of Embodiment 1, the specific process of installing the system and configuring system parameters described in this embodiment is as follows:

[0089] Install the operating system according to the requirements, which can support RHEL, Centos, and SUSE series operating systems; the system is recommended to be fully installed to facilitate subsequent configuration of system parameters;

[0090] Kernel parameter settings:

[0091] Set the following parameters into the / etc / sysctl.conf file, and then run sysctl-p to make it take effect; these parameters should not be modified casually, they will be strictly checked when gpcheck is executed later, if they are found to be different from them, an error will be reported .

[0092] kernel.shmmax=500000000

[0093] kernel.shmmni=4096

[0094] kernel.shmall=4000000000

[0095] kernel.sem=2505120001002048

[0096] kernel.sysrq=1

[0097] kernel.core_uses_pid=1

[0098] kernel.msgmnb=65536

[0099] kernel.msgmax=...

Embodiment 3

[0117] On the basis of Embodiment 1, the process of installing the database and configuring the database parameters described in this embodiment is as follows:

[0118] Install the database:

[0119] Log in to the host as root to install Greenplumbinaries;

[0120] # / bin / bashgreenplum-db-*.bin has different version names under different systems;

[0121] Create a gpadmin user;

[0122] [rootgreenplumtmp]#useraddgpadmin

[0123] [rootgreenplumtmp]#passwdgpadmin

[0124] Changing password for user gpadmin.

[0125] New UNIX password:

[0126] BADPASSWORD:itisbasedonadictionaryword

[0127] RetypenewUNIXpassword:

[0128] passwd: allauthentication token updated successfully.

[0129] Create seg_hosts and all_hosts files and edit them;

[0130] Because this embodiment only uses one server, which is used as both the Master node and the Segment node, therefore, the content of these two files only needs to fill in a host name. In the environment of multiple servers, it needs...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a disk performance evaluating method based on a database. According to the method, based on disk performance evaluation on the aspect of the database, the performance condition of a disk in a server on the practical application of the database is detected. The method specifically comprises the steps that a system is installed, and parameters of the system are configured, wherein an application server is prepared according to a practical application, the operation system is installed, and the parameters of the system are configured; the database is installed, and parameters of the database are configured, wherein a database GP is installed, and related user and environment variable parameters are configured; the database environment is debugged, wherein the database environment is configured according to system information, and related files are established to facilitate subsequent tests; the disk is configured, and the performance of the disk is tested; the disk needing to the tested is partitioned and mounted in the system, and a testing command is executed to carry out reading-writing operation on the disk; the reading-writing performance condition of the disc is checked according to a result; the implementing steps are completed in the server provided with the operation system with a linux kernel, and a user logs into the server with the root identity in operation.

Description

technical field [0001] The invention relates to the technical field of computer servers, in particular to a database-based disk performance evaluation method, a flexible disk performance evaluation method applicable to various server products. Background technique [0002] With the continuous development of technology in the IT field, traditional information services and increasingly powerful cloud computing services have increasingly complex server requirements. As a server product provider, the quality of a server lies in whether it can meet different application requirements. As the number of disks on a single machine increases and the capacity of disks increases, different disks have different impacts on database applications; in this case, for database applications, it is very important to evaluate the performance of disks. necessary. By comparing the data of different disks and different arrays, you can find a disk that is more suitable for database applications and ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F3/06G06F17/30
Inventor 刘云飞
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap