Why aren commits working in MySQL?
Some versions of MySQL don’t support transactions at all. But modern versions do, if you create tables using a table type that supports transactions. The InnoDB table type is the most commonly used transaction-supporting table type. To use the InnoDB table type, use a create statement like the following: create table testtable (col1 int) type=innodb However, you may be surprised at MySQL’s behavior even when you’re using InnoDB tables or another table type that supports transactions. With most databases, if a client has a connection open and commits a set of inserts, updates or deletes in, then those changes are immediately visible to other clients using separate connections. MySQL doesn’t support this behavior, at least not with InnoDB tables. Instead, with MySQL, after beginning a transaction, the database will appear to be unaffected by queries run in other transactions until the transaction you are running is committed. So, if another client commits a set of inserts, you won’t see
