Database capacity control method and database capacity control device
A capacity control, database technology, applied in the field of database systems, can solve the problem of client sending call request and so on
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0048] Embodiments of the present invention provide a database capacity control method, such as figure 1 shown, including:
[0049] 101. The database capacity control device determines statistical characteristic information of a database.
[0050] Among them, the statistical feature information in this embodiment includes the number of times the application reads and writes to the database within a specific time period, the average disk space usage rate of the database within a specific time period, or the number of times the application requests to establish a connection with the database within a specific time period. At least one of the number of requests.
[0051] The embodiment of the present invention provides a database capacity control method, by detecting the statistical feature information of the database corresponding to the database capacity control device, determining whether the statistical feature information meets the preset conditions, and then deciding wheth...
Embodiment 2
[0065] Embodiments of the present invention provide a database capacity control method, such as figure 2 shown, including:
[0066] 201. The database capacity control device generates a statistical feature information table in response to a monitoring instruction.
[0067] Wherein, the statistical feature information table is used to count at least one of the number of reads and writes to the database by each application, the disk space usage rate of the database, and the number of connections between each application and the database within a preset time period.
[0068] Optionally, as shown in Table 1, in order to facilitate understanding of the statistical feature information table, we give a possible form.
[0069] Table 1
[0070]
[0071] Wherein, the first threshold value, the second threshold value and the third threshold value in Table 1 are empirical values preset by those skilled in the art according to corresponding technical means.
[0072] 202. The datab...
Embodiment 3
[0092] Embodiments of the present invention provide a database capacity control device, such as image 3 shown, including:
[0093] The statistical unit 01 is used to determine the statistical feature information of the database; the statistical feature information includes the number of reads and writes to the database by the application within a certain period of time, the average value of the disk space usage of the database within a certain period of time, or the average value of the disk space used by the application within a certain period of time At least one of the number of requests to establish a connection with the database;
[0094] The processing unit 02 is configured to prevent the application's request for the database from being sent to the database if the statistical characteristic information satisfies a preset condition.
[0095] Further, as Figure 4 As shown, the device also includes:
[0096] The judging unit 03 is used for when the statistical feature...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More 