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
begin:vcard fn:Vahan Yerkanian n:Yerkanian;Vahan org:ARMINCO Global Telecommunications;Head, Research & Development dept. adr:;;28, Isahakian ave., PO BOX 10;Yerevan;;375009;Armenia email;internet:[EMAIL PROTECTED] x-mozilla-html:FALSE url:http://www.arminco.com/ version:2.1 end:vcard
_______________________________________________ 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
