CN107368498A - 优化MySQL悲观锁的锁等待超时时间的方法及装置 - Google Patents
优化MySQL悲观锁的锁等待超时时间的方法及装置 Download PDFInfo
- Publication number
- CN107368498A CN107368498A CN201610318817.2A CN201610318817A CN107368498A CN 107368498 A CN107368498 A CN 107368498A CN 201610318817 A CN201610318817 A CN 201610318817A CN 107368498 A CN107368498 A CN 107368498A
- Authority
- CN
- China
- Prior art keywords
- time
- lock
- waits
- out time
- pessimistic
- 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
Classifications
-
- 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/23—Updating
- G06F16/2308—Concurrency control
- G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
- G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
-
- 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/23—Updating
- G06F16/2308—Concurrency control
- G06F16/2315—Optimistic concurrency control
- G06F16/2322—Optimistic concurrency control using timestamps
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610318817.2A CN107368498B (zh) | 2016-05-13 | 2016-05-13 | 优化MySQL悲观锁的锁等待超时时间的方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610318817.2A CN107368498B (zh) | 2016-05-13 | 2016-05-13 | 优化MySQL悲观锁的锁等待超时时间的方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107368498A true CN107368498A (zh) | 2017-11-21 |
CN107368498B CN107368498B (zh) | 2020-08-04 |
Family
ID=60304159
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610318817.2A Active CN107368498B (zh) | 2016-05-13 | 2016-05-13 | 优化MySQL悲观锁的锁等待超时时间的方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107368498B (zh) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110502224A (zh) * | 2019-08-22 | 2019-11-26 | 深圳前海环融联易信息科技服务有限公司 | 基于http请求的接口模拟方法、装置和计算机设备 |
CN111405015A (zh) * | 2020-03-09 | 2020-07-10 | 中国建设银行股份有限公司 | 一种数据处理方法、装置、设备及存储介质 |
WO2020211382A1 (zh) * | 2019-04-19 | 2020-10-22 | 深圳壹账通智能科技有限公司 | 基于Redis分布式锁的超时时间动态调整方法及系统 |
CN111813791A (zh) * | 2020-06-17 | 2020-10-23 | 上海悦易网络信息技术有限公司 | 一种分布式补偿事务的方法及设备 |
-
2016
- 2016-05-13 CN CN201610318817.2A patent/CN107368498B/zh active Active
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2020211382A1 (zh) * | 2019-04-19 | 2020-10-22 | 深圳壹账通智能科技有限公司 | 基于Redis分布式锁的超时时间动态调整方法及系统 |
CN110502224A (zh) * | 2019-08-22 | 2019-11-26 | 深圳前海环融联易信息科技服务有限公司 | 基于http请求的接口模拟方法、装置和计算机设备 |
CN111405015A (zh) * | 2020-03-09 | 2020-07-10 | 中国建设银行股份有限公司 | 一种数据处理方法、装置、设备及存储介质 |
CN111405015B (zh) * | 2020-03-09 | 2022-09-30 | 中国建设银行股份有限公司 | 一种数据处理方法、装置、设备及存储介质 |
CN111813791A (zh) * | 2020-06-17 | 2020-10-23 | 上海悦易网络信息技术有限公司 | 一种分布式补偿事务的方法及设备 |
CN111813791B (zh) * | 2020-06-17 | 2024-05-21 | 上海万物新生环保科技集团有限公司 | 一种分布式补偿事务的方法及设备 |
Also Published As
Publication number | Publication date |
---|---|
CN107368498B (zh) | 2020-08-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10101991B2 (en) | Managing a software-patch submission queue | |
Karmani et al. | Actor frameworks for the JVM platform: a comparative analysis | |
WO2018072493A1 (zh) | 编译方法和编译系统 | |
CN110716748B (zh) | 业务处理方法、装置、计算机可读介质及电子设备 | |
Alvaro et al. | Blazes: Coordination analysis for distributed programs | |
CN107368498A (zh) | 优化MySQL悲观锁的锁等待超时时间的方法及装置 | |
CN109446395A (zh) | 一种提高基于Hadoop大数据综合查询引擎效率的方法及系统 | |
CN104541244A (zh) | 用于进行重放执行的方法和系统 | |
CN106325984B (zh) | 一种大数据任务调度装置 | |
CN110489310B (zh) | 一种记录用户操作的方法、装置、存储介质及计算机设备 | |
CN105074656B (zh) | 管理并发谓词表达式的方法和装置 | |
CN114756357A (zh) | 一种基于jvm的非阻塞分布式计划任务调度方法 | |
US8826428B2 (en) | Event detection method and apparatus in a distributed environment | |
US20090327995A1 (en) | Annotation-aided code generation in library-based replay | |
Levis et al. | Schedulers and tasks | |
US20120159487A1 (en) | Identifying threads that wait for a mutex | |
US10063567B2 (en) | System for cross-host, multi-thread session alignment | |
Kim et al. | Efficient asynchronous event handling in the real-time specification for java | |
CN111782373B (zh) | 作业调度方法及装置 | |
Rahman | Process synchronization in multiprocessor and multi-core processor | |
Geeraerts et al. | Queue-dispatch asynchronous systems | |
CN110442404A (zh) | 一种对象释放方法、装置、设备和存储介质 | |
Jiang et al. | A generic specification framework for weakly consistent replicated data types | |
WO2014110701A1 (zh) | 独立主动构件和可运行主动构件组装模型及构件拆分方法 | |
Belwal et al. | Schedulability analysis of transactions in software transactional memory using timed automata |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20200925 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200925 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: Greater Cayman, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |