MyBB Community Forums

My ISP states the following. This is greek to me. Do any of the experts on here translate this to anything specific I can fix?

Thanks!

I've taken a look at the server's Mysql slow queries log. It appears that you have a number of slow queries recorded. Here are some examples:


# Time: 120909 14:27:46
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 11.398296 Lock_time: 0.000086 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215266;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:28:38
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 11.179342 Lock_time: 0.000054 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215318;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:29:09
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 16.287995 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215349;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:29:19
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 18.192660 Lock_time: 0.000050 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215359;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 18.428155 Lock_time: 0.000075 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215359;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:29:23
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 15.620163 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215363;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 11.353177 Lock_time: 0.000056 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215363;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:30:06
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 11.935763 Lock_time: 0.000050 Rows_sent: 1 Rows_examined: 407685
SET timestamp=1347215406;
SELECT pid FROM mybb_fcfposts WHERE tid='77522' AND dateline > '0' AND visible='1' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:35:25
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 12.968074 Lock_time: 0.000066 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215725;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:35:27
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 14.256305 Lock_time: 0.710958 Rows_sent: 1 Rows_examined: 414891
SET timestamp=1347215727;
SELECT pid FROM mybb_fcfposts WHERE tid='77990' ORDER BY dateline ASC LIMIT 0, 1;
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 13.619960 Lock_time: 0.000080 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215727;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 14.661598 Lock_time: 0.063125 Rows_sent: 1 Rows_examined: 414891
SET timestamp=1347215727;
SELECT pid FROM mybb_fcfposts WHERE tid='77990' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 14:35:28
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 14.991192 Lock_time: 0.576825 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215728;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# User@Host: bringitu[bringitu] @ localhost []
# Query_time: 15.016256 Lock_time: 0.487208 Rows_sent: 1 Rows_examined: 414810
SET timestamp=1347215728;
SELECT pid FROM mybb_fcfposts WHERE tid='77982' ORDER BY dateline ASC LIMIT 0, 1;
# Time: 120909 16:30:18
# User@Host: root[root] @ localhost []
# Query_time: 17.479858 Lock_time: 0.000152 Rows_sent: 19 Rows_examined: 929
use mysql;
SET timestamp=1347222618;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 120910 8:30:29
# User@Host: root[root] @ localhost []
# Query_time: 19.556825 Lock_time: 0.000123 Rows_sent: 19 Rows_examined: 929
SET timestamp=1347280229;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 120910 9:15:14
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 17.257437 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 4905
use eximstats;
SET timestamp=1347282914;
update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=1 where smtp.transport_is_remote=1 and sends.user='bringitu' and smtp.processed=0;
# Time: 120910 12:30:31
# User@Host: root[root] @ localhost []
# Query_time: 22.124735 Lock_time: 0.000155 Rows_sent: 19 Rows_examined: 929
use mysql;
SET timestamp=1347294631;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables GROUP BY TABLE_SCHEMA;
# Time: 120910 13:09:26
# User@Host: eximstats[eximstats] @ localhost []
# Query_time: 19.989678 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 4891
use eximstats;
SET timestamp=1347296966;
update smtp INNER JOIN sends ON (sends.msgid=smtp.msgid) set smtp.processed=1 where smtp.transport_is_remote=1 and sends.user='bringitu' and smtp.processed=0;
# Time: 120910 16:30:23
# User@Host: root[root] @ localhost []
# Query_time: 14.504016 Lock_time: 0.000147 Rows_sent: 19 Rows_examined: 929
use mysql;
SET timestamp=1347309023;
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(IN

How big is your board?

(2012-09-24, 12:05 AM)Paul H. Wrote: [ -> ]How big is your board?

Only 500 users. 100 concurrent atthe time of this issue

How many posts and threads do you have?

Over 250,000 posts

You might want to apply to join the big board owners. They would help you to optimize your forum.

go to MyBB Community Forums / User Control Panel / Group Memberships and apply to join.

But I have less than 500 users.

what plugin is "FCF" or is "mybb_fcf" the table prefix you used? It appears that you may not have that table indexed on "tid" as a specific query like that should be very fast.

Where do I find the answer to that. Mybb_fcf is the name of the database I have assigned the site too

That query is by no means the least fastest query but it should not be taking 15 ~ 20 seconds to do it. I would place blame typically on the host here.