The latest articles on DEV Community by huynhit-92 (@huynhit92). https://dev.to/huynhit92 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F111784%2F28ef411d-90b5-49be-9c58-c98eab1965f3.jpeg https://dev.to/huynhit92 en huynhit-92 Mon, 09 Dec 2019 03:58:43 +0000 https://dev.to/huynhit92/need-idea-to-improve-mysql-s-lock-performance-29a1 https://dev.to/huynhit92/need-idea-to-improve-mysql-s-lock-performance-29a1 <p>We currently do goods management system like amazon<br> With each product, there are about 5000 orders every day, which means that there are 5000 transactions processed.<br> Currently, I am using the lock row mysql mechanism to ensure the correctness of the data.<br> Mysql does a great job but the execution time is too long because the transactions are waiting for each other.<br> So I want to ask if there is any way to increase the processing ability of mysql or is there any other approach to handle the problem of multiple transactions updating the same record (using a different database ...)</p> help mysql lock