Baron wrote nice article comparing locking hints in MySQL and SQL Server. In MySQL/Innodb LOCK IN SHARE MODE and SELECT FOR UPDATE are more than hints. Behavior will be different from normal SELECT statements. Here is simple example:
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
- May 31, 2013 - MySQL Query Patterns, Optimized
- June 05, 2013 - Choosing a MySQL High Availability Solution
- June 26, 2013 - Percona XtraDB Cluster Operations
- June 26, 2013 - Percona Server 5.6: Enterprise Grade MySQL
Percona MySQL Training
- Madrid, Spain on Monday, 03 June 2013
- Moving to MySQL 5.6 - Austin, TX on Monday, 10 June 2013
- Moving to MySQL 5.6 - San Jose, CA on Thursday, 13 June 2013
- New York City, New York, USA on Monday, 17 June 2013
- Moving to MySQL 5.6 - Manchester, UK on Monday, 17 June 2013
Percona Careers
- Director of Open Source Development
- Perl Programmer [Americas timezone]
- MySQL Instructor [Any Location - US]
- PHP and UI/Frontend Developer
- MySQL Operations DBA - Consulting
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.