dns_net_performance

Based on multi-factor measurement and analysis of network performance of users to local DNS recursive servers

This job measures network performance from two network detection points in Beijing and Shandong, and simulates the user setting up different DNS servers. The network performance of the user to the DNS recursive server is measured from multiple factors such as network delay, delay jitter, packet loss rate, and average path length, and the data is analyzed from multiple dimensions.

Project Document Introduction

• net_result_sd_sd.sql
  Database structure file can be imported directly and used. Currently, all data is located in the cyn_test database on the database 3 server.

• Based on *** network performance.pdf
  A simple analysis and summary of existing data and write down the areas to be improved.

• database.py
  Database operation files

• netState.py
  Read the DNS server IP to be queried for measurement

• source_ip
  Directory where the original dns data is saved

• result
  Save the result directory

• insert2db.py
  Store the result data into the database and add information such as geographic location, operator, etc.

• ztfb.py
  Simple removal of exception data, and remove z-score greater than 3 or less than -3. Read data in test.txt .

• DNS_track.py
  Verify that dns can resolve domain names normally. The program itself has not been used and may be used in the future.

• ip_location
  ip geographic location confirmation

Run the command

python netState.py ip_source.txt result.txt

• ip_source.txt is the DNS data to be detected
• result.txt is the saved result file

Things to note

Improvements are made in relevant places based on the description in the paper.

• The length of the path from Shandong to Beijing to Shandong is so different, why