Re: Occasional very long LOAD DATA commands

[Rick James]

> I understand that the query cache helps performance only if one has reoccurring queries, is that correct?
True.
> Are LOAD DATA or INSERT statements considered queries in this context? In other words, should I have a query cache?
Any _write_ operation, including LOAD DATA will flush _all_ queries in the QC for the relevant table. So, for loading, the QC costs something.

4GB RAM:
1GB for Java
1GB for misc
That leaves 2GB for MySQL caching. I would not assign more than a quarter of that (500M) to the index caching (key_buffer_size). (I doubt if this change will matter much.)

> post something to this effect on the JDBC and Java forum
Good. The last time I touched Java was in 1999, so my experience is essentially useless.

> And this did the trick: The 5 sec latencies are gone
:)