Welcome to SP!  -
Areas & RangesMountains & RocksRoutesImagesArticlesTrip ReportsGearOtherPeoplePlans & PartnersWhat's NewForum

Server speed

Suggestions and comments about SummitPost's features, policies, and procedures. Post bugs here.
 

Re: Server speed

Postby Kiefer » Wed Oct 05, 2011 8:51 pm

Page load pretty good, Matt. Seems to work fine.
This afternoon, I've been trying to make changes to some pages I took over and submitting the changes
is taking quite a while. Maybe I'm just impatient but it seems to be taking upwards of 30 seconds to upload everything
from a sentence change to whole images with links. Is there a difference in the 'coding end of things' between uploading content vs.
clicking previously uploaded content?
Thanks, Matt!
User Avatar
Kiefer

 
Posts: 531
Joined: Thu Jan 19, 2006 1:30 pm
Location: Estes Park, Colorado, United States
Thanked: 116 times in 65 posts

Re: Server speed

Postby Montana Matt » Wed Oct 05, 2011 10:04 pm

Kiefer Thomas wrote:Page load pretty good, Matt. Seems to work fine.

OK good. I think so too.
Kiefer Thomas wrote:Is there a difference in the 'coding end of things' between uploading content vs. clicking previously uploaded content?

If I recall correctly, no, the code is essentially the same, but it may be worth looking at again. You're noticing longer times to edit existing content than simply creating new content? If it's repeatable, then it would be worth investigating.

The root of the problem is that in either case (modifying content or creating new content), the `objects` table in the database has to be written to. The `objects` table and the `users` table are the only two tables left in the database that use MyISAM storage engine. All of the rest of the tables in the database have been moved to the InnoDB storage engine. The key difference between the two storage engines that is causing the delays is that the MyISAM storage engine locks at a table level when doing writes, while the InnoDB locks at a row level.

That means that anytime someone is writing to either MyISAM table (objects or users), they must wait for all of the reads to complete before the table can be locked and the write is completed. And every time someone loads a page on SP, they're reading from the MyISAM `objects` and `users` tables. So writes are delayed until all pending reads are completed, which during high traffic times could be quite a wait.

The solution to the problem is to move the `objects` and `users` tables to a storage engine that allows simultaneous reads and writes (the InnoDB engine in MySQL). The problem with that is that the InnoDB engine doesn't support fulltext search, so if those tables were switched to using the InnoDB storage engine, end users couldn't search for users or objects by name which would be unacceptable. So to fix this problem gets very involved and complicated. There are ways around having tables with fulltext indices while maintaining a way to search the entries of the table, but it requires a significant change to site structure (database and code). I want to do it sometime in the near future, but I don't currently have the time to invest in such a large project. I'm hoping that I will sometime this winter though.
User Avatar
Montana Matt
Site Admin
 
Posts: 1136
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 341 times in 184 posts

The following user would like to thank Montana Matt for this post
Josh Lewis, Kiefer, mvs

Re: Server speed

Postby Josh Lewis » Wed Oct 05, 2011 10:33 pm

I got bored and decided to read part of this article:
http://tag1consulting.com/MySQL_Engines ... _vs_InnoDB

