General discussion on installation and configuration of SOGo

Text archives Help


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


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

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 = '/83267EACED3941B78F7CBF772F693C9C+folderINBOX'
264634 Query UPDATE sogo_cache_folder_heupink SET c_lastmodified = 1414563394, c_deleted = 0, c_version = 2187, c_content = '/tYCAAJTeW5jS2V5AAwAAAAxMjI1My0zMjU1MwADRGF0ZUNhY2hlAIYzAgARNzU4MAAZAAAA
MjAxNC0wNi0xMSAwODozNDowNSBDRVNUABE3NTgxABkAAAAyMDE0LTA2LTExIDA4OjM0OjA1
IENFU1QAETI1NTIAGQAAADIwMTQtMDYtMTEgMDA6MTg6MjcgQ0VTVAARMTE1MjAAGQAAADIw
MTQtMDktMTcgMTQ6MTc6NDggQ0VTVAARNzU4MgAZAAAAMjAxNC0wNi0xMSAwODozNDowNSBD
RVNUABExMTUyMQAZAAAAMjAxNC0wOS0xNyAxNDoyNjoyMiBDRVNUABExMTUyMgAZAAAAMjAx
NC0wOS0xNyAxNDozOTowNyBDRVNUABE3NTg0ABkAAAAyMDE0LTA2LTExIDA4OjM0OjA2IENF
U1QAETExNTIzABkAAAAyMDE0LTA5LTE3IDE0OjUxOjQ0IENFU1QAETc1ODUAGQAAADIwMTQt
MDYtMTEgMDg6MzQ6MDYgQ0VTVAARNzU4NgAZAAAAMjAxNC0wNi0xMSAwODozODo0NCBDRVNU
ABExMTUyNwAZAAAAMjAxNC0wOS0xNyAyMToyNDowMyBDRVNUABE3NTg5ABkAAAAyMDE0LTA2
LTExIDA4OjQzOjIzIENFU1QAETExNTI4ABkAAAAyMDE0LTA5LTE4IDAxOjMwOjM5IENFU1QA
ETc5MzAAGQAAADIwMTQtMDYtMTEgMDk6MjA6MTQgQ0VTVAARMTE1MjkAGQAAADIwMTQtMDkt
MTggMDg6MzY6MDQgQ0VTVAARMjkwNQAZAAAAMjAxNC0wNi0xMSAwMDoyODowMyBDRVNUABE3
OTM0ABkAAAAyMDE0LTA2LTExIDA5OjIwOjE0IENFU1QAETc5MzUAGQAAADIwMTQtMDYtMTEg
(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



Archive powered by MHonArc 2.6.18.

Top of page