title: Testing for concurrency and/or transactional integrity in a web application with JMeter
body: <p>I'm rather new to working with multiple threads in a database (most of my career has been spent on the frontend).  </p>
  
  <p>Today I tried testing out a simple php app I wrote to store values in a mysql db using ISAM tables emulating transactions using Table Locking.</p>
  
  <p>I just wrote a blog post on the procedure Here: </p>
  
  <p><a href="http://leeand00.tiddlyspot.com/#[[Testing%20With%20JMeter]]" rel="nofollow noreferrer">Testing With JMeter</a></p>
  
  <p>From my results my simple php app appears to keep the transactional integrity intact (as seen from the data in my csv files being the same as the data I re-extracted from the database):</p>
  
  <h1>CSV Files:</h1>
  
  <p><img src="https://i9.photobucket.com/albums/a58/Maskkkk/AL_CSV_Data.png" alt="alt csv for al"> <img src="https://i9.photobucket.com/albums/a58/Maskkkk/BL_CSV_Data.png" alt="alt csv for bl"></p>
  
  <h1>Query Of Data for Both Users After JMeter Test Run:</h1>
  
  <p><img src="https://i9.photobucket.com/albums/a58/Maskkkk/AL_Query_Result.png" alt="alt "> <img src="https://i9.photobucket.com/albums/a58/Maskkkk/BL_Query_Result.png" alt="alt "></p>
  
  <p>Am I right in my assumption that the transactional data integrity is intact?</p>
  
  <p>How do you test for concurrency?</p>