Node Load Rate Calculation Method Based on Database Query Statistics in Load Balancing Strategy

The calculation of node load rate critically impacts the quality of load balancing strategies in distributed systems. Existing commonly used node load rate calculation methods fail to adequately account for the current actual state of nodes, resulting in discrepancies between computed values and actual conditions. This paper focuses on distributed information systems, taking the database as an entry point, and proposes a node load rate calculation method based on database query statistics suitable for load balancing strategies. This method employs an analytical approach combining theoretical computation data with benchmark performance test data, comprehensively accounting for factors such as data volume in the distributed information system database, peak database access periods, and data table indices that affect computation results. Under the premise of ensuring the accuracy of node load rate computation, the method minimizes repetitive testing, conserves computational performance and energy resources, and reduces both the time and economic costs of node load rate calculation. Algorithm validation results show that the mean error rate between the computed seconds per query (SPQ) and the actual value is as low as 1.7%.