Page History

...

Prior to generating the Interconnect Traffic graph, you will need to run the following query: (Use either MySQL Workbench or Heidi-SQL clients )*** You need to generate to interconnect data prior to generating the NREN datato run the 2 queries below)

1:

SELECT ROUND(volume_in,1) as 'Volume In',ROUND(volume_out,1) as 'Volume Out'
FROM reports.excel_yearly_volumes
WHERE project='GEANT2'
AND circuit_usage='Interconnect'
AND period = 201707;

...

Take a note of the volume_in and volume_out values and then insert a record in the reports.msr_graphical_data table using the following SQL statement:

E.g.2:

INSERT INTO reports.msr_graphical_data (period,year,month,from_data,to_data) values ('201707',2017,7, 5675.2,5427.3);

...

*** The from_data field value should be set to the value of volume_in and the to_data field value should be set to the value of volume_out 

Please Now, click the Generate Graph button for the following graphs:

...

DWS Traffic

IPv6 Traffic

LHCONE

INFO: When you click the Generate Graph button, a call is made to the GraphGenerator servlet (net.dante.msr.graphs.GraphGenerator), which constructs the graphs. The generated images are stored in the /var/lib/tomcat6/webapps/msr/media/images directory on the server.

** Warning - Sometimes there is a browser caching issue and you may have to refresh the page (Press F5 button) to see the generated graph appear at the bottom of the page. Or, you might need to restart tomcat on test MSR. Run command: “sudo service tomcat6 restart”

INFO: The main MySQL Tables used are: reports.report_utilization, reports.opsdb_circuit and reports.msr_graphical_data

...