Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 69194

Recovery is the rebuilding of a database or table space after a problem such as media or storage failure, power interruption, or application failure. If you have backed up your database, or individual table spaces, you can rebuild them should they become damaged or corrupted in some way.

1 vote
3 answers
683 views

InnoDB: will uncommitted transaction produce redo log?

Before MySQL commit a transaction, it will write REDO log first, then commit the transaction, that is write ahead log. start transaction; update users set uuid = UUID() from user where id = 1 update …
Ryan Lyu's user avatar
  • 523
1 vote
Accepted

InnoDB: will uncommitted transaction produce redo log?

Based on Jeremy Cole's presentation InnoDB: A journey to the core III in Percona Live MySQL Conference 2015. When the transaction is first started: A transaction ID (TRX_ID) is assigned and may be …
Ryan Lyu's user avatar
  • 523
1 vote
0 answers
599 views

MySQL: why undo log is required in the processes of database recovery?

Is undo log for recover from an crash that happens within recovery? …
Ryan Lyu's user avatar
  • 523