sdawson wrote:We have a board with 400,000 posts and 80,000 users and it took around 2 hours to convert. We run 2 dedicated servers, 1 for database, 1 for httpd.
I would really like to know your trick. I have a similar setting, both servers have double dual core processors and 6G RAM. I have a 1.500.000 posts /65.000 users DB. The conversion has been running all night long and I had to stop it in the morning. This has been performed several times with the same results: aborted conversion. Besides, every time there is an error, such as a lost connection, all work is lost.
Also tried the offline trick. The conversion has been running in my local server for over 5 hours and is has converted only 500.000 rows (1/3 of the total). It still has a long way to go.
Tried tweaking the batch limit. Have tried several values, 1000, 2000, 3000, 6000, with no noticeable improvement. Locally, 6000 lines seems to improve speed a little, on the remote server, it crashes it. I had to set it down to 1000. The other setting, num_wait_rows, don't really understand what is for. Extended Insert ?