Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Explain multi-version concurrency control in MySQL?

Answers were Sorted based on User's Feedback



Explain multi-version concurrency control in MySQL?..

Answer / cp

Multiversion concurrency control (abbreviated MCC or MVCC),
in the database field of computer science, is a concurrency
control method commonly used by database management systems
to provide concurrent access to the database.
MVCC provides each user connected to the database with a
"snapshot" of the database for that person to work with. Any
changes made will not be seen by other users of the database
until the transaction has been committed.

Is This Answer Correct ?    2 Yes 0 No

Explain multi-version concurrency control in MySQL?..

Answer / amith

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I get a list of table names in mysql?

0 Answers  


How can we get the number of rows affected by query?

0 Answers  


How do I completely remove mysql from windows?

0 Answers  


Why mongodb is faster than mysql?

0 Answers  


If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,


How to update info already in a table and delete a row(s) from a table.

0 Answers  


What is bdb (berkeleydb)?

0 Answers  


What is view? How can you create and drop view in mysql?

0 Answers  


How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  


What is row level locking in access?

0 Answers  


Explain the difference between FLOAT, DOUBLE and REAL.

14 Answers   Yahoo,


ru compare the 2 null values?

2 Answers   ACC,


Categories