[Asterisk-Users] ANNOUNCEMENT : NEWCallingCard Application forAsterisk

Manjit Riat manjit at riat.net
Wed Jan 26 16:39:33 MST 2005


I am sorry but I think you're mistaken about heavy traffic.

This is my stats (from MySQL)


Query statistics: Since its startup, 746,184,562 queries have been sent to
the server in 16 days..

And I really don't consider that high load.



-----Original Message-----
From: Vahan Yerkanian [mailto:vahan at arminco.com] 
Sent: Wednesday, January 26, 2005 12:35 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] ANNOUNCEMENT : NEWCallingCard Application
forAsterisk

Sergey,

You should really revisit MySQL.com :) 4.0.x is way outdated...

Regarding the high load etc... how about this copy-pasted excerpt from 
phpmyadmin?

---8<----
This MySQL server has been running for 19 days, 6 hours, 8 minutes and 
28 seconds. It started up on Jan 07, 2005 at 02:21 PM.
Server traffic: These tables show the network traffic statistics of this 
MySQL server since its startup.
  Traffic   ø per hour
  Received   2,579 MB   5,714 KB
  Sent   1,050 MB   2,327 KB
  Total   3,629 MB   8,040 KB
Connections   ø per hour   %
  Failed attempts   83   0.18   0.00 %
  Aborted   1,416,484   3,065.05   6.42 %
  Total   22,064,865   47,744.87   100.00 %

Query statistics: Since its startup, 68,530,509 queries have been sent 
to the server.
---8<----

regards,
Vahan

Sergey Kuznetsov wrote:
> Robert,
> 
> It is better to stay with Postgres. If you don't want to loose your 
> business stay away from MySQL.
> If you are from Toronto ( I suppose you are ), you can check my posts to 
> TLUG (Toronto Linux User Group)
> regarding MySQL and Postgres. I would say Postgres is a Open Source 
> Oracle. It's very stable, very scalable
> and it's perfectly works under serious workload. MySQL is dying at the 
> same configuration.
> I have client of mine who having issue with MySQL. Under some workload ( 
> 10 users inserting at the same time )
> it corrupts the index. Even MySQL 4.0.X is still corrupts the indexes 
> under heavy load.
> I never saw it with Postgres. At the same time Postgres provides you a 
> very flexible SQL language and features,
> as well as you can make stored procedures on Perl and many-many more.
> 
> 
> All the Best!
> Sergey.
> 
> 
> Robert Augustyn wrote:
> 
>> NICE!
>> I understand that it works against Postgress, any idea what it would 
>> take to
>> port it to mysql if anything?
>> robert
>> -----Original Message-----
>> From: asterisk-users-bounces at lists.digium.com
>> [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Areski
>> Sent: Wednesday, January 26, 2005 12:05 PM
>> To: Asterisk-Users Mailing-list
>> Subject: [Asterisk-Users] ANNOUNCEMENT : NEW CallingCard Application
>> forAsterisk
>>
>> Hello everyone,
>>
>>
>> If you want to know why I am so tired today :D Check this CallingCard
>> Solution : http://areski.net/areskicc-doc/ Just finish it yesterday 
>> night!
>>
>>
>> Briefly, AreskiCC is an AGI script and PHP-Web application which greatly
>> handle the complete CallingCard System.
>>
>>
>> FEATURES - AGI :
>>      * Authenticate with the use of a Cardnumber        the Cardnumber 
>> can also be defined as accountcode into sip.conf,
>>        iax.conf, etc..      * take care of multiple calls using the 
>> same Cardnumber      * Caller gets informed about his credit        
>> Announce the remaining credit
>>      * Caller is requested to enter a destination number      * 
>> Announce the maximal call time for the given destination number        
>> It calculates the remaining duration of the actual call (based
>>        on tariffrate tables), informs the caller about this and sets a
>>        timeout
>>      * Interupt the call if the card balance gets zero        Warn the 
>> caller about the call interupt 60 & 30 seconds before
>>        the call gets interupted
>>      * It connects the Caller to the destination through the configured
>>        trunk        note : different trunks can be configured and 
>> associated by
>>        prefix
>>      * After disconnecting the call AGI updates the credit and stores
>>        the concerning Call-Detail-Records with CallingPartyNumber,
>>        CalledPartyNumber, CallSetupTime, Duration, Charge and the
>>        remaining credit
>>
>>
>> FEATURES - WEB INTERFACE:
>>      * CARD/CUSTOMERS
>>              * List customers
>>              * Refill customer
>>      * CARD/CUSTOMERS
>>              * List customers/cards
>>              * Refill customer/card
>>              * Create customer/card
>>              * Generate customers/cards
>>      * BILLING
>>              * View money situation
>>              * View Payment
>>              * Add new Payment
>>      * RATECARD
>>              * List Tariffplan
>>              * Create new Tariffplan
>>              * Define Tariffplan
>>      * TRUNK
>>              * List Trunk
>>              * Add Trunk
>>      * CALL REPORT - BALANCE
>> Last note : It's distributed under GNU GPL Licence.
>>
>>
>>
>> I hope there will have a big interest for the soft,
>> I am waiting your feedbacks...
>> Regards, /Areski
>>
>>
>>
>>
>>
>> -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
>>
>> Belaïd Arezqui
>> www.areski.net
>> E-mail : areski [alt at alt] gmail (.dot.) com
>>        
>> _______________________________________________
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
>>
>> _______________________________________________
>> Asterisk-Users mailing list
>> Asterisk-Users at lists.digium.com
>> http://lists.digium.com/mailman/listinfo/asterisk-users
>> To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>  
>>
> 
> 





More information about the asterisk-users mailing list