Start FreeSWITCH without any SQL but at the same time have all info available on realtime/runtime
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
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:
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
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:
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:
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
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> wrote:
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.
-- -Rupa
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:
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:
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:
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
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:
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:
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:
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:
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
_______________________________________________ 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
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
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:
So how Asterisk does that "show channels" without SQL? I don't think they use SQLite internally.
Just being curious.
Diego
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-... On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com> wrote:
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
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:
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-...
On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com> wrote:
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400
_______________________________________________ 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
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:
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:
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-...
On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com> wrote:
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400
_______________________________________________ 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
To be fair, most of these messages are 4-5 years old. That said to date, I can crash * by repeatedly doing a 'show channels'. All the same FS should be robust enough to suffer this abuse. If it's not,. the issue needs to be investigated. Regards, ________________________________ From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: 15 March 2009 13:30 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime 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> wrote: 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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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 -- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
Perhaps a misunderstanding? We do not suffer from any problem at all regarding "show channels". The reason for the link was to demonstrate the issue we are familiar with from our asterisk days (3-4 years ago) and to help explain how we solved it by storing the calls states in a separate table to avoid locking the channels. You can type show channel in FS all you want and all you are doing is selecting from the SQLite db. The Original question by the poster was if we can find a way to turn off SQL and still allow show channels to work and the answer is, sorry no. On Sun, Mar 15, 2009 at 7:01 PM, Nik Middleton < nik.middleton@noblesolutions.co.uk> wrote:
To be fair, most of these messages are 4-5 years old. That said to date, I can crash * by repeatedly doing a ‘show channels’. All the same FS should be robust enough to suffer this abuse. If it’s not,. the issue needs to be investigated.
Regards, ------------------------------
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Anthony Minessale *Sent:* 15 March 2009 13:30 *To:* freeswitch-users@lists.freeswitch.org *Subject:* Re: [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime
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-...
On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com> wrote:
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
Yup, my mistake, got the wrong end of the stick. However while we're on the subject of show channels, is it possible to get a formatted response back from the event socket? It would be nice to interrogate an event style response. Perhaps even including some other goodies such as load etc. Regards, ________________________________ From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: 16 March 2009 00:16 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but atthesame time have all info available on realtime/runtime Perhaps a misunderstanding? We do not suffer from any problem at all regarding "show channels". The reason for the link was to demonstrate the issue we are familiar with from our asterisk days (3-4 years ago) and to help explain how we solved it by storing the calls states in a separate table to avoid locking the channels. You can type show channel in FS all you want and all you are doing is selecting from the SQLite db. The Original question by the poster was if we can find a way to turn off SQL and still allow show channels to work and the answer is, sorry no. On Sun, Mar 15, 2009 at 7:01 PM, Nik Middleton <nik.middleton@noblesolutions.co.uk> wrote: To be fair, most of these messages are 4-5 years old. That said to date, I can crash * by repeatedly doing a 'show channels'. All the same FS should be robust enough to suffer this abuse. If it's not,. the issue needs to be investigated. Regards, ________________________________ From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: 15 March 2009 13:30 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime 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> wrote: 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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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 -- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400 _______________________________________________ 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 -- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
Depending on the API you're calling, of course show channels as xml show calls as xml uuid_dump [uuid] xml sofia xmlstatus and probably more than that. Math On 16-Mar-09, at 7:52 AM, Nik Middleton wrote:
Yup, my mistake, got the wrong end of the stick.
However while we’re on the subject of show channels, is it possible to get a formatted response back from the event socket? It would be nice to interrogate an event style response. Perhaps even including some other goodies such as load etc.
Regards,
From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org ] On Behalf Of Anthony Minessale Sent: 16 March 2009 00:16 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but atthesame time have all info available on realtime/runtime
Perhaps a misunderstanding?
We do not suffer from any problem at all regarding "show channels".
The reason for the link was to demonstrate the issue we are familiar with from our asterisk days (3-4 years ago) and to help explain how we solved it by storing the calls states in a separate table to avoid locking the channels.
You can type show channel in FS all you want and all you are doing is selecting from the SQLite db.
The Original question by the poster was if we can find a way to turn off SQL and still allow show channels to work and the answer is, sorry no.
On Sun, Mar 15, 2009 at 7:01 PM, Nik Middleton <nik.middleton@noblesolutions.co.uk
wrote: To be fair, most of these messages are 4-5 years old. That said to date, I can crash * by repeatedly doing a ‘show channels’. All the same FS should be robust enough to suffer this abuse. If it’s not,. the issue needs to be investigated.
Regards,
From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org ] On Behalf Of Anthony Minessale Sent: 15 March 2009 13:30 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime
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-...
On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola@gmail.com> wrote:
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:
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:
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:
Since we added indexes to the SQLite DB its not so bad. /b On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
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
_______________________________________________ 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
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400 _______________________________________________ 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
participants (7)
-
Anthony Minessale
-
Brian West
-
Diego Viola
-
Mathieu Rene
-
Michael Jerris
-
Nik Middleton
-
Rupa Schomaker