| Bug #109599 | Support creating snapshot based on SCN | ||
|---|---|---|---|
| Submitted: | 12 Jan 2023 8:48 | Modified: | 7 Feb 2:30 |
| Reporter: | zhai weixiang (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S4 (Feature request) |
| Version: | 8.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Contribution | ||
- View
- Add Comment
- Files
- Developer
- Edit Submission
- View Progress Log
- Contributions
To submit contributions, please log in.
[12 Jan 2023 8:48]
zhai weixiang
[2 Mar 2023 3:35]
zhai weixiang
fix some bugs (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: snapshot.diff (application/octet-stream, text), 134.82 KiB.
[8 May 2023 2:16]
zhai weixiang
latest version (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: snapshot_80_33.diff (application/octet-stream, text), 136.59 KiB.
[5 Jul 2023 3:21]
zhai weixiang
bugfix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: snapshot_80_33.diff (application/octet-stream, text), 139.61 KiB.
[25 Jul 2024 15:23]
zhai weixiang
rebase to 9.0.1 (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_9_1.diff (text/x-patch), 135.05 KiB.
[11 Nov 2024 4:23]
zhai weixiang
bugfix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: bug10599.diff (application/octet-stream, text), 135.77 KiB.
[16 Jan 3:02]
zhai weixiang
latest version not fully tested (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn.diff (application/octet-stream, text), 194.35 KiB.
[22 Jan 11:29]
zhai weixiang
fix some cores (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0122.diff (application/octet-stream, text), 194.03 KiB.
[23 Jan 2:16]
zhai weixiang
let purge thread/gtid flush thread using latest low limit no, so truncating related cases are passed (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0123.diff (application/octet-stream, text), 193.94 KiB.
[24 Jan 7:09]
zhai weixiang
1. new strategy of searching undo header 2. remove spin_lock and use Seq_lock TBD: solve issue with long-running transaction (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0124.diff (application/octet-stream, text), 190.34 KiB.
[24 Jan 7:53]
zhai weixiang
fixed bug in ReadView::prepare that user ro session runs slow path to get low_limit_no (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0124.diff (application/octet-stream, text), 190.57 KiB.
[27 Jan 16:10]
zhai weixiang
fix long-running trx by picking them out and advance up_limit_id (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_fix_long_trx.diff (application/octet-stream, text), 197.76 KiB.
[28 Jan 2:22]
zhai weixiang
fix a bug of changes_visible (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0128.diff (application/octet-stream, text), 197.79 KiB.
[1 Feb 3:23]
zhai weixiang
new version, comment in bellow (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0201.diff (application/octet-stream, text), 173.79 KiB.
[3 Feb 10:24]
zhai weixiang
bugfix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0203.diff (application/octet-stream, text), 173.77 KiB.
[4 Feb 1:20]
zhai weixiang
bugfix: trx_purge_t::min_up_id is not correctly calculated (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0204.diff (application/octet-stream, text), 174.21 KiB.
[4 Feb 1:33]
zhai weixiang
bugfix:view_open:: should set view slot before prepare (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0204_2.diff (application/octet-stream, text), 174.21 KiB.
[7 Feb 2:29]
zhai weixiang
patch based on previous one and add history list for insert undo (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: insert_history_list.diff (application/octet-stream, text), 10.01 KiB.
[8 Feb 12:19]
zhai weixiang
add new read only variable innodb_mvcc_use_scn, true by default (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0208.diff (application/octet-stream, text), 178.87 KiB.
[10 Feb 9:54]
zhai weixiang
1. some bugfix 2. parallel reading use traditional mvcc (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0210.diff (application/octet-stream, text), 181.15 KiB.
[11 Feb 3:57]
zhai weixiang
bugfix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0211.diff (application/octet-stream, text), 181.49 KiB.
[17 Feb 2:31]
zhai weixiang
remove scn_mutex, and bugfix (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0217.diff (application/octet-stream, text), 178.00 KiB.
[19 Feb 2:14]
zhai weixiang
remove unnecessary debug checking in ReadView::copy_trx_ids (*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.
Attachment: scn_0219.diff (application/octet-stream, text), 179.35 KiB.
