Very Large Invision board . What now ? :(

[justbenice]

Hello
After 2 years tired of hacking and un-stable of my invision forum today i decide to convert my whole board to VBB. But after testing i found out that it may take a week of converting because it convert only 20 users/post one time when i have around 160k registered member and 1,5mil post . What should i do now ? Are there anyway we can make it convert faster ? I am running forum in a dedicated server which is opteron dualcore 275 and 4Gram, i even rise up php limit memory to 512MB but it still very slow .
Regards.

[justbenice]

Ok, sorry for bother your guys. How stupid am i :( I found a solutions already . Just fix a script.

[Jerry]

With that kind of hardware you should be able to do it in 6 hours I would of thought, just ramp up the memory PHP can have and do 100,000 posts/users/threads per page etc

20 users/posts ? I don't understand, I do 100,000 per page on large imports on a machine a fraction as powerful as the one you have.

[justbenice]

Hi
What is your my.ini and php.ini config ? I am now converting post . I do 30k post/ page but it hang when come to 1,2mil post. :( My php memory now is 1.5G .

[Jerry]

My PHP is 256 Meg and no time out, I import 100,000 posts per page usually.

You will have to check your time out and MySQL settings as well.

Also, it may be the last page, in which case its updating the parent id's.

[justbenice]

I still haven't finish converting forum post. Could you tell me what is your mysql config ? Or what should i place in my.ini ?
Regards,

[Jerry]

.....
set-variable = key_buffer=512M
set-variable = max_allowed_packet=256M
set-variable = table_cache=512M
set-variable = sort_buffer_size=128M
set-variable = read_buffer_size=128M
set-variable = myisam_sort_buffer_size=256M
set-variable = thread_cache=64M
set-variable = query_cache_size=64M
.....
.....
#set-variable = max_allowed_packet=10M
set-variable = thread_stack=128K


That's what I use, so any allowed packet, I wouldn't expect there to be anything over a few meg, unless you have a post, with a huge amount of content, or you store attachments in the database.