[Freeswitch-users] Performance bottleneck

Yossi Neiman freeswitch at cartissolutions.com
Mon Aug 18 07:51:30 PDT 2008

Just to clarify about the license for MySQL. MPL is listed as a 
compatible license by MySQL for using the client code (-lmysqlclient or 
-lmysqlclient_r). See EXCEPTIONS-CLIENT in the MySQL source tree. 
However, if you want to embed the whole database directly into 
FreeSWITCH, I believe that would be incompatible without the purchase of 
a commercial license.

Yossi Neiman
Cartis Solutions, Inc.
P) 630-259-8100

Ken Rice wrote:
> Actually having evaluated MySQL for large scale environments it works 
> well up to a point... Postgres on the other hand has much more mature 
> replication, store procedures, triggers, a query cacher that insane 
> and no need to use mysql’s so called ‘hash tables’ to get the data 
> loaded into ram (pg does this automagically via its caching mechanism)
> Mix that with table partitioning and you have some fairly crazy numbers
> Real world deployments doing some pretty complex LCR shows that a 
> small cluster (4 boxes) or old dell 2650s are able to sustain > 40K 
> queries/sec (~10% being inserts for CDRs)
> When you get into this scale the real enterprise work that has been 
> done on pgsql starts to show thru... Companies like Greenplum feed a 
> good bit of their core performance tuning back to PgSQL... (for those 
> that are wondering pgsql is bsd licensed so its actually license 
> compatible w/ FreeSwitch say some someone want to look at replacing 
> sqlite with a pgsql engine)

More information about the FreeSWITCH-users mailing list