XF 2.2 MyBB Migration to XF 2.2

Dragonfruit

Well-known member
Hi I'm currently importing through the CLI method, it's taken 30 minutes to process 74 private messages on Step 4 of 10. There's over 1.2 million. Steps 1 to 3 wasn't as bad as this. Is there anything that can be done to speed things up?
 
I set up XAMPP so I can use my own PC with a lot more memory.
After adjusting these MySQL configs:
Code:
innodb_buffer_pool_size        = 12G
innodb_buffer_pool_instances   = 4
innodb_flush_method            = O_DIRECT
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1
innodb_log_files_in_group      = 2
innodb_log_file_size           = 512M
It sped up, but it's still rather slow. It's completing 0.20% per hour on Stage 4 of 10, the PMs. Is there anything more I can do to help this along?
 
The total size is about 2.3gb
The PM table is next being the largest table aside from the posts with somewhere between 1.2-1.3 mil rows. Can this thread just be moved there? Or do I need to make it again?
 
Top Bottom