MyBB Community Forums

Hi guys!!! I have been using mybb for quite some time now, and my forum has also grown...... But as it has grown so have the problems.
Ok so here it goes, my site has around 20000 members but not too many posts, and there are around 100 users online at the average. They are basically university students, so they just browse stuff, and download assignment solutions etc.
Now my website had performance issues from the start, but they were not bad enough. But as the users started to grow, so did the problems. My website recently got kicked by hostmonster due to "performance issues". I have moved to another host who has given me around 256 mb ram and around 20 entry process limit. Not there is a major issue with the script I guess, because it really consumes all of the ram 24/7 and the cpu usage falls below 90%, in addition to that, the entry processes limit is also exhausted all the time, the result? A lot of "RESOURCE LIMIT REACHED" error pages.
Now at first I thought this was due to a lot of active users, so I changed the tables from MyIsam to Innodb, still no result. I have tried various techniques but I still can't get around these problems. To make matters worse, the board is growing very quickly. And I do not know how to handle this. At first I disabled some plugins, it did reduce the number of active sql queries, but it had no effect on the cpu, memory usage. SO I really do not know how to deal with this, and seeing bigger boards active on the same hosts I have tried, I am getting frustrated.
I am ready to give cpanel and adminCP access to my forum, but please do help me, I would really appreciate it.
The forum name is vuaskari.com.

Quote:And this piece of information might help you guys
Generated in 0.7647381 seconds (58.11% PHP / 41.89% MySQL)
SQL Queries: 14 / Global Parsing Time: 0.1415660 / Memory Usage: 51.25 MB
PHP version: 5.2.17 / Server Load: 4.09 / GZip Compression: Enabled

From reading reviews of hsotmonster, you may want to find a different host instead of anything else. There are some really rather bad reviews out there.

Also, can we have some more statistics about your site?

hmm yeah ok..... you can just go to vuaskari.com......
the cpu is actually shown on the cpanel.... and doesnt lower from 100%.
and that is worrying. i'm just askin whether i can remove fulltext indexing from the tables mentioned in the article i referred to, above?



age Generation
Page Generation Statistics
Page Generation Time: 2.78970503807 seconds No. DB Queries: 51
PHP Processing Time: 0.6416886 seconds (23.00%) DB Processing Time: 2.1480165 seconds (77.00%)
Extensions Used: mysql, xml Global.php Processing Time: 1.5135469 seconds
PHP Version: 5.2.17 Server Load: 5.09
GZip Encoding Status: Enabled No. Templates Used: 40 (46 Cached / 2 Manually Loaded)
Memory Usage: 49 MB (51380224 bytes) Memory Limit: 64M
Database Connections (1 Total)
[READ] alimaula_newask@localhost (Connected in 1s)

