[asterisk-users] VERY HIGH LOAD AVERAGE: top - 10:27:57 up 199 days, 5:18, 2 users, load average: 67.75, 62.55, 55.75

[Tzafrir Cohen]

On Wed, Feb 10, 2010 at 04:26:48AM -0500, Steve Totaro wrote:

[snip]

> > my $data0= $ARGV[0];
> > my $data1= $ARGV[1];
> > my $data2= $ARGV[2];
> > my $data3= $ARGV[3];
> > my $data4= $ARGV[4];
> > my $data5= $ARGV[5];
> > my $data6= $ARGV[6];
> > my $data7= $ARGV[7];

[snip]

> >
> > my $insert_str = "insert into $mysql_table (calldate, language, src,
> > duration, accountcode, uniqueid, currentmenu, nextmenu) values
> > (\"$data0\", \"$data1\", \"$data2\", \"$data3\",  \"$data4\", \"$data5\",
> > \"$data6\", \"$data7\");\n";
> >       $sth = $dbh->prepare($insert_str);
> >       $sth->execute();

> If I were you, and I am not and never will be, I would move over to
> fastagi and offload all that Perl and database stuff off to a
> designated server just to handle that stuff.

Or, in the case of such a simple AGI, use the MySQL app from addons.

Alternatively, can the CDR mechnism be (ab?)used to record this
information?

-- 
               Tzafrir Cohen
icq#16849755              jabber:tzafrir.cohen at xorcom.com
+972-50-7952406           mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com  iax:guest at local.xorcom.com/tzafrir