Re: Occasional very long LOAD DATA commands

[Rick James]

> insertions in the future, but they should all be quite fast
In MyISAM, a slow INSERT will block any SELECT; a slow SELECT will block any INSERT.

> 100 msec was just a compromise
Wow! What application can't afford a 100ms delay?

> key_buffer_size | 1019215872
That's a reasonable setting if you have 4-6GB of RAM, aside from Java. How much RAM do you have?

SHOW VARIABLES LIKE 'query_cache%';
A too-large QC will have periodic hiccups.

> no swapping
Good.

> SHOW PROFILE, but that does not tell me much
Nor I :(

Instead of using LOAD DATA, consider building a batched INSERT statement.

Does your SSD controller and/or driver do "wear leveling"? If so, I worry that it is in software, and it blocks I/O during the process.

If you do switch to InnoDB, I recommend you use Percona's Xtradb. It has more tunables that can make better use of SSDs.

Is an Anti-virus program running?

Consider switching to Linux.