EmergencyEMERGENCY? Get 24/7 Help Now!

MyRocks and LOCK IN SHARE MODE

 | May 11, 2017 |  Posted In: MyRocks, MySQL, Technical Webinars

LOCK IN SHARE MODE

In this blog post, we’ll look at MyRocks and the LOCK IN SHARE MODE. Those who attended the March 30th webinar “MyRocks Troubleshooting” might remember our discussion with Yoshinori on  LOCK IN SHARE MODE. I did more tests, and I can confirm that his words are true: LOCK IN SHARE MODE works in MyRocks. This quick example demonstrates this. The initial setup:

In session 1:

[…]

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

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