|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Ive tested the problem on these forums and it seems ok so for now my problem is local to me so any diagnostic advice would be appreciated.
on my forums when i click on a user name to go to there profile page it can hang for 10seconds before displaying. At first i thought a recent server update may be causing this but its still happening after a week?
i have rebooted the server : no change checked database tables : no errors.
if i go via the control panel and bring up a user profile make a small change and then submit that also takes a similar time, but the point being that via the admin side of things there are no custom islands that could be causing this problem.
eventually a user profile will drop in from a users point of view, or time out with page can not be displayed. its frustrating.
result from forum main page Generated in 0.041 seconds in which 0.011 seconds were spent on a total of 9 queries. Zlib compression enabled.
results from click on a user name and the profile showing.
Generated in 20.027 seconds in which 0.006 seconds were spent on a total of 14 queries. Zlib compression enabled
any ideas? everything else seems fine.
thanks in advance.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Generated in 20.027 seconds???? Are your sure??? That is a lot of time! Possibly you may need to try the optimize table command. For the user data tables.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
thats a copy and paste.
optimize table command. i can give that a go.
i only used "check tables" via phpadmin view. as there were no errors (come back as ok) i thought that was the end.
i can try the optimize table command in the morning when the forums are quiet. so another 10hrs.
Thanks Ruben.
i do have just under 8,500 users. i will optimize all the tables with user as a prefix.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Just a thought since you have been around since dirt. Maybe your tables need to be cleaned a bit.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
cleaned ? ive used optimized in the past, but not seeing anything actually report back or changed presumed it was a function that i did not need to use and check tables was going to be my flag if there were any problems.
did you mean clean the tables, by optimizing ?
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Yes, Optimize can be run from the ubb control panel or such as phpadmin, Either way it will clean up the tables much like de-fragment does for hard drives. Since you have been around a long time with 8500 plus members possibly it may need to be cleaned up.
I myself have never seen any feedback of status of using the optimize table myself other than it was successful.
But I have seen improvement in response speed.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
OK i will give that a blast in the morning. lets hope it is that simple.
Thanks for the advice appreciated.
mark
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Results from Optermizing all the Tables. OK (Up to date).
Copy and pasted result from clicking on a user name.
Generated in 20.140 seconds in which 0.027 seconds were spent on a total of 14 queries. Zlib compression enabled. Powered by UBB.threadsâ„¢ 7.5.6p2
Even though is says 20 seconds its not that long its more like 6 - 10 Seconds.
The User List page via the main forum is instant.
Via the Admin Side Updating a user it seems to have come good, that's instant again. So now i have to look at my custom islands i think. There must be something on the profile page that's causing the delay.
Give me until next week and i should come back with some results. Finding the time to poke about hummmm.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Ok ive just tried turning off the side islands and there is no difference.
The one thing constant is this. Generated in 20.037 seconds in which 0.010 seconds were spent on a total of 14 queries. Zlib compression enabled
9 times out of 10 its always reads "20" seconds, but its more like 6 - 10 seconds really.
I need to run repair on the tables to see if that helps. I'm not prompted for a repair but lets see if that helps. I also turned of comments in the user profile options with no change.
Next test will be a few days as i go visiting family.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
no solution found. its pretty constant at reporting back 20second but in reality its less than 10.
if as admin from the main forum select edit user from the drop list alongside a post its instant.
if i want to view a there profile page on the forum it has that delay.
i noticed that when i was using the open /close forum option the admin screens seem to be taking a similar time to save and rotate back.
ive more time in a week to dig a bit deeper.
will update this post as and when.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yah, the bug is where it calls getimagesize for the 'nopicture.gif' i submitted the bug fix to Rick awhile back... not sure if it made it into 7.5.6
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
this is what i have for my modified forum(s) $imagehw = getimagesize("{$config['FULL_PATH']}/images/{$style_array['general']}/nopicture.gif");
scripts/showprofile.inc.php
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Thanks SD for that update. i missed my email you had replied.
i will give that ago when i have time.
Thanks again cheers.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Just done a quick test on the theory that it could improve if a user has / has not a avatar (profile image).
Anyway Generated in 20.024 seconds in which 0.008 seconds were . . . . . . (no image)
Generated in 20.023 seconds in which 0.005 sec . . . ( with a image )
ive not looked at the code yet. But just showing so far a profile page is constant with regards to Timings.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
$stockPicture = "{$config['FULL_URL']}/images/{$style_array['general']}/nopicture.gif";
$imagehw = getimagesize($stockPicture);
$stockWidth = $imagehw[0];
$stockHeight = $imagehw[1]; Is the only search in that file that uses " getimagesize" So it looks like that has been covered. Looks like i may have to see if i can comment out some of the query's to pin down the pause with it all ? But now i have the file name is a big help.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Just a quick drive by; getimagesize is declared in: [root@ns1 forum]# grep -r "getimagesize" *
cache_builders/gallery_island.php: $is = getimagesize("{$config['FULL_PATH']}/gallery/{$posts['TOPIC_THUMBNAIL']}");
cache_builders/featured_member.php: $imagehw = getimagesize($avatar);
libs/smarty/plugins/function.html_image.php: if(!$_image_data = @getimagesize($_image_path)) {
libs/image.inc.php: $is = getimagesize("{$config['FULL_PATH']}/tmp/$sourcefile");
scripts/showprofile.inc.php: $imagehw = getimagesize($stockPicture);
scripts/changebasic.inc.php: $imagehw = getimagesize($Picture);
scripts/changebasic.inc.php: $imagehw = getimagesize("{$config['UPLOADED_AVATAR_PATH']}/$Picturefile");
scripts/adduser.inc.php: $imagehw = getimagesize($USER_AVATAR);
scripts/adduser.inc.php: $imagehw = getimagesize("{$config['UPLOADED_AVATAR_URL']}/$Picturefile");
I haven't checked to see if they all use the full url (or an associated url as with the uploaded_avatar_url reference in the config file) yet, but if we're having buglets elsewhere we should validate against all instances... I'll check more in the morning (unless someone else checks).
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
What's weird is that its just kind of happened or its been noticed.
Like i say on these forums it flys so it has to be down to my install or everyone would be moaning about it.
But it may not still be down to an image yet ?
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Well, different environments for different folks...
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
With out me doing anything this fixed its self or began to behave normally about 4wks ago. I'm still on the same version 7.5.6p2 just thought i would update you guys.
Not sure if a Update on the server (software) kicked this into working or a Huuuuuuuuuuge mysql dump in the admin logs sql. I deleted the file, but that was the only Event between me realising it was working as it should.
Thanks for your replies. I never did get the time to try the fixes above.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|