*What steps will reproduce the problem?*
1. Add ICQ transport with account where over 200 buddies
2. Try to connect to the server
*What is the expected output? What do you see instead?*
My jabber client show "Connecting..." status over 20-30 sec. When I look into server load I see 100% CPU load.
*What version of the product are you using? On what operating system?*
Prosody: 0.8.2
Spectrum: 1.4.8
OS: Gentoo Linux
*Please provide any additional information below.*
When you have long contact list in your roster, jabber client contacts server very slow. Also when you add spectrum ICQ transport you need to wait over 1 min after your contacts apear in contact list. The same problen when you delete transport from jabber client.
I don't see any errors in log file.
I'm going to build high load server. Such kind of long periods of connections is terrible for it.
P.S: For example, to ejabberd my jabber client connects immediately with the same roster items.
Many thanks!
MattJ
on
Hi,
Would it be possible for you to enable debug logs, to get a capture of a slow login? It will contain JIDs and such, which it would be better to email to me privately at matthew@prosody.im (please quote this bug number in the email so I know what it is!).
Your config file would also be helpful.
Thanks!
Changes
owner MattJ
iron.udjin
on
Thanks for your reply! I'll send soon.
MattJ
on
Received, thanks. Is this debug log of the first login with the transport enabled? Are subsequent logins also slow?
iron.udjin
on
Yes, it's when I add transport. But when I connect to the server, time of connection near the same. Do you need debug log of the connection time?
MattJ
on
Any chance you could join us in the chatroom ( http://prosody.im/discuss ) to discuss this issue further? I'm afraid our tracker isn't realtime yet :)
MattJ
on
We tracked this issue down to LuaDBI+MySQL, needs further investigation.
Changes
tags Milestone-0.9 Status-Accepted
title LuaDBI+MySQL storage can be slow
MattJ
on
Hi, I believe this is due to a bug that was already fixed in LuaDBI. If you are on Debian then you can use the `lua-dbi` package from testing which already has this patch applied.
Alternatively you can compile LuaDBI yourself from: http://code.matthewwild.co.uk/luadbi
Or wait for the 0.9.0rc1 where I'll be packaging it up.
If the new LuaDBI doesn't fix this issue for you, feel free to reopen it.
Thanks!
*What steps will reproduce the problem?* 1. Add ICQ transport with account where over 200 buddies 2. Try to connect to the server *What is the expected output? What do you see instead?* My jabber client show "Connecting..." status over 20-30 sec. When I look into server load I see 100% CPU load. *What version of the product are you using? On what operating system?* Prosody: 0.8.2 Spectrum: 1.4.8 OS: Gentoo Linux *Please provide any additional information below.* When you have long contact list in your roster, jabber client contacts server very slow. Also when you add spectrum ICQ transport you need to wait over 1 min after your contacts apear in contact list. The same problen when you delete transport from jabber client. I don't see any errors in log file. I'm going to build high load server. Such kind of long periods of connections is terrible for it. P.S: For example, to ejabberd my jabber client connects immediately with the same roster items. Many thanks!
Hi, Would it be possible for you to enable debug logs, to get a capture of a slow login? It will contain JIDs and such, which it would be better to email to me privately at matthew@prosody.im (please quote this bug number in the email so I know what it is!). Your config file would also be helpful. Thanks!
ChangesThanks for your reply! I'll send soon.
Received, thanks. Is this debug log of the first login with the transport enabled? Are subsequent logins also slow?
Yes, it's when I add transport. But when I connect to the server, time of connection near the same. Do you need debug log of the connection time?
Any chance you could join us in the chatroom ( http://prosody.im/discuss ) to discuss this issue further? I'm afraid our tracker isn't realtime yet :)
We tracked this issue down to LuaDBI+MySQL, needs further investigation.
ChangesHi, I believe this is due to a bug that was already fixed in LuaDBI. If you are on Debian then you can use the `lua-dbi` package from testing which already has this patch applied. Alternatively you can compile LuaDBI yourself from: http://code.matthewwild.co.uk/luadbi Or wait for the 0.9.0rc1 where I'll be packaging it up. If the new LuaDBI doesn't fix this issue for you, feel free to reopen it. Thanks!
Changes