CN109558242A - A method of promoting database cloud platform resource utilization - Google Patents
A method of promoting database cloud platform resource utilization Download PDFInfo
- Publication number
- CN109558242A CN109558242A CN201811435113.9A CN201811435113A CN109558242A CN 109558242 A CN109558242 A CN 109558242A CN 201811435113 A CN201811435113 A CN 201811435113A CN 109558242 A CN109558242 A CN 109558242A
- Authority
- CN
- China
- Prior art keywords
- database
- usage amount
- cloud platform
- resource utilization
- promoting
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5011—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resources being hardware resources other than CPUs, Servers and Terminals
- G06F9/5016—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resources being hardware resources other than CPUs, Servers and Terminals the resource being the memory
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
Abstract
The invention discloses a kind of methods for promoting database cloud platform resource utilization, obtain the process number of the database instance of all operations on server;According to the memory usage amount of the process in process number inquiry operation system;The CPU usage amount of the process is inquired according to process number;The disk file total size of staqtistical data base example;Compare the specification and actual use amount of database instance;According to comparison result, dilatation is carried out to database instance or capacity reducing is handled.The present invention passes through the process-stats library in analysis operating system, get true database instance memory and cpu resource usage amount, as data-base capacity-enlarging/capacity reducing judgment basis, the resource utilization of database cloud platform is promoted, to promote platform economic benefit.
Description
Technical field
The present invention relates to a kind of method for promoting resource utilization, especially a kind of promotion database cloud platform utilizations of resources
The method of rate.
Background technique
With the extensive application of database cloud platform technology, the importance for promoting hardware resource utilization is also increasingly significant.
Database cloud platform supplier is desirable with existing hardware resource, promotes the quantity of operation data library example to the maximum extent, with
Promote platform economic benefit.Most of database users cannot accurately expect actual resource use demand, therefore flat in cloud
When platform request for data library services, it is intended to using the database instance of more high standard, result in waste of resources.Usual database uses
Person can not obtain the real resource service condition of cloud platform database, therefore have no way of judging whether database specification is super and match.
Summary of the invention
Technical problem to be solved by the invention is to provide a kind of methods for promoting database cloud platform resource utilization, mention
Peaceful economic benefit.
In order to solve the above technical problems, the technical scheme adopted by the invention is that:
A method of promoting database cloud platform resource utilization, it is characterised in that comprise the steps of:
Step 1: the process number of the database instance of all operations on server is obtained;
Step 2: according to the memory usage amount of the process in process number inquiry operation system;
Step 3: the CPU usage amount of the process is inquired according to process number;
Step 4: the disk file total size of staqtistical data base example;
Step 5: compare the specification and actual use amount of database instance;
Step 6: according to comparison result, dilatation is carried out to database instance or capacity reducing is handled.
Further, the step 1 obtains the concrete operations of the process number of the database instance of all operations on server
Process is to execute shell-command: ps-ef | grepmysqld | awk ' { print $ 2 } '.
Further, the step 2 is specially
2.1 obtain the current memory usage amount of process;
2.2 obtain the history maximum memory usage amount of process.
Further, the described 2.1 current memory usage amount specific operation process for obtaining process are to execute shell-command:
GrepVmRSS/proc/ ' process number '/status.
Further, the described 2.2 history maximum memory usage amount specific operation process for obtaining process are to execute shell life
It enables: grepVmHWM/proc/ ' process number '/status.
Further, the step 3 is specially the current CPU usage amount of acquisition process, is counted according to history monitoring information
The maximum CPU usage amount of process.
Further, the step 4 is specially the data file total size of staqtistical data base example, and staqtistical data base is real
The journal file total size of example.
Further, the disk file total size specific operation process of the step 4 staqtistical data base example is to execute
Shell-command: du-sh ' database data catalogue ';Du-sh ' database journal catalogue '.
Further, the step 5 is specially
5.1 comparison database example memory standards and process actual memory usage amount;
5.2 comparison database example CPU specification and the practical CPU usage amount of process;
5.3 comparison database example magnetic disk specifications and process disk usage amount.
Compared with prior art, the present invention having the following advantages that and effect: the present invention by analysis operating system into
Journey staqtistical data base gets true database instance memory and cpu resource usage amount, as data-base capacity-enlarging/capacity reducing
Judgment basis promotes the resource utilization of database cloud platform, to promote platform economic benefit.
Detailed description of the invention
Fig. 1 is a kind of schematic diagram of database cloud platform of the invention.
Specific embodiment
Below by specific embodiment, the present invention is described further, and following embodiment is only to solution of the invention
It releases and the invention is not limited to following embodiments.
As shown in Figure 1, being the schematic diagram of database cloud platform of the invention.As database platform supplier, can use logical
The real resource service condition for crossing various technical method staqtistical data base examples, the data branch as data-base capacity-enlarging or capacity reducing
Support.Based on this, the present invention proposes a kind of method for promoting database cloud platform resource utilization, by counting process real resource
Using database cloud platform resource utilization is promoted, to promote platform economic benefit.Detailed process is as follows for it:
Step 1: the process number of the database instance of all operations on server is obtained;
Specific operation process is to execute shell-command: ps-ef | grepmysqld | awk ' { print $ 2 } '.
Step 2: according to the memory usage amount of the process in process number inquiry operation system;
2.1 obtain the current memory usage amount of process;
Specific operation process is to execute shell-command: grepVmRSS/proc/ ' process number '/status.
2.2 obtain the history maximum memory usage amount of process.
Specific operation process is to execute shell-command: grepVmHWM/proc/ ' process number '/status.
Step 3: the CPU usage amount of the process is inquired according to process number;
The current CPU usage amount of acquisition process counts the maximum CPU usage amount of process according to history monitoring information.
Step 4: the disk file total size of staqtistical data base example;
The data file total size of staqtistical data base example, the journal file total size of staqtistical data base example.Specific behaviour
Make process to execute shell-command: du-sh ' database data catalogue ';Du-sh ' database journal catalogue '.
Step 5: compare the specification and actual use amount of database instance;
5.1 comparison database example memory standards and process actual memory usage amount;
5.2 comparison database example CPU specifications and the practical CPU usage amount of process;
5.3 comparison database example magnetic disk specifications and process disk usage amount.
Step 6: according to comparison result, dilatation is carried out to database instance or capacity reducing is handled.
The present invention by analysis operating system in process-stats library, get true database instance memory and
Cpu resource usage amount promotes the resource utilization of database cloud platform as data-base capacity-enlarging/capacity reducing judgment basis, thus
Promote platform economic benefit.
Above content is only illustrations made for the present invention described in this specification.Technology belonging to the present invention
The technical staff in field can do various modifications or supplement or is substituted in a similar manner to described specific embodiment, only
It should belong to guarantor of the invention without departing from the content or beyond the scope defined by this claim of description of the invention
Protect range.
Claims (9)
1. a kind of method for promoting database cloud platform resource utilization, it is characterised in that comprise the steps of:
Step 1: the process number of the database instance of all operations on server is obtained;
Step 2: according to the memory usage amount of the process in process number inquiry operation system;
Step 3: the CPU usage amount of the process is inquired according to process number;
Step 4: the disk file total size of staqtistical data base example;
Step 5: compare the specification and actual use amount of database instance;
Step 6: according to comparison result, dilatation is carried out to database instance or capacity reducing is handled.
2. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
The specific operation process that step 1 obtains the process number of the database instance of all operations on server is to execute shell-command:
ps–ef|grepmysqld|awk‘{print$2}’。
3. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
Step 2 is specially
2.1 obtain the current memory usage amount of process;
2.2 obtain the history maximum memory usage amount of process.
4. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 3, it is characterised in that: described
The 2.1 current memory usage amount specific operation process for obtaining process are to execute shell-command: grepVmRSS/proc/ ' process
Number '/status.
5. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 3, it is characterised in that: described
2.2 obtain processes history maximum memory usage amount specific operation process be execute shell-command: grepVmHWM/proc/ ' into
Journey number '/status.
6. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
Step 3 is specially the current CPU usage amount of acquisition process, and the maximum CPU usage amount of process is counted according to history monitoring information.
7. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
Step 4 is specially the data file total size of staqtistical data base example, the journal file total size of staqtistical data base example.
8. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
The disk file total size specific operation process of step 4 staqtistical data base example is to execute shell-command: du-sh ' database
Data directory ';Du-sh ' database journal catalogue '.
9. a kind of method for promoting database cloud platform resource utilization described in accordance with the claim 1, it is characterised in that: described
Step 5 is specially
5.1 comparison database example memory standards and process actual memory usage amount;
5.2 comparison database example CPU specifications and the practical CPU usage amount of process;
5.3 comparison database example magnetic disk specifications and process disk usage amount.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811435113.9A CN109558242A (en) | 2018-11-28 | 2018-11-28 | A method of promoting database cloud platform resource utilization |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811435113.9A CN109558242A (en) | 2018-11-28 | 2018-11-28 | A method of promoting database cloud platform resource utilization |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109558242A true CN109558242A (en) | 2019-04-02 |
Family
ID=65867911
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811435113.9A Withdrawn CN109558242A (en) | 2018-11-28 | 2018-11-28 | A method of promoting database cloud platform resource utilization |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109558242A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112272218A (en) * | 2020-10-16 | 2021-01-26 | 苏州浪潮智能科技有限公司 | Cloud platform instance resource operation method and device, computer equipment and storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6636874B1 (en) * | 1998-06-23 | 2003-10-21 | Microsoft Corporation | Generation, validation and reservation of reference handles |
CN101763389A (en) * | 2008-12-23 | 2010-06-30 | 中兴通讯股份有限公司 | Device and method for controlling database resource |
CN106407830A (en) * | 2015-07-29 | 2017-02-15 | 阿里巴巴集团控股有限公司 | Detection method and device of cloud-based database |
CN108737224A (en) * | 2017-09-28 | 2018-11-02 | 新华三技术有限公司 | A kind of message processing method and device based on micro services framework |
-
2018
- 2018-11-28 CN CN201811435113.9A patent/CN109558242A/en not_active Withdrawn
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6636874B1 (en) * | 1998-06-23 | 2003-10-21 | Microsoft Corporation | Generation, validation and reservation of reference handles |
CN101763389A (en) * | 2008-12-23 | 2010-06-30 | 中兴通讯股份有限公司 | Device and method for controlling database resource |
CN106407830A (en) * | 2015-07-29 | 2017-02-15 | 阿里巴巴集团控股有限公司 | Detection method and device of cloud-based database |
CN108737224A (en) * | 2017-09-28 | 2018-11-02 | 新华三技术有限公司 | A kind of message processing method and device based on micro services framework |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112272218A (en) * | 2020-10-16 | 2021-01-26 | 苏州浪潮智能科技有限公司 | Cloud platform instance resource operation method and device, computer equipment and storage medium |
CN112272218B (en) * | 2020-10-16 | 2023-01-06 | 苏州浪潮智能科技有限公司 | Cloud platform instance resource operation method and device, computer equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108848039B (en) | Server, message distribution method and storage medium | |
CN109992350B (en) | Migration method and device for virtual machines in resource pool of cloud computing system | |
TWI738721B (en) | Task scheduling method and device | |
CN104407926A (en) | Scheduling method of cloud computing resources | |
CN104915902A (en) | Cloud platform based implementation method for take-out order online delivery | |
CN103685517A (en) | Storage hierarchical scheduling method and system based on service class characteristics | |
CN102567683A (en) | Cloud computing system and cloud computing realizing method | |
CN103369038A (en) | PaaS (platform as a service) management platform and method | |
CN103561060A (en) | Communication link method under multi-thread environment and transit server | |
CN109558242A (en) | A method of promoting database cloud platform resource utilization | |
CN104915376B (en) | A kind of archival compression method of file in cloud storage | |
CN106250501A (en) | Report processing method and reporting system | |
US20240054110A1 (en) | Method, apparatus and electronic device for creating quantum vehicle model parts basic database, and storage medium | |
CN110737425A (en) | billing platform system application program establishing method and device | |
CN102624757A (en) | Data security access method in cloud computing environment | |
CN113297148B (en) | Method, device and equipment for collecting service log data and readable storage medium | |
CN112437125B (en) | Information concurrent processing method and device, electronic equipment and storage medium | |
CN109240599A (en) | A kind of big data stocking system is integrated | |
CN110855454B (en) | Method and device for extracting timing speed-up user list in PCC network | |
US11580082B2 (en) | Object storage system with control entity quota usage mapping | |
CN102915485A (en) | Medium-sized and small enterprises one-stop service system and method | |
CN203301534U (en) | Virtual machine management platform based on cloud architecture | |
CN109995551B (en) | Service metering method and device of cloud computing system | |
CN104182522A (en) | Secondary indexing method and device on basis of circulation bitmap model | |
CN105656946A (en) | Method for processing logging account, business service terminal and account service terminal |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WW01 | Invention patent application withdrawn after publication | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20190402 |