Forum Settings
       
Reply To Thread

problems posting commentsFollow

#1 Jul 31 2017 at 5:04 PM Rating: Excellent
*
161 posts
seems everytime I post a comment it takes a very long time. most of the time I get an error and have to reopen zam to see if it posted and then it shows a double post.
#2 Jul 31 2017 at 6:57 PM Rating: Excellent
Avatar
****
4,580 posts
mtgdragon wrote:
seems everytime I post a comment it takes a very long time. most of the time I get an error and have to reopen zam to see if it posted and then it shows a double post.


You're not alone in this.


Gidono has posted in a similar thread about his efforts towards getting Zam to resolve this. So there is hope.
#3 Jul 31 2017 at 9:29 PM Rating: Excellent
Avatar
*
178 posts
As snailish said. Most of my posts here result in some kind of white screen error: proxy, server failed to respond, etc. The good thing is they know.
#4 Jul 31 2017 at 11:06 PM Rating: Excellent
As you are all aware, there is a problem with posting. I do know the database table where all posts are stored has been having issues for years just by looking at all the double/triple postings over the years. It's just more prevalent now that were are getting more traffic to the site than it has had in years. I have investigated into the issue debugging on the site here and 2 database tables show up to be the issues and you guessed it, the biggest culprit is the table where posts are stored for the forums. It's completely choking the SQL server to the point where it times out or a script is set up to kill processes if they run over 45 seconds. I'm sure that table is huge and it has some big performance issues because of it, at least that is my guess at this point. There can be other contributing factors causing these tables to take a long time inserting and pulling records as well.

Unfortunately ZAM is busy right now working on their featured sites and they can't spare developer resources for our site. However I was recently brought on as a consultant for ZAM and have looked over what I have access to right now. Once I get all the proper access I need I will be able to properly look through logs, monitor server performance and see what all is involved in the problem.

I have some theories as to what is contributing.

1. Large SQL tables performing badly.
2. Poorly designed pages with large SQL queries.
3. Heavy traffic on these poorly designed pages.

I just wanted to let ya guys know that we are aware of the issue and no one wants to get this fixed more than me. I work on the site quite a bit almost every day and it gets real old timing out, getting errors, double/triple posting. In posting this, it timed out on me and the entire site went unresponsive, ya it's quite annoying.

Edited, Aug 1st 2017 12:09am by Gidono
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#5 Aug 01 2017 at 9:29 PM Rating: Excellent
Avatar
*
178 posts
The site lag when someone posts has gotten to the point that everything is totally unresponsive for a minute. I feel like I am contributing to the problem now by posting. Somehow the forum posts have to be segregated from the rest of the site/server/database so that the transaction time of writing to the forum tables doesn't impact the functionality of the remainder of the site.

Could you split the forum DB tables into functional segments? ItemPosts. QuestPosts. GeneralPosts. MobPosts. ZonePosts. Query the one you need.

I'm going to take a hiatus from posting - I hate being part of the problem.
#6 Aug 01 2017 at 10:24 PM Rating: Excellent
That would be nice if we can move that table off onto into another database on another server. However that isn't something I can do, ZAM would have to get involved with that. I sent an email about it, we'll see what they say.
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#7 Aug 04 2017 at 7:37 AM Rating: Good
Guru
**
365 posts
Here is something I just did on last post that seemed to help. Typed my response in, hit post then went to top of screen and hit home while the circle was spinning. Took me out of the post screen but did not see my post when I returned to the screen I was posting on so I went to another screen and back and the post was there - just once. So clicking out to home maybe stopped the second post or at least made me feel it went faster.
#8 Aug 04 2017 at 11:38 AM Rating: Excellent
Waiting until the post times out sometimes will make it so the post doesn't double post but most of the time that doesn't help. I usually nuke the double posts so don't be afraid to post until we can get whatever wrong fixed. If I don't see your double posts, report the post and put in duplicate or whatever and when I get on, I'll nuke them.
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#9 Aug 06 2017 at 1:05 PM Rating: Excellent
It looks like some work has been done on the performance of the site within the last couple of days. Pages are opening up quicker. I just made a few posts and they posted within a few seconds. We'll see if that lasts under a heavy site load.
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#10 Aug 07 2017 at 6:18 AM Rating: Excellent
Sage
Avatar
**
756 posts
Just the opposite for me. The Latest ZAM Articles videos make pages almost impossible to read. They are always jumping around. I use an ad blocker to no avail and I refuse to pay to have sites work correctly. It's like paying "protection" money to gangsters.... Extortion in legal terms....
#12 Aug 13 2017 at 2:15 AM Rating: Excellent
*
161 posts
The last few things I've posted have been perfect. No doubles, no time outs and was almost instant. Thanks :)
#13 Aug 13 2017 at 1:29 PM Rating: Excellent
We haven't done any fixes to the posting database yet. I just got that database table over the weekend and I'm importing it into my local dev environment. The database table is very large (several gigs in size) so the import will take a while (almost 13 hours and still going and only at 38%). There is still some set up to do on my end to get my local dev environment completely set up. Also I will probably need more database tables it looks like to properly prune forum posts. Once I get the import done, I can go in and see what all I need to collect to do this.

The posting database table contains posts from all allakhazam sites (eq2, ffxi, ffxiv and so on). I have a plan on which forums I will be getting rid of. There are sites that were shutdown so I will be removing all posts from those sites. Also there will be some pruning of the sites that are still around. Mainly getting rid of posts that were nuked by content admins. When a content admin nukes a post, it actually isn't deleted. It's hidden from normal users. Also will be deleting blank posts or one word/character posts, spam and so forth that's not useful for the site.

Once everything is done, posting should no longer lock down the site and make people double/triple post. Hopefully posts will actually post right away. We'll see what happens.
____________________________
Allakhazam Developer and Admin

For real time update information on Allakhazam, follow me on Twitter!
https://twitter.com/gidono

Or join us via our Discord channel at https://discord.gg/zu9tTS7
#14 Aug 14 2017 at 10:26 AM Rating: Good
Scholar
***
1,156 posts
Just crashed hard posting a reply to "fellowship fire timer" and couldn't get the site to open for a couple of minutes.

When I got back in, the reply was there.. though.
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 149 All times are in CST
KC13, Anonymous Guests (148)