Explain Multi-version Concurrency Control In Mysql?

1.	Explain Multi-version Concurrency Control In Mysql?
Answer» Each row has two ADDITIONAL columns ASSOCIATED with it - creation TIME and deletion time, but instead of storing timestamps, MySQL STORES version NUMBERS. Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.

Answer»

Each row has two ADDITIONAL columns ASSOCIATED with it - creation TIME and deletion time, but instead of storing timestamps, MySQL STORES version NUMBERS.

Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.

Discussion

No Comment Found

Related InterviewSolutions

Where Is Standard Output Usually Directed?
You Wish To Restore The File Memo.ben Which Was Backed Up In The Tarfile Mybackup.tar. What Command Should You Type?
You Want To Create A Compressed Backup Of The Users' Home Directories. What Utility Should You Use?
You Have A File Called Phonenos That Is Almost 4,000 Lines Long. What Text Filter Can You Use To Split It Into Four Pieces Each 1,000 Lines Long?
What Command Should You Use To Check The Number Of Files And Disk Space Used And Each User's Defined Quotas?
In Order To Improve Your System's Security You Decide To Implement Shadow Passwords. What Command Should You Use?
What Command Is Used To Remove The Password Assigned To A Group?
What Key Combination Can You Press To Suspend A Running Job And Place It In The Background?
What Utility Can You Use To Automate Rotation Of Logs?
What Is The Name And Path Of The Main System Log?

Explain Multi-version Concurrency Control In Mysql?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment