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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] gmail (.dot.) com >> >> _______________________________________________ >> Asterisk-Users mailing list >> [email protected] >> 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 >> [email protected] >> 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 [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