Lately I been working with databases myself. It gets a bit complicated (although yes, I'm not super experienced at it). :wink: Anyways, thanks for looking into it Matt, hope some day for a solution to this.
My Websites: Alpine Josh · Alpine Ascent · AceMaps
User Avatar
Josh Lewis

 
Posts: 2288
Joined: Thu Jan 06, 2011 11:12 pm
Location: Lynnwood, Washington, The Cloudiest Place on Earth, United States
Thanked: 475 times in 324 posts

Re: Server speed

Postby Josh Lewis » Mon Oct 10, 2011 6:44 am

Has anyone else noticed this. It seems to be decent speed most of the time, then randomly it goes slow for a page load (while it's loading I open up a new tab for sp which is virtually instant, and then my other tab eventually works). But then again this mostly applies to changing pages. Well it's not a big deal so far. :wink: (this post took less than a second to be published. :D )
My Websites: Alpine Josh · Alpine Ascent · AceMaps
User Avatar
Josh Lewis

 
Posts: 2288
Joined: Thu Jan 06, 2011 11:12 pm
Location: Lynnwood, Washington, The Cloudiest Place on Earth, United States
Thanked: 475 times in 324 posts

Re: Server speed

Postby Kiefer » Mon Oct 17, 2011 1:45 am

Josh Lewis wrote:Has anyone else noticed this. It seems to be decent speed most of the time, then randomly it goes slow for a page load (while it's loading I open up a new tab for sp which is virtually instant, and then my other tab eventually works). But then again this mostly applies to changing pages. Well it's not a big deal so far. :wink: (this post took less than a second to be published. :D )


Yep. Noticed that too. It had me scratching my head. In fact, it still scratches.
Thanks for the response, Matt. I actually had to look up a couple words in your response! :oops:
I'll keep plugging away at it. Today, page loads for edits to new content is taking upwards of 4 minutes. But at least there's
a reason for it. Thanks, Matt.
User Avatar
Kiefer

 
Posts: 531
Joined: Thu Jan 19, 2006 1:30 pm
Location: Estes Park, Colorado, United States
Thanked: 116 times in 65 posts

Re: Server speed

Postby Josh Lewis » Mon Oct 17, 2011 2:31 am

Now I'm becoming more hesitant to post my trip reports in pieces (with most of it done in the first posting). I try to post as much as possible before hitting the submit button because I know how long it will take for it to be published. :?
My Websites: Alpine Josh · Alpine Ascent · AceMaps
User Avatar
Josh Lewis

 
Posts: 2288
Joined: Thu Jan 06, 2011 11:12 pm
Location: Lynnwood, Washington, The Cloudiest Place on Earth, United States
Thanked: 475 times in 324 posts

Re: Server speed

Postby butitsadryheat » Mon Oct 17, 2011 5:48 am

Really? I haven't seen any slowdown for the last couple of weeks
User Avatar
butitsadryheat

 
Posts: 8247
Joined: Fri Dec 30, 2005 7:59 pm
Location: Bakersfield, California, United States
Thanked: 1443 times in 1048 posts

Re: Server speed

Postby Josh Lewis » Mon Oct 17, 2011 7:07 am

So do your submissions post fast when making a edit on a page? I just did a test which it seems as though it is faster to post a page than it is to edit a page. :?: Try editing one of your mountain pages or trip reports and let me know if it posted at a decent speed. I posted a test page a few seconds ago (I deleted it) and it posted right away. :)
My Websites: Alpine Josh · Alpine Ascent · AceMaps
User Avatar
Josh Lewis

 
Posts: 2288
Joined: Thu Jan 06, 2011 11:12 pm
Location: Lynnwood, Washington, The Cloudiest Place on Earth, United States
Thanked: 475 times in 324 posts

Re: Server speed

Postby Alpinist » Mon Mar 19, 2012 2:23 am

SP is dead slow again this evening. It's unusable if you're trying to upload images or work on pages.
User Avatar
Alpinist

 
Posts: 6005
Joined: Tue Jul 29, 2003 7:21 pm
Location: Kildeer, Illinois, United States
Thanked: 639 times in 436 posts

Re: Server speed

Postby Josh Lewis » Mon Mar 19, 2012 6:40 am

Well I guess than pretty soon I should launch what I call "Operation Clean up SummitPost". Basically it would encourage users to do some simple things that would help speed up SP. I'll have to make some screen shots so it might be a few days. :wink:
My Websites: Alpine Josh · Alpine Ascent · AceMaps
User Avatar
Josh Lewis

 
Posts: 2288
Joined: Thu Jan 06, 2011 11:12 pm
Location: Lynnwood, Washington, The Cloudiest Place on Earth, United States
Thanked: 475 times in 324 posts

Re: Server speed

Postby lcarreau » Mon Mar 19, 2012 1:11 pm

Aaaarg ... it's been moving like a SNAIL on my end ...!

Hope "Operation Clean-up Summitpost" gets started quickly ... my hands are getting tired holding up this sign ...

Image
User Avatar
lcarreau

 
Posts: 4052
Joined: Thu Sep 06, 2007 10:27 pm
Location: Court of the Crimson King, Arizona, United States
Thanked: 879 times in 660 posts

Re: Server speed

Postby Marmaduke » Sat Jul 07, 2012 8:33 pm

Real SSSSSSSSLLLLLLLLOOOOOOOWWWWWW, recently
User Avatar
Marmaduke

 
Posts: 1327
Joined: Tue Feb 02, 2010 1:08 am
Location: Sonoma, California, United States
Thanked: 578 times in 444 posts

Re: Server speed

Postby Montana Matt » Sat Jul 07, 2012 8:55 pm

Marmaduke wrote:Real SSSSSSSSLLLLLLLLOOOOOOOWWWWWW, recently

Should be a bit better now. But I think I might have to migrate the entire site to a new server sometime soon. The software that the server is running is getting old now and, after speaking with our host, SP could definitely benefit from updated/better optimized software.
User Avatar
Montana Matt
Site Admin
 
Posts: 1136
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 341 times in 184 posts

The following user would like to thank Montana Matt for this post
Diego Sahagún, lcarreau, MarkDidier, Marmaduke

Re: Server speed

Postby Kahuna » Sat Jul 07, 2012 9:21 pm

Montana Matt wrote:...., SP could definitely benefit from updated/better optimized software.


Like everything else in life, adapting to change, progress and upgraded from old ways of operating, is a true sign of wisdom. Speaking from personal experience actually.

Thanks for all your hard efforts and work here on SP, Matt.
Kahuna

 
Posts: 396
Joined: Sun Jul 01, 2012 4:43 am
Thanked: 153 times in 105 posts

The following user would like to thank Kahuna for this post
Buz Groshong, Josh Lewis

Previous

Return to Site Feedback

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 0 guests

© 2006-2013 SummitPost.org. All Rights Reserved.