MyBB Community Forums

Hi,

Sorry for my english, this is not my natural language.

I have a serious problem with my install of MyBB 1.0.4 .

First, I have installed it on my server.

Second, I have download my PHPBB database on my local server to converse it in MyBB database.

Third, I send the local MyBB database on my distant server.

All the 3 operations were success.

But my problem is the next :

After, I have opened my forum, and problem : MySQL server load was very high !!!

I tried many solutions :
- Change the "*NIX Load Limiting" value, from 0 to 5
- Change PHP File, from 1.0.4 version to 1.0PR2 version
- Delete the mysql_pconnect() code in /inc/db_mysql.php

When I close the forum, the MySQL load goes down. But when I open it, the MySQL Server load grows up to 20-25%.

Somebody can please help me ?

Thanks a lot.

Regards,

Nico

It seems the fautly request is maybe that :

" SELECT pid FROM mybb_posts WHERE tid='8337' AND visible='1' ORDER BY dateline LIMIT 75, 15 "

It is unlikely that query is causing the problem, especially as it's limited, but I may be wrong.
At the bottom of every page (if you are the admin) is a little bog of debugging information. It shows you how many mysql queries were used and how long the page took. If you click advanced, it shows you how long eac query took.

Can you save the advanced debug page as html and attach it to a post for us to examine?