Hi,
we have 3 solr cores, each of them is running a delta-import every 2
minutes on
a MySQL database.
We've noticed a significant increase of MySQL queries per second, since
we've
started the delta updates.
Before that, the database server received between 50 and 100 queries per
second,
since the Delta-Imports the query count has rised up to 100 to 200
queries per second.
I've temporarily disabled the delta imports for 2 hours, and the queries
per second immediately
decreased again to 50-100 per second.
I followed the Wiki entry which only uses one Query for the delta import:
http://wiki.apache.org/solr/DataImportHandlerDeltaQueryViaFullImport
I did not expect the queries per seconds to the database increase that
high, so i'm wondering
if others experienced similar issues.
cheers
-robert
