[horde] MySQL Massive number of queries

Jan Schneider jan at horde.org
Thu Sep 14 09:53:08 UTC 2017


Zitat von Andreas Mauser <andreas at mauser.info>:

> Hi Group,
>
> can someone please tell me why I have massive number of requests like this?:
>
>                    75 Query     SELECT event_id, event_uid,  
> calendar_id, event_description, event_location, event_private,  
> event_status, event_attendees, event_title, event_recurcount,  
> event_url, event_timezone, event_recurty
> pe, event_recurenddate, event_recurinterval, event_recurdays,  
> event_start, event_end, event_allday, event_alarm,  
> event_alarm_methods, event_modified, event_exceptions,  
> event_creator_id, event_resources, event_baseid, event_ex
> ceptionoriginaldate FROM kronolith_events WHERE event_uid =  
> '20170910232443.QLvWlquvl2ooWGO4mlB1xYM at post.mauser.info' AND  
> calendar_id IN ('a5m_xwalMq9e4SJg7X_jnD_')
>
> I get 200 queries/second.
>
> It drives the mysql server crazy and decreases performance dramatically.
>
> Can someone please hint me in the right direction?
>
> Many thanks,
> Andreas

Probably some synchronization.

-- 
Jan Schneider
The Horde Project
https://www.horde.org/



More information about the horde mailing list