Database Queries (51 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 8.89301300049E-5

#2 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 33
Query Time: 0.00797891616821

#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='dfc37b65155779678fdd9bfbd5e9177c' AND ip='182.177.130.111' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.000294923782349

#4 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
Query Time: 0.000292062759399

#5 - Write Query
UPDATE mybb_sessions SET uid='1', time='1321980135', location='/index.php?debug=1', useragent='Mozilla/5.0 (Windows NT 6.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', location1='0', location2='0', nopermission='0' WHERE sid='dfc37b65155779678fdd9bfbd5e9177c' LIMIT 1
Query Time: 0.00572991371155

#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='13' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.000103950500488

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','12') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1321 Using where; Using filesort
Query Time: 0.00166201591492

#8 - Select Query
SELECT template FROM mybb_templates WHERE title='global_boardclosed_warning' AND sid IN ('-2','-1','12') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1321 Using where; Using filesort
Query Time: 0.000263929367065

#9 - Select Query
SELECT uid FROM mybb_sessions WHERE uid != '0' AND time > '1321979235'
table type possible_keys key key_len ref rows Extra
mybb_sessions range time,uid time 8 274 Using where
Query Time: 0.0215630531311

#10 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (22988,19583,11402,2414,2095,19478,19890,12859,12497,15800,5984,21176,17938,5764,22173,21944,12047,2555,249,10521,9614,1414,9748,993,22799,5643,19345,1679,18321,1144,13495,13784,13178,22039,15617,20281,891,13419,12970,10902,10409,16936,758,12436,1740,348,20357,16056,15506,12524,9074,15021,22865,13138,10665,22321,22252,18409,3317,21966,17526,10203,22327,14155,8059,21073,6377,8934,143,15825,22257,5845,12297,16217,1)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 75 Using where
Query Time: 0.718731164932

(Plugin Hook: index_start)
#11 - Select Query
SELECT u.uid,u.username,u.displaygroup,u.usergroup,u.avatar,COUNT(*) AS ptoday FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1321893735 GROUP BY p.uid ORDER BY ptoday DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
p range dateline dateline 8 140 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 alimaula_vuaskari.p.uid 1
Query Time: 0.00980186462402

(Plugin Hook: index_start)
#12 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (12660)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.00790810585022

(Plugin Hook: index_start)
#13 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10099)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000150203704834

(Plugin Hook: index_start)
#14 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (6774)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0185220241547

(Plugin Hook: index_start)
#15 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (19272)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000156164169312

(Plugin Hook: index_start)
#16 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (20335)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000144958496094

(Plugin Hook: index_start)
#17 - Select Query
SELECT u.uid,u.username,u.displaygroup,u.usergroup, u.avatar ,COUNT(*) AS pweek FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1321375335 GROUP BY p.uid ORDER BY pweek DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
p range dateline dateline 8 866 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 alimaula_vuaskari.p.uid 1
Query Time: 0.018168926239

(Plugin Hook: index_start)
#18 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (9986)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000182867050171

(Plugin Hook: index_start)
#19 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (9572)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0184590816498

(Plugin Hook: index_start)
#20 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (7862)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000198841094971

(Plugin Hook: index_start)
#21 - Select Query
SELECT u.uid,u.username,u.displaygroup,u.usergroup,u.avatar,COUNT(*) AS pmonth FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1319388135 GROUP BY p.uid ORDER BY pmonth DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
p range dateline dateline 8 4336 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 alimaula_vuaskari.p.uid 1
Query Time: 0.0185949802399

(Plugin Hook: index_start)
#22 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (19521)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.018669128418

(Plugin Hook: index_start)
#23 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (11484)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0346930027008

(Plugin Hook: index_start)
#24 - Select Query
SELECT * FROM mybb_users ORDER BY postnum DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users ALL 22877 Using filesort
Query Time: 0.0545160770416

(Plugin Hook: index_start)
#25 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (3618)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0327019691467

(Plugin Hook: index_start)
#26 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (26)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000154972076416

(Plugin Hook: index_start)
#27 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (12487)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0189950466156

(Plugin Hook: index_start)
#28 - Select Query
SELECT template FROM mybb_templates WHERE title='itp' AND sid IN ('-2','-1','12') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1321 Using where; Using filesort
Query Time: 9.91821289062E-5

#29 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1321979235' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 274 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 alimaula_vuaskari.s.uid 1
Query Time: 0. 0022599697113

#30 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 828 Using where; Using filesort
fr eq_ref fid fid 8 alimaula_vuaskari.f.fid,const 1
Query Time: 0.00192809104919

#31 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (3,98,287,209,214,267,410,17,19,20,21,22,18,205,662,404,8,259,258,207,213,208,800,661,9,13,12,14,15,16,411,418,424,430,436,442,448,71,219,566,567,238,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,117,42,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,72,234,570,571,244,73,233,568,569,241,74,235,572,573,247,75,236,574,575,250,76,237,576,577,253,77,271,595,596,517,78,276,603,604,532,79,272,593,594,520,80,273,597,598,523,81,274,599,600,526,82,275,601,602,529,83,636,637,638,390,84,641,639,640,391,85,642,643,644,392,86,645,646,647,393,87,654,655,656,394,88,669,670,671,395,89,648,649,650,396,90,651,653,652,397,91,672,673,674,398,92,675,676,677,399,93,678,679,680,400,94,681,682,683,401,95,684,685,686,402,96,687,688,689,403,299,691,690,692,332,300,697,695,696,333,301,405,698,699,334,302,707,708,709,335,305,712,713,714,338,306,307,717,718,339,309,703,702,704,341,310,726,727,728,342,311,721,722,723,343,903,904,314,733,731,732,346,316,815,818,819,348,97,808,811,812,349,317,820,821,822,350,323,825,826,827,356,324,830,831,832,357,65,66,67,104,105,106,407,224,222,221,223,620,621,231,226,225,227,622,623,232,229,228,230,103,99,124,153,854,256,898,899,64,100,101,102,107,108,109,110,111,112,114,148,116,44,113,118,119,120,121,122,123,4,1,10,11,277,605,366,292,360,279,280,367,293,362,281,282,368,294,363,283,284,370,295,364,285,286,371,296,365,372,375,384,297,381,374,378,386,383,379,454,836,387,455,388,456,278,389,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,149,150,151,152,457,458,624,625,459,462,463,626,627,464,467,468,628,629,469,472,473,630,631,474,477,478,632,635,479,482,483,633,634,484,487,488,665,666,489,492,493,667,668,494,503,504,799,801,505,498,499,500,507,508,509,512,513,514,155,838,743,744,745,746,747,154,158,164,165,181,182,183,184,189,190,191,192,193,194,196,197,198,199,200,201,202,203,204,750,751,752,753,754,757,758,759,760,761,764,765,766,767,768,771,772,773,774,775,736,737,738,739,740,878,879,880,881,882,884,885,886,888,887,792,793,794,795,796,783,785,784,786,787,778,866,779,780,781,782,900,891,892,893,894,895,901,902,210,211,212,220,837,218,217,216,215,326,563,616,617,618,619,239,240,242,243,245,246,248,249,251,252,254,255,268,270,269,265,288,289,290,291,327,328,693,694,813,814,700,701,710,711,715,716,719,720,705,706,729,730,724,725,734,735,816,817,809,810,823,824,828,829,833,834,606,607,608,609,610,611,612,613,614,615,663,664,659,660,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,883,413,414,578,579,415,416,417,419,420,580,581,421,422,423,425,426,582,583,427,428,429,431,432,584,585,433,434,435,437,438,586,587,439,440,441,443,444,588,589,445,446,447,449,450,590,591,451,452,453,460,461,465,466,470,471,475,476,480,481,485,486,490,491,495,497,501,502,506,807,510,511,515,516,518,519,521,522,524,525,527,528,530,531,533,534,564,565,741,742,748,749,755,756,762,763,769,770,776,777,790,791,788,789,797,798,839,844,849,840,841,842,843,845,846,847,848,850,851,852,853,855,856,857,858,859,860,861,862,157,162,166,169,185,186,163,171,172,178,187,173,160,168,170,180,156,161,167,176,177,873,871,874,872,188,195,875,876,877,159,174,175,889,890,896,897)
table type possible_keys key key_len ref rows Extra
mybb_google_seo ref idtype,active active 3 const,const 68 Using where
Query Time: 0.165112018585

#32 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (8654,9324,15431,9315,11915,15395,15700,30,14057,14233,261,15608,1683,14337,15650,15585,15680,13027,14994,15433,15432,15589,14247,9302,12900,9316,27,669,10316,15497,10540,15560,12994,15652,15649,11512,10501,15183,15172,10989,2784,13118,12091,15690,2270,14205,12834,15379,13477,13530,15491,15490,14555,14438,15523,11239,14738,15392,9701,15053,11329,12392,415,60,15619,15694,11088,413,13637,15629,9129,417,82,15644,15515,10996,420,83,15643,15695,424,14551,15545,3261,14444,957,1540,15600,15393,10298,870,11983,15682,15353,10849,885,10108,15514,11113,10297,1024,844,15576,15676,15087,1045,1752,15538,7803,10775,1074,2259,15659,15434,12837,1219,5964,15614,15660,15486,5207,5588,15657,15475,11457,5264,12097,15633,15414,15009,5158,9916,15618,15677,12871,6686,12848,15201,14135,10158,6817,15203,1215,8376,15564,8460,1207,9917,15669,12881,1194,5692,15698,15445,1193,10138,15128,15642,9417,1192,6821,13576,10903,9496,1190,6820,13575,12887,1188,6818,15602,15415,7996,1186,6819,15182,12627,14322,10262,15488,15494,7833,13372,1497,13695,15648,15551,1261,6810,15658,15701,10725,3778,9912,13232,14158,3842,7630,15364,15559,4592,15329,13395,789,4661,7983,15388,15558,13268,4860,9914,13233,12890,3752,10065,15541,15646,15082,15544,6749,9893,15626,15697,6809,9919,15195,14440,10779,1331,9896,15641,15563,4546,9945,15627,12636,4953,9943,10761,15556,5107,9942,12765,12057,15359,11545,14208,3680,687,15699,7863,6378,7637,10233,15502,15663,2475,6111,9873,10237,15250,15160,709,781,15100,15352,8107,12404,15314,15085,10773,11517,10974,15319,8901,14613,7437,9420,8876,9421,9550,13110,7210,15511,15512,14409,558,15274,15603,10228,7619,15568,14182,2304,5801,12084,14101,8708,4346,5850,12083,10601,15592,4873,3639,5987,10744,15591,9251,1115,1122,3142,8629,2169,6202,7922,15537,7660,6156,12025,15409,15246,6603,15325,6646,2946,6403,14814,10976,683,2954,8038,12939,14615,14206,15611,12124,11122,9430,9370,14902,14903,14904,5396,4970,12795,15623,5993,9840,12835,12913,6045,14095,15501,8407,5687,12087,15692,15673,15688,11460,5897,15211,7919,6249,12024,12321,12573,14659,5640,12023,15365,7854,13363,6298,14113,15362,8572,6449,13381,6508,6553,14003,11357,13156,6899,9871,12537,11063,13179,10090,15170,7680,15127,4251,10528,11316,11427,638,11387,10526,9874,6944,9888,15302,15562,6993,13962,15647,14823,7039,9890,15186,15371,6789,7096,13377,15689,7918,6855,13700,15331,15664,9867,11843,15108,15248,15343,13812,13671,15565,15548,7191,8623,736,7252,15582,7126,10217,15404,9357,14430,13860,2947,15234,15590,14914,14027,14029,14092,14791,10069,15687,15470,15693,15521,15691,1962,14159,14568,7817,14704,858,9879,859,9921,11364,4666,2253,678,2254,11737,14361,228,5510,12816,14063,1152,7563,12588,14456,14457,1345,1463,11190,8279,11191,8280,10287,8281,11253,13931,14450,14726,15016,13226,11269,14928,11255,10288,12998,11604,12916,11388,12970,10260,13282,11389,13070,11401,13205,11579,13284,14947,14579,11445,9371,14948,13947,13358,14645,14407,13394,14729,11366,13951,14809,14964,15028,9139,15581,13435,6835,9239,14136,13083,10803,11288,13024,7979,13064,11382,13323,11333,13264,11310,13013,11271,13092,11405,13108,11147,13249,5462,9166,15324,15071,12774,13484,15073,5575,11404,15385,15665,8059,8206,11995,9748,10715,5944,9900,10774,10433,11381,9837,11511,9792,5755,5756,7656,13085,13158,8127,13948,14335,12923,2451,13277,9962,14603,11459,14607,11418,12595,14406,13950,9968,14664,14448,14722,11450,14669,11263,13146,13392,13144,15575,14779,15615,4102,2275,13269,1532,8806,10299,9355,15384,14889,15227,13067,11257,10160,13348,14468,11298,13052,13407,13273,13411,568,11535,13114,2366,13332,13111,12181,13748,14463,10485,11561,13706,14433,10427,11673,13696,15235,11574,11910,15355,12090,13171,13071,9618,11985,11775,11513,14587,12908,12093,15605,15221,11612,15573,14986,13276)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 665 Using where
Query Time: 0.0856590270996

#33 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10521,13394,19521,1801,2571,10099,6774,5643,11484,22538,22458,18701,17294,3618,16866,143,12660,22367,14440,13058,9572,5266,18898,18566,21370,14975,8266,13417,10319,10003,13415,3452,14427,8849,7349,4069,7907,3,9708,21901,5790,16438,12144,13063,13476,5937,22844,7862,177,20786,17873,7663,8153,18671,12382,6114,13139,1388,12019,16655,15174,7376,14273,12332,7719,13939,21725,18923,984,1775,12459,5654,295,1,6089,11597,19770,4530,1741,9986,11965,393,8772,17340,518,12274,19358,2574,891,3868,15017,60,19216,198,19272,2144,4311,9452,10334,17311,2543,19969,11731,21617,16030,19543,21759,19986,19707,9301,22277,12507,14870,6839,22952,22113,19922,4234,21945,13730,12978,808,2420,15887,13196,22268,8127,8229,12487,1077,1184,8730,1149,22726,14512,6369,13872,18028,15671,18076,603,21494,10926,18409,2425,18228,49,12604,10530,21815,65,8976,6782,10453,20881,11439,8983,19737,16920,11159,14689,13305,19511,20335,15682,20197,19,8751,2377,21720,9923,8798,1464,18321,20126,10718,17270,156,16419,11387,21527,20,18481,9629,19917,4519,20657,21199,3156,22565,22433,22387,18437,15040,13867,22465,19728,7712,21281,11472,15011,20381,22120,12101,9853,19374,22827,8365,1548,8698,16613,10801,22851,3321,585,11519,8085,15321,12344,965,19429,1894,19614,9604,15012,11503,20844,5627,19621,14681,3700,16726,6118,8392,11930,16683,4087,17966,17108,16294,21104,6844,19206,19703,14938,9444,16281,929,19150,8784)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 250 Using where
Query Time: 0.310086011887

#34 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (40)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000327825546265

#35 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (586)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.00963497161865

#36 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (3318)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.00777697563171

#37 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (3425)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000485897064209

#38 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (3584)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000210046768188

#39 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (47)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000214099884033

#40 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (415)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000263214111328

#41 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (301)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000223875045776

#42 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (5101)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000216007232666

#43 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (21)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000205993652344

#44 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (796)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000178098678589

#45 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (232)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000145196914673

#46 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (966)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000163078308105

#47 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (4983)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000141143798828

#48 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (810)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000184059143066

#49 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (4897)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000234842300415

#50 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (4902)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000137805938721

#51 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (7775)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.000152826309204

---

hey should i remove this ????/?

---

the server load never gets down from 4.46..... and now i'm freaking out.........

Google SEO is clearly causing you problems.

Removing the indexes won't help unless you're changing your table engines to InnoDB or XtraDB.

yeah well, i'm ready to do that too. according to the guy, i just need to change the users table and the threads table. now i can do that..... but i don't know how to remove the indexing part..
ive disabled the plugin, the queries are now, like 15 but the server load is still 4.46

---

orange.... [update] : now it has climbed to 5. even with the board offline but the damn users won't go away, there are like a 150 online now

---

i really need to do something , if i have to change all the tables from myisamp to innodb and remove the indexing, i will
but i just need a mentor who can guide me....

You'd go into phpmyadmin, select the table, view the structure, and delete the index.

I'd advise you change the tables that are being hit the hardest. It might also be a good idea to move to a VPS at least if your host can't handle it.

table index means? Tid? Or is it something specific? And how do i know which tables are being hit the hardest? And should i change only those tables to innodb?

(2011-11-22, 05:53 PM)musanaqvi110 Wrote: [ -> ]table index means? Tid? Or is it something specific?

It will be shown in a table under the table structure. Only fulltext indexes should be removed

(2011-11-22, 05:53 PM)musanaqvi110 Wrote: [ -> ]And how do i know which tables are being hit the hardest?

phpmyadmin should be able to show you the statistics of your database.

(2011-11-22, 05:53 PM)musanaqvi110 Wrote: [ -> ]should i change only those tables to innodb?

It might be worth it to change all tables to InnoDB. The tables being hit the hardest should be atleast.

Ok so the older thread was closed, now can I get that help here please? I'd really appreciate it.

What plugins do you use?