Previous Thread
Next Thread
Print Thread
Hop To
#214412 06/13/2008 10:31 AM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
I'm hopeful that one of you can lead me in the right direction! (Note: I did submit a support ticket to my host, but ...)

---

My site seems to be going down more and more--especially since the upgrade, and I don't know why that is.

(FYI--it's up now--but running very sluggishly)

IF there is something that would slow down a site that I currently have turned on, I will turn it off. I mainly (right now) just want a site that my community can rely upon 99.9% of the time.

I *think* the only really resource draining option I have turned on is "Who's Online." I can certainly turn this off, but, well, I like to be able to have some bells & whistles!

I don't have the Shout Box enabled.

I haven't been able to figure out the gallery, so that isn't taking up any resources.

---

I went into the Plesk--but I keep getting a certificate error. When I got in the back-door, I couldn't even access the server.

I saw that things were in the Red after being in the Yellow (with Red being very severe).

---

Anyway, I was hopeful that someone could either give me a 101 lesson, or point me to a site with more information, or let me know if there are some resource draining bells & whistles that I might have on but don't realize it.

I like 7.3, but I also like my site up and running!

Thank you for any & all feedback.

~Sue
adwoff.com

ADWOFF #214415 06/13/2008 11:07 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
well 7.3 is no more resource intensive than 7.2.2, so i'd look into what has changed as far as your hosting..

SD #214427 06/13/2008 4:44 PM
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
My personal sites get a small amount of traffic yet my VPS was dragging more and more. I 'd open a support ticket with the host, it would speed up for a day or 2 then back to a crawl. After waaaayyy too long I ditched the host for a dedicated server with another provider - it was overkill (we use <10% of the alloted resources) but really flies now smile


- Allen
- ThreadsDev | PraiseCafe
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
According to the tech guys with my site, the following is happening:

quote
This is something you're running. It might be related to the boards you have. Apache is just spawning processes like mad. Someone is exploiting UBB, as evidenced by this string from your access_log:

195.242.99.93 - - [10/Jun/2008:00:00:21 -0400] "GET /messageboard/ubbthreads.php?ubb=showflat&Number=650725%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=adwoff.com/messageboard/ubbthreads.php%3Fubb%3Dshowflat%26Number%3D650725&w=ubbthreads&d=WbXAS5zfQ7GE&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r2%22%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.jakchat.com/forums/ubbthreads.php/ubb/activetopics/range/7/type/p%22%20%3EJakChat%20-%20Forums%20and%20Chat%20for%20Indonesia's%20English-speaking%20community%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3EForums%20and%20chat%20for%20Indonesia's%20English-speaking%20community,%20in%20particular%20Jakarta%20and%20Bali.%20...%20JakChat%20Free-for-all%20...%20%B7%20My%20Cookies%20%B7%20Mark%20all%20read.%20Powered%20by%20...%3C/div%3E%3C!
span%20class=url%3Ewww.jakchat.com/forums/ubbthreads.php/ubb/activetopics/range/7/type/p%3C/span%3E%20-%20%3Cem%3E54k%3C/em%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=www.jakchat.com/forums/ubbthreads.php/ubb/activetopics/range/7/type/p&w=ubbthreads&d=Utj0H5zfQ5zx&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r3%22%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.darkskyfilms.com/DarkSkyForums/ubbthreads.php?ubb=showprofile&User=3%22%20%3EDark%20Sky%20Films'%20Forums:%20UBB%20Error%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3EHome.%20View%20All%20Titles.%20Pre-Orders.%20New%20Releases.%20Dark%20Sky%20...%20My%20Cookies%20%B7%20Mark%20all%20read.%20Powered%20by%20UBB.threads%20Contact%20Us%20%B7%20Dark%20Sky%20Films%20Home%20Page%20%B7%20Top%20...%3C/div%3E%3Cspan%20class=url%3Edarkskyfilms.c!
om/DarkSkyForums/ubbthreads.php?ubb=showprofile&User=3%3C!
/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=www.darkskyfilms.com/DarkSkyForums/ubbthreads.php%3Fubb%3Dshowprofile%26User%3D3&w=ubbthreads&d=X-k2oJzfQ64K&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r4%22%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.rightstuf.com/ubbthreads/ubbthreads.php/ubb/markallread.html%22%20%3EUBB%20Message%20-%20Anime%20Today%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3EYou%20must%20be%20logged%20in%20to%20access%20this%20page!%20Please%20click%20back%20...%20All%20Rights%20Reserved.%20Dealer%20Inquiries%20Invited.%20*The%20following%20restrictions%20apply%20to%20all%20...%3C/div%3E%3Cspan%20class=url%3Ewww.rightstuf.com/ubbthreads/ubbthreads.php/ubb/markallread.html%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-!
8&p=all%22%2Fubbthreads%2F%22&u=www.rightstuf.com/ubbthreads/ubbthreads.php/ubb/markallread.html&w=ubbthreads&d=dnEM8JzfQ5EO&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r5%22%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/curezone.com/forums/fm.asp?i=1190492%22%20%3Eanother%20group%20of%20mirena%20users%20at%20Mirena%20IUD%20Forum:%20Side%20Effects%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3E...%20www.aphroditewomenshealth.com/forums/ubbthreads.php?ubb=showflat&Number=64775&fpart=32%20...%20with%20artwork,%20100%%20all%20natural%20bamboo,%20reduces%20snoring%20and%20sleep%20...%3C/div%3E%3Cspan%20class=url%3Ecurezone.com/forums/fm.asp?i=1190492%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=curezone.com/forums/fm.asp%3Fi%3D1190492&w=ubbthreads&d=DJuRB5zfQ7gN&icp=1&.intl=us%22%3E!
Cached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r6%2!
2%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.obdii.com/forums/ubbthreads.php?ubb=showflat&Number=15357&page=1&fpart=1%22%20%3EOBDII%20Forums:%20O2%20sensors%20read%20high%20all%20the%20time,%20low%20mpg%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3E...%20Discussion%20%22%20OBDII%20(1996%20and%20up)%20%22%20O2%20sensors%20read%20high%20all%20the%20time,%20low%20mpg%20...%20My%20Cookies%20%B7%20Mark%20all%20read.%20Powered%20by%20UBB.threads%20Contact%20Us%20%B7%20OBDII%20...%3C/div%3E%3Cspan%20class=url%3Eobdii.com/forums/ubbthreads.php?ubb=showflat&Number=15357&...&fpart=1%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=www.obdii.com/forums/ubbthreads.php%3Fubb%3Dshowflat%26Number%3D15357%26page%3D1%26fpart%3D1&w=ubbthreads&d=LH1GYZzfQ5xH&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%!
3Cli%20id=%22r7%22%3E%3Cdiv%20class=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.soulstrut.com/ubbthreads/printthread.php?Cat=0&Board=crates&main=1118548&type=thread%22%20%3Esoulstrut.com/ubbthreads/printthread.php?Cat=0&Board=crates&...%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3E...%20cutting%20room%20floor,%20along%20with%20all%20of%20the%20other%20remotely%20hot%20...%20song%20on%20youtube%20and%20the%20comments%20are%20all%20like%20%22oh%20shit%22%20wayne%20killed%20this%20dudes%20beat%20etc.%20...%3C/div%3E%3Cspan%20class=url%3Esoulstrut.com/ubbthreads/printthread.php?...&main=1118548&type=thread%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=www.soulstrut.com/ubbthreads/printthread.php%3FCat%3D0%26Board%3Dcrates%26main%3D1118548%26type%3Dthread&w=ubbthreads&d=Tape35zfQ5B9&icp=1&.intl=us%22%3ECached%3C/a%3E%!
3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r8%22%3E%3Cdiv%20cl!
ass=%22res-p%22%3E%3Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/www.macfixitforums.com/ubbthreads.php/ubb/showflat/Number/441962/fpart/1%22%20%3ENot%20all%20new%20threads%20recognized%20-%20MacFixIt%20Forums%3C/a%3E%3C/h3%3E%3C/div%3E%3Cdiv%20class=%22abstr%22%3E...%20Forums%20%22%20MFIF%20Community%20%22%20Forums%20Feedback%20%22%20Not%20all%20new%20threads%20recognized%20...%20List%20page,%20try%20clicking%20on%20the%20%22Mark%20all%20read%22%20link%20in%20the%20lower%20left%20of%20the%20page.%20...%3C/div%3E%3Cspan%20class=url%3Emacfixitforums.com/ubbthreads.php/ubb/showflat/Number/441962/fpart/1%3C/span%3E%20-%20%3Ca%20href=%22http:/cache.search.yahoo-ht2.akadns.net/search/cache?ei=UTF-8&p=all%22%2Fubbthreads%2F%22&u=www.macfixitforums.com/ubbthreads.php/ubb/showflat/Number/441962/fpart/1&w=ubbthreads&d=bWFHm5zfQ69a&icp=1&.intl=us%22%3ECached%3C/a%3E%3C/div%3E%3C/div%3E%3C/li%3E%3Cli%20id=%22r9%22%3E%3Cdiv%20class=%22res-p%22%3E%3!
Cdiv%20class=%22res%22%3E%3Cdiv%3E%3Ch3%3E%3Ca%20class=%22yschttl%22%20href=%22http:/readerrant.capitolhillblue.com/ubbthreads.php?ubb=showflat&Number=30761&page=2%22%20%3ERussia%20" 414 323 "-" "-"

You need to fix this issue ASAP.
/quote

Yikes!

I have no idea what is happening or why it is happening or how to fix it!

Any and all advice would be appreciated.

Sue
adwoff.com

ADWOFF #214437 06/13/2008 9:22 PM
Joined: Dec 2005
Posts: 122
member
member
Joined: Dec 2005
Posts: 122
odd indeed. what's my site doing in there?!


JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I think "related searching"


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #214513 06/16/2008 5:07 PM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
Doesn't anyone have any idea what might be causing this?

I'm seriously concerned that if I cannot figure out what is taxing my board so much, I'll have no choice but to find a different board to use.

I don't want to do that.

I really, truly do not.

I've been with this software/company for more than 7 years now, and I really want to continue using the board, but if it
  1. either slows down my site, and/or
  2. doesn't even allow me access to my site ...

... I fear I'll have no choice but to find a different board to use.

I really, truly do not want to do this, but I also am not able/capable to figure out/fix this on my own.

Is there anyone else out there experiencing this?

Sue
adwoff.com

ADWOFF #214515 06/16/2008 5:30 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
The access log that they posted shows an odd URL, however if your support would have actually tried to go to that URL, they'd see that it actually just gives the standard UBB error message as all of the fields are sanitized. So, that's not the issue. It looks like just some sort of odd URL that is being accessed because of a search.

I see you have a VPS. The biggest question is has MySQL been properly tuned, or are you just running the stock MySQL config?

An example of why a properly tuned MySQL is so important. I just worked on a site a couple weeks back that has well over 2 million posts. They were running a stock MySQL config, and were getting load times anywhere from 1 second to 15 seconds. Searches taking 30-60 seconds.

After proper tuning, everything is in the subsecond range with searches taking 1-5 seconds.

You don't have a huge forum and generally when viewing your site right now, everything is very quick. Typical debug line I'm getting is:

Generated in 0.156 seconds in which 0.040 seconds were spent on a total of 22 queries

Looks like you have about 50 users online right now. So, under normal conditions such as these, everything appears to be running fine and fast. When you get slowdowns, it would be useful to see the debug line to see if it's coming from MySQL or from just general server slowdown.

Another thing is if you have SSH access to the server and if it's a Linux box then when you get the slowdowns you can run the 'top' command to get some info on what all is going on at that particular time.

Rick #214517 06/16/2008 5:35 PM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
Rick, thank you so much for taking the time to look/respond.

To be honest, I have no idea how to make sure MySQL has been properly tuned, and I also have no idea about this:

Originally Posted by Rick
Another thing is if you have SSH access to the server and if it's a Linux box then when you get the slowdowns you can run the 'top' command to get some info on what all is going on at that particular time

Is there a way to check?

While I'm no way an expert on any of this--in fact, most of this programming is absolutely Greek to me--I am able to follow directions fairly well. smile

Sue
adwoff.com

ADWOFF #214518 06/16/2008 6:11 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
The easiest might be to contact your host. They can probably give you the info on if you have SSH access, or if it's a Windows server, then if you have Remote Desktop access.

I'm going to guess they probably just set you up with the standard MySQL configuration. But the main thing will be to get some kind of idea on what the processing time looks like during a slowdown period. Maybe start a topic on your site and when any of your users experiences a slowdown, have them paste the bottom debug line that shows the page generation time into that thread so we can get some data.

Rick #214519 06/16/2008 6:17 PM
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I looked at the server header and seen:

Initiating server query ...
Looking up IP address for domain: adwoff.com
The IP address for the domain is: 209.216.253.27
Connecting to the server on standard HTTP port: 80
[Connected] Requesting the server's default page.
The server returned the following response headers:
HTTP/1.1 200 OK
Date: Mon, 16 Jun 2008 22:15:35 GMT
Server: Apache/2.0.52 (CentOS)
Last-Modified: Thu, 13 Mar 2008 10:14:46 GMT
ETag: "2ee180fe-13f4-d2ac5180"
Accept-Ranges: bytes
Content-Length: 5108
Connection: close
Content-Type: text/html
Query complete


Looks like Linux with a html control pannel.

Rick #214520 06/16/2008 6:18 PM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
Thanks, again, Rick. I appreciate the feedback.

--

Question for you: when you suggested setting up a thread and having people post the page generation info, are you talking about this:

Quote
Generated in 0.102 seconds in which 0.018 seconds were spent on a total of 12 queries. Zlib compression disabled.

Sue
adwoff.com

ADWOFF #214521 06/16/2008 6:24 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yep, that's the one. When you get any pages that are slow just copy/paste that. The first number shows the overall generation time for the page. The second shows how long it took for MySQL to do all of the queries.

If the first number is large and the second number is small, then it's general server slowdown. If the first number is large and the second number is almost equally large, then it's MySQL causing the bottleneck.

Rick #214522 06/16/2008 6:26 PM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
Again, thank you, Rick.

I'll get the thread going so that I can gather some info.

Sue
adwoff.com

Rick #214527 06/16/2008 7:39 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
she has full ssh access, but she doesn't know how to use it.

Her MySQL is the stock config.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #214528 06/16/2008 8:02 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Well if it comes down to MySQL needing tuning I know there are several people that can do it. It isn't something Groupee offers as it falls outside of the realm of general support, but I've done a this for a few sites on the side like the one I referred to originally.

Rick #214531 06/16/2008 9:42 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'd offer to do it, but I'm not really familliar with tuning mysql; apache on the other hand, I can tend to wade through


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 396 guests, and 110 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)