General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] big increase in mysql.log size due to activesync use..?


Chronological Thread 
  • From: heupink < >
  • To:
  • Subject: Re: [SOGo] big increase in mysql.log size due to activesync use..?
  • Date: Wed, 29 Oct 2014 13:58:53 +0100

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
<
<mailto: >>
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
--



<mailto: >
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.



Archive powered by MHonArc 2.6.18.

Top of page