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:
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.
You need to optimize your database. Most likely you need to index tables 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
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
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