VoIP Mailing List Archives

[diego.viola at gmail.com]

Hello,

I was wondering if it is possible to start FreeSWITCH without any SQL
at all, yeah I know there is -nosql but I still want to have all the
information available at run time, ie: show channels, sofia status,
sofia status profile <profile>, everything.

Would that improve performance? I ask this because I heard that SQLite
causes some performance issues and I heard it's being removed from the
core, I also think that making that optional would be nice along with
UnixODBC support for everything.

I also got a few situations where I had to rm -f
/usr/local/freeswitch/db/* because there were some data there that was
not supposed to be, that's why I think real time data on run time
would be better.

Anyway, just some feedback/question I wanted to share, FS is awesome,
keep up the great work.

Regards,

Diego

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

[diego.viola at gmail.com]

Erhm, this is what I wanted to say.

--

I think FreeSWITCH should leave that SQLite option as optional, I
think it would be nicer if FS doesn't depend on any SQL at all, if you
do a show channels right now with -nosql, this is what you will see:

freeswitch@internal> show channels
-ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!

freeswitch@internal>

I think it would be nice if FS can show you the information on real
time, and on run time, without any SQL at all, and leave UnixODBC &
SQLite as optional options, I also think this will improve
performance.

On Fri, Mar 13, 2009 at 6:53 AM, Diego Viola <diego.viola@gmail.com> wrote:

[diego.viola at gmail.com]

This is what I get when I do a show channels with -nosql.

freeswitch@internal> show channels
-ERR SQL DISABLED NO CHANNEL DATA AVAILABLE!

freeswitch@internal>

It would be nice if it prints the channels on runtime without the
need/overheat of SQL.

Regards,

Diego

On Fri, Mar 13, 2009 at 6:46 AM, Diego Viola <diego.viola@gmail.com> wrote:

[rupa at rupa.com]

Using sql for the show commands is pretty elegant.  It allows one to get info without having to lock a bunch of in memory data structures prior to collecting stats.  Locking data structures just for reporting == bad -- especially on a high volume server.

On Fri, Mar 13, 2009 at 6:12 AM, Diego Viola <diego.viola@gmail.com (diego.viola@gmail.com)> wrote:

[mrene_lists at avgs.ca]

In this case sqlite separates the core from what show channels uses
etc, the DB is filled in by an event handler. This actually increases
performance since you dont need to exclusively lock the session
manager's table just to list channels.


Math

On 13-Mar-09, at 7:12 AM, Diego Viola wrote:

[diego.viola at gmail.com]

Oh, I thought that SQLite wasn't that great on performance and that
people wanted to replace/remove it from the core.

"On of the most interesting things about FreeSWITCH to me has been the
fact that most data in the system such as registrations are kept in a
SQL database. The default installation uses SQLite internally though
you can easily point FreeSWITCH at one of a number of other SQL
servers such as PostgreSQL or MySQL via UnixODBC. Sadly, SQLite has
become somewhat of a bottleneck in the core so future versions of
FreeSWITCH will use less of it. For example, doing a "show channels"
with over 500 channels in use starts to show issues. While I'm sad to
see SQLite go in these cases, I am anxious to see how Minessale
replaces it."

http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale

I was just being curious about it

Regards,

Diego

On Fri, Mar 13, 2009 at 10:09 AM, Mathieu Rene <mrene_lists@avgs.ca> wrote:

[brian at freeswitch.org]

Since we added indexes to the SQLite DB its not so bad.

/b

On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:

[diego.viola at gmail.com]

Yeah, but still, it would be nice to see the channels with -nosql

I don't want to be a pain in the ass, just giving some user feedback.

Regards,

Diego

On Fri, Mar 13, 2009 at 3:02 PM, Brian West <brian@freeswitch.org> wrote:

[mike at jerris.com]

To clarify, -nosql turns on and off only the collecting of data for
the show commands, and can now handle higher load than the sip stack
can. The only thing your doing by saying -nosql is turning off the
exact functionality you say you want. Its similar to saying I would
like to support sip but don't want to load mod_sofia. There should be
no reasons to use that command anymore, if you encounter any I would
be interested in knowing what is going on.

Mike


On Mar 14, 2009, at 12:12 AM, Diego Viola wrote:

[diego.viola at gmail.com]

So how Asterisk does that "show channels" without SQL? I don't think
they use SQLite internally.

Just being curious.

Diego

On Sat, Mar 14, 2009 at 9:20 AM, Michael Jerris <mike@jerris.com> wrote:

[brian at freeswitch.org]

They walk across and lock every channel while printing the info... its
a flawed way of doing things.

/b

On Mar 14, 2009, at 7:29 PM, Diego Viola wrote:

[anthony.minessale at g...]

search google for bugs related to crash and show channels
http://www.google.com/search?q=asterisk+crash+show+channels&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a


On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com (diego.viola@gmail.com)> wrote:

[diego.viola at gmail.com]

Wow, that sucks.

It's clear now why it's done this way, keep up the great work.

Diego

On Sun, Mar 15, 2009 at 9:30 AM, Anthony Minessale
<anthony.minessale@gmail.com> wrote:

[diego.viola at gmail.com]

Forget this, I don't want show channels without SQL anymore.

Diego

On Sun, Mar 15, 2009 at 9:56 AM, Diego Viola <diego.viola@gmail.com> wrote: