Reply To: Need reindexing after cloning a WordPress site?
In a batch of 100. Right now, it has been 30 minutes and 10400 documents indexed so far.
In a batch of 100. Right now, it has been 30 minutes and 10400 documents indexed so far.
You have an issue. a) SQL is slow to retrieve data to index b) Elasticsearch is slow to ingest data
I believe the SQL is slow. Although we are on 16 GB RAM server.
Yes, SSD. DigitalOcean. Should we increase the RAM and CPU for indexing purpose and then bring it down?
During index synch, you can check the debug option, it will output the SQL query used.
My website mysqld is 198.59%. Let me test.
You can also use monitoring plugins, like https://wordpress.org/plugins/query-monitor/
As of now, around 40,000 products has been indexed. How to test it? We are using YITH Ajax and the plugin is enabled.