EmergencyEMERGENCY? Get 24/7 Help Now!

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

Instrumentation and the cost of Foreign Keys

 | September 20, 2010 |  Posted In: Insight for Developers, MySQL

I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.  My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”. .. that’s when […]

Read More