MyBB Community Forums

Hi,

first of all, thank you to the community for this wonderful tool called MyBB.
After having searched for a good solution to replace our dying XMB forum, I've chosen MyBB and each time I'm connecting on my test site, I discover great functionnalities...

So, as said I'm working on a migration from XMB to MyBB for our forum (12300 members, more than 2 million posts...)

The 1.6 merger system doesn't provide XMB conversion and the authors explained why.

So there were 2 solutions :
1) install 1.4, merge and upgrade
2) try to make the XMB merge on 1.6 directly

As far as I have MANY custom programs on my XMB, I had to go for solution 2.

So, for those who want to convert directly to 1.6, that's pretty easy...
* install 1.6 merge system
* download 1.4 merge system from svn
* copy merge.1.4/boards.xmb* to merge/boards
* modify each php in boards/xmb to add the function fetch_total() at the end of the proggy (take it from the smf board for example and modify the $query line) and add also
[i] 'default_per_screen' => 1000, [/quote]
in the beginning ( var $settings = array ...)

The conversion is working...

if you want more details, don't hesitate i'll paste the diff of files....

but I've one question for the developers....
running the merge either on 1.4 or on 1.6 I encounter the same problem....
the posts conversion is slooooooooowwww (on a bipro + 6GB RAM VM)...
to merge the +2 millions post, it would last more than 5 days....
and I can't afford stopping the forum for a so long time..

does anybody have an idea to improve this time?

Good to know that it's working Thanks for the feedback.

Unfortunately I know nothing on the subject of VPS's or dedicated servers. Anyone else have any input?

My forum is running in another VM on the same host, without any trouble and the perf is quite good...(and I manage such kvm servers @work too...)

I've put the same my.cnf on my test server as on my XMB server just in order to be sure it's the same database configuration.

I've also made a test on a "physical" server => same issue... (on 1.4 and 1.6)

I think the problem is due either to the design of the merge or maybe to some missing index for example...

Does anybody have merged an XMB forum of an equivalent size of mine?

I did a merge from XMB about 6 months ago and found it pretty painless but it was only for a really small board. i was only interested in getting members and posts across to be honest.

ok
so I think I need to investigate.
I'll keep the community informed of course

I'm checking http://dev.mybb.com/issues/1181

---

ok I think I see one problem :

if I show processlist from the database, I see nearly only lines like this :

UPDATE mybb_threads SET `firstpost`='18004' WHERE firstpost='-394746'  

first post is an UNSIGNED....

mysql> select firstpost from mybb_threads WHERE firstpost='-117006';
Empty set, 1 warning (0.16 sec)

mysql> show warnings ;
+---------+------+----------------------------------------------------+
| Level   | Code | Message                                            |
+---------+------+----------------------------------------------------+
| Warning | 1264 | Out of range value for column 'firstpost' at row 1 |
+---------+------+----------------------------------------------------+
1 row in set (0.00 sec)

I'm investigating if this could cause the lag...
anyway it causes the firstpost not to be updated...

ok problem of warning fixed (due to the use of 1.4 merger...)
I had to update the way the firstpost was managed...

now I'm computing the time needed to insert a post...
and it fluctuates a lot... from 0.0012s to more than 3s ...

still investigating

---

ok I've found the reason...
top shows a big %wa....
If I reduce the number of posts merged per shot to 500 instead of 1000.. that's better...but still not terrific...

does anybody have any advice on it?