EmergencyEMERGENCY? Get 24/7 Help Now!

Open Source Databases on Big Machines: Does READ COMMITTED Scale on 144 Cores?

 | January 19, 2017 |  Posted In: open source databases, OpenSource Databases on big machines

READ COMMITTED

In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is  READ COMMITTED, and is known to work well. While the  REPEATABLE READ level maintains the transaction history up to the start of the transaction, […]

Read More

InnoDB locks and transaction isolation level

 | June 17, 2016 |  Posted In: InnoDB, MySQL

Overlooked MySQL performance optimization

What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post. Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The question: > I am reading your article: > https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar > Full table […]

Read More