mersenneforum.org  

Go Back   mersenneforum.org > Fun Stuff > Lounge

Reply
 
Thread Tools
Old 2002-08-18, 01:11   #1
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

3×2,539 Posts
Default Speed issues...

I am exchanging emails with our support engineer about the database lag we are experiencing... If possible, if you have a real slow load time, post it here so I can show him...

The relevant information is at the bottom of each page...

Given that our database is so small, anything over 1 second can be considered "bad"...

Please don't post all of them you experience, just the worst...

Thanks!
Xyzzy is offline   Reply With Quote
Old 2002-08-18, 01:26   #2
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

11101110000012 Posts
Default

Here are a few I got just since I posted that first message...

phpBB Created this page in 7.126877 seconds : 16 queries executed : GZIP compression enabled
phpBB Created this page in 7.853537 seconds : 16 queries executed : GZIP compression enabled
phpBB Created this page in 3.285688 seconds : 13 queries executed : GZIP compression enabled
phpBB Created this page in 2.813092 seconds : 13 queries executed : GZIP compression enabled
phpBB Created this page in 8.193640 seconds : 8 queries executed : GZIP compression enabled
phpBB Created this page in 2.929961 seconds : 13 queries executed : GZIP compression enabled
Xyzzy is offline   Reply With Quote
Old 2002-08-18, 05:39   #3
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

3·2,539 Posts
Default

After exchanging what seems like hundreds of emails, the support engineer is convinced that our database needs to be "optimised"... I went ahead and did that, and the BBS seems to be back up to speed... I hope that solved the problem...

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

I tried reading the MySQL documentation, but it is a little more complicated than what I am used to, which is dBase!
Xyzzy is offline   Reply With Quote
Old 2002-08-18, 15:23   #4
xtreme2k
 
xtreme2k's Avatar
 
Aug 2002

AE16 Posts
Default

You dont like using phpmyadmin?
xtreme2k is offline   Reply With Quote
Old 2002-08-18, 15:26   #5
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

3×2,539 Posts
Default

Hmm... I've seen that program mentioned before...

I'll have to check it out... I do prefer doing things via the command line, just because I am used to it... But anything is better than the vague buttons they offer to me on the admin page...

Thanks!
Xyzzy is offline   Reply With Quote
Old 2002-08-18, 15:26   #6
xtreme2k
 
xtreme2k's Avatar
 
Aug 2002

2×3×29 Posts
Default

You should really check out phpmyadmin. :)

Its really easy to use, yet hugely powerful.
xtreme2k is offline   Reply With Quote
Old 2002-08-18, 15:36   #7
xtreme2k
 
xtreme2k's Avatar
 
Aug 2002

AE16 Posts
Default

By the way, since you are using GZIP I might ask what level of compression are you at now? I am not too sure if phpbb lets you choose the level of gzip compression since I am more familier with VBulletin than phpbb. However, if it lets you to choose, dont choose the level too high as it is a waste on CPU yet very little savings in terms of bandwidth. Usually there is 0-9 levels of compression, 9 being maximum compressed. Normally we consider 1 is being enough. Anything above 2 is a waste on CPU.

Hope this helps.
xtreme2k is offline   Reply With Quote
Old 2002-08-18, 17:18   #8
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

761710 Posts
Default

This BBS does not let me choose the level... I always use "-9" when I gzip stuff from the command prompt... For me, it is only a bit slower than "-1", unless it is an ISO... Then it really bogs down...
Xyzzy is offline   Reply With Quote
Old 2002-08-19, 00:25   #9
Stormblade
 
Aug 2002

2·5 Posts
Default

Ya, but imagine that little bit slower time however many hits per minute you expect the forum to get, and you get a rather large problem. :)
Stormblade is offline   Reply With Quote
Old 2002-08-19, 00:28   #10
Stormblade
 
Aug 2002

2·5 Posts
Default

Oh, BTW, in browsing the forum today, so far it has "hung" twice.. waiting for data for an unreasonably long time (several minutes) if I hit refresh it will come thru OK, and of course the time at the bottom is good, because it was a new request...

[edit]
got this one right after posting this, and returning to topic list.

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

It looked like it was going to hang, but popped up after a couple seconds..
[/edit]
Stormblade is offline   Reply With Quote
Old 2002-08-19, 02:41   #11
xtreme2k
 
xtreme2k's Avatar
 
Aug 2002

2·3·29 Posts
Default

[code:1]phpBB Created this page in 13.450974 seconds : 17 queries executed : GZIP compression enabled[/code:1]
xtreme2k is offline   Reply With Quote
Reply

Thread Tools


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

All times are UTC. The time now is 05:20.

Sat Aug 15 05:20:36 UTC 2020 up 2 days, 1:56, 0 users, load averages: 2.93, 2.82, 2.80

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.