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