A small, high-concurrency deduction method for placing an order with inventory

Abstract

The invention discloses a small-scale, high-concurrency deduction inventory ordering method, which belongs to the technical field of order processing, and respectively establishes virtual pipelines, virtual external locks, virtual pipeline tables and virtual inventory pools; each item corresponds to multiple virtual pipelines and multiple virtual pipelines. A virtual inventory pool, multiple virtual pipelines and multiple virtual inventory pools correspond one-to-one, and the virtual inventory pool is placed in the MYSQL data table; in the case of high concurrency of inventory deduction, each transaction initiated is first in the virtual pipeline table Find the currently available virtual pipes, find the non-LOCK virtual pipes in order, enter the corresponding inventory data in the virtual inventory pool through the virtual pipes, and modify the inventory; when the virtual inventory pool is unavailable, other available virtual pipes are automatically occupied and LOCKed Use this virtual pipeline to deduct multiple inventory pools. The present invention adopts an external lock mechanism to share concurrently with multiple inventory pools, which can linearly increase the concurrent amount, and is more convenient to realize.

Description

technical field [0001] The invention relates to a method for placing an order with deduction of inventory, in particular to a method for placing an order with deduction of inventory for small size and high concurrency, and belongs to the technical field of order processing. Background technique [0002] In recent years, e-commerce has been booming in our country, and people are becoming more and more accustomed to online shopping. With the development of electronic information, order service based on mobile Internet has been widely used. At present, the realization principle of the open source PHP+MYSQL e-commerce system is almost the same for order placement and inventory deduction, that is, order placement and inventory deduction are performed in transactions, but this transaction process cannot cope with high concurrency inventory deduction , in the high-concurrency ordering scenario, multiple users create multiple transactions and modify the inventory of a product at th...

AI Technical Summary

Problems solved by technology

At present, the realization principle of the open source PHP+MYSQL e-commerce system is almost the same for order placement and inventory deduction, that is, order placement and inventory deduction are performed in transactions, but this transaction process cannot cope with high concurrency inventory deduction , in the high-concurrency ordering scenario, multiple users create multiple transactions and modify the inventory of a product at the same time, and MYSQL will lock the lock when modifying, resulting in the execution of the previous transaction. The lock cannot be released, and the subsequent deduction Reducing inventory will fail