Database test method and device

A testing method and testing device technology, applied in the database field, can solve problems such as the inability to accurately reflect the real performance of the MySQL database

Active Publication Date: 2016-03-30
ALIBABA GRP HLDG LTD
View PDF10 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the prior art, since MySQL performance testing generally uses sample data generated by random programs for database performance testing, the test results cannot accurately reflect the real performance of the MySQL database

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
  • Database test method and device
  • Database test method and device
  • Database test method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] In the prior art, MySQL database testing usually adopts the following approach:

[0054] Configure the same machine as the online database;

[0055] Synchronize the online data table to the performance database;

[0056] According to the rules of online business data, sample data of the same amount as online is basically generated through a random program.

[0057] Understand the business to get the business logic, and perform pressure testing through the pressure testing tool according to this logic.

[0058] In the above database testing method, the test data used is randomly generated, and the randomly generated test data is different from the real data of the online database in terms of data volume and data distribution, and the configured test scenarios cannot Reflect the real database running status. Therefore, the database test results obtained by using this test method will not accurately reflect the real performance of the database.

[0059]为解决上述问题,本申请实施例通过...

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

A database test method and device are provided; the method comprises the following steps: stopping a backup database from copying a main database, wherein the backup database is the backup database for the main database; obtaining a first data operation request on the main database in a preset time; starting a second data operation request on the backup database according to the obtained first data operation request on the main database in the preset time; carrying out database test for the backup database when the backup database executes corresponding data operation according to the received second data operation request, thus obtaining a database test result. The method and device can effectively improve database test result accuracy.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a database testing method and device. Background technique [0002] MySQL, an open-source relational database management system, belongs to small and medium-sized relational database management systems. It stores data in different tables instead of putting all the data together, so it can improve data processing speed. and flexibility. MySQL database system, which uses the most commonly used database management language - Structured Query Language (StructuredQueryLanguage, referred to as SQL) for database management. The MySQL database is open source, with small size, fast speed, and low cost, especially this feature, which makes MySQL popular with developers of small and medium-sized websites in general, and uses it as a website database. [0003] MySQL database performance test can help users understand the performance of MySQL database. In the prior art, because...

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): G06F11/14G06F17/30
Inventor 陈锦赋李圣陶和利孙莎莎戴其量
Owner ALIBABA GRP HLDG 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