Hi there, I had a similar problem some time ago in one of my clients -for monitoring infrastructure-
Some items you might want to revisit in your application: (a) You need to capture the "health" of your server - there's open- source software that lets you do this easily. I suggest you to look into this, instead of reinventing the wheel. (b) Don't use arrays as data storage: write to a database, and read from there as needed. You get to keep the server's health records, and replay the data when necessary. (c) Once you're ready to plot the chart, you will have one axis with the time dimension (24 hours at 5 minute intervals) and the other axis with the different servers you want to chart. As you read the database, you should be able to generate a URL with the chart information, and then send that over to Google Charts, good luck Carlos M : www.carloslabs.com : On Sep 15, 9:42 pm, z3rongod <[email protected]> wrote: > Hello! > > I've just started working with PHP and made server monitoring script > that runs on a cron job every 5 minutes. It stores information in > mysql, and now I want to print out a graph of the servers. > > So I have made a script to get that information out of the database > into this array: arr = array(array('time1','time2','nrOFservers'); > > Imagine the script checks the servers on UNIX timestamp (which i will > call T1,T2,T3 and T4) on 1252838866 and writes 30 servers, 1252838900 > and writes 0 servers, 1252839266 writes 15 servers, 1252832500 writes > 25 servers, the array would be like: > > arr[0][0] = T1; > arr[0][1] = T2; > arr[0][2] = 30; > > arr[1][0]=T2; > arr[1][1]=T3; > arr[1][2]=0; > > arr[2][0]=T3; > arr[2][1]=T4; > arr[2][2]=15; > > arr[3][0]=T4; > arr[3][1]=T5; > arr[3][2]=25; > > and so on. > > How would i be able to represent a 24 hour chart using that array with > a 5 minute granularity? > > Yours thankfully, > Sergiu. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Chart API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en -~----------~----~----~----~------~----~------~--~---
