<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br>It's unlikely the graph creation is the problem for you. I went through the effort of re-writing rateup to remove<br>all the GD calls and turned it into an update-only version, with no graphing, so that I could offload all the graphing<br>to a separate server that was running the webserver; going through all that work only netted me a 14% performance<br>improvement. Most of the time is spent in updating the data, not in drawing the graphs.<br><br>From our experiences at work writing SNMP data to mySQL as part of RTG. it's unlikely you'll get better <br>performance in trying to do highly structured SQL calls for writing data than you will in doing block oriented<br>updates to a local RRD
file. So if item 1 is really a concern for you, consider moving to RRD files rather than<br>moving to Oracle, as there's a lot more overhead involved in sending SQL updates than there is in writing bits<br>to a local disk. However, if item 3 is more of an issue than item 1, moving to SQL would make sense; in<br><span>that case, I'd investigate RTG: <a target="_blank" href="http://rtg.sourceforge.net/">http://rtg.sourceforge.net/</a> as it is already written to do its data storage via</span><br>SQL calls.<br><br>Matt<br><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Craig Metzer <ucantspamthis@hotmail.com><br>To: mrtg@lists.oetiker.ch<br>Sent: Friday, October 19, 2007 9:44:27 AM<br>Subject: [mrtg] Logging to database<br><br>
<style>
.hmmessage P
{
margin:0px;padding:0px;}
body.hmmessage
{
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}
</style>
Has anyone written a mod to log targets to an Oracle (or any other) database using SQL rather than local log/rrd files?<br> <br>I'm using MRTG to monitor performance on a large network. I have the need to change the log format to use Oracle for several reasons. <br>
1. I'm running into performance problems with the dotlog files. <br>
2. I'm using the Sean Adams 95th%ile to archive my 5 minute samples and <br>
calculate 95th%ile over several days with the 5 minute granularity. <br>
3. I need reporting capabilities. We use Crystal Reports, so storing my <br>
data in the enterprise Oracle db opens the door to many reporting options. <br>
4. We're replacing MRTG with Proviso next year, so I just need to keep it <br>
going until we get the new system on-line. I don't want to invest too<br>
much effort in developing the db support.<br> <br>I've got RRD support installed and I'm, using it where I can, but the bulk of my targets use log files. My processors are at 100% most due to IOwait. I believe I'm chewing up my resources writing graphs.<br> <br>It looks easy enough to write a function to write to the db using SQL. I need to create the graphs on-demand like is done with RRD, so I could mod the CGI script to pull the data from the db rather than RRD. I think that's more involved because it looks like the graph functions are in the RRD mod. If anyone has done this in whole or in part, I'd like to start with that. If not, does anyone have any ideas on the best approach to this?<br>
<br>
<br>
Thanks,<br>
Craig<br><br><SPAN style="width:100%;height:2px;border-bottom:1px solid rgb(212,208,200); border-top:1px solid rgb(128,128,128);background-color:black;overflow:hidden; margin:8px 0px;"></SPAN>Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. <a rel="nofollow" target="_blank" href="http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct">Play Now!</a></div><br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>