I have no problem creating a scale factor 1 (1,000 customers) TPC-E database.
But if I try a scale factor 10 (10,000 customers), then the 5 largest tables (E_TRADE_HISTORY, E_SETTLEMENT,E_TRADE,E_HOLDING_HISTORY, and E_CASH_TRANSACTION) will fail with error "ODBC Error (S1000,4B6) - [MySQL][ODBC 5.3(a) Driver][mysqld-5.7.8-rc]The total number of locks exceeds the lock table size "
All of the respective BAK tables are built fine. (so… building and loading the E_TRADE_BAK etc. tables was no problem).
Any best practices regarding loading big tables from BAK with Benchmark Factory?
In particular, where are the LOAD statements? (I was considering customizing them for these tables)