[umshastr@hod03]/export/umesh/server/binaries/GABuilds/R: bin/Rscript --version
R scripting front-end version 3.4.1 (2017-06-30)

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/R/examples: ./gen_data.R 100000000 > data.csv

## Session 1

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19/mysql-test: ./mtr --start innodb --mysqld=--innodb_buffer_pool_size=2G --mysqld=--innodb_log_file_size=512M &
[1] 25060
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19/mysql-test: Logging: ./mtr  --start innodb --mysqld=--innodb_buffer_pool_size=2G --mysqld=--innodb_log_file_size=512M
MySQL Version 5.7.19
Checking supported features...
 - SSL connections supported
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.19/mysql-test/var'...
Installing system database...
Using parallel: 1

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1]
Started [mysqld.1 - pid: 25093, winpid: 25093]
worker[1] Using config for test innodb.innodb
worker[1] Port and socket path for server(s):
worker[1] mysqld.1  13000  /export/umesh/server/binaries/GABuilds/mysql-5.7.19/mysql-test/var/tmp/mysqld.1.sock
worker[1] Waiting for server(s) to exit...



## Session 2

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot -S mysql-test/var/tmp/mysqld.1.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> CREATE TABLE `testtable` ( `col3` text ) ENGINE=INNODB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.01 sec)

root@localhost [test]> load data infile 'data.csv' into table testtable fields enclosed by '"' ignore 1 lines;
Query OK, 100000000 rows affected (14 min 45.65 sec)
Records: 100000000  Deleted: 0  Skipped: 0  Warnings: 0

root@localhost [test]> Select * from testtable where col3 LIKE '%qwertyd%'; Select * from testtable LIMIT 59745270,10;
Empty set (3 min 8.05 sec)

+------------------------------------------------------------------+
| col3                                                             |
+------------------------------------------------------------------+
| LJL1NWgksw5VbDtiorslrQF5HLtTXUgU8sCg5brJFjE6POHZxxXlyZlsLdtj0Fne |
| I8p1k6s9faREiZ6T6EttpgIa111hgQb5tcguiCo4oziMIYBEIeqokOEY8YZHlcdY |
| EMKedu28ATlYG6CLU8qQTqaCtr5UNN2OeDdi71CZLcnbuN3gkyWOmY9upwEhu3u2 |
| gXU50CNBhgSM65nwGxm8FpryDmnNKltAxGt4zZHAN8T3L5ghBwoKDQiCNPMJTrOw |
| 3S2aboFlofXjFfm9l8WaeYzzCWBiQI9XYWJGgOfjYvjHv08VWD04BnP96vCU2c2u |
| Qv2WUAxaD8vnNNqdt2Pmlosk6ph3BdRzLn1nPiJvPBrapLsqzeCmoSPh3bDAuj6b |
| gxDFDnzlVryBNYhumyju1gmUkeLXDV73eLsI95r4z70ks6SVdpvZy7mr4QQrEfYs |
| fSl0Q8qCxhUVoSlKeQKbjf75HjYwx3enwyWmbxJK8vls0ipgSgHGhTTvN99p5EFe |
| YHH3sIYf98IjxK3kUludDx89kMSLEPwNSbCu5BodJz50MJ3WYuOmxSxXGROhu4La |
| M4mzLvNhZ823ELkSi1JOKuvuXx9vhQflT7vd8gO9v4vmZdX4WCXbagrnUsLb307Z |
+------------------------------------------------------------------+
10 rows in set (1 min 4.23 sec)

root@localhost [test]> alter table testtable engine=myisam;
Query OK, 100000000 rows affected (5 min 51.96 sec)
Records: 100000000  Duplicates: 0  Warnings: 0

root@localhost [test]> Select * from testtable where col3 LIKE '%qwertyd%'; Select * from testtable LIMIT 59745270,10;
Empty set (1 min 20.03 sec)

+------------------------------------------------------------------+
| col3                                                             |
+------------------------------------------------------------------+
| LJL1NWgksw5VbDtiorslrQF5HLtTXUgU8sCg5brJFjE6POHZxxXlyZlsLdtj0Fne |
| I8p1k6s9faREiZ6T6EttpgIa111hgQb5tcguiCo4oziMIYBEIeqokOEY8YZHlcdY |
| EMKedu28ATlYG6CLU8qQTqaCtr5UNN2OeDdi71CZLcnbuN3gkyWOmY9upwEhu3u2 |
| gXU50CNBhgSM65nwGxm8FpryDmnNKltAxGt4zZHAN8T3L5ghBwoKDQiCNPMJTrOw |
| 3S2aboFlofXjFfm9l8WaeYzzCWBiQI9XYWJGgOfjYvjHv08VWD04BnP96vCU2c2u |
| Qv2WUAxaD8vnNNqdt2Pmlosk6ph3BdRzLn1nPiJvPBrapLsqzeCmoSPh3bDAuj6b |
| gxDFDnzlVryBNYhumyju1gmUkeLXDV73eLsI95r4z70ks6SVdpvZy7mr4QQrEfYs |
| fSl0Q8qCxhUVoSlKeQKbjf75HjYwx3enwyWmbxJK8vls0ipgSgHGhTTvN99p5EFe |
| YHH3sIYf98IjxK3kUludDx89kMSLEPwNSbCu5BodJz50MJ3WYuOmxSxXGROhu4La |
| M4mzLvNhZ823ELkSi1JOKuvuXx9vhQflT7vd8gO9v4vmZdX4WCXbagrnUsLb307Z |
+------------------------------------------------------------------+
10 rows in set (8.82 sec)

root@localhost [test]>