[Asterisk-Users] cdr_mysql - would index slow down?

[Scott Stingel]

Roger-

Assuming that you have a fast machine, and a reasonably fast disk, I don't
anticipate a problem at this call level.

At one customer site, I have 5 systems, each running 120 lines with very
high call volume - no problem with MySQL keeping up.  This customer uses
asterisk for IVR, not VoIP, and so has a higher rate of call setups than a
typical VoIP setup would.

I tend to clear out my DB's way before they reach 1,000,000 records however.
You might consider doing what I do, and that's have a Perl process on each
machine that transfers the DB records off to a database server on a very
regular basis.  I do it because of multiple machines - you might do it to
maintain large numbers of records on-line.

Cheers
Scott Stingel 


Scott M. Stingel
President,
Emerging Voice Technology, Inc.
Palo Alto California & London England
www.evtmedia.com 

-----Original Message-----
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Roger Schreiter
Sent: Wednesday, May 12, 2004 7:13 AM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] cdr_mysql - would index slow down?

Hi,

I intend to change the cdr_mysql-field "uniqueid", which seems not to be
used so far, to an (not unique) indexed field and use it later for my own
hints and infos.

I don't have very much traffic so far, and I wonder, if there will appear
problems when asterisk is under high load (100 simultanious calls) and the
log table contains 1.000.000 log lines.

This would mean, that asterisk would have to wait some time when writing a
log line, because mysql has to update the index.

Can anyone with some more experience predict, whether there will be problems
cause to the indexed field?


Your opinion is welcome!
Roger.

_______________________________________________
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