I don't particularly like mysql so I don't know the exact answer, but I do know that by default it disables transactions and multi statements as a knee-jerk solution to injection and that it's some numeric param deep in some config file. So I would just google for "enable transactions mysql" or something like that.You can tell if it matters if freeswitch complains about transactions disabled when it connect to the db for the first time.On Tue, Oct 25, 2011 at 9:55 AM, Hynek Cihlar <hynek.cihlar@gmail.com> wrote:
For the transactions, what would be required to change? Any tweaks in the ODBC driver/DSN settins?
Hynek
On Tue, Oct 25, 2011 at 4:49 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote:make sure you have it setup so it can do transactions or multiple statements.--On Mon, Oct 24, 2011 at 5:11 PM, Cliff Wells <cliff@develix.com> wrote:
On Mon, 2011-10-24 at 17:36 -0400, Tim St. Pierre wrote:You need to optimize your database. Most likely you need to index tables
> Database is MySQL 5.5. I'm seeing 18 queries per second, mostly complicated internal
> joins on tables like sip_dialogs and sip_subscriptions.
>
> Freeswitch is Version 1.0.head (git-7531fed 2011-08-17 11-27-20 -0500) and hardly breaking
> a sweat, while the database server is at 100% CPU load.
that are used in joins (I doubt further optimization is needed for such
a small dataset and such a light load). I don't use MySQL, but I recall
it has a way to log slow queries. You should turn this on and use the
output to figure out the right queries to optimize. Don't blindly
create needless indexes as this will actually slow it more.
Cliff
Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire
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
googletalk:conf+888@conference.freeswitch.org
pstn:+19193869900
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/
Twitter: http://twitter.com/FreeSWITCH_wire
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
googletalk:conf+888@conference.freeswitch.org
pstn:+19193869900
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