Heroes of Might and Magic Community
visiting hero! Register | Today's Posts | Games | Search! | FAQ/Rules | AvatarList | MemberList | Profile


Age of Heroes Headlines:  
5 Oct 2016: Heroes VII development comes to an end.. - read more
6 Aug 2016: Troubled Heroes VII Expansion Release - read more
26 Apr 2016: Heroes VII XPack - Trial by Fire - Coming out in June! - read more
17 Apr 2016: Global Alternative Creatures MOD for H7 after 1.8 Patch! - read more
7 Mar 2016: Romero launches a Piano Sonata Album Kickstarter! - read more
19 Feb 2016: Heroes 5.5 RC6, Heroes VII patch 1.7 are out! - read more
13 Jan 2016: Horn of the Abyss 1.4 Available for Download! - read more
17 Dec 2015: Heroes 5.5 update, 1.6 out for H7 - read more
23 Nov 2015: H7 1.4 & 1.5 patches Released - read more
31 Oct 2015: First H7 patches are out, End of DoC development - read more
5 Oct 2016: Heroes VII development comes to an end.. - read more
[X] Remove Ads
LOGIN:     Username:     Password:         [ Register ]
New Server | HOMM1: info forum | HOMM2: info forum | HOMM3: info forum | HOMM4: info forum | HOMM5: info forum | MMH6: wiki forum | MMH7: wiki forum
Heroes Community > Turban Tribunal > Thread: Forum slowness
Thread: Forum slowness This thread is 5 pages long: 1 2 3 4 5 · «PREV
Storm-Giant
Storm-Giant


Responsible
Undefeatable Hero
On the Other Side!
posted December 20, 2015 02:04 PM

Getting a lot of 20-40s loading times over the past few days
____________

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
fred79
fred79


Promising
Undefeatable Hero
posted January 11, 2016 06:40 PM

Quote:
Page generated in 57.12 seconds.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Neraus
Neraus


Supreme Hero
Emperor of the Bromans
posted January 11, 2016 08:20 PM

Can confirm, it takes a minute to load the reply page.
____________
Wait, where is my clever punchline?

 Send Instant Message | Send E-Mail | View Profile | PP | Quote Reply | Link
Valeriy
Valeriy

Mage of the Land
Naughty, Naughty Valeriy
posted January 18, 2016 09:58 PM

Did some more work on this problem. The system will now log every forum/thread generation that takes over 10 seconds to complete along with some useful diagnostic information.

Let me know when the error happens next time and I will check the log.
____________
You can wait for others to do it, but if they don't know how, you'll wait forever.
Be an example of what you want to see on HC and in the world.
http://www.heroesofmightandmagic.com

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
fred79
fred79


Promising
Undefeatable Hero
posted January 18, 2016 10:11 PM

Valeriy said:
Did some more work on this problem. The system will now log every forum/thread generation that takes over 10 seconds to complete along with some useful diagnostic information.

Let me know when the error happens next time and I will check the log.


that's gonna be a lengthly log, val. but we'll all keep our reporting up, i have no doubt. just let us know when you want us to stop. we don't want you going insane on us.

what diagnostic information are you referring to, btw?

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
frostymuaddib
frostymuaddib


Supreme Hero
By the power of Vivendi!
posted January 19, 2016 08:16 PM

Quote:
Page compiled in 42.111 seconds

____________
"Occam's shuriken: when the answer is elusive, never rule out ninjas." -- Dr. Gordon Freeman (Freeman's Mind)
"lol" -- VERRIKER VON ERWINSSEN

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Valeriy
Valeriy

Mage of the Land
Naughty, Naughty Valeriy
posted January 19, 2016 09:49 PM

After analyzing the log and investigating further I think I may have finally found the cause. Or at least one of the causes.

Server CPU and RAM don't seem to be the issue, there are plenty of system resources available when the problem happens. It seems to be the database server slowing down, without overloading the CPU.

The cause turned out to be a poorly written query that was triggered on the post page to check if the user has made 20 posts in the last 24 hours. The query involved a table join on very large tables and used unindexed columns. The query took a long time to execute, slowing down the database server and all other requests being processed at the time. This also explains the problems people were experiencing with the post page.

I've rewritten the query to make it more efficient and tweaked the database configuration. Let's see what happens.
____________
You can wait for others to do it, but if they don't know how, you'll wait forever.
Be an example of what you want to see on HC and in the world.
http://www.heroesofmightandmagic.com

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
frostymuaddib
frostymuaddib


Supreme Hero
By the power of Vivendi!
posted January 19, 2016 09:50 PM

That was fast
____________
"Occam's shuriken: when the answer is elusive, never rule out ninjas." -- Dr. Gordon Freeman (Freeman's Mind)
"lol" -- VERRIKER VON ERWINSSEN

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
fred79
fred79


Promising
Undefeatable Hero
posted January 19, 2016 10:23 PM

cool beans. i hope that fix works. thanks for the ongoing work, val.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Valeriy
Valeriy

Mage of the Land
Naughty, Naughty Valeriy
posted January 20, 2016 08:08 PM

Checked this morning and there have been only 3 slow thread loads in the last 20 hours As opposed to dozens / hundreds the day before.

In the mean time I optimized another inefficient join query in the thread display page. The database server load has gone down significantly as a result, in fact it is crazy to see that the database is now using less CPU than PHP!

Let's give it another week to be 100% sure that the problem is resolved. If so, I'll cancel the unnecessary RAM upgrade made a few months ago.
____________
You can wait for others to do it, but if they don't know how, you'll wait forever.
Be an example of what you want to see on HC and in the world.
http://www.heroesofmightandmagic.com

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Corribus
Corribus

Hero of Order
The Abyss Staring Back at You
posted January 22, 2016 03:09 AM
Edited by Corribus at 03:09, 22 Jan 2016.

Page generated in 0.008 seconds.
____________
I'm sick of following my dreams. I'm just going to ask them where they're goin', and hook up with them later. -Mitch Hedberg

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Drakon-Deus
Drakon-Deus


Bad-mannered
Legendary Hero
Everywhere and nowhere
posted January 22, 2016 05:58 AM

Great job, guys. Forum slowness was a real pain in the...

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Valeriy
Valeriy

Mage of the Land
Naughty, Naughty Valeriy
posted February 09, 2016 03:09 AM

I've been watching the logs and the slow page generation issue is indeed resolved I've downgraded the RAM to what it was before and things are still running smoothly.
____________
You can wait for others to do it, but if they don't know how, you'll wait forever.
Be an example of what you want to see on HC and in the world.
http://www.heroesofmightandmagic.com

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
fred79
fred79


Promising
Undefeatable Hero
posted February 09, 2016 04:09 AM

awesome! thanks, val.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
fred79
fred79


Promising
Undefeatable Hero
posted November 04, 2016 04:50 PM

hc is loading really slow for me for hours now. at least 8.

 Send Instant Message | Send E-Mail | View Profile | Quote Reply | Link
Jump To: « Prev Thread . . . Next Thread » This thread is 5 pages long: 1 2 3 4 5 · «PREV
Post New Poll    Post New Topic    Post New Reply

Page compiled in 0.0179 seconds