MySQL: The Impact of Transactions on Query ThroughputThe dataset could fit in memory as there were no disk reads. I have tested four cases: PK selects – without transaction (select only) PK selects – inside a transaction (begin,select,commit) PK selects – autocommit=off (select,commit) PK selects – Read-Only transaction (START TRANSACTION READ ONLY, select, commit)DisclaimerI was not trying to do a proper performance test to see the maximum performa
Home
