Hello. I have a problem on my forum here one of the queries is taking 9 seconds long. Yesterday it was the SET NAMES 'utf8' query but that's going at under 0.1 secs now.
At the moment it's the SELECT * FROM mybb_board_messages WHERE enabled='1' query - Query Time: 9.58442687988E-5
It also says in Extra - Impossible WHERE noticed after reading const tables
This query SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE def='1' LIMIT 1 is also slow - Query Time: 8.29696655273E-5
It says that in Extra for SELECT COUNT(pmid) AS pms_unread FROM mybb_privatemessages WHERE uid='1030' AND status='0' AND folder='1' this query as well.
Can anyone help me? How do I fix this so my forum isn't running incredibly slow?
They're not slow at all, they have E-5 at the end; 9.58442687988E-5 is actually 0.0000958442687988 and 8.29696655273E-5 is actually 0.0000829696655273 seconds. It a query has E-5 at the end it was so quick it has to format the number differently. Does the forum actually seem slow or are you just looking at these numbers?
(2012-04-15, 10:22 AM)MattRogowski Wrote: [ -> ]They're not slow at all, they have E-5 at the end; 9.58442687988E-5 is actually 0.0000958442687988 and 8.29696655273E-5 is actually 0.0000829696655273 seconds. It a query has E-5 at the end it was so quick it has to format the number differently. Does the forum actually seem slow or are you just looking at these numbers?
Oh I see. No, the forum is really really slow. I was looking around the stats etc and saw those and thought it could be that.
These are the stats at the bottom of the page:
Generated in 0.1269701 seconds (90.18% PHP / 9.81% MySQL)
SQL Queries: 13 / Global Parsing Time: 0.1055620 / Memory Usage: 9.25 MB
PHP version: 5.2.17 / Server Load: 0.58 / GZip Compression: Enabled
Am I just going to need to swap to a new host or is it fixable?
It isn't taking 9 seconds - it's actually taking far less than a second. Notice how it says E-5 at the bottom, that means it's actually taking 9.58442687988 x e^-5 seconds.
EDIT: beaten by Matt. I should really refresh before posting.
From those stats it'd seem like the slowness is because of the downstream connection to your actual computer; the page is being generated in 0.1 seconds which is perfectly normal, and the load and memory usage aren't overly high so from the looks of it it 'should' be loading quite quickly; there's nothing alarming in those stats. Can you post your URL so we can see how quickly it loads for us?
(2012-04-15, 10:34 AM)euantor Wrote: [ -> ]EDIT: beaten by Matt. I should really refresh before posting.
Happens to me all the time
Sheesh that is bad, I'd definitely ask your host about this... and to stop them saying it's MyBB's fault you can give them those footer stats from above to prove MyBB is actually generating the page in 0.1 seconds so it's not a MyBB issue. I assume you didn't have the same speed issues when using vBulletin though?
(2012-04-15, 10:44 AM)MattRogowski Wrote: [ -> ]Sheesh that is bad, I'd definitely ask your host about this... and to stop them saying it's MyBB's fault you can give them those footer stats from above to prove MyBB is actually generating the page in 0.1 seconds so it's not a MyBB issue. I assume you didn't have the same speed issues when using vBulletin though?
Okay I'll do that. And I've only recently switched to MyBB, the vbulletin kept having random slow days, then it was infected with a virus that kept redirecting to a drug website, got rid of that then a random php error, and then the licence expired. So it did occasionally go really slow.
Thanks for the help
Definitely a host problem.
Host issue. Likely they have terrible load on a shared server. Nothing you can do but contact them to complain or change hosts.