Loading two CSV files from two sessions into TokuDB / Timeout exceeded


I am playing with Percona Server 5.6.27 and TokuDB engine.

I tried to load two (different) CSV files into the same table with LOAD DATA INFILE from two separate ‘mysql’ sessions. It worked with InnoDB (XtraDB) and MyISAM, but not with TokuDB. The session that starts loading first succeeds, but the other doesn’t and returns: “ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction.”

Besides increasing the timeout value, is there a way to do this with TokuDB?



Hello Andy,
You are running into the TokuDB bulk loader lock. Please see https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_variables.html#tokudb_prelock_empty

George O. Lorch III
Software Engineer, Percona