Chris Albertson wrote:
Would it just be easier to use a database system that managed concurent access better? Most all of them don't have trouble with this and don't require work-arounds like hot copies and so on.
--- [EMAIL PROTECTED] wrote:
I am always wary of allowing ad-hoc queries that may lock tables on a
production system. One relatively easy way to avoid this issue is to use hotcopy to make a
read-only reporting database that gets updated every x minutes. The other is to use replication
if you need an up to the second copy.
Bill
Chris Albertson wrote:
I tested both MySQL and PostgreSQL under various loads, Actually got paid to do it. In the simple case where one process just stuffs data into the database with INSERT MySQL was about 4x faster in terms of INSERT/second
However if you have five or six processes that are doing lots of transactions, mixed INSERT and SELECT, MySQL grinds to a halt The trouble is locking. MySQL only lets one process at a table at
a
time so everyone else is shut out waiting.
On a large PBX with high call volume you can't afford to have a table locked for 10 or 30 seconds while some guy does an ad-hoc join.
PostgreSQL is more stable but can "only" do a few hundred INSERT per second on PC hardware vs. well over 1000/sec for MySQL.
--- Matteo Brancaleoni <[EMAIL PROTECTED]> wrote:
I agree. postgres could be too slow if used into a big system and you can't afford a rather good machine.
mysql is very fast and simple.
and I don't see where's the problem into the extraction...
a simple division could be done in any language, with any
program...
matteo.
Il mar, 2003-03-04 alle 20:27, [EMAIL PROTECTED] ha scritto:
Why would anyone use such a big axe for a small problem, a trigger
to do simple math. Bah.
MySql is perfectly suitable for CDR logging on any practical phone
system short of telco main office
eqpt.
Karl Putland wrote:
On Tue, 2003-03-04 at 11:57, Matthew S. Hill wrote:
I am pushing all the cdr info to a MySQL database on a separate
machine.
I have noticed that the duration times for all calls are
recorded
in
seconds, by Asterisk. Is there a way to set the recorded call
duration
to a decimal representation of minutes? ie 90 sec = 1.5 min. My extraction process would be a little simpler if the data dumped
into the
database were minutes and not seconds.
Write a trigger for on insert or a view that converts sec->min.
Oh wait
your using MySQL. Use PostgreSQL ;)
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
-- Matteo Brancaleoni <[EMAIL PROTECTED]> Espia - Emmegi Srl
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
===== Chris Albertson Home: 310-376-1029 [EMAIL PROTECTED] Cell: 310-990-7550 Office: 310-336-5189 [EMAIL PROTECTED] KG6OMK
__________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
===== Chris Albertson Home: 310-376-1029 [EMAIL PROTECTED] Cell: 310-990-7550 Office: 310-336-5189 [EMAIL PROTECTED] KG6OMK
__________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
