Comment 4 for bug 1646100

Revision history for this message
Francisco Bordenave (francisco-bordenave) wrote : Re: Server becomes unresponsive during flushing after loading big files through LOAD DATA INFILE

How to repeat:
Fire a VM with 2 cores and 2G of RAM, good IO capacity (maybe something around 10k IOPS), 1G of innodb_buffer_pool_size and load a file bigger than buffer pool capacity:
- Table definition:
CREATE TABLE `test` (
  `process_date` datetime NOT NULL,
  `account_id` int(11) NOT NULL,
  `rtb_rule_id` int(11) NOT NULL,
  `revenue_gain` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `recommended_floor` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `revenue_gain_currency_id` char(3) NOT NULL DEFAULT 'USD',
  `recommended_floor_currency_id` char(3) NOT NULL DEFAULT 'USD',
  `bid_distribution` longtext,
  `price_floor_distribution` longtext,
  `fill_rate_distribution` longtext,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `account_rtb_rule` (`account_id`,`rtb_rule_id`),
  KEY `create_date` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

- Command:
load data local infile '/tmp/test.txt' into table test;

I could provide sample rows in pvt, can't publish them.