Sub Menu
Links Menu
Online Users

In total there are 313 users online :: 1 registered, 0 hidden and 312 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Google [Bot] based on users active over the past 60 minutes

optimizing db

Support for IntegraMOD 140

Moderator: Integra Moderator

optimizing db

PostAuthor: Rosey » Tue Oct 17, 2006 5:15 am

I'm back. *sigh*

So apparently it's not a host issue they say.

This is what I've done:

- cached the templates
- enabled gzip
- debug disabled
- prillian isn't installed
(i'm probably forgetting a few things)
- I've tried setting the cache for the blocks but when i do the userblock one, it screws up and when you refresh the page, you get welcome back someoneelse'snick so I took that one off. The others are set basically to the settings I saw on a post somewhere, I don't even remember now.

The one thing I haven't done is optimize the db, will that remove posts, what does that do exactly and does it make a difference?

It IS a lot faster already but it's not quite there yet.

<img>
Last edited by Rosey on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Rosey
Newbie
Newbie
 
Posts: 24
Likes: 0 post
Liked in: 0 post
Joined: Wed Oct 11, 2006 5:59 am
Cash on hand: 0.00

Re: optimizing db

PostAuthor: Frost » Wed Oct 18, 2006 9:17 pm

No, optimizing the db will not remove any content you added. It basically just cleans up a bit, it should also show you if they need to be optimized. But yes it's safe to do so and will most likely help a little.

Frost
Last edited by Frost on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[size=99px]PhpBB3 Themes[/url] ]PhpBB3 Development Center[/url] [/size]

Frost
Sr Integra Member
Sr Integra Member
 
Posts: 776
Likes: 0 post
Liked in: 0 post
Joined: Wed Sep 13, 2006 1:04 am
Cash on hand: 0.00
Location: Photoshop CS3

PostAuthor: Rosey » Wed Oct 18, 2006 9:54 pm

Thank you. I took the plunge earlier and it did help. It seems to be running great for me now but some people are still whinning.
Last edited by Rosey on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Rosey
Newbie
Newbie
 
Posts: 24
Likes: 0 post
Liked in: 0 post
Joined: Wed Oct 11, 2006 5:59 am
Cash on hand: 0.00

PostAuthor: Rosey » Thu Oct 19, 2006 2:25 pm

It's still slow during the day. I don't know what to do anymore <img>
Last edited by Rosey on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Rosey
Newbie
Newbie
 
Posts: 24
Likes: 0 post
Liked in: 0 post
Joined: Wed Oct 11, 2006 5:59 am
Cash on hand: 0.00

Re: optimizing db

PostAuthor: Drop-Forged » Thu Oct 19, 2006 2:47 pm

Well:

1. Integramod is a heavily moded portal, so it is not the fastest thing out there, but with a good setup, and a good server it is not a slow portal system either.


2. If your site is on a slower server, or if the servers resources are depleted by other sites, this will affect your site, especially during busy times.


If you and your guest notice it is slower at certain times, it probably means that the server that your site is hosted on is usually busy during those times.
Last edited by Drop-Forged on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://www.christiansoldiers.com/Sig/sig.png[/img][/url]
[url=http]Free IntegraMod 141 Themes at webhutch.net[/url]

Drop-Forged
Integra Member
Integra Member
 
Posts: 167
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 08, 2006 7:07 pm
Cash on hand: 0.00

PostAuthor: Rosey » Thu Oct 19, 2006 2:51 pm

That's what I'm thinking because in the evening, it flies. I keep telling this to the owner but he is dragging his feet. I think I have done everything I can on my end.

This is what I've done

4518 registered users
114663 articles in 11536 topics

Usually about 30 people are on at one time and I think in a day we get 2/300 new posts or so.

- Prillian not installed
- debug off
- gzip enabled
- Style cached (only have one right now)
- Cached the portal blocks
- optimized the db
- upped the php size deal in config.php
- took out the shout box, chat's not active, took out the calendar
- it isn't graphic heavy, just the one banner 15kb.


Also, what is the cron feature on the optimizing and would collapsing the index help?

Thank you so much, I have racked my brain on this and read so many posts and tried everything I've seen.

I just reoptimized the DB, how often do you do this? I did it yesterday and now there are tables that are not ok again...same ones as yesterday.
Last edited by Rosey on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Rosey
Newbie
Newbie
 
Posts: 24
Likes: 0 post
Liked in: 0 post
Joined: Wed Oct 11, 2006 5:59 am
Cash on hand: 0.00

PostAuthor: Rosey » Mon Oct 23, 2006 7:11 pm

Anybody? It's still slow and I'm going to have to revert back to just plain old phpbb if I can't get this to improve. I've given it almost 3 weeks of tweaking and I don't know what I can do anymore <img>
Last edited by Rosey on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

Rosey
Newbie
Newbie
 
Posts: 24
Likes: 0 post
Liked in: 0 post
Joined: Wed Oct 11, 2006 5:59 am
Cash on hand: 0.00

PostAuthor: ZacFields » Sun Dec 03, 2006 11:13 am

I've had this same problem as of recently. When I first moved to the new VPS it wasn't a problem at all.

Now the site is getting around 5 second page loads but my CPU usage spikes to 100% every few seconds and then back down to around 1%.

My host (spry) says that my script needs optimizing.

Zac
Last edited by ZacFields on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ZacFields
Sr Integra Member
Sr Integra Member
 
Posts: 426
Likes: 0 post
Liked in: 0 post
Joined: Wed May 24, 2006 10:14 pm
Cash on hand: 0.00

PostAuthor: ZacFields » Sun Dec 03, 2006 12:25 pm

Anyone have any ideas on how I can check to see which script is causing this spike. This is a sudden recent problem as far as I know.

I installed the garage mod to my forums last night but as far as I can tell that's just a coincidence. I have my statistics (like webalizer for cpanel) updated only once a week and it updated last night which was when this started. Anyone know if that might be part of the problem?

Zac

PS: Even though this was a sudden occurance, I still went through and did everything from that integramod.com link just to make sure. (The integramod link was from a different topic, but it had a list of suggestions such as "remove prillian" disable debug, and etc)

Zac
Last edited by ZacFields on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

ZacFields
Sr Integra Member
Sr Integra Member
 
Posts: 426
Likes: 0 post
Liked in: 0 post
Joined: Wed May 24, 2006 10:14 pm
Cash on hand: 0.00

PostAuthor: tekguru » Sun Dec 03, 2006 11:05 pm

I hit similar problems and th only way out was to upgrade to a more powerful VPS <img>
Last edited by tekguru on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[size=99px]http][/size]
[url=http][img=left]http://www.4winmobile.com/news/MVP_Horizontal_FullColor.png[/img][/url]
User avatar
tekguru
Sr Integra Member
Sr Integra Member
 
Posts: 329
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 28, 2006 10:29 pm
Cash on hand: 0.00

Re: optimizing db

PostAuthor: Helter » Sun Dec 03, 2006 11:55 pm

I have been a strang advocate for Spry for the last 2 years. They used to be fast both in hardware and tech support. I had the same problem as you (ZacFields), a sudden unexplained huge cpu and db overhead. I shut off all but one completely stock IM140 site with only 2 members and no acivity and the cup usage was 100%. Spry has serious issus and they left me hanging with the same advise, to optimize a file that you should not change due to the fact that you do not have enough info about the actual specs of the server/os. I think all the really knowlegeble staff that I used to deal with are gone, and they are overloading thier servers. I say this because through all my problems, they could do nothing but point the finger at me, and I know that nothing had changed in my sever setup in months, and that member activity was way down compared to the previous month when the server was extremely fast.

even now with the dedicated server, there are quite a few things that are misconfigured, or broken, and they cannot/will not fix it. They tell me the dedicated server does not come with tech support. I tell them that if the server were working correctly when they set it up, I would not need tech support, then they ignore me. needless to say, im looking for another dedicated server host...
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3


Return to IntegraMOD 140

Who is online

Registered users: Google [Bot]

cron