The new recommended transaction isolation level for Drupal sites is 'READ COMMITTED' as per the Setting the MySQL transaction isolation level documentation. The document suggest it is recommended, but then also contradicts itself with "if required".

Should we be doing this and if so, is there anything evasive about running the database query to switch on live site?