Go Back   Computer Forums > Welcome To Computer Forums .org > Site Admin, News and Feedback
Click Here to Login
Join Computer forums Today


Closed Thread
 
Thread Tools Search this Thread Display Modes
 
Old 04-30-2007, 02:02 PM   #41
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,007
Default Re: Two things

Quote:
Originally Posted by David Lindon View Post
The server is not stressed in any way, cpu and memory are fine. The CF DB is ~420MB and is fully indexed so no problems them.
I meant in terms of row size...

there is over a half million posts, does this meant that the threads table has a half million rows in it.

if you actually log into the server use SQL query and type a simple query how long does it actually take to return this data? and what about more complex queries?

fair enough the site may be fully indexed, but does that actually help in this siteuation, (http://www.mysqlperformanceblog.com/...-large-tables/)



and what of the databases for other sites that are always on as well.
how many rows do all these other sites take up?
and what of the free forums that are also hosted on the same server?

you're running handfuls of sites of a server that just doesn't seem up to the job,
alternatively,
what's the traffic like coming to the sites? (as in all the sites running on the same server, not just this site).

whats the Apache configuration like, like how many active connections can you process, what's the keep alive time, what's Maxclients set to, is this too low for the amount of traffic that you receive?



The point is that there is something wrong somewhere and ideally it does need to be fixed.

just hopping to a new server isn't really going to help I doubt, but you do need to look at what is going on with these things. consider more possibilities...

TBH I doubt that it's the new forum software that's causing these troubles
__________________

__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline  
Old 04-30-2007, 02:29 PM   #42
Golden Master
 
Join Date: Mar 2005
Posts: 13,091
Default Re: Two things

Like I said, it looks like the PHP scripting. I don't know much about those languages, but it looks like PHP.
__________________

lhuser is offline  
Old 04-30-2007, 04:55 PM   #43
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: Two things

Quote:
Originally Posted by root View Post
I meant in terms of row size...

there is over a half million posts, does this meant that the threads table has a half million rows in it.

if you actually log into the server use SQL query and type a simple query how long does it actually take to return this data? and what about more complex queries?

fair enough the site may be fully indexed, but does that actually help in this siteuation, (http://www.mysqlperformanceblog.com/...-large-tables/)



and what of the databases for other sites that are always on as well.
how many rows do all these other sites take up?
and what of the free forums that are also hosted on the same server?

you're running handfuls of sites of a server that just doesn't seem up to the job,
alternatively,
what's the traffic like coming to the sites? (as in all the sites running on the same server, not just this site).

whats the Apache configuration like, like how many active connections can you process, what's the keep alive time, what's Maxclients set to, is this too low for the amount of traffic that you receive?



The point is that there is something wrong somewhere and ideally it does need to be fixed.

just hopping to a new server isn't really going to help I doubt, but you do need to look at what is going on with these things. consider more possibilities...

TBH I doubt that it's the new forum software that's causing these troubles
Its something to do with the configuration of the various components, it just takes me time to work through them tweaking here and there
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 04-30-2007, 05:16 PM   #44
Golden Master
 
Join Date: Apr 2006
Posts: 7,534
Default Re: Two things

Guys, give David a rest. With all the possibilities of what could be wrong, if I owned the forum now, I would definitely be frustrated (considering I know nothing about PHP/MySQL).

So what if we don't get 10,000 skins or custom avatars? (I know it would be nice, but) at least David tries to keep everything stable.
LA061 is offline  
Old 05-02-2007, 04:21 AM   #45
Golden Master
 
Brookfield's Avatar
 
Join Date: Apr 2005
Posts: 10,056
Default Re: Two things

Three database errors this morning so far, the glitches are alive & well & are doing fine!, oh & everything has slowed down again.
Brookfield is offline  
Old 05-02-2007, 05:12 AM   #46
Fully Optimized
 
A True Folder's Avatar
 
Join Date: Jan 2007
Posts: 2,789
Default Re: Two things

The problems plagueing this forum are definitely annoying. Most times I just give up and try the next day
A True Folder is offline  
Old 05-02-2007, 06:09 AM   #47
Golden Master
 
Brookfield's Avatar
 
Join Date: Apr 2005
Posts: 10,056
Default Re: Two things

Quote:
Originally Posted by A True Folder View Post
The problems plagueing this forum are definitely annoying. Most times I just give up and try the next day
If you're talking about database errors, is that what you mean?, they are occurring everywhere, not just here, David is trying to eliminate them.
Brookfield is offline  
Old 05-02-2007, 06:32 AM   #48
Daemon Poster
 
Steff's Avatar
 
Join Date: Sep 2006
Posts: 1,435
Send a message via MSN to Steff
Default Re: Two things

I've been getting them more and more everyday even the white screen thing now and again.
__________________
hi, i like eggs.
Steff is offline  
Old 05-02-2007, 04:46 PM   #49
Site Team
 
David Lindon's Avatar
 
Join Date: Dec 2002
Posts: 15,233
Default Re: Two things

Well it went down today because I was trying a few different settings. I tried using persistant connections so each user maintains the db connection while they are logged on instead of creating a connection each time they view a page and then discard it. But ofcourse a search engine bot appear and put the number of connections over the limit so new visitors were denied access
__________________
[url=http://www.LNXPS.NET]LNXPS.NET - The XPS Library]
David Lindon is offline  
Old 05-02-2007, 04:56 PM   #50
Golden Master
 
Brookfield's Avatar
 
Join Date: Apr 2005
Posts: 10,056
Default Re: Two things

Quote:
Originally Posted by David Lindon View Post
Well it went down today because I was trying a few different settings. I tried using persistant connections so each user maintains the db connection while they are logged on instead of creating a connection each time they view a page and then discard it. But ofcourse a search engine bot appear and put the number of connections over the limit so new visitors were denied access
Mmmm
__________________

Brookfield is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 08:28 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0