Interested to Buy Any Domain ? << Click Here >> for more details...
Explain multi-version concurrency control in MySQL?
- 2 Answers
- 9639 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are the disadvantages of stored procedures?
Where is the myisam table stored?
What are the different table present in MYsql?
what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 Answers Infosys, Sierra Atlantica,
What are the benefits of mysql?
Why mongodb is faster than mysql?
What is query log in mysql?
What is table level locking in mysql?
What is an index? How can an index be declared in mysql?
What are the difference between mongodb and mysql?
How to see table's field formats or description of table .
how to take mysql database backup?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
