Hi Vedran,

This basically means turning off the general_log?

I know slow_queries logging can be turned on and off seperately, but turning off the general_log seems to be a bit more than I would like...

Anyway, I have now set general_log = 0.

Thanks,
MJ

On 10/29/2014 12:51, Vedran Krivokuca wrote:
Turn off query logging for MySQL?

On Wed, Oct 29, 2014 at 12:16 PM, heupink <heup...@gmail.com
<mailto:heup...@gmail.com>> wrote:

    Hi,

    I have noticed that yesterday and today I have been playing with
    outlook/activesync, and it seems to do it's job fine, only: I
    noticed just now that this caused a huge increase in mysql logging.

    They used to be around 2 or 3 mb compressed, and yesterday/today
    they became close to 100mb compressed. (uncompressed between 500 and
    700 mb)

    We are seeing many lines line:

    141029  7:16:34 264639 Query    SELECT * FROM
    sogo_cache_folder_heupink WHERE c_path =
    '/__83267EACED3941B78F7CBF772F693C__9C+folderINBOX'
                     264634 Query    UPDATE sogo_cache_folder_heupink
    SET c_lastmodified = 1414563394, c_deleted = 0,      c_version =
    2187, c_content =
    
'/__tYCAAJTeW5jS2V5AAwAAAAxMjI1My0__zMjU1MwADRGF0ZUNhY2hlAIYzAgARN__zU4MAAZAAAA
    MjAxNC0wNi0xMSAwODozNDowNSBDRV__NUABE3NTgxABkAAAAyMDE0LTA2LTEx__IDA4OjM0OjA1
    IENFU1QAETI1NTIAGQAAADIwMTQtMD__YtMTEgMDA6MTg6MjcgQ0VTVAARMTE1__MjAAGQAAADIw
    MTQtMDktMTcgMTQ6MTc6NDggQ0VTVA__ARNzU4MgAZAAAAMjAxNC0wNi0xMSAw__ODozNDowNSBD
    RVNUABExMTUyMQAZAAAAMjAxNC0wOS__0xNyAxNDoyNjoyMiBDRVNUABExMTUy__MgAZAAAAMjAx
    NC0wOS0xNyAxNDozOTowNyBDRVNUAB__E3NTg0ABkAAAAyMDE0LTA2LTExIDA4__OjM0OjA2IENF
    U1QAETExNTIzABkAAAAyMDE0LTA5LT__E3IDE0OjUxOjQ0IENFU1QAETc1ODUA__GQAAADIwMTQt
    MDYtMTEgMDg6MzQ6MDYgQ0VTVAARNz__U4NgAZAAAAMjAxNC0wNi0xMSAwODoz__ODo0NCBDRVNU
    ABExMTUyNwAZAAAAMjAxNC0wOS0xNy__AyMToyNDowMyBDRVNUABE3NTg5ABkA__AAAyMDE0LTA2
    LTExIDA4OjQzOjIzIENFU1QAETExNT__I4ABkAAAAyMDE0LTA5LTE4IDAxOjMw__OjM5IENFU1QA
    ETc5MzAAGQAAADIwMTQtMDYtMTEgMD__k6MjA6MTQgQ0VTVAARMTE1MjkAGQAA__ADIwMTQtMDkt
    MTggMDg6MzY6MDQgQ0VTVAARMjkwNQ__AZAAAAMjAxNC0wNi0xMSAwMDoyODow__MyBDRVNUABE3
    OTM0ABkAAAAyMDE0LTA2LTExIDA5Oj__IwOjE0IENFU1QAETc5MzUAGQAAADIw__MTQtMDYtMTEg
    (and this goes on for a VERY long time, causing a big file)

    Is this expected and regared as normal behaviour when using
    ActiveSync? Are others here seeing this as well?

    MJ
    --
    users@sogo.nu <mailto:users@sogo.nu>
    https://inverse.ca/sogo/lists




--
<https://www.linkedin.com/in/casastorta> <https://github.com/casastorta>
Pozdrav/Greetings,
<https://twitter.com/casastorta/>
<https://plus.google.com/115558490731481521000> Vedran Krivokuća
<http://krivokuca.net/> <http://www.last.fm/user/vkrivokuca> Disclaimer:
This message may contain information.
--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to