Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for controlling concurrent operation of MySQL database

A database and initiator technology, applied in the database field, can solve problems such as the inability of the MySQL database to provide services stably

Active Publication Date: 2016-06-29
ALIBABA GRP HLDG LTD
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] This application provides a method for controlling the concurrent operations of the MySQL database to solve the problem that the MySQL database may not be able to provide services stably in the case of a large number of concurrent operations

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
  • Method and device for controlling concurrent operation of MySQL database
  • Method and device for controlling concurrent operation of MySQL database
  • Method and device for controlling concurrent operation of MySQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0079] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the application. However, the present application can be implemented in many other ways different from those described here, and those skilled in the art can make similar promotions without violating the connotation of the present application. Therefore, the present application is not limited by the specific implementation disclosed below.

[0080] In this application, a method for controlling concurrent operations of a MySQL database and an apparatus for controlling concurrent operations of a MySQL database are respectively provided, which will be described in detail in the following embodiments.

[0081] Please refer to figure 1 , which is a flow chart of a method embodiment for controlling concurrent operations of a MySQL database of the present application, the method includes the following steps:

[0082] Step 101: Receive a database operation requ...

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 method for controlling concurrent operation of an MySQL database. The method comprises the following steps: receiving a database operation request for the MySQL database; judging whether an index value of representing loading pressure of the MySQL database is smaller than a preset first threshold or not; if so, further processing the database operation request and delivering to a storage engine for execution; and if not, finishing processing of the database operation request. The invention provides a device for controlling the concurrent operation of the MySQL database. By the method disclosed by the invention, the loading pressure of the MySQL database can be accurately controlled; the response time aiming at the database operation request is maintained within a range which can be accepted by an application; and the availability of the whole MySQL database is improved.

Description

technical field [0001] This application relates to the field of databases, in particular to a method for controlling concurrent operations of a MySQL database. The present application also provides a device for controlling concurrent operations of a MySQL database. Background technique [0002] MySQL is an open source relational database management system that speeds up data access and improves flexibility by storing data in different interrelated data tables instead of putting all data in a large warehouse. MySQL supports a variety of plug-in database engines, the mainstream of which is the InnoDB storage engine that supports the transaction mechanism, and also supports MyISAM, BDB, Memory and other storage engines. [0003] The architecture of the MySQL database usually includes two layers. The first layer is the MySQL server layer. All the work before the MySQL database system processes the underlying data is done at this layer, including: client authentication, connecti...

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
IPC IPC(8): G06F17/30
CPCG06F16/00Y02D10/00
Inventor 黄欢欢
Owner ALIBABA GRP HLDG LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products