Server Performance... - Page 6 - PeachParts Mercedes-Benz Forum

smharr4 · #76 09-29-2011, 04:32 PM

Quote:

Originally Posted by Army

Can you run mysql on more than one server?

I didn't think it was capable of doing Oracle-like tricks...

You can replicate your datasets amongst several slave MySQL servers to spread out load for a read-heavy application. In theory, all your data writes should go to the master, all your reads should go to the slave, and backups/mysqldumps should come from yet another slave.

This is actually one half of my favourite pair of interview questions when talking to potential employees.

Aquaticedge · #77 09-29-2011, 11:47 PM

another error- When I post replies, at times it'll sit at the submit page, when I go and hit refresh the box comes up saying it's a simular post and it will take me to it.. it's like at times the submission page will hang while the reply is made without redirecting back to the topic inwhich the reply was in.

Stretch · #78 10-01-2011, 02:02 PM

Wow - really S L O W today for previous hour at least...

Brian Carlton · #79 10-03-2011, 09:10 AM

9:05 EDT

Firefox and Chrome unable to load a page for over one minute.

9:06-9:10 EDT

Pages load slowly...........4-5 seconds each.

9:30 EDT

Pages load normally (fast).

Wayne 962 · #80 10-04-2011, 05:49 PM

Quote:

Originally Posted by smharr4

This looks like multiple machines are used to run the forums behind some form of load-balancing system, but the user's login session information is being stored on the server, so the next time you log in (and hit a different server) that machine thinks you're not logged in (because it doesn't have any information about your session), but the database does.

I think it's related to some of the old files being cached on the old server?

Not 100% sure, I can't seem to replicate this from this end...

-Wayne

Wayne 962 · #81 10-04-2011, 05:51 PM

Quote:

Originally Posted by sjh

Slow.

Font & Size links above do not work.

I just checked, and they work on my browser? Firefox?

-Wayne

Wayne 962 · #82 10-04-2011, 05:52 PM

Quote:

Originally Posted by Brian Carlton

9:05 EDT

Firefox and Chrome unable to load a page for over one minute.

9:06-9:10 EDT

Pages load slowly...........4-5 seconds each.

9:30 EDT

Pages load normally (fast).

I was working on the server this day, during the day. I saw some slowdowns too, might have been related to what I was working on. I'll take a closer look...

-Wayne

Wayne 962 · #83 10-04-2011, 06:38 PM

I just made some more changes to the configuration on the server. Hopefully, this will fix some of the slowdown issues that you guys have been seeing.

-Wayne

Stretch · #84 10-05-2011, 12:44 AM

For the last 20 hours or so I've had to log in twice to actually log in...

(Linux + firefox)

Wayne 962 · #85 10-05-2011, 01:35 AM

Quote:

Originally Posted by Army

For the last 20 hours or so I've had to log in twice to actually log in...

(Linux + firefox)

What does that mean exactly? How are you getting to the site? Do you have it bookmarked or something like that? The old site used some old bookmarks, the new server is redirecting you probably. I would re-bookmark the site, and that will probably cause the issues to go away? Maybe?

I added something called VBSEO which is a superb search-engine optimization tool for the forums. Trouble is, it turns all of the URLs into "text friendly" ones. The old links still work fine, but they may give trouble when the cookies are not updated, or you do not click the "remember me / keep me logged in button".

-Wayne

Stretch · #86 10-05-2011, 04:16 AM

Quote:

Originally Posted by Wayne at Pelican Parts

What does that mean exactly? How are you getting to the site? Do you have it bookmarked or something like that? The old site used some old bookmarks, the new server is redirecting you probably. I would re-bookmark the site, and that will probably cause the issues to go away? Maybe?

I added something called VBSEO which is a superb search-engine optimization tool for the forums. Trouble is, it turns all of the URLs into "text friendly" ones. The old links still work fine, but they may give trouble when the cookies are not updated, or you do not click the "remember me / keep me logged in button".

-Wayne

I'm a paranoid internet user.

I have a firefox add-on called better privacy that removes all of the flash cookies on my hard drive (in addition to firefox doing it as standard - firefox seems to leave the main index cookie for some reason or other). In addition I have another add-on called noscript that stops script executions without my permission.

Peach Parts is on my white list.

So in effect each time I log on to the site by typing in your address I arrive with a clean never been used before system. I don't use bookmarks much - certainly not for the 3 places I visit on the internet - no point.

I click on "shop forum" and then type in my user name and then my password.

It is very boring and mechanical! I don't use any help programs to log me in - I don't even use a commonly typed words utilities - neither do I use auto fill - or remember passwords... I have never used remember me...

I have logged on twice this morning. On each occasion I got through in one go.

Yesterday I had to type in my user name - then password - (press return)

I got the welcome XXXX thank you for logging in screen...

...and then It was as though I was not logged in.

No quick reply boxes at the bottom of threads - just not logged in!

So I retyped my user name and password and whey hey - logged in!

At times - perhaps at busy times? - there seems to be a delay in the system. I can't tell for sure here but that seems to be the case from where I'm sitting!

Wayne 962 · #87 10-05-2011, 11:44 AM

Hmm, I can't seem to replicate that behavior here. I use Opera for testing issues like these, which I have set to wipe out everything upon exit. I just opened it up, typed in the address, logged in, and it says I'm logged in okay.

Okay, I think I see what's happening, you're probably typing in peachparts.com, not PeachParts - Mercedes Parts & Tech Info. Is that the case?

-Wayne

Wayne 962 · #88 10-05-2011, 11:47 AM

Okay, I just added a "rewrite rule" that will automatically convert peachparts.com requests into PeachParts - Mercedes Parts & Tech Info requests. This should fix the problem that you're having. The variability is probably caused by sometimes typing it in with the www and without. Before I updated this, if you typed it without, you would get the behavior you're experiencing.

-Wayne

Stretch · #89 10-05-2011, 12:56 PM

Thanks! I'm amazed that that makes a difference - thanks again.

Wayne 962 · #90 10-05-2011, 10:28 PM

Quote:

Originally Posted by Army

Thanks! I'm amazed that that makes a difference - thanks again.

It has to do with domains and subdomains and security with cookies not being able to be cross-read amongst the domains. I had to figure this out the hard way a long time ago!

-Wayne