S sajal Active member Nov 8, 2019 #1 It seems that the free text search is working too slow after we have moved out to site to AWS. Anyone has experienced something similar?
It seems that the free text search is working too slow after we have moved out to site to AWS. Anyone has experienced something similar?
fly Well-known member Nov 8, 2019 #2 That is not nearly enough information. Are you using ES? Are your instances properly sized? I/O issues?
That is not nearly enough information. Are you using ES? Are your instances properly sized? I/O issues?
S sajal Active member Nov 9, 2019 #3 @fly Yeah our instances are properly sized, and we're using 2 application servers and 2 db servers with master/slave setup. So I think we might need some fine tuning on the db side, as we've around 12M records in the xf_post table. Last edited: Nov 9, 2019
@fly Yeah our instances are properly sized, and we're using 2 application servers and 2 db servers with master/slave setup. So I think we might need some fine tuning on the db side, as we've around 12M records in the xf_post table.
Walter Well-known member Nov 11, 2019 #4 Is your Innodb cache big enough to hold the complete database in memory? Otherwise I would recommend enhanced search (using Elasticsearch).
Is your Innodb cache big enough to hold the complete database in memory? Otherwise I would recommend enhanced search (using Elasticsearch).
S sajal Active member Nov 11, 2019 #5 thanks @Walter, I don't thinks as it's around 60G db. Anyways, I'll try Elasticsearch at some point for sure.
thanks @Walter, I don't thinks as it's around 60G db. Anyways, I'll try Elasticsearch at some point for sure.
