MyBB Community Forums

(2009-01-29, 05:50 PM)HotBangali Wrote: [ -> ]

Quote:It has come to our attention that your hosting account
> hotbangali.com is causing excessive mysql load on the server,
> causing it to slow down and crash. The processes are listed below.
> The problem is not with bandwidth or space use. This is not allowed on
> a shared server. If you would like to host this domain as is, then you
> would need a virtual private server (VPS) or dedicated server. We
> now sell virtual private servers for a fraction of the cost of
> dedicated machine. You get full root access and it is your own
> server (not a shared machine). If you would would like pricing on
> this, please let us know. To insure you can continue to host with us,
> we will need you to upgrade to a VPS or dedicated machine.
>
> MySQL Process List
> Id User Host db Command Time State Info
> 1674 russell_russell localhost russell_dara1 Query 4098 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 2517 russell_russell localhost russell_dara1 Query 3568 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 3146 russell_russell localhost russell_dara1 Query 3186 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 6271 russell_russell localhost russell_dara1 Query 2407 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 6590 russell_russell localhost russell_dara1 Query 2344 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 8436 russell_russell localhost russell_dara1 Query 1903 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 9438 russell_russell localhost russell_dara1 Query 1662 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 11148 russell_russell localhost russell_dara1 Query 1123 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 11436 russell_russell localhost russell_dara1 Query 995 Copying to tmp table
> SELECT m.word_id \n\t\t\t\tFROM phpbb_search_wordmatch m,
> phpbb_search_wordlist w \n\t\t\t\tWHERE w.word_text
> 14000 russell_russell localhost russell_dara1 Query 187 Sending data INSERT
> INTO phpbb_search_wordmatch (post_id, word_id, title_match)
> \n\t\t\t\tSELECT 33534, word_id, 0 \n\t
>
>

Hi Ive a quarry that how its possible ? cas all my link is External link . Ive only small attachment so howcome its happen ?
plz help me to solve it .

Thanks
Regards

(2009-01-29, 08:42 PM)BMR777 Wrote: [ -> ]Um, why do the table names begin with phpbb_

?

BMR777