CN108241700A - 一种基于数据重整的快速恢复MySQL逻辑备份的方法 - Google Patents
一种基于数据重整的快速恢复MySQL逻辑备份的方法 Download PDFInfo
- Publication number
- CN108241700A CN108241700A CN201611222013.9A CN201611222013A CN108241700A CN 108241700 A CN108241700 A CN 108241700A CN 201611222013 A CN201611222013 A CN 201611222013A CN 108241700 A CN108241700 A CN 108241700A
- Authority
- CN
- China
- Prior art keywords
- data
- record
- reference value
- consumption
- value
- 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.)
- Granted
Links
- 238000011084 recovery Methods 0.000 title claims abstract description 19
- 238000000034 method Methods 0.000 title claims abstract description 13
- 238000002407 reforming Methods 0.000 title claims abstract description 7
- 238000012360 testing method Methods 0.000 claims abstract description 20
- 238000005520 cutting process Methods 0.000 claims abstract description 13
- 238000009826 distribution Methods 0.000 claims abstract description 5
- 238000013515 script Methods 0.000 claims description 11
- 241001269238 Data Species 0.000 abstract description 3
- 238000005457 optimization Methods 0.000 description 10
- 230000000694 effects Effects 0.000 description 7
- 238000003780 insertion Methods 0.000 description 7
- 230000037431 insertion Effects 0.000 description 7
- 230000008901 benefit Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 239000000686 essence Substances 0.000 description 3
- 230000009467 reduction Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000005303 weighing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
Description
Claims (1)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611222013.9A CN108241700B (zh) | 2016-12-23 | 2016-12-23 | 一种基于数据重整的快速恢复MySQL逻辑备份的方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611222013.9A CN108241700B (zh) | 2016-12-23 | 2016-12-23 | 一种基于数据重整的快速恢复MySQL逻辑备份的方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108241700A true CN108241700A (zh) | 2018-07-03 |
CN108241700B CN108241700B (zh) | 2020-04-24 |
Family
ID=62702389
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611222013.9A Active CN108241700B (zh) | 2016-12-23 | 2016-12-23 | 一种基于数据重整的快速恢复MySQL逻辑备份的方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108241700B (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109144783A (zh) * | 2018-08-22 | 2019-01-04 | 南京壹进制信息技术股份有限公司 | 一种分布式海量非结构化数据备份方法及系统 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101989305A (zh) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | 数据增量备份方法和系统 |
CN103186624A (zh) * | 2011-12-31 | 2013-07-03 | 北京亿阳信通科技有限公司 | 一种数据同步方法和数据同步装置 |
US20160335162A1 (en) * | 2013-09-18 | 2016-11-17 | International Business Machines Corporation | Optimizing the number and type of database backups to achieve a given recovery time objective (rto) |
CN106155838A (zh) * | 2015-04-24 | 2016-11-23 | 中国移动通信集团河南有限公司 | 一种数据库备份数据恢复方法及装置 |
-
2016
- 2016-12-23 CN CN201611222013.9A patent/CN108241700B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101989305A (zh) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | 数据增量备份方法和系统 |
CN103186624A (zh) * | 2011-12-31 | 2013-07-03 | 北京亿阳信通科技有限公司 | 一种数据同步方法和数据同步装置 |
US20160335162A1 (en) * | 2013-09-18 | 2016-11-17 | International Business Machines Corporation | Optimizing the number and type of database backups to achieve a given recovery time objective (rto) |
CN106155838A (zh) * | 2015-04-24 | 2016-11-23 | 中国移动通信集团河南有限公司 | 一种数据库备份数据恢复方法及装置 |
Non-Patent Citations (4)
Title |
---|
CSND: "Mybatis批量插入引发的血案", 《HTTPS://BLOG.CSDN.NET/SYY_C_J/ARTICLE/DETAILS/52151402》 * |
博客园: "MYSQL开发性能研究——批量插入的优化措施", 《HTTPS://WWW.CNBLOGS.COM/AICRO/P/3851434.HTML》 * |
博客园: "大数据量下MYSQL插入方法的性能比较", 《HTTPS://WWW.CNBLOGS.COM/ALIGHT/P/4484812.HTML》 * |
脚本之家: "MySQL实现批量插入以优化性能的教程", 《HTTPS://WWW.JB51.NET/ARTICLE/63895.HTM》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109144783A (zh) * | 2018-08-22 | 2019-01-04 | 南京壹进制信息技术股份有限公司 | 一种分布式海量非结构化数据备份方法及系统 |
CN109144783B (zh) * | 2018-08-22 | 2020-08-18 | 南京壹进制信息科技有限公司 | 一种分布式海量非结构化数据备份方法及系统 |
Also Published As
Publication number | Publication date |
---|---|
CN108241700B (zh) | 2020-04-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Wang et al. | Performance prediction for apache spark platform | |
Poess et al. | TPC-DI: the first industry benchmark for data integration | |
CN104850411B (zh) | 存储系统基准评测程序生成方法及装置 | |
US6708185B2 (en) | SQL execution analysis | |
CN108388515A (zh) | 测试数据生成方法、装置、设备以及计算机可读存储介质 | |
US10101796B2 (en) | Processor power estimation | |
CN109165153A (zh) | 一种高仿真证券业交易类系统的性能测试方法 | |
JP2016100006A (ja) | パフォーマンス試験のためのベンチマーク・アプリケーションを生成する方法および装置 | |
US9092577B2 (en) | Method for generating test data for evaluating program execution performance | |
CN107168868B (zh) | 一种基于采样和集成学习的软件更改缺陷预测方法 | |
Schlagkamp et al. | Understanding user behavior: from HPC to HTC | |
O'neal et al. | GPU performance estimation using software rasterization and machine learning | |
US20140143525A1 (en) | Systems and methods for data generation | |
Ehatäht | NANOAOD: a new compact event data format in CMS | |
CN108241700A (zh) | 一种基于数据重整的快速恢复MySQL逻辑备份的方法 | |
CN106776779A (zh) | 基于Mac平台的JSON数据生成实体文件的方法 | |
Islam et al. | Measuring energy footprint of software features | |
CN111341391B (zh) | 一种用于异构集群环境中的自由能微扰计算调度方法 | |
CN114880224A (zh) | 软件性能测试的方法、装置、存储介质以及电子设备 | |
Tiwari et al. | Identification of critical parameters for MapReduce energy efficiency using statistical Design of Experiments | |
CN109669827B (zh) | 一种BIOS模块TurboMode功能的自动化测试方法 | |
Iman et al. | Comparison of several rank tests for the two-way layout | |
Koller | Replication code for simulation studies | |
Liu et al. | An automatic testing platform for object-oriented software based on code coverage | |
CN115543719B (zh) | 基于芯片设计的组件优化方法、装置、计算机设备及介质 |
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 | ||
CB02 | Change of applicant information | ||
CB02 | Change of applicant information |
Address after: 210014 three floor, building five, five, Bai Xia hi tech park, No. 5, Yong Zhi Road, Qinhuai District, Nanjing, Jiangsu. Applicant after: NANJING UNARY INFORMATION TECHNOLOGY Co.,Ltd. Address before: 210014 three floor, building five, five, Bai Xia hi tech park, No. 5, Yong Zhi Road, Qinhuai District, Nanjing, Jiangsu. Applicant before: NANJING UNARY INFORMATION TECHNOLOGY Inc.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP03 | Change of name, title or address | ||
CP03 | Change of name, title or address |
Address after: Building 1, 6th Floor, Changfeng Building, No.14 Xinghuo Road, Research and Innovation Park, Jiangbei New District, Nanjing City, Jiangsu Province, 210000 Patentee after: Aerospace One System (Jiangsu) Information Technology Co.,Ltd. Address before: 210014 three floor, building five, five, Bai Xia hi tech park, No. 5, Yong Zhi Road, Qinhuai District, Nanjing, Jiangsu. Patentee before: NANJING UNARY INFORMATION TECHNOLOGY Co.,Ltd. |