Speed issues... - Page 2

outlnder · 2002-08-19, 23:39

Quote:

phpBB Created this page in 13.686364 seconds : 16 queries executed : GZIP compression enabled

Quote:

phpBB Created this page in 15.138998 seconds : 13 queries executed : GZIP compression enabled

Tasuke · 2002-08-20, 00:57

phpBB Created this page in 17.779320 seconds : 14 queries executed : GZIP compression enabled

to bring up this page

phpBB Created this page in 19.904057 seconds : 18 queries executed : GZIP compression enabled

to post

/edited for the post speed

Xyzzy · 2002-08-20, 01:41

The current plan is to change our database to a different server... Apparently the people we deal with have a pile of them...

For now, remember that most of the time you will get the page you requested... It just might take a few seconds...

Personally, I rarely see one beyond 10 seconds, but I do occasionally get them longer than that...

I am doing everything I can to fix this...

Digital Concepts · 2002-08-20, 03:06

Quote:

Originally Posted by Xyzzy

Anyways, they provide a button to optimise it, but I'd rather do it from the command line... Could someone tell me how to do this? I'm logged in to the database right now and I have a "mysql>" prompt...

Not knowing MySQL...

Does it have an audit function? I envision turning it on, hitting your optimize button, looking up the audit log, and finding the SQL that was executed?

xtreme2k · 2002-08-20, 03:36

From what I know, there is NO way that phpbb will need more than 10 seconds to process a page. Especially with a userbase of this size. Have you got the server access such that you can check out what processes are eating up the CPU cycles?

MySQL + vb handle >300 users online without too much trouble on a P3 1000. Now on this website, with only 5 users online and pages taking >10 seconds to generate, I dont think its the db thats causing the problem...

Xyzzy · 2002-08-20, 19:30

I have figured out how to move the database, but all morning everything has been fast, so I am going to hold off and see if maybe the problem has been fixed...

It is nice to know they have several other servers available to us in the event we have a problem...

gowen72 · 2002-08-22, 15:23

Some real slow access this morning. I think this one must be a record...

[code:1]phpBB Created this page in 129.312249 seconds : 17 queries executed : GZIP compression enabled[/code:1]

Edit:

Almost doubled it:

[code:1]phpBB Created this page in 242.998277 seconds : 17 queries executed : GZIP compression enabled[/code:1]

Xyzzy · 2002-08-22, 17:22

The database is moved to a new server... Moving it was pretty easy... I apologize for the lags this morning... I woke up at noon and noticed that I could not get in at all, so sometime between 6AM and noon it must have broke...

Fortunately, I have done a backup every day so no matter what happens the most we ever could lose is one day's worth or data...

Again, thanks for your patience...

Angular · 2002-08-22, 20:05

Xyzzy,

It is working much better now. Thank you. Out of curiosity, what hardware is this board's server running on?

Xyzzy · 2002-08-22, 23:28

I have no idea...

The OS is FreeBSD 4.1.1-STABLE...

It is hosted for us...

http://www.pair.com/pair/facilities/servers.html

I used to host everything at home, but it is too expensive to get the redundant power and bandwidth we need... I have a nice loaded Sun Ultra 1 server that was the primary server for us until very recently... If we ever outgrow this setup I'll maybe just colocate that box or pick up another 1U Netra X1 or SunFire V100...

Fortunately, our current plan is pretty generous... As of now, between everything we run, we use around 2/5 of our allotted bandwidth...

Xyzzy · 2002-08-28, 22:19

It looks like the move paid off... Over the last few days I haven't seen a page creation time > .4 seconds...

If you all experience any problems please let me know... :)

FYI, I have the forums set to show 100 posts per page... IMO this makes it easier to read, but those of you on dialup need to let me know if this is too extreme...

Even though the pages have a lot of graphics, most of them are repeated heavily, so the difference between 50 posts per page and 100 should just be a small one...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ECM RAM issues	yoyo	GMP-ECM	7	2018-04-28 05:51
Windows 10 Issues	Sulamandora	Software	5	2015-08-13 06:47
Mersenne.org Issues	SiliconSentry	Information & Answers	3	2014-05-21 22:36
New GPU; new issues...	chalsall	GPU Computing	18	2013-06-12 19:28
memory issues?	jcjuice	Hardware	7	2006-01-11 20:41

2002-08-20, 00:57	#13
Tasuke Aug 2002 2³×3² Posts	phpBB Created this page in 17.779320 seconds : 14 queries executed : GZIP compression enabled to bring up this page phpBB Created this page in 19.904057 seconds : 18 queries executed : GZIP compression enabled to post /edited for the post speed

2002-08-20, 01:41	#14
Xyzzy Aug 2002 2·3²·13·37 Posts	The current plan is to change our database to a different server... Apparently the people we deal with have a pile of them... For now, remember that most of the time you will get the page you requested... It just might take a few seconds... Personally, I rarely see one beyond 10 seconds, but I do occasionally get them longer than that... I am doing everything I can to fix this...

2002-08-20, 03:36	#16
xtreme2k Aug 2002 2·3·29 Posts	From what I know, there is NO way that phpbb will need more than 10 seconds to process a page. Especially with a userbase of this size. Have you got the server access such that you can check out what processes are eating up the CPU cycles? MySQL + vb handle >300 users online without too much trouble on a P3 1000. Now on this website, with only 5 users online and pages taking >10 seconds to generate, I dont think its the db thats causing the problem...

2002-08-20, 19:30	#17
Xyzzy Aug 2002 2·3²·13·37 Posts	I have figured out how to move the database, but all morning everything has been fast, so I am going to hold off and see if maybe the problem has been fixed... It is nice to know they have several other servers available to us in the event we have a problem...

2002-08-22, 15:23	#18
gowen72 Aug 2002 7² Posts	Some real slow access this morning. I think this one must be a record... [code:1]phpBB Created this page in 129.312249 seconds : 17 queries executed : GZIP compression enabled[/code:1] Edit: Almost doubled it: [code:1]phpBB Created this page in 242.998277 seconds : 17 queries executed : GZIP compression enabled[/code:1]

2002-08-22, 17:22	#19
Xyzzy Aug 2002 8658₁₀ Posts	The database is moved to a new server... Moving it was pretty easy... I apologize for the lags this morning... I woke up at noon and noticed that I could not get in at all, so sometime between 6AM and noon it must have broke... Fortunately, I have done a backup every day so no matter what happens the most we ever could lose is one day's worth or data... Again, thanks for your patience...

2002-08-22, 20:05	#20
Angular Aug 2002 2×3³ Posts	Xyzzy, It is working much better now. Thank you. Out of curiosity, what hardware is this board's server running on?

2002-08-22, 23:28	#21
Xyzzy Aug 2002 10000111010010₂ Posts	I have no idea... The OS is FreeBSD 4.1.1-STABLE... It is hosted for us... http://www.pair.com/pair/facilities/servers.html I used to host everything at home, but it is too expensive to get the redundant power and bandwidth we need... I have a nice loaded Sun Ultra 1 server that was the primary server for us until very recently... If we ever outgrow this setup I'll maybe just colocate that box or pick up another 1U Netra X1 or SunFire V100... Fortunately, our current plan is pretty generous... As of now, between everything we run, we use around 2/5 of our allotted bandwidth...

2002-08-28, 22:19	#22
Xyzzy Aug 2002 21D2₁₆ Posts	It looks like the move paid off... Over the last few days I haven't seen a page creation time > .4 seconds... If you all experience any problems please let me know... :) FYI, I have the forums set to show 100 posts per page... IMO this makes it easier to read, but those of you on dialup need to let me know if this is too extreme... Even though the pages have a lot of graphics, most of them are repeated heavily, so the difference between 50 posts per page and 100 should just be a small one...