Slow Loading in Roundcube

Benjamin Griese der.darude at gmail.com
Mon Jan 27 10:40:06 CET 2014


Yes indeed,

I couldn't find any errors, found something in the sql about the 60secs timing:

[27-Jan-2014 10:10:30,000000 +0100]: [1] SELECT vars, ip, changed,
now() AS ts FROM session WHERE sess_id = '<session id>';
[27-Jan-2014 10:10:30,000000 +0100]: [2] SELECT * FROM users WHERE
user_id = '2';
[27-Jan-2014 10:10:47,000000 +0100]: [19] SELECT vars, ip, changed,
now() AS ts FROM session WHERE sess_id = '<session id>';
[27-Jan-2014 10:10:47,000000 +0100]: [20] UPDATE session SET changed =
now(), vars = <a lot of text>
[27-Jan-2014 10:11:30,000000 +0100]: [3] SELECT flags, data FROM
cache_messages WHERE user_id = '2' AND mailbox = 'Kategorien/<Name>'
AND uid = '33';
[27-Jan-2014 10:11:30,000000 +0100]: [4] SELECT vars, ip, changed,
now() AS ts FROM session WHERE sess_id = '<session id>';
[27-Jan-2014 10:11:30,000000 +0100]: [5] UPDATE session SET changed =
now(), vars = <a lot of text>

Clicking on email at 10:10:30 and preview visible at 10:11:30
Looks like a mysql timeout or something like that.
I'm running a owncloud instance on the same mysql db instance, in a
different database.
How can check if there is a mysql performance bottleneck?
I'm currently fiddling around with monitorix to get an overview about
the caching.
Nothing what I think of, just to exclude.


More information about the users mailing list