Device and method for improving throughput of online examination system based on three-level cache

Abstract

The invention discloses a device and method for improving throughput of an online examination system based on three-level cache, and the method comprises the steps that a browser receives an answer caching request of each question, and the browser caches the answer of each question; M is a positive integer when the number of questions of the answer cache request received by the browser reaches a set threshold value M; the answers of the M questions are dumped into a second-level cache through the first-level cache; the second-level cache compares the answers of the M questions with preset correct answers and records the number of correct questions; and the second-level cache synchronizes the answers of the M questions and the correct question number into the MySQL database of the management end server. The three-level cache is introduced, the impact on the relational database is reduced, the examination data is asynchronously synchronized into the relational database, and the concurrent bearing capacity of the examination system can be greatly improved by caching the concurrent flow of coping with the examination.

Description

technical field [0001] The invention relates to the technical field of improving throughput of an online examination system, in particular to a device and method for improving throughput of an online examination system based on a three-level cache. Background technique [0002] The statements in this section merely mention the background technology related to the present invention and do not necessarily constitute the prior art. [0003] When an online examination system developed based on a relational database is used online by more than tens of millions of users at the same time, it is inevitable that the system will freeze or even go down. In response to such problems, the industry mostly adopts the mode of horizontal expansion of cluster deployment for support. In this mode, the cost of server investment is too high. Taking 10,000 people to take an exam at the same time as an example, regardless of high availability, a set of services needs to be deployed at least Two s...

AI Technical Summary

Problems solved by technology

[0005] 1. MYSQL and other relational databases perform unsatisfactorily in terms of system throughput when submitting high-concurrency small transactions. Under 16C32G configuration, TPS is less than 500. Considering the processing time of upper-level business applications, the actual value during stress testing is around 300.

Therefore, when the number of online users increases, the waiting time will also become longer, and the delay will also increase. When the server is always under high pressure, it is prone to downtime

[0006] 2. Tens of thousands of people take online exams at the same time. Regardless of the cluster method or the method of using SSD hard disks to improve MYSQL throughput, a high economic cost is required. Overall, the cost performance is low, and it is not recommended to adopt it in actual operation.

[0007] 3. When calculating the candidate’s score, it is necessary to query all the answers of the candidate’s test questions from the database and then traverse and compare them with the correct answers. This process consumes resources. When the number of testees increases, it is easy to become a system bottleneck.

Images