Jump to content

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


Recommended Posts

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.

Link to comment
  • Replies 45
  • Created
  • Last Reply

Top Posters In This Topic

  • Administrator

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. :shrug:

Link to comment

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

Link to comment
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.

Link to comment
  • Administrator
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.

:lol:

Link to comment
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.

Link to comment
  • Administrator

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.

Link to comment
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 by Mugster
Link to comment
  • Administrator

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.

Link to comment
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.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

TRADING POST NOTICE

Before engaging in any transaction of goods or services on TGO, all parties involved must know and follow the local, state and Federal laws regarding those transactions.

TGO makes no claims, guarantees or assurances regarding any such transactions.

THE FINE PRINT

Tennessee Gun Owners (TNGunOwners.com) is the premier Community and Discussion Forum for gun owners, firearm enthusiasts, sportsmen and Second Amendment proponents in the state of Tennessee and surrounding region.

TNGunOwners.com (TGO) is a presentation of Enthusiast Productions. The TGO state flag logo and the TGO tri-hole "icon" logo are trademarks of Tennessee Gun Owners. The TGO logos and all content presented on this site may not be reproduced in any form without express written permission. The opinions expressed on TGO are those of their authors and do not necessarily reflect those of the site's owners or staff.

TNGunOwners.com (TGO) is not a lobbying organization and has no affiliation with any lobbying organizations.  Beware of scammers using the Tennessee Gun Owners name, purporting to be Pro-2A lobbying organizations!

×
×
  • Create New...

Important Information

By using this site, you agree to the following.
Terms of Use | Privacy Policy | Guidelines
 
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.