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.
How to repeat: buffer_ pool_size and load a file bigger than buffer pool capacity: floor` decimal(10,4) NOT NULL DEFAULT '0.0000', gain_currency_ id` char(3) NOT NULL DEFAULT 'USD', floor_currency_ id` char(3) NOT NULL DEFAULT 'USD', distribution` longtext, floor_distribut ion` longtext, rate_distributi on` longtext, id`,`rtb_ rule_id` ),
Fire a VM with 2 cores and 2G of RAM, good IO capacity (maybe something around 10k IOPS), 1G of innodb_
- 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_
`revenue_
`recommended_
`bid_
`price_
`fill_
`created` datetime NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
KEY `account_rtb_rule` (`account_
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.