mike at jerris.com
Tue Sep 20 14:50:37 MSD 2011
If I'm correct these are just run on startup, and those statements would just harmlessly fail on mysql. Is this a problem?
On Jul 17, 2011, at 3:39 PM, Robert Huddleston wrote:
> Wondering if I should log this to Jira?
> Looks like a recent code addition - so not sure protocol here - also never having logged a Jira before.
> In switch_core_sqldb.c there are some PRAGMA calls.
> I'm finding that in my MYSQL unixODBC environment - these PRAGMA calls are causing syntax errors.
> I'm not familiar with the syntax - I've seen equivalents on MS-SQL and Oracle etc - but never seen such on MYSQL.
> Any ideas?
> switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA synchronous=OFF;", NULL);
> switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA count_changes=OFF;", NULL);
> switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA temp_store=MEMORY;", NULL);
> switch_cache_db_execute_sql(sql_manager.event_db, "PRAGMA journal_mode=OFF;", NULL);
> Join us at ClueCon 2011, Aug 9-11, Chicago
> http://www.cluecon.com 877-7-4ACLUE
> FreeSWITCH-dev mailing list
> FreeSWITCH-dev at lists.freeswitch.org
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-dev