Explain multi-version concurrency control in MySQL?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What does mysql flush tables do?

507


How to define numeric 9(3) in db2 table without decimal point??

2391


What do we use to remove duplicate records while fetching a data in mysql ?

513


Why do we use views instead of tables?

494


How large can a mysql database become?

481






How database are managed?

552


What is difference between oracle and mysql?

492


Explain the storage engines in mysql?

524


How would you get the current date in mysql?

646


How do I stop a mysql command?

481


How can we optimize stored procedure?

485


What is mysql slow query?

520


Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

497


What are mysql queries?

480


What is a table schema?

534