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

[Jay Milk]

I have mySQL running on several servers where it is driving
web-applications.  One one site I track logins, ip-addresses and UAs, in
addition to file downloads.  The site is logging about 1,000,000
hits/month and the DB doesn't slow it down one but.  mySQL has very good
performance, as long as you plan your tables and indices well.  On that
note, you probably wouldn't re-use existing fields (whether they're used
or not) but rather add new fields if needed.  In order to keep
insert-performance at peak, you may want to run table optimzation
regularly.  

If size does become an issue, consider archiving old data -- you
probably won't NEED 1,000,000 call records at your fingertips.  Reality
check: 100 simultaneous calls, 5 min average call, 6 days x 8 hours is
less than 60K records per week, so 1M records would keep over four
months of data.  Even in that scenario, you only have about one insert
every three seconds, and that shouldn't even cause a blip in your system
load.

Keep in mind that when asterisk is processing 100 simultaneous calls,
you'll need a pretty beefy machine anyway, and if you're running a lot
of queries against your CDR data, you may need to move the DB to a
separate server.

-----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 9: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