title: Concurrent UPDATE's on MySQL TRIGGER
body: <p>I have this TRIGGER in MySQL:</p>
  
  <pre><code>CREATE DEFINER = CURRENT_USER TRIGGER `test`.`view_AFTER_INSERT` AFTER INSERT ON `views` FOR EACH ROW
  BEGIN
  UPDATE metrics SET met_nu_vie = met_nu_vie + 1 WHERE usp_id = NEW.usp_id;   
  END
  </code></pre>
  
  <p>Basically, when an user receives a 'view' from another user in a web application, the system creates a new row in table 'views', and after insert, increments a counter value in another table (metrics).</p>
  
  <p>My question is: If the user receives 10 concurrent views from 10 different users... ¿is this UPDATE safe?</p>
  
  <p>All tables on my schema are INNODB.</p>
  
  <p>Thanks.</p>