Made some changes to our database server and it seems faster to me. How about you?

[Guest GT_Rat]

Moving along nicely now. Yesterday afternoon it was doing well but last night it got really slow for some reason. Now it seems to be good.

[TGO David]

This morning's changes seem to be holding nicely. I've got a feature enabled that shows me (and only me) a list of stats at the bottom of each page and so far the numbers are well below the threshold that usually causes problems.

I'll be monitoring this continually and making adjustments as needed to keep it running smoothly.

[Guest slim]

Thank's David, last night was the worst and slowest i have ever seen on the forum, but today all is great again.

So now i can speed-Troll again.

Thank's James:D

[TripleDigitRide]

Fatal error: Out of memory (allocated 6553600) (tried to allocate 71167 bytes) in /home/tgoforum/public_html/forums/includes/vba_cmps_include_bottom.php on line 178

Got this error message two times today. No problems with any other site.

[Guest tnmale46]

Fatal error: Out of memory (allocated 6553600) (tried to allocate 71167 bytes) in /home/tgoforum/public_html/forums/includes/vba_cmps_include_bottom.php on line 178

Got this error message two times today. No problems with any other site.

i got that a couple time too.

[TGO David]

On the main page?

[TripleDigitRide]

Yes. Trying to refresh the "Home" page. It's happened 2 or 3 times to me.

[Guest tnmale46]

on a couple different pages for me seems ok now.

[TGO David]

I've rolled back all of the changes I have made so far and am going to try some different things. The forum will seem slower at times, but should be more stable.

[TGO David]

Running a very conservative customized version of the default database settings. Performance looks good at the moment but will have to monitor for errors and such.

[strickj]

Getting allot of slow responses today,along with some pages not even pulling up.gotta click refresh a couple times on some of them

[TGO David]

Getting allot of slow responses today,along with some pages not even pulling up.gotta click refresh a couple times on some of them

Moderators have no excuse for not reading the Announcements Forum.

[strickj]

What this?

http://www.tngunowners.com/forums/tn-gun-owners-announcements/19733-server-upgrade-ordered-april-7-2009-a.html

I read that,but it didn't contain any tactical rolling advice,so I must've not paid attention.

Just consider it a last minute update before the new server upgrade whatever.Ill repost again afterwards to let you know if it worked or not!

[TGO David]

I'm going to tactically roll you down a boat ramp.

[Guest db99wj]

Bahwahahhahahahaaaaa!

[Guest Mugster]

On the memory problems for a cheap fix, you should have a php.ini file. In that file there is a memory threshold a php script can consume. Looks like yours is set to 64 megs. Double it to 128.

Should look like this:

memory_limit = 64M

Make it look like this:

memory_limit = 128M

This file is located in /etc on most linux systems. I don't do windows.

[TGO David]

I usually run 128M on mine but we pulled it back to 64 at the request of the hosting company while they were "testing and troubleshooting". I really miss having my own server. Our last box had dual Xeon procs and 4GB memory. It hauled ass.

[Guest Mugster]

The little company I support is down. I may hit you up for a hosting recommendation. Turns out a tornado in the grill ain't good for t1 lines. Its 6 of 1 half dozen of the other. For the little guy, you have a control/reliability continuum thats tough to crack without throwing alot of money at it.

Edited April 12, 2009 by Mugster

[TGO David]

So far today, we've had good results with our server. I have inquired about any changes that were made but I suspect that when I rebooted this morning, either changes that I had made previous and were stuck pending went through, or they made some changes that they haven't told me about yet.

Our load average right now looks like this: 0.73 0.58 : 0.55

It's been below 1.00 all morning long, too. Seems kind of ironic that we've had spikes up to 30.xx throughout the week and now suddenly we're seeing good performance.

[Guest Mugster]

Any loads that high (30) almost have to be I/O related/disk. I doubt your doing much if anything with the procs.

You can fool around with looking at /proc/diskstats or something similar and compare it to hdparm output to verify, but its all "funny numbers" on a VM. VM's are overrated and used as crutches to propagate poor systems design, security, and admin, imo. It could also be they allocated you X ram on VM creation and you were using X + 1.

sysreport is also a handy utility, but marginal useage on a VM.

[Smith]

What was the deal last night. Neither sites would come up at all from about 0000 to 0800?