Prevent deadlocks with JMeter O l e k s i i Z o z u l e n k oautomated-testing.info
History
deadlock - is ... ? Не разрешимая ситуация, которая возникает при попыт...
5%15% 80% Database Threads Sync Others
Example
 UPDATE products AS p, products AS pp   SET  p.is_low_on_stock =IFNULL(p.products_low_stock_level,IFNULL(pp.products_low_s...
Tools
Tools
Tools JDBC Sampler BSF Sampler Your Own Sampler
Assume Causes
 SELECT p.is_low_on_stock,p.products_low_stock_level,p.products_quantity, pp.is_low_on_stockFROM products AS p, products A...
Users = Requests
Failure Example
ThanksOleksii Zozulenkoozozulenko@gmail.comautomated-testing.info
Prevent deadlockswithj meter
Prevent deadlockswithj meter
Prevent deadlockswithj meter
Prevent deadlockswithj meter
Prevent deadlockswithj meter
of 19

Prevent deadlockswithj meter

Published on: Mar 4, 2016
Published in: Technology      
Source: www.slideshare.net


Transcripts - Prevent deadlockswithj meter

  • 1. Prevent deadlocks with JMeter O l e k s i i Z o z u l e n k oautomated-testing.info
  • 2. History
  • 3. deadlock - is ... ? Не разрешимая ситуация, которая возникает при попытке одновременно получить доступ к одному ресурсу с нескольких потоков или источников
  • 4. 5%15% 80% Database Threads Sync Others
  • 5. Example
  • 6.  UPDATE products AS p, products AS pp   SET  p.is_low_on_stock =IFNULL(p.products_low_stock_level,IFNULL(pp.products_low_stock_level,0)) >= p.products_quantity,pp.is_low_on_stock =IFNULL(p.products_low_stock_level,IFNULL(pp.products_low_stock_level,0)) >= p.products_quantity WHEREp.products_parent = pp.products_id ANDpp.products_id IN (5000, 10529);
  • 7. Tools
  • 8. Tools
  • 9. Tools JDBC Sampler BSF Sampler Your Own Sampler
  • 10. Assume Causes
  • 11.  SELECT p.is_low_on_stock,p.products_low_stock_level,p.products_quantity, pp.is_low_on_stockFROM products AS p, products AS ppWHERE p.products_parent =pp.products_id AND pp.products_id IN(5000, 10529); INSERT into products(product_id,product_title, is_low_on_stock,products_low_stock_level) values (NULL,‘sometitle’, 5,0);
  • 12. Users = Requests
  • 13. Failure Example
  • 14. ThanksOleksii Zozulenkoozozulenko@gmail.comautomated-testing.info

Related Documents