Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: tommy382 - Tuesday, 5 October 2010 03:15:59
I have a relatively weak server (dual core VM, 3GB memory) hosting a few web apps but there is only 2 with relatively high traffic: my custom web app and YAF each having about equal traffic. I noticed the CPU and memory usage is always high on the server. I decided to take down the YAF forum for a few minutes and see what happen. Oddly, the resource usage came down a lot (less than 15% vs 80+% before). By "resources", I specifically mean the CPU usage by process sql server and this process also used 2GB of memory (max memory for a 32-bit process). I compiled YAF in debug mode to try to identify which part result in high database usage. I noticed that these 2 SP are not cached and hence constantly take up time each page refresh: yaf_forum_listread and yaf_message_getallthanks. See complete listing below. Not sure what "listread" does but I think "getallthanks" can be cached for maybe 5 minutes? I really don't need up-to-date thanks list if it slow down the app. Anyone goet an idea on how to lower the resource usage? I tried not showing the date on the thanks but that doesn't help much. Snapshot 1: [dbo].[yaf_prov_getuser]: 0.003 [dbo].[yaf_smiley_listunique]: 0.009 [dbo].[yaf_forum_listread]: 0.421 [dbo].[yaf_forum_listread]: 0.003 [dbo].[yaf_forum_listread]: 0.005 [dbo].[yaf_forum_listread]: 0.145 [dbo].[yaf_forum_listread]: 0.002 [dbo].[yaf_forum_listread]: 0.002 [dbo].[yaf_forum_listread]: 0.012 [dbo].[yaf_topic_latest]: 0.011 [dbo].[yaf_active_stats]: 0.001 [dbo].[yaf_prov_getuser]: 0.002 Snapshot 2: [dbo].[yaf_topic_info]: 0.000 [dbo].[yaf_forum_list]: 0.000 [dbo].[yaf_forum_listpath]: 0.000 [dbo].[yaf_post_list]: 0.025 [dbo].[yaf_message_getallthanks]: 0.732 [dbo].[yaf_message_gettextbyids]: 0.006 [dbo].[yaf_prov_getuser]: 0.002 [dbo].[yaf_buddy_list]: 0.001 [dbo].[yaf_active_listtopic]: 0.001 [dbo].[yaf_watchtopic_check]: 0.000 [dbo].[yaf_prov_getuser]: 0.003 [dbo].[yaf_active_list]: 0.002

Posted by: tommy382 - Tuesday, 5 October 2010 03:15:59

I have a relatively weak server (dual core VM, 3GB memory) hosting a few web apps but there is only 2 with relatively high traffic: my custom web app and YAF each having about equal traffic. I noticed the CPU and memory usage is always high on the server. I decided to take down the YAF forum for a few minutes and see what happen. Oddly, the resource usage came down a lot (less than 15% vs 80+% before). By "resources", I specifically mean the CPU usage by process sql server and this process also used 2GB of memory (max memory for a 32-bit process). I compiled YAF in debug mode to try to identify which part result in high database usage. I noticed that these 2 SP are not cached and hence constantly take up time each page refresh: yaf_forum_listread and yaf_message_getallthanks. See complete listing below. Not sure what "listread" does but I think "getallthanks" can be cached for maybe 5 minutes? I really don't need up-to-date thanks list if it slow down the app. Anyone goet an idea on how to lower the resource usage? I tried not showing the date on the thanks but that doesn't help much. Snapshot 1: [dbo].[yaf_prov_getuser]: 0.003 [dbo].[yaf_smiley_listunique]: 0.009 [dbo].[yaf_forum_listread]: 0.421 [dbo].[yaf_forum_listread]: 0.003 [dbo].[yaf_forum_listread]: 0.005 [dbo].[yaf_forum_listread]: 0.145 [dbo].[yaf_forum_listread]: 0.002 [dbo].[yaf_forum_listread]: 0.002 [dbo].[yaf_forum_listread]: 0.012 [dbo].[yaf_topic_latest]: 0.011 [dbo].[yaf_active_stats]: 0.001 [dbo].[yaf_prov_getuser]: 0.002 Snapshot 2: [dbo].[yaf_topic_info]: 0.000 [dbo].[yaf_forum_list]: 0.000 [dbo].[yaf_forum_listpath]: 0.000 [dbo].[yaf_post_list]: 0.025 [dbo].[yaf_message_getallthanks]: 0.732 [dbo].[yaf_message_gettextbyids]: 0.006 [dbo].[yaf_prov_getuser]: 0.002 [dbo].[yaf_buddy_list]: 0.001 [dbo].[yaf_active_listtopic]: 0.001 [dbo].[yaf_watchtopic_check]: 0.000 [dbo].[yaf_prov_getuser]: 0.003 [dbo].[yaf_active_list]: 0.002

Posted by: Jaben - Tuesday, 5 October 2010 03:43:44
Thanks for the information. All modified in v1.9.5.

Posted by: tommy382 - Tuesday, 5 October 2010 04:35:00
Anyway to take those changes and apply to 1.9.4 now or that is too hard to merge the diffs?

Posted by: Jaben - Tuesday, 5 October 2010 04:36:26
v1.9.5 was going to be released today... but I'm still encountering a few issues here on this server, so I'm doing some more tweaks. Either way, you don't have to wait long. :)

Posted by: Jaben - Tuesday, 5 October 2010 04:36:58
[quote=tommy382]Anyway to take those changes and apply to 1.9.4 now or that is too hard to merge the diffs?[/quote] They would not be simplistic to merge, no.

Posted by: tommy382 - Tuesday, 5 October 2010 05:59:36
Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?

Posted by: tha_watcha - Tuesday, 5 October 2010 08:01:57
[quote=tommy382]Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?[/quote] Here is a list of whats new http://www.watchersnet.de/yaf/WhatsNew.html

Posted by: tommy382 - Tuesday, 5 October 2010 11:00:37
Thanks for the link, looks great. Is it an RC1 or a final version? I recalled 1.9.4Final just came out recently? Very nice to see quicker release interval :o)

Posted by: Jaben - Tuesday, 5 October 2010 15:34:54
[quote=tha_watcha][quote=tommy382]Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?[/quote] Here is a list of whats new http://www.watchersnet.de/yaf/WhatsNew.html [/quote] Excellent list there....

Important Information: