AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] Import very slow. What to expect?

1 Posts
2 Users
0 Reactions
5,097 Views
(@hagen)
Posts: 7
Active Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 
[#48468]

I'am about to migrate from bbPress to wpForo but I have notices this will take some time.

Therefor I have deployed a new bare metal server with the fastest CPU I could find but it's still very slow. It started ok but the rate have gone down and I think the total time will be at least 3 days to finish.

25k users

95k posts

650k replies

CPU 8 cores with single core speed/rate of 3500, 128Gb mem and SSD disks.

 A new fresh install of Wordpress with wpforo and the import is from another database.

Only one CPU is in use of course but no IO wait.

 

Is there something to be done to speed things up?

Tuning of mariadb, tuning opcache. Should I use redis object cache or not etc.

I have noticed that the server is set to multithread but I think it should be better to turn that off in BIOS.

Any tips are welcome!


 
Posted : 02/03/2023 10:46 am
Chris
(@chris)
Posts: 3610
Famed Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Hi @hagen,

We can suggest the following:

  • Manage the import in local server, if it's possible.
  • It's desirable that the source and destination Databases are one in the server.
  • Change all WP and wpForo tables Engines to MyISAM before the import, and after the import maker sure that you have changed all back to InnoDB

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

 
Posted : 02/03/2023 3:53 pm
Share: