Processing method for dealing with warehousing bottleneck problem of relational database

• Main Authors: CHEN YI, LI GUI, ZHANG LUHANG
• Format: Patent
• Language: Chinese; English
• Published: 02.06.2020
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention relates to a processing method for dealing with a storage bottleneck problem of a relational database, and aims at the problem that 1000 MySQL processing capacities per second and the speed of 15000 pieces per second are not in line with the reality. A cache function is added and named as a message queue, and obtained excessive data is not stored in a message queue and then is actively and regularly notified to a platform to be stored in the database. When the data to be written into the database in the message queue still reaches the peak period, the processing speed exceeds thesaturation state, to solve the problem, a multi-level warehouse (hard disk) is added, and the data is slowly written into the database after several minutes. Finally, the short message tickets in thewarehouse are all written in the database in the low ebb period. According to the method, the bottleneck problem of relational database writing is solved, a caching strategy is added, data reading isoptimized, and the platfor