e.com/Solr-optimize-operation-slows-my-MySQL-serveur-tp1877270p1879527.html
Sent from the Solr - User mailing list archive at Nabble.com.
On 11/10/2010 11:00 AM, Skreo wrote:
I just made a test :
avg-cpu: %user %nice %system %iowait %steal %idle
2,230,001,40 28,110,00 68,26
Your iowait percentage for that 10 second interval was 28%, which is
pretty high. Solr has to make a complete copy of
232
dm-0 8,90 5,60 151,20 56 1512
dm-1 6830,30 0,00 54641,60 0 546416
(I have 2 SSD in RAID 1, and 2 unused HDD in RAID 1)
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-optimize-operation-slows
On 2010-11-10 18:08, Skreo wrote:
Hello,
I've a Solr index with few millions of entries, so an "optimize" usually
takes several minutes (or at least tens of seconds). During the optimize
process, there is free RAM and the load average stays under 1.
But... the machine also hosts a MySQL server,
ptimize
process, there are a lot of slow mysql queries (4 to 10 seconds), without
apparent reason.
I don't understand why Solr interferes with MySQL in my case. Do you have an
idea ?
Thank you !
Godefroy
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-optimize-oper